C_PrepaymentPostedDocumentsTP

DDL: C_PREPAYMENTPOSTEDDOCUMENTSTP SQL: CPPMGAPPRMSGTP Type: view CONSUMPTION
30 Fields 1 Data Sources 6 Associations

Prepayment Settlement Document C View

C_PrepaymentPostedDocumentsTP is a Consumption CDS View that provides data about "Prepayment Settlement Document C View" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentPostedDocuments) and exposes 30 fields with key field PrepaymentAgrmtDocUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentPostedDocuments ApprovalDoc from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CoCode $projection.CompanyCode = _CoCode.CompanyCode
[0..1] I_PrepaymentAgrmtDistr _PrepaymentDistribution $projection.PrepaymentAgrmtDistrUUID = _PrepaymentDistribution.PrepaymentAgrmtDistrUUID --Distribution Type Text
[0..1] I_PrepaymentAgrmtDistrTypeVH _DistrType $projection.prepaymentdistrtype = _DistrType.PrepaymentAgrmtDomainCode and _DistrType.PrepaymentAgrmtDomainLangCode = $session.system_language --Business partner
[0..1] I_BusinessPartner _BPText $projection.prepaymentdistrbeneficiaryname = _BPText.BusinessPartner --Business Object Text
[0..1] I_BusinessObjTypeText _BusinessObjTypeText $projection.SAPBusinessObjectTypeCode = _BusinessObjTypeText.BusinessObjectType and _BusinessObjTypeText.Language = $session.system_language --Prepayment user text
[0..1] I_PrepaymentAgrmtUserNameText _UserText $projection.CreatedByUser = _UserText.UserName

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPPMGAPPRMSGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Prepayment Settlement Document C View view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtDocUUID I_PrepaymentPostedDocuments PrepaymentAgrmtDocUUID Key
PrepaymentApprovalUUID I_PrepaymentPostedDocuments PrepaymentApprovalUUID Key
PrepaymentAgrmtDistrUUID I_PrepaymentPostedDocuments PrepaymentAgrmtDistrUUID Key
PrepaymentAgreement I_PrepaymentPostedDocuments PrepaymentAgreement Renegotiation PPA
PrepaymentAgreementType I_PrepaymentPostedDocuments PrepaymentAgreementType Prepay Agreemnt Type
SAPBusinessObjectTypeCode I_PrepaymentPostedDocuments SAPBusinessObjectTypeCode SAP Obj Rep
DocumentItemNumber I_PrepaymentPostedDocuments DocumentItemNumber Item
PrepaymentPostedDocument I_PrepaymentPostedDocuments PrepaymentPostedDocument Posted Document No.
PrepaymentFeesDocument I_PrepaymentPostedDocuments PrepaymentFeesDocument Posted Document No.
PrepaymentReversedDocument I_PrepaymentPostedDocuments PrepaymentReversedDocument Reversed DocumentNo.
PrepaymentFeesReversedDocument I_PrepaymentPostedDocuments PrepaymentFeesReversedDocument Reversed DocumentNo.
PrepaymentAgrmtRefDocument I_PrepaymentPostedDocuments PrepaymentAgrmtRefDocument Linking Document No.
CompanyCode I_PrepaymentPostedDocuments CompanyCode Receiver Company Code
FiscalYear I_PrepaymentPostedDocuments FiscalYear G/L Fiscal Year
PrepaymentAgrmtAccrPostgPrfl I_PrepaymentPostedDocuments PrepaymentAgrmtAccrPostgPrfl
CreatedByUser I_PrepaymentPostedDocuments CreatedByUser User Name
CreationDateTime I_PrepaymentPostedDocuments CreationDateTime Timestamp
LastChangedByUser I_PrepaymentPostedDocuments LastChangedByUser User Name
LastChangeDateTime I_PrepaymentPostedDocuments LastChangeDateTime Timestamp
PrepaymentAgreementAmount PrepaymentAgreementAmount Pre Agrm Amount
PrepaymentAgreementCurrency PrepaymentAgreementCurrency Currency
BusinessObjectTypeDescription _BusinessObjTypeText BusinessObjectTypeDescription
PrepaymentDistrType _PrepaymentDistribution PrepaymentDistrType Distribution Type
PrepaymentDistrBeneficiaryName _PrepaymentDistribution PrepaymentDistrBeneficiaryName Busn. Partner
_CoCode _CoCode
_PrepaymentDistribution _PrepaymentDistribution
_DistrType _DistrType
_BPText _BPText
_BusinessObjTypeText _BusinessObjTypeText
_UserText _UserText

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 C_PrepaymentPostedDocumentsTP.
-- 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: CPPMGAPPRMSGTP

