P_PrepaymentAssignedDocument

DDL: P_PREPAYMENTASSIGNEDDOCUMENT SQL: PPPMGAGDBD Type: view COMPOSITE
36 Fields 1 Data Sources

P_PrepaymentAssignedDocument is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAssignedDocument) and exposes 36 fields with key field PrepaymentAssignedDocumentUUID.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAssignedDocument ConsumptionDocument from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPMGAGDBD view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAssignedDocumentUUID I_PrepaymentAssignedDocument PrepaymentAssignedDocumentUUID Key
PrepaymentConsumptionDocUUID I_PrepaymentAssignedDocument PrepaymentConsumptionDocUUID Key
SAPBusinessObjectTypeCode I_PrepaymentAssignedDocument SAPBusinessObjectTypeCode SAP Obj Rep
DocNumber
DocumentItemNumber I_PrepaymentAssignedDocument DocumentItemNumber Item
PrepaymentAgreement I_PrepaymentAssignedDocument PrepaymentAgreement Renegotiation PPA
PrepaymentAgrmtLinkType I_PrepaymentAssignedDocument PrepaymentAgrmtLinkType Link Type
PrepaymentStopIntrstDateType I_PrepaymentAssignedDocument PrepaymentStopIntrstDateType Int. Stop Date Type
ReferenceApplicationDocument I_PrepaymentAssignedDocument ReferenceApplicationDocument Ref Preceeding Doc
ReferenceSettlementUUID I_PrepaymentAssignedDocument ReferenceSettlementUUID UUID
PrepaymentAgreementIsActive I_PrepaymentAssignedDocument PrepaymentAgreementIsActive Active
PrepaymentAgrmtRefLink I_PrepaymentAssignedDocument PrepaymentAgrmtRefLink Reference Link
PrepaymentAgrmtRefLinkUUID I_PrepaymentAssignedDocument PrepaymentAgrmtRefLinkUUID Key
PrepaymentAgrmtRefBusObject I_PrepaymentAssignedDocument PrepaymentAgrmtRefBusObject Business Object Type
PrepaymentAgrmtRefDocumentType I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocumentType Document Type
SDDocumentCategory I_PrepaymentAssignedDocument SDDocumentCategory Document Cat.
PrepaymentAgrmtRefDocItem I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocItem Linking Docu No. Itm
PrepaymentAgrmtRefDocument
PrepaymentAgrmtRefDoc I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocument Linking Document No.
PrepaymentAgrmtRefDocYear I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocYear Reference Doc Year
PrepayAgrmtRefDocAmount I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocAmount Linking Document Amt
PrepayAgrmtRefDocCurrency I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocCurrency Currency
PrepaymentAgrmtLinkAmount I_PrepaymentAssignedDocument PrepaymentAgrmtLinkAmount Pre Agrm Amount
PrepaymentAgreementCurrency I_PrepaymentAssignedDocument PrepaymentAgreementCurrency Currency
PrepaymentAgrmtActualEventAmt I_PrepaymentAssignedDocument PrepaymentAgrmtActualEventAmt Pre Agrm Event Amt
PrepaymentAgrmtActualEventCrcy I_PrepaymentAssignedDocument PrepaymentAgrmtActualEventCrcy Currency
PrepayAgrmtAccrInterestAmount I_PrepaymentAssignedDocument PrepayAgrmtAccrInterestAmount Accrual Inter. Amt
PrepayAgrmtAccrInterestCrcy I_PrepaymentAssignedDocument PrepayAgrmtAccrInterestCrcy Accrual Inter. Curr
PrepayAgrmtValidFromDateTime I_PrepaymentAssignedDocument PrepayAgrmtValidFromDateTime Valid From Date Time
PrepayAgrmtValidToDateTime I_PrepaymentAssignedDocument PrepayAgrmtValidToDateTime Valid To Date Time
PrepaymentAgrmtUnlinkReason I_PrepaymentAssignedDocument PrepaymentAgrmtUnlinkReason Reason Code
CreatedByUserasCreatedByUser
CreationDateTime I_PrepaymentAssignedDocument CreationDateTime Timestamp
LastChangedByUser I_PrepaymentAssignedDocument LastChangedByUser User Name
LastChangeDateTime I_PrepaymentAssignedDocument LastChangeDateTime Timestamp
PrepaymentEconomicGroup I_PrepaymentAssignedDocument PrepaymentEconomicGroup Economic Group

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_PrepaymentAssignedDocument.
-- 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: PPPMGAGDBD

