C_CADocumentTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CADocumentTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_CADocumentTP AS
SELECT
  cast ( CADocumentNumber as opbel_gfn_kk preserving type ) AS CADocumentNumber,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  CATaxCompanyCode,
  CATaxCodeWasExchanged,
  TaxReportingDate,
  CAReconciliationKey,
  CASeparateDocIsCreatedInGL,
  CARequestedPeriodForGLTransfer,
  CAApplicationArea,
  CADocumentOriginCode,
  _DocOriginCode._Text[1:Language=$session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName,
  TransactionCurrency,
  DocumentDate,
  CAPostingDate,
  ExchangeRateDate,
  CAReferenceDocument,
  CAReturnReason,
  _CAReturnReason[1:HouseBank=HouseBank]._Text[1:Language=$session.system_language].CAReturnReasonName AS CAReturnReasonName,
  CAPostingReason,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CAClearingInformation,
  CAReversalDocumentNumber,
  CADocumentSupplements,
  LogicalSystem,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CADocumentTransactionClass,
  CADocContainsCashFlowItems,
  CADocumentClass,
  CADocumentVersion,
  IsIndividualPosting,
  CADocumentIsAged,
  CADocumentType,
  _DocType._Text[1:Language=$session.system_language].CADocumentTypeName AS CADocumentTypeName,
  _DocUI.CAOpenAmountInTransactionCrcy AS CAOpenAmountInTransactionCrcy,
  _DocUI.CADueAmountInTransactionCrcy AS CADueAmountInTransactionCrcy,
  _DocUI.CAClrdAmountInTransactionCrcy AS CAClrdAmountInTransactionCrcy,
  _DocUI.NumberOfCADocumentBPItems AS NumberOfCADocumentBPItems,
  _DocUI.NumberOfCADocumentGLItems AS NumberOfCADocumentGLItems,
  CA1stCountrySpecificReference,
  CAFirstCountrySpecificDate,
  _DocUI.HouseBank AS HouseBank,
  _DocUI.HouseBankAccount AS HouseBankAccount,
  _DocUI.CAMassRunDate AS CAMassRunDate,
  _DocUI.CAMassRunID AS CAMassRunID,
  _DocUI.CAPaymentDocument AS CAPaymentDocument,
  _DocUI.CAPaymentMethod AS CAPaymentMethod,
  _DocUI.CABankClearingAccount AS CABankClearingAccount,
  _DocUI.CompanyCode AS CompanyCode,
  _DocUI.CABankAccountHolderName AS CABankAccountHolderName,
  _DocUI.CAPaymentLot AS CAPaymentLot,
  _DocUI.CAPaymentLotItem AS CAPaymentLotItem,
  _DocUI.BankNumber AS BankNumber,
  _DocUI.BankAccount AS BankAccount,
  _DocUI.BankCountry AS BankCountry,
  _DocUI.BankDetailReference AS BankDetailReference,
  _DocUI.CANoteToPayeeInPayment AS CANoteToPayeeInPayment,
  _DocUI.LastName AS LastName,
  _DocUI.FirstName AS FirstName,
  _DocUI.CAPaymentDocumentReference AS CAPaymentDocumentReference,
  _DocUI.CAPaymentOrder AS CAPaymentOrder,
  _DocUI.CAPaymentOrderExternalRef AS CAPaymentOrderExternalRef,
  _DocUI.CAPaymentOrderStatus AS CAPaymentOrderStatus,
  _DocUI.CANetAmountInTransCurrency AS CANetAmountInTransCurrency,
  _DocUI.PaidItemDueDate AS PaidItemDueDate,
  _DocUI.ValueDate AS ValueDate,
  _DocUI.CAPaymentOrderExpirationDate AS CAPaymentOrderExpirationDate,
  _DocUI.BusinessPartner AS BusinessPartner,
  _DocUI.CAReturnLot AS CAReturnLot,
  _DocUI.CAItemNumberInReturnLot AS CAItemNumberInReturnLot,
  _DocUI.CAReturnReasonOfHouseBank AS CAReturnReasonOfHouseBank,
  _DocUI.CAReturnCharge1 AS CAReturnCharge1,
  _DocUI.TaxCodeForFirstReturnCharge AS TaxCodeForFirstReturnCharge,
  _DocUI.CATaxAmountForReturnCharge1 AS CATaxAmountForReturnCharge1,
  _DocUI.CAChargeAmountFromBank1 AS CAChargeAmountFromBank1,
  _DocUI.TaxCodeForFirstBankCharge AS TaxCodeForFirstBankCharge,
  _DocUI.CATaxAmountOfBankCharge1 AS CATaxAmountOfBankCharge1,
  _DocUI.CARepaymentRequest AS CARepaymentRequest,
  _DocUI.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _DocUI.CANetDueDate AS CANetDueDate,
  _DocUI.CAPaymentCompanyCode AS CAPaymentCompanyCode,
  _DocUI.ProfitCenter AS ProfitCenter,
  _DocUI.CARepaymentRequestDocument AS CARepaymentRequestDocument,
  _DocUI.PayeeBankNumber AS PayeeBankNumber,
  _DocUI.PayeeBankCountry AS PayeeBankCountry,
  _DocUI.PayeeBankAccount AS PayeeBankAccount,
  _DocUI.PayeeIBAN AS PayeeIBAN,
  _DocUI.PayeeSWIFTCode AS PayeeSWIFTCode,
  virtual UICT_PaymentLotOrigin : boole_d AS virtualUICT_PaymentLotOriginboole_d,
  virtual UICT_PaymentRunOrigin : boole_d AS virtualUICT_PaymentRunOriginboole_d,
  virtual UICT_PaymentOrderOrigin : boole_d AS virtualUICT_PaymentOrderOriginboole_d,
  virtual UICT_ReturnOrigin : boole_d AS virtualUICT_ReturnOriginboole_d,
  virtual UICT_CADueAmountCriticality : int1 AS virtualUICT_CADueAmountCriticalityint1,
  virtual UICT_HideClearedItems : boole_d AS virtualUICT_HideClearedItemsboole_d,
  virtual UICT_HideBPItems : boole_d AS virtualUICT_HideBPItemsboole_d,
  virtual UICT_HideGLItems : boole_d AS virtualUICT_HideGLItemsboole_d,
  virtual UICT_HideReverseButton : boole_d AS virtualUICT_HideReverseButtonboole_d,
  virtual UICT_WriteOffButton : boole_d AS virtualUICT_WriteOffButtonboole_d,
  virtual UICT_UserIsAuthorized : boole_d AS virtualUICT_UserIsAuthorizedboole_d
FROM R_CADocumentTP
LEFT OUTER JOIN C_CADocumentSumBPItem AS _SumBPItem ON CADocumentNumber = _SumBPItem.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN C_CADocumentSumGLItem AS _SumGLItem ON CADocumentNumber = _SumGLItem.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN C_CADocumentSumClearedItem AS _SumClearedItem ON CADocumentNumber = _SumClearedItem.CAClearingDocumentNumber  -- association [0..*]
LEFT OUTER JOIN C_CADocumentIssue AS _DocIssue ON CADocumentNumber = _DocIssue.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN C_CADocumentTaxGLItem AS _TaxItem ON CADocumentNumber = _TaxItem.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN C_CADocumentClearedItem AS _ClearedItem ON CADocumentNumber = _ClearedItem.CAClearingDocumentNumber  -- association [0..*]
LEFT OUTER JOIN C_CADocumentLinkedObject AS _LinkedObject ON CADocumentNumber = _LinkedObject.CADocumentNumber association[0..*] to C_CADocumentBPItemLogical as _BPItem on CADocumentNumber = _BPItem. CADocumentNumber  -- association [0..*]
;