CREATE VIEW C_PrepaymentPostedDocumentsTP AS
SELECT
  ApprovalDoc.PrepaymentAgrmtDocUUID AS PrepaymentAgrmtDocUUID,
  ApprovalDoc.PrepaymentApprovalUUID AS PrepaymentApprovalUUID,
  ApprovalDoc.PrepaymentAgrmtDistrUUID AS PrepaymentAgrmtDistrUUID,
  ApprovalDoc.PrepaymentAgreement AS PrepaymentAgreement,
  ApprovalDoc.PrepaymentAgreementType AS PrepaymentAgreementType,
  ApprovalDoc.SAPBusinessObjectTypeCode AS SAPBusinessObjectTypeCode,
  ApprovalDoc.DocumentItemNumber AS DocumentItemNumber,
  ApprovalDoc.PrepaymentPostedDocument AS PrepaymentPostedDocument,
  ApprovalDoc.PrepaymentFeesDocument AS PrepaymentFeesDocument,
  ApprovalDoc.PrepaymentReversedDocument AS PrepaymentReversedDocument,
  ApprovalDoc.PrepaymentFeesReversedDocument AS PrepaymentFeesReversedDocument,
  ApprovalDoc.PrepaymentAgrmtRefDocument AS PrepaymentAgrmtRefDocument,
  ApprovalDoc.CompanyCode AS CompanyCode,
  ApprovalDoc.FiscalYear AS FiscalYear,
  ApprovalDoc.PrepaymentAgrmtAccrPostgPrfl AS PrepaymentAgrmtAccrPostgPrfl,
  ApprovalDoc.CreatedByUser AS CreatedByUser,
  ApprovalDoc.CreationDateTime AS CreationDateTime,
  ApprovalDoc.LastChangedByUser AS LastChangedByUser,
  ApprovalDoc.LastChangeDateTime AS LastChangeDateTime,
  PrepaymentAgreementAmount,
  PrepaymentAgreementCurrency,
  _BusinessObjTypeText.BusinessObjectTypeDescription AS BusinessObjectTypeDescription,
  _PrepaymentDistribution.PrepaymentDistrType AS PrepaymentDistrType,
  _PrepaymentDistribution.PrepaymentDistrBeneficiaryName AS PrepaymentDistrBeneficiaryName
FROM I_PrepaymentPostedDocuments AS ApprovalDoc
LEFT OUTER JOIN I_CompanyCode AS _CoCode ON CompanyCode = _CoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtDistr AS _PrepaymentDistribution ON PrepaymentAgrmtDistrUUID = _PrepaymentDistribution.PrepaymentAgrmtDistrUUID  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtDistrTypeVH AS _DistrType ON prepaymentdistrtype = _DistrType.PrepaymentAgrmtDomainCode AND _DistrType.PrepaymentAgrmtDomainLangCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BPText ON prepaymentdistrbeneficiaryname = _BPText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjTypeText AS _BusinessObjTypeText ON SAPBusinessObjectTypeCode = _BusinessObjTypeText.BusinessObjectType AND _BusinessObjTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtUserNameText AS _UserText ON CreatedByUser = _UserText.UserName  -- association [0..1]
;

Learn More