I_CADocumentUI

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 I_CADocumentUI.
-- 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 I_CADocumentUI AS
SELECT
  CADocumentNumber,
  CADocumentOriginCode,
  _OpenAmount.CAOpenAmountInTransactionCrcy AS CAOpenAmountInTransactionCrcy,
  _DueAmount.CADueAmountInTransactionCrcy AS CADueAmountInTransactionCrcy,
  _ClearedAmount.CAClrdAmountInTransactionCrcy AS CAClrdAmountInTransactionCrcy,
  TransactionCurrency,
  _DocBPItemCount.NumberOfCADocumentBPItems AS NumberOfCADocumentBPItems,
  _DocGLItemCount.NumberOfCADocumentGLItems AS NumberOfCADocumentGLItems,
  case when CADocumentOriginCode = '05' then _PayInfoLot._BkClrgAcct.HouseBank when CADocumentOriginCode = '06' then _PayInfoRun.HouseBank when CADocumentOriginCode = '08' then _PayInfoReturn.HouseBank when CADocumentOriginCode = '45' then _PayInfoOrder.HouseBank end as HouseBank AS HouseBankendasHouseBank,
  case when CADocumentOriginCode = '05' then _PayInfoLot._BkClrgAcct.HouseBankAccount when CADocumentOriginCode = '06' then _PayInfoRun.HouseBankAccount when CADocumentOriginCode = '08' then _PayInfoReturn.HouseBankAccount when CADocumentOriginCode = '45' then _PayInfoOrder.HouseBankAccount end as HouseBankAccount AS HouseBankAccountendasHouseBankAccount,
  case when CADocumentOriginCode = '06' then _PayInfoRun.CAMassRunDate when CADocumentOriginCode = '45' then _PayInfoOrder.CAMassRunDate end as CAMassRunDate AS CAMassRunDateendasCAMassRunDate,
  case when CADocumentOriginCode = '06' then _PayInfoRun.CAMassRunID when CADocumentOriginCode = '45' then _PayInfoOrder.CAMassRunID end as CAMassRunID AS CAMassRunIDendasCAMassRunID,
  case when CADocumentOriginCode = '35' then _PayInfoRepayReq.CAPaymentDocument when CADocumentOriginCode = '45' then _PayInfoOrder.CAPaymentDocument end as CAPaymentDocument AS CAPaymentDocumentendasCAPaymentDocument,
  case when CADocumentOriginCode = '06' then _PayInfoRun.CAPaymentMethod when CADocumentOriginCode = '35' then _PayInfoRepayReq.CAPaymentMethod when CADocumentOriginCode = '45' then _PayInfoOrder.CAPaymentMethod end as CAPaymentMethod AS CAPaymentMethodendasCAPaymentMethod,
  case when CADocumentOriginCode = '35' then _PayInfoRepayReq.CompanyCode when CADocumentOriginCode = '45' then _PayInfoOrder.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  _PayInfoLot.CAPaymentLot AS CAPaymentLot,
  _PayInfoLot.CAPaymentLotItem AS CAPaymentLotItem,
  _PayInfoLot.BankNumber AS BankNumber,
  _PayInfoLot.BankAccount AS BankAccount,
  _PayInfoLot.BankCountry AS BankCountry,
  _PayInfoLot.BankDetailReference AS BankDetailReference,
  _PayInfoLot.CANoteToPayeeInPayment AS CANoteToPayeeInPayment,
  _PayInfoRun.LastName AS LastName,
  _PayInfoRun.FirstName AS FirstName,
  _PayInfoRun.CAPaymentDocumentReference AS CAPaymentDocumentReference,
  _PayInfoOrder.CAPaymentOrder AS CAPaymentOrder,
  _PayInfoOrder.CAPaymentOrderExternalRef AS CAPaymentOrderExternalRef,
  _PayInfoOrder.CAPaymentOrderStatus AS CAPaymentOrderStatus,
  _PayInfoOrder.CANetAmountInTransCurrency AS CANetAmountInTransCurrency,
  _PayInfoOrder.PaidItemDueDate AS PaidItemDueDate,
  _PayInfoOrder.ValueDate AS ValueDate,
  _PayInfoOrder.CAPaymentOrderExpirationDate AS CAPaymentOrderExpirationDate,
  _PayInfoOrder.BusinessPartner AS BusinessPartner,
  _PayInfoReturn.CAReturnLot AS CAReturnLot,
  _PayInfoReturn.CAItemNumberInReturnLot AS CAItemNumberInReturnLot,
  _PayInfoReturn.CAReturnReasonOfHouseBank AS CAReturnReasonOfHouseBank,
  _PayInfoReturn.CAReturnCharge1 AS CAReturnCharge1,
  _PayInfoReturn.TaxCodeForFirstReturnCharge AS TaxCodeForFirstReturnCharge,
  _PayInfoReturn.CATaxAmountForReturnCharge1 AS CATaxAmountForReturnCharge1,
  _PayInfoReturn.CAChargeAmountFromBank1 AS CAChargeAmountFromBank1,
  _PayInfoReturn.TaxCodeForFirstBankCharge AS TaxCodeForFirstBankCharge,
  _PayInfoReturn.CATaxAmountOfBankCharge1 AS CATaxAmountOfBankCharge1,
  _PayInfoRepayReq.CARepaymentRequest AS CARepaymentRequest,
  _PayInfoRepayReq.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _PayInfoRepayReq.CANetDueDate AS CANetDueDate,
  _PayInfoRepayReq.CAPaymentCompanyCode AS CAPaymentCompanyCode,
  _PayInfoRepayReq.ProfitCenter AS ProfitCenter,
  _PayInfoRepayReq.CARepaymentRequestDocument AS CARepaymentRequestDocument,
  _PayInfoRepayReq.CAPostingDate AS CAPostingDate,
  _PayInfoRepayReq.PayeeBankNumber AS PayeeBankNumber,
  _PayInfoRepayReq.PayeeBankCountry AS PayeeBankCountry,
  _PayInfoRepayReq.PayeeBankAccount AS PayeeBankAccount,
  _PayInfoRepayReq.PayeeIBAN AS PayeeIBAN,
  _PayInfoRepayReq.PayeeSWIFTCode AS PayeeSWIFTCode