CREATE VIEW P_PrepaymentAssignedDocument AS
SELECT
  ConsumptionDocument.PrepaymentAssignedDocumentUUID AS PrepaymentAssignedDocumentUUID,
  ConsumptionDocument.PrepaymentConsumptionDocUUID AS PrepaymentConsumptionDocUUID,
  ConsumptionDocument.SAPBusinessObjectTypeCode AS SAPBusinessObjectTypeCode,
  right( ConsumptionDocument.DocNumber, 10 ) AS DocNumber,
  ConsumptionDocument.DocumentItemNumber AS DocumentItemNumber,
  ConsumptionDocument.PrepaymentAgreement AS PrepaymentAgreement,
  ConsumptionDocument.PrepaymentAgrmtLinkType AS PrepaymentAgrmtLinkType,
  ConsumptionDocument.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  ConsumptionDocument.ReferenceApplicationDocument AS ReferenceApplicationDocument,
  ConsumptionDocument.ReferenceSettlementUUID AS ReferenceSettlementUUID,
  ConsumptionDocument.PrepaymentAgreementIsActive AS PrepaymentAgreementIsActive,
  ConsumptionDocument.PrepaymentAgrmtRefLink AS PrepaymentAgrmtRefLink,
  ConsumptionDocument.PrepaymentAgrmtRefLinkUUID AS PrepaymentAgrmtRefLinkUUID,
  ConsumptionDocument.PrepaymentAgrmtRefBusObject AS PrepaymentAgrmtRefBusObject,
  ConsumptionDocument.PrepaymentAgrmtRefDocumentType AS PrepaymentAgrmtRefDocumentType,
  ConsumptionDocument.SDDocumentCategory AS SDDocumentCategory,
  ConsumptionDocument.PrepaymentAgrmtRefDocItem AS PrepaymentAgrmtRefDocItem,
  right( ConsumptionDocument.PrepaymentAgrmtRefDocument, 10 ) AS PrepaymentAgrmtRefDocument,
  ConsumptionDocument.PrepaymentAgrmtRefDocument AS PrepaymentAgrmtRefDoc,
  ConsumptionDocument.PrepaymentAgrmtRefDocYear AS PrepaymentAgrmtRefDocYear,
  ConsumptionDocument.PrepaymentAgrmtRefDocAmount AS PrepayAgrmtRefDocAmount,
  ConsumptionDocument.PrepaymentAgrmtRefDocCurrency AS PrepayAgrmtRefDocCurrency,
  ConsumptionDocument.PrepaymentAgrmtLinkAmount AS PrepaymentAgrmtLinkAmount,
  ConsumptionDocument.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  ConsumptionDocument.PrepaymentAgrmtActualEventAmt AS PrepaymentAgrmtActualEventAmt,
  ConsumptionDocument.PrepaymentAgrmtActualEventCrcy AS PrepaymentAgrmtActualEventCrcy,
  ConsumptionDocument.PrepayAgrmtAccrInterestAmount AS PrepayAgrmtAccrInterestAmount,
  ConsumptionDocument.PrepayAgrmtAccrInterestCrcy AS PrepayAgrmtAccrInterestCrcy,
  ConsumptionDocument.PrepayAgrmtValidFromDateTime AS PrepayAgrmtValidFromDateTime,
  ConsumptionDocument.PrepayAgrmtValidToDateTime AS PrepayAgrmtValidToDateTime,
  ConsumptionDocument.PrepaymentAgrmtUnlinkReason AS PrepaymentAgrmtUnlinkReason,
  ConsumptionDocument.CreationDateTime AS CreationDateTime,
  ConsumptionDocument.LastChangedByUser AS LastChangedByUser,
  ConsumptionDocument.LastChangeDateTime AS LastChangeDateTime,
  ConsumptionDocument.PrepaymentEconomicGroup AS PrepaymentEconomicGroup
FROM I_PrepaymentAssignedDocument AS ConsumptionDocument
;

Learn More