P_CAExtCollsItemBPAmountInDC

DDL: P_CAEXTCOLLSITEMBPAMOUNTINDC Type: view_entity COMPOSITE
31 Fields 1 Data Sources

Collections Items with BP Amounts in DC

P_CAExtCollsItemBPAmountInDC is a Composite CDS View that provides data about "Collections Items with BP Amounts in DC" in SAP S/4HANA. It reads from 1 data source (P_CAExtCollsItemBPAmount) and exposes 31 fields with key fields CADocumentNumber, CAGrpgCodeForTransfToCollAgcy.

Data Sources (1)

SourceAliasJoin Type
P_CAExtCollsItemBPAmount P_CAExtCollsItemBPAmount from

Parameters (1)

NameTypeDefault
P_DisplayCurrency waers_kk

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Collections Items with BP Amounts 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 (31)

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
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAPaymentAmountInTransCurrency CAPaymentAmountInTransCurrency
CANoncollectableAmount CANoncollectableAmount
CAIntrstReceivableFromCollAgcy CAIntrstReceivableFromCollAgcy
CAChargeReceivableFromCollAgcy CAChargeReceivableFromCollAgcy
DisplayCurrency
BalanceTransactionCurrency BalanceTransactionCurrency Currency
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_CAExtCollsItemBPAmountInDC.
-- 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_CAExtCollsItemBPAmountInDC AS
SELECT
  CADocumentNumber,
  CAGrpgCodeForTransfToCollAgcy,
  CACollectionAgency,
  ContractAccount,
  BusinessPartner,
  CompanyCode,
  CADateOfTransferToCollAgcy,
  CAReasonForTransferToCollAgcy,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAPaymentAmountInTransCurrency,
  CANoncollectableAmount,
  CAIntrstReceivableFromCollAgcy,
  CAChargeReceivableFromCollAgcy,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  BalanceTransactionCurrency,
  CAReferenceDocument,
  CATransferToCollAgcyStatus,
  CAPaymentFormNumber,
  CAReceivableRecallDate,
  CAReceivableRecallReason,
  CACollectionExternalReference
FROM P_CAExtCollsItemBPAmount
;

Learn More