FROM R_CADocumentTP
LEFT OUTER JOIN P_CADocumentOpenAmountInTC AS _OpenAmount ON CADocumentNumber = _OpenAmount.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN P_CADocumentDueAmountInTC AS _DueAmount ON CADocumentNumber = _DueAmount.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN P_CADocumentClearedAmountInTC AS _ClearedAmount ON CADocumentNumber = _ClearedAmount.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN P_CADocumentBPItemCount AS _DocBPItemCount ON CADocumentNumber = _DocBPItemCount.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN P_CADocumentGLItemCount AS _DocGLItemCount ON CADocumentNumber = _DocGLItemCount.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN P_CADocumentPaytInfoPaymentLot AS _PayInfoLot ON CADocumentNumber = _PayInfoLot.CADocumentNumber AND CADocumentOriginCode = '05'  -- association [0..1]
LEFT OUTER JOIN P_CADocumentPaytInfoPaymentRun AS _PayInfoRun ON CADocumentNumber = _PayInfoRun.CADocumentNumber AND CADocumentOriginCode = '06'  -- association [0..1]
LEFT OUTER JOIN P_CADocumentPaytInfoReturn AS _PayInfoReturn ON CADocumentNumber = _PayInfoReturn.CAPaymentDocument AND CADocumentOriginCode = '08'  -- association [0..1]
LEFT OUTER JOIN P_CADocumentPaytInfoPaytOrder AS _PayInfoOrder ON CADocumentNumber = _PayInfoOrder.CAPaymentDocument AND CADocumentOriginCode = '45'  -- association [0..1]
LEFT OUTER JOIN P_CADocumentPaytInfoRpaytReq AS _PayInfoRepayReq ON CADocumentNumber = _PayInfoRepayReq.CAPaymentDocument AND CADocumentOriginCode = '35'  -- association [0..1]
;