P_CADocCreditItemBPAmount

DDL: P_CADOCCREDITITEMBPAMOUNT Type: view_entity COMPOSITE
28 Fields 1 Data Sources

Document with business partner amounts

P_CADocCreditItemBPAmount is a Composite CDS View that provides data about "Document with business partner amounts" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemLogical) and exposes 28 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemLogical _OpenCredit from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Document with business partner amounts view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItemLogical CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItemLogical CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItemLogical CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemLogical CASubItemNumber Subitem
CompanyCode I_CADocumentBPItemLogical CompanyCode Receiver Company Code
Segment I_CADocumentBPItemLogical Segment Segment number
Division I_CADocumentBPItemLogical Division Internal Division ID
BusinessArea I_CADocumentBPItemLogical BusinessArea Business Area
BusinessPartner I_CADocumentBPItemLogical BusinessPartner Issuing Authority
ContractAccount I_CADocumentBPItemLogical ContractAccount Contract Acct
CADocumentType I_CADocumentBPItemLogical CADocumentType Document Type
CAMainTransaction I_CADocumentBPItemLogical CAMainTransaction Main Trans.
CASubTransaction I_CADocumentBPItemLogical CASubTransaction Subtransaction
CANetDueDate I_CADocumentBPItemLogical CANetDueDate Net Due Date
CAContract I_CADocumentBPItemLogical CAContract Contract
CAApplicationArea I_CADocumentBPItemLogical CAApplicationArea ApplicationArea
CASubApplication I_CADocumentBPItemLogical CASubApplication Subapplication
CAAmountInTransactionCurrency I_CADocumentBPItemLogical CAAmountInTransactionCurrency Amount
TransactionCurrency I_CADocumentBPItemLogical TransactionCurrency Transaction Currency
CABPDebitAmountInTC _TotalAmounts CABPDebitAmountInTC
CABPCreditAmountInTC _TotalAmounts CABPCreditAmountInTC
CABPBalanceAmountInTC _TotalAmounts CABPBalanceAmountInTC
BalanceTransactionCurrency _TotalAmounts TransactionCurrency Transaction Currency
CADocumentOriginCode I_CADocumentBPItemLogical CADocumentOriginCode Document Origin
_BusinessPartner I_CADocumentBPItemLogical _BusinessPartner
_CAPartner I_CADocumentBPItemLogical _CAPartner
_ProviderContract I_CADocumentBPItemLogical _ProviderContract
_CompCode I_CADocumentBPItemLogical _CompCode

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 P_CADocCreditItemBPAmount.
-- 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 P_CADocCreditItemBPAmount AS
SELECT
  _OpenCredit.CADocumentNumber AS CADocumentNumber,
  _OpenCredit.CARepetitionItemNumber AS CARepetitionItemNumber,
  _OpenCredit.CABPItemNumber AS CABPItemNumber,
  _OpenCredit.CASubItemNumber AS CASubItemNumber,
  _OpenCredit.CompanyCode AS CompanyCode,
  _OpenCredit.Segment AS Segment,
  _OpenCredit.Division AS Division,
  _OpenCredit.BusinessArea AS BusinessArea,
  _OpenCredit.BusinessPartner AS BusinessPartner,
  _OpenCredit.ContractAccount AS ContractAccount,
  _OpenCredit.CADocumentType AS CADocumentType,
  _OpenCredit.CAMainTransaction AS CAMainTransaction,
  _OpenCredit.CASubTransaction AS CASubTransaction,
  _OpenCredit.CANetDueDate AS CANetDueDate,
  _OpenCredit.CAContract AS CAContract,
  _OpenCredit.CAApplicationArea AS CAApplicationArea,
  _OpenCredit.CASubApplication AS CASubApplication,
  _OpenCredit.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _OpenCredit.TransactionCurrency AS TransactionCurrency,
  _TotalAmounts.CABPDebitAmountInTC AS CABPDebitAmountInTC,
  _TotalAmounts.CABPCreditAmountInTC AS CABPCreditAmountInTC,
  _TotalAmounts.CABPBalanceAmountInTC AS CABPBalanceAmountInTC,
  _TotalAmounts.TransactionCurrency AS BalanceTransactionCurrency,
  _OpenCredit.CADocumentOriginCode AS CADocumentOriginCode,
  _OpenCredit._BusinessPartner AS _BusinessPartner,
  _OpenCredit._CAPartner AS _CAPartner,
  _OpenCredit._ProviderContract AS _ProviderContract,
  _OpenCredit._CompCode AS _CompCode
FROM I_CADocumentBPItemLogical AS _OpenCredit
;

Learn More