P_CrdtMNrOfBrokenPromisesToPay

DDL: P_CRDTMNROFBROKENPROMISESTOPAY Type: view COMPOSITE
3 Fields 5 Data Sources

P_CrdtMNrOfBrokenPromisesToPay is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_BPCollectionsSegmentAssgmt, I_BusinessPartnerCustomer, I_CollsPromiseToPay, I_CollsSgmtCompanyCodeAssgmt, I_CollsSgmtCrdtSgmtAssgmt) and exposes 3 fields with key fields BusinessPartner, CreditSegment.

Data Sources (5)

SourceAliasJoin Type
I_BPCollectionsSegmentAssgmt I_BPCollectionsSegmentAssgmt inner
I_BusinessPartnerCustomer I_BusinessPartnerCustomer inner
I_CollsPromiseToPay I_CollsPromiseToPay inner
I_CollsSgmtCompanyCodeAssgmt I_CollsSgmtCompanyCodeAssgmt inner
I_CollsSgmtCrdtSgmtAssgmt I_CollsSgmtCrdtSgmtAssgmt inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCRDBRP2P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_CreditManagementAccount BusinessPartner Issuing Authority
KEY CreditSegment I_CreditManagementAccount CreditSegment Credit Segment
NumberOfBrokenPromisesToPay

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_CrdtMNrOfBrokenPromisesToPay.
-- 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_CrdtMNrOfBrokenPromisesToPay AS
SELECT
  I_CreditManagementAccount.BusinessPartner AS BusinessPartner,
  I_CreditManagementAccount.CreditSegment AS CreditSegment,
  cast ( count ( * ) as ukm_number_of_broken_p2p preserving type ) AS NumberOfBrokenPromisesToPay
INNER JOIN I_BusinessPartnerCustomer ON /* join condition not captured in parsed metadata */
INNER JOIN I_CollsSgmtCrdtSgmtAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_BPCollectionsSegmentAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_CollsSgmtCompanyCodeAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_CollsPromiseToPay ON /* join condition not captured in parsed metadata */
;

Learn More