C_CAOpenItemListItem

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_CAOpenItemListItem.
-- 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.
-- SQL view name: CCAOPENITMLSTITM

CREATE VIEW C_CAOpenItemListItem AS
SELECT
  CAOpenItemListUUID,
  cast(CADocumentNumber as opbel_gfn_kk preserving type ) AS CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CompanyCode,
  BusinessArea,
  Segment,
  ProfitCenter,
  BusinessPartner,
  CAContract,
  ContractAccount,
  CAReconciliationAccount,
  CADoubtfulOrValueAdjmtCode,
  CADocumentType,
  CAIsDownPaymentRequest,
  DocumentDate,
  CAPostingDate,
  CANetDueDate,
  TransactionCurrency,
  CompanyCodeCurrency,
  cast(CAAmountInLocalCurrency as betrh_aggr_kk) AS CAAmountInLocalCurrency,
  cast( CAAmountInTransactionCurrency as betrw_aggr_kk ) AS CAAmountInTransactionCurrency,
  cast(CAAmountInSecondCurrency as betr2_aggr_kk) AS CAAmountInSecondCurrency,
  cast(CAAmountInThirdCurrency as betr3_aggr_kk) AS CAAmountInThirdCurrency,
  TaxCode,
  cast(CATaxAmountInLocalCurrency as sbeth_aggr_kk) AS CATaxAmountInLocalCurrency,
  cast(CATaxAmountInTransCurrency as sbetw_aggr_kk) AS CATaxAmountInTransCurrency,
  cast(CATaxAmountInSecondCurrency as sbet2_aggr_kk) AS CATaxAmountInSecondCurrency,
  cast(CATaxAmountInThirdCurrency as sbet3_aggr_kk) AS CATaxAmountInThirdCurrency,
  CADownPaymentOffsetTaxAccount,
  CAClearingStatus,
  CAClearingDate,
  CAClearingDocumentNumber,
  CAPostingDateOfClearingDoc,
  CAClearingReason,
  CAClearingCurrency,
  cast(CAClearingAmountInClearingCrcy as augbt_aggr_kk) AS CAClearingAmountInClearingCrcy,
  cast(CATaxAmountInClearingCrcy as augbs_aggr_kk) AS CATaxAmountInClearingCrcy,
  CAClearingPostingIsReset,
  CAGLPostingCurrency,
  cast(CAGLPostingAmount as pswbt_aggr_kk) AS CAGLPostingAmount,
  cast(CAGLPostingTaxAmount as pswtx_aggr_kk) AS CAGLPostingTaxAmount,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CAOpenItemListItem
LEFT OUTER JOIN E_CAOpenItemListItem AS _Extension ON CAOpenItemListUUID = _Extension.CAOpenItemListUUID AND CADocumentNumber = _Extension.CADocumentNumber AND CARepetitionItemNumber = _Extension.CARepetitionItemNumber AND CABPItemNumber = _Extension.CABPItemNumber AND CASubItemNumber = _Extension.CASubItemNumber  -- association [1..1]
;