P_CAExtCollsItemBPAmtTotalInDC

DDL: P_CAEXTCOLLSITEMBPAMTTOTALINDC Type: view_entity COMPOSITE
25 Fields 1 Data Sources

Collection Item with BP Totals in DC

P_CAExtCollsItemBPAmtTotalInDC is a Composite CDS View that provides data about "Collection Item with BP Totals in DC" in SAP S/4HANA. It reads from 1 data source (P_CAExtCollsItemBPAmountInDC) and exposes 25 fields with key fields CADocumentNumber, CAGrpgCodeForTransfToCollAgcy.

Data Sources (1)

SourceAliasJoin Type
P_CAExtCollsItemBPAmountInDC P_CAExtCollsItemBPAmountInDC from

Parameters (1)

NameTypeDefault
P_DisplayCurrency waers_kk

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Collection Item with BP Totals in DC 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

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CAGrpgCodeForTransfToCollAgcy CAGrpgCodeForTransfToCollAgcy Collection item
CACollectionAgency CACollectionAgency
ContractAccount ContractAccount Contract Acct
BusinessPartner BusinessPartner Issuing Authority
CompanyCode CompanyCode Receiver Company Code
CADateOfTransferToCollAgcy CADateOfTransferToCollAgcy
CAReasonForTransferToCollAgcy CAReasonForTransferToCollAgcy
TransactionCurrency TransactionCurrency Transaction Currency
DisplayCurrency
CAReferenceDocument CAReferenceDocument Reference
CATransferToCollAgcyStatus CATransferToCollAgcyStatus
CAPaymentFormNumber CAPaymentFormNumber Payment Form
CAReceivableRecallDate CAReceivableRecallDate
CAReceivableRecallReason CAReceivableRecallReason
CACollectionExternalReference CACollectionExternalReference
_CompCode _CompCode
_BusinessPartner _BusinessPartner
_Currency _Currency
_CAPartner _CAPartner
_CAHeader _CAHeader
_CollAgcy _CollAgcy
_Status _Status
_RblRecallRsn _RblRecallRsn
_TransfRsn _TransfRsn

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_CAExtCollsItemBPAmtTotalInDC.
-- 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.
-- Parameters: P_DisplayCurrency : waers_kk

CREATE VIEW P_CAExtCollsItemBPAmtTotalInDC AS
SELECT
  CADocumentNumber,
  CAGrpgCodeForTransfToCollAgcy,
  CACollectionAgency,
  ContractAccount,
  BusinessPartner,
  CompanyCode,
  CADateOfTransferToCollAgcy,
  CAReasonForTransferToCollAgcy,
  TransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  CAReferenceDocument,
  CATransferToCollAgcyStatus,
  CAPaymentFormNumber,
  CAReceivableRecallDate,
  CAReceivableRecallReason,
  CACollectionExternalReference
FROM P_CAExtCollsItemBPAmountInDC
;

Learn More