I_PREPAYMENTAPPROVALDOCUMENT

CDS View
16 Fields 3 CDS Views

Prepayment Approval Doc basic view

I_PREPAYMENTAPPROVALDOCUMENT is a CDS View in S/4HANA. Prepayment Approval Doc basic view. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PrepaymentApprovalDocumentTP view from TRANSACTIONAL Prepayment Appr Doc Transactional view
I_PrepaymentAssignDocLatestDis view from COMPOSITE Latest APP DOC details of each distribution
I_PrepaymentPayTermPostingMade view inner COMPOSITE Prepayment Payment Terms Posting Made

Fields (16)

KeyField CDS FieldsUsed in Views
KEY PrepaymentAgrmtDocUUID PrepaymentAgrmtDocUUID 1
CompanyCode CompanyCode 1
CreationDateTime CreationDateTime 1
FiscalYear FiscalYear 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PrepaymentAgreementAmount PrepaymentAgreementAmount 1
PrepaymentAgreementCurrency PrepaymentAgreementCurrency 1
PrepaymentAgrmtDistrUUID PrepaymentAgrmtDistrUUID 1
PrepaymentAgrmtRefDocument PrepaymentAgrmtRefDocument 1
PrepaymentApprovalUUID PrepaymentApprovalUUID 1
PrepaymentFeesDocument PrepaymentFeesDocument 1
PrepaymentFeesReversedDocument PrepaymentFeesReversedDocument 1
PrepaymentPostedDocument PrepaymentPostedDocument 2
PrepaymentReversedDocument PrepaymentReversedDocument 1
SAPBusinessObjectTypeCode SAPBusinessObjectTypeCode 1

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.

-- Prepayment Approval Doc basic view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTAPPROVALDOCUMENT (
    PREPAYMENTAGRMTDOCUUID,
    COMPANYCODE,
    CREATIONDATETIME,
    FISCALYEAR,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PREPAYMENTAGREEMENTAMOUNT,
    PREPAYMENTAGREEMENTCURRENCY,
    PREPAYMENTAGRMTDISTRUUID,
    PREPAYMENTAGRMTREFDOCUMENT,
    PREPAYMENTAPPROVALUUID,
    PREPAYMENTFEESDOCUMENT,
    PREPAYMENTFEESREVERSEDDOCUMENT,
    PREPAYMENTPOSTEDDOCUMENT,
    PREPAYMENTREVERSEDDOCUMENT,
    SAPBUSINESSOBJECTTYPECODE,
    PRIMARY KEY (PREPAYMENTAGRMTDOCUUID)
);

Learn More