P_PREPAYMENTREFDOCTOTALAMTPO

CDS View
19 Fields 1 CDS Views

Prepayment Document Total Amount

P_PREPAYMENTREFDOCTOTALAMTPO is a CDS View in S/4HANA. Prepayment Document Total Amount. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PrepaymentRefDocAmtDetailsPO view_entity from COMPOSITE Prepayment Document Amount Details

Fields (19)

KeyField CDS FieldsUsed in Views
KEY DocNumber DocNumber 1
KEY DocumentItemNumber DocumentItemNumber 1
KEY PrepaymentAgrmtRefBusObject PrepaymentAgrmtRefBusObject 1
KEY PrepaymentAgrmtRefDocumentCat PrepaymentAgrmtRefDocumentCat 1
KEY PrepaymentAgrmtWorkCenterType PrepaymentAgrmtWorkCenterType 1
Commodity Commodity 1
CompanyCode CompanyCode 1
Counterparty Counterparty 1
DocumentType DocumentType 1
Material Material 1
OrderQuantity OrderQuantity 1
OrderQuantityUnit OrderQuantityUnit 1
PrepaymentAgrmtRefDocument PrepaymentAgrmtRefDocument 1
PrepaymentRefDocItmValdFromDte PrepaymentRefDocItmValdFromDte 1
PrepaymentRefDocItmValdToDte PrepaymentRefDocItmValdToDte 1
PrepaymentTotalAmt PrepaymentAgreementAmount 1
PrepaymentTotalAmtCrcy PrepaymentAgreementCurrency 1
PrepaymentTotalAmtIsFixedPrice PrepaymentTotalAmtIsFixedPrice 1
PurchasingDocumentITem PurchasingDocumentITem 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 Document Total Amount
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PREPAYMENTREFDOCTOTALAMTPO (
    DOCNUMBER,
    DOCUMENTITEMNUMBER,
    PREPAYMENTAGRMTREFBUSOBJECT,
    PREPAYMENTAGRMTREFDOCUMENTCAT,
    PREPAYMENTAGRMTWORKCENTERTYPE,
    COMMODITY,
    COMPANYCODE,
    COUNTERPARTY,
    DOCUMENTTYPE,
    MATERIAL,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    PREPAYMENTAGRMTREFDOCUMENT,
    PREPAYMENTREFDOCITMVALDFROMDTE,
    PREPAYMENTREFDOCITMVALDTODTE,
    PREPAYMENTTOTALAMT,
    PREPAYMENTTOTALAMTCRCY,
    PREPAYMENTTOTALAMTISFIXEDPRICE,
    PURCHASINGDOCUMENTITEM,
    PRIMARY KEY (DOCNUMBER, DOCUMENTITEMNUMBER, PREPAYMENTAGRMTREFBUSOBJECT, PREPAYMENTAGRMTREFDOCUMENTCAT, PREPAYMENTAGRMTWORKCENTERTYPE)
);

Learn More