I_PrepaymentAgrmtDistr

DDL: I_PREPAYMENTAGRMTDISTR SQL: IPPAGRDISTR Type: view BASIC
27 Fields 1 Data Sources 2 Associations

Prepayment Agmnt Dstrbtn Interface View

I_PrepaymentAgrmtDistr is a Basic CDS View that provides data about "Prepayment Agmnt Dstrbtn Interface View" in SAP S/4HANA. It reads from 1 data source (ppmgag_t_distrb) and exposes 27 fields with key field PrepaymentAgrmtDistrUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ppmgag_t_distrb AgreementDistr from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerSupplier _BusinessPartner $projection.PrepaymentDistrBeneficiaryName = _BusinessPartner.BusinessPartner -- Extension View for Distribution in Prepayment
[0..1] E_PrepaymentAgrmtDistribution _Extension $projection.PrepaymentAgrmtDistrUUID = _Extension.PrepaymentAgrmtDistrUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPPAGRDISTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Prepayment Agmnt Dstrbtn Interface View view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtDistrUUID ppmgag_t_distrb prepaymentagrmtdistruuid Key
PrepaymentAgreementUUID ppmgag_t_distrb prepaymentagreementuuid Key
prepaymentdistrtypeasPrepaymentDistrType
PrepaymentDistrPaymentDate ppmgag_t_distrb prepaymentdistrpaymentdate Payment Date
PrepaymentDistrBeneficiaryName ppmgag_t_distrb prepaymentdistrbeneficiaryname Busn. Partner
PrepaymentDistrAmount ppmgag_t_distrb prepaymentdistramount Distribution Amount
PrepaymentDistrCurrency ppmgag_t_distrb prepaymentdistrcurrency Currency
PrepaymentDistrQuantity ppmgag_t_distrb prepaymentdistrquantity Distribution Qnty
PrepaymentDistrUoM ppmgag_t_distrb prepaymentdistruom Distri. UoM
PrepaymentDistrCnvrsnFctr ppmgag_t_distrb prepaymentdistrcnvrsnfctr Conversion Factor
PrepaymentDistrUnitValCrcy ppmgag_t_distrb prepaymentdistrunitvalcrcy Distri. Unit Curr.
PrepaymentDistrUnitValUoM ppmgag_t_distrb prepaymentdistrunitvaluom Distri. Value UoM
PrepaymentAgreementProduct ppmgag_t_distrb prepaymentagreementproduct Prepayment Product
PrepaymentAgreementFXRate ppmgag_t_distrb prepaymentagreementfxrate Prepayment FX Rate
PrepaymentAgreementExchRate ppmgag_t_distrb prepaymentagreementexchrate Prepayment FX Rate
PrepaymentAgreementFXDate ppmgag_t_distrb prepaymentagreementfxdate Prepayment ForexDate
BuyerTaxCode ppmgag_t_distrb buyertaxcode Tax Code
DocumentItemNumber ppmgag_t_distrb documentitemnumber Item
PrepaymentAgrmtLinkStatus ppmgag_t_distrb prepaymentagrmtlinkstatus Link Status
PrepaymentAgrmtPostingStatus ppmgag_t_distrb prepaymentagrmtpostingstatus Pre Posting Status
PrepaymentAgreement _PrepayAgreement PrepaymentAgreement Renegotiation PPA
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
createdbyuserasCreatedByUser
CreationDateTime ppmgag_t_distrb creationdatetime Timestamp
LastChangedByUser ppmgag_t_distrb lastchangedbyuser User Name
LastChangeDateTime ppmgag_t_distrb lastchangedatetime Timestamp

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 I_PrepaymentAgrmtDistr.
-- 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: IPPAGRDISTR

CREATE VIEW I_PrepaymentAgrmtDistr AS
SELECT
  AgreementDistr.prepaymentagrmtdistruuid AS PrepaymentAgrmtDistrUUID,
  AgreementDistr.prepaymentagreementuuid AS PrepaymentAgreementUUID,
  AgreementDistr.prepaymentdistrpaymentdate AS PrepaymentDistrPaymentDate,
  AgreementDistr.prepaymentdistrbeneficiaryname AS PrepaymentDistrBeneficiaryName,
  AgreementDistr.prepaymentdistramount AS PrepaymentDistrAmount,
  AgreementDistr.prepaymentdistrcurrency AS PrepaymentDistrCurrency,
  AgreementDistr.prepaymentdistrquantity AS PrepaymentDistrQuantity,
  AgreementDistr.prepaymentdistruom AS PrepaymentDistrUoM,
  AgreementDistr.prepaymentdistrcnvrsnfctr AS PrepaymentDistrCnvrsnFctr,
  AgreementDistr.prepaymentdistrunitvalcrcy AS PrepaymentDistrUnitValCrcy,
  AgreementDistr.prepaymentdistrunitvaluom AS PrepaymentDistrUnitValUoM,
  AgreementDistr.prepaymentagreementproduct AS PrepaymentAgreementProduct,
  AgreementDistr.prepaymentagreementfxrate AS PrepaymentAgreementFXRate,
  AgreementDistr.prepaymentagreementexchrate AS PrepaymentAgreementExchRate,
  AgreementDistr.prepaymentagreementfxdate AS PrepaymentAgreementFXDate,
  AgreementDistr.buyertaxcode AS BuyerTaxCode,
  AgreementDistr.documentitemnumber AS DocumentItemNumber,
  AgreementDistr.prepaymentagrmtlinkstatus AS PrepaymentAgrmtLinkStatus,
  AgreementDistr.prepaymentagrmtpostingstatus AS PrepaymentAgrmtPostingStatus,
  _PrepayAgreement.PrepaymentAgreement AS PrepaymentAgreement,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  AgreementDistr.creationdatetime AS CreationDateTime,
  AgreementDistr.lastchangedbyuser AS LastChangedByUser,
  AgreementDistr.lastchangedatetime AS LastChangeDateTime
FROM ppmgag_t_distrb AS AgreementDistr
LEFT OUTER JOIN I_BusinessPartnerSupplier AS _BusinessPartner ON PrepaymentDistrBeneficiaryName = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_PrepaymentAgrmtDistribution AS _Extension ON PrepaymentAgrmtDistrUUID = _Extension.PrepaymentAgrmtDistrUUID  -- association [0..1]
;

Learn More