I_PREPAYMENTASSIGNEDDOCUMENT

CDS View
41 Fields 26 CDS Views

Basic View PPMT Consumption Docs

I_PREPAYMENTASSIGNEDDOCUMENT is a CDS View in S/4HANA. Basic View PPMT Consumption Docs. It contains 41 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
C_PrepaymentAgrmtLinkHistory view from CONSUMPTION Linkage history of prepayments
I_PreAgrmtContrItmDocAmt view_entity from COMPOSITE Linked amount for contract Item to PPMG
I_PreAgrmtPurchasingDocAmount view from COMPOSITE Purchasing Document Linked Amount
I_PrepayBarterSalesDocLinkAmt view from COMPOSITE Sales Document Linked Amount for Barter
I_PrepayBarterTrdgContrLinkAmt view from COMPOSITE Prepayment Barter Trading Contract Linked Amount
I_PrepaymentAgrmtContracts view from BASIC Prepayment Agreement Contracts
I_PrepaymentAgrmtNominations view from BASIC Prepayment Agreement Nominations
I_PrepaymentAssignedDocHistory view from COMPOSITE Prepayment Assigned Docment History
I_PrepaymentAssignedDocumentTP view from TRANSACTIONAL PPMT Consumption Doc Transactional view
I_PrepaymentContractHeader view from BASIC Prepayment Contract Header Information
P_ACMContrPpaytRetAmt view_entity from COMPOSITE Prepayment Returned Amount
P_ACMTrdgContrPpaytRetAmt view from COMPOSITE Prepayment Returned Amount
P_ACMTrdgContrPpaytStlAmt view from COMPOSITE Prepayment Settled Amount
P_ACMTrdgContrPrePaytAgrmt view from BASIC Private View: Prepayment Agreement
P_PreAgrmtCashSettlmtAmount view from COMPOSITE
P_PreAgrmtConsumeAmount view from COMPOSITE
P_PreAgrmtDocAmount view from COMPOSITE
P_PreAgrmtDocReturnAmount view from COMPOSITE
P_PreAgrmtDocSettleAmount view from COMPOSITE
P_PreAgrmtEventAmount view from COMPOSITE
P_PreAgrmtInterestAmount view from COMPOSITE
P_PreAgrmtRetInterestAmount view from COMPOSITE
P_PreAgrmtReturnAmount view from COMPOSITE
P_PreAgrmtSettleAmount view from COMPOSITE
P_PrepaymentAssignedDocument view from COMPOSITE
P_PrepaymentReferenceDocument view from BASIC

Fields (41)

KeyField CDS FieldsUsed in Views
KEY PrepaymentAgreement PrepaymentAgreement 13
KEY PrepaymentAgreementUUID PrepaymentAgreementUUID 1
KEY PrepaymentAgrmtRefDocItem DocumentItemNumber,PrepaymentAgrmtRefDocItem 11
KEY PrepaymentAgrmtRefDocument DocNumber,PrepaymentAgrmtRefDoc,PrepaymentAgrmtRefDocument 9
KEY PrepaymentAgrmtRefLinkUUID PrepaymentAgrmtRefLinkUUID 6
KEY PrepaymentAssignedDocumentUUID PrepaymentAssignedDocumentUUID 8
CreationDateTime CreationDateTime 4
DocNumber DocNumber,PrepaymentAgreement 4
DocumentItemNumber DocumentItemNumber,PrepaymentDocumentItemNumber 7
LastChangeDateTime LastChangeDateTime 4
LastChangedByUser LastChangedByUser 4
PrepayAgrmtAccrInterestAmount PrepayAgrmtAccrInterestAmount 4
PrepayAgrmtAccrInterestCrcy PrepayAgrmtAccrInterestCrcy 7
PrepayAgrmtValidFromDateTime PrepayAgrmtValidFromDateTime 4
PrepayAgrmtValidToDateTime PrepayAgrmtValidToDateTime 4
PrepaymentAgreementCategory PrepaymentAgreementCategory 1
PrepaymentAgreementCurrency PrepayAccrualPostedCurrency,PrepaymentAgreementCurrency,PrepaymentCreditCurrency,PrepaymentDistrCurrency 14
PrepaymentAgreementIsActive PrepaymentAgreementIsActive 4
PrepaymentAgreementType PrepaymentAgreementType 1
PrepaymentAgrmtActualEventAmt PrepaymentAgrmtActualEventAmt 2
PrepaymentAgrmtActualEventCrcy PrepaymentAgrmtActualEventCrcy 2
PrepaymentAgrmtLinkAmount PrepaymentAgrmtLinkAmount 6
PrepaymentAgrmtLinkStatus PrepaymentAgrmtLinkStatus 1
PrepaymentAgrmtLinkType PrepaymentAgrmtLinkType 6
PrepaymentAgrmtPostingStatus PrepaymentAgrmtPostingStatus 1
PrepaymentAgrmtRefBusObject PrepaymentAgrmtRefBusObject,SAPBusinessObjectTypeCode 9
PrepaymentAgrmtRefDocAmount PrepayAgrmtRefDocAmount,PrepaymentAgrmtRefDocAmount 2
PrepaymentAgrmtRefDocCurrency PrepayAgrmtRefDocCurrency,PrepaymentAgrmtRefDocCurrency 2
PrepaymentAgrmtRefDocumentType PrepaymentAgrmtRefDocumentType 4
PrepaymentAgrmtRefDocYear PrepaymentAgrmtRefDocYear 6
PrepaymentAgrmtRefLink PrepaymentAgrmtRefLink 4
PrepaymentAgrmtUnlinkReason PrepaymentAgrmtUnlinkReason 3
PrepaymentBarterLinkStatus PrepaymentBarterLinkStatus 1
PrepaymentConsumptionDocUUID PrepaymentConsumptionDocUUID 4
PrepaymentEconomicGroup PrepaymentEconomicGroup 3
PrepaymentIsAssignedViaEconGrp PrepaymentIsAssignedViaEconGrp 1
PrepaymentStopIntrstDateType PrepaymentStopIntrstDateType 3
ReferenceApplicationDocument ReferenceApplicationDocument 4
ReferenceSettlementUUID ReferenceSettlementUUID 3
SAPBusinessObjectTypeCode SAPBusinessObjectTypeCode 4
SDDocumentCategory SDDocumentCategory 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Basic View PPMT Consumption Docs
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTASSIGNEDDOCUMENT (
    PREPAYMENTAGREEMENT,
    PREPAYMENTAGREEMENTUUID,
    PREPAYMENTAGRMTREFDOCITEM,
    PREPAYMENTAGRMTREFDOCUMENT,
    PREPAYMENTAGRMTREFLINKUUID,
    PREPAYMENTASSIGNEDDOCUMENTUUID,
    CREATIONDATETIME,
    DOCNUMBER,
    DOCUMENTITEMNUMBER,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PREPAYAGRMTACCRINTERESTAMOUNT,
    PREPAYAGRMTACCRINTERESTCRCY,
    PREPAYAGRMTVALIDFROMDATETIME,
    PREPAYAGRMTVALIDTODATETIME,
    PREPAYMENTAGREEMENTCATEGORY,
    PREPAYMENTAGREEMENTCURRENCY,
    PREPAYMENTAGREEMENTISACTIVE,
    PREPAYMENTAGREEMENTTYPE,
    PREPAYMENTAGRMTACTUALEVENTAMT,
    PREPAYMENTAGRMTACTUALEVENTCRCY,
    PREPAYMENTAGRMTLINKAMOUNT,
    PREPAYMENTAGRMTLINKSTATUS,
    PREPAYMENTAGRMTLINKTYPE,
    PREPAYMENTAGRMTPOSTINGSTATUS,
    PREPAYMENTAGRMTREFBUSOBJECT,
    PREPAYMENTAGRMTREFDOCAMOUNT,
    PREPAYMENTAGRMTREFDOCCURRENCY,
    PREPAYMENTAGRMTREFDOCUMENTTYPE,
    PREPAYMENTAGRMTREFDOCYEAR,
    PREPAYMENTAGRMTREFLINK,
    PREPAYMENTAGRMTUNLINKREASON,
    PREPAYMENTBARTERLINKSTATUS,
    PREPAYMENTCONSUMPTIONDOCUUID,
    PREPAYMENTECONOMICGROUP,
    PREPAYMENTISASSIGNEDVIAECONGRP,
    PREPAYMENTSTOPINTRSTDATETYPE,
    REFERENCEAPPLICATIONDOCUMENT,
    REFERENCESETTLEMENTUUID,
    SAPBUSINESSOBJECTTYPECODE,
    SDDOCUMENTCATEGORY,
    PRIMARY KEY (PREPAYMENTAGREEMENT, PREPAYMENTAGREEMENTUUID, PREPAYMENTAGRMTREFDOCITEM, PREPAYMENTAGRMTREFDOCUMENT, PREPAYMENTAGRMTREFLINKUUID, PREPAYMENTASSIGNEDDOCUMENTUUID)
);

Learn More