I_PPAYTDOCCMMDTYPRCVALPO

CDS View
21 Fields 1 CDS Views

Document Condition Market Prices for PO

I_PPAYTDOCCMMDTYPRCVALPO is a CDS View in S/4HANA. Document Condition Market Prices for PO. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrepaymentDocFixedValDataPO view_entity from COMPOSITE PPMT Document Fixed pricing data for PO

Fields (21)

KeyField CDS FieldsUsed in Views
KEY ConditionType ConditionType 1
KEY DocItemCommodityPricingUUID DocItemCommodityPricingUUID 1
KEY PrepaymentRefDocCondition PrepaymentRefDocCondition 1
KEY PrepaymentRefDocConditionItem PrepaymentRefDocConditionItem 1
KEY PurchasingDocument PurchasingDocument 1
BasisID BasisID 1
BasisType BasisType 1
CalculationPeriodEndDate CalculationPeriodEndDate 1
CompanyCode CompanyCode 1
ConditionTermRateCurrency ConditionTermRateCurrency 1
Counterparty Counterparty 1
DerivativeContrSpecification DerivativeContrSpecification 1
MarketIdentifierCode MarketIdentifierCode 1
MaturityKeyDate MaturityKeyDate 1
PrcgCndnFmlaCmmdtyQuantityUnit PrepaymentDocCmmdtyMktQtyUnit 1
PrcgCndnTermCnvrsnSourceCrcy PrcgCndnTermCnvrsnSourceCrcy 1
PrcgCndnTermCnvrsnTargetCrcy PrcgCndnTermCnvrsnTargetCrcy 1
PrcgCndnTermFixationOptnStatus PrcgCndnTermFixationOptnStatus 1
PrepaymentRefDocFixedPriceCrcy PrepaymentRefDocFixedPriceCrcy 1
PrepaymentWrkCtrDocPricingOptn PrepaymentWrkCtrDocPricingOptn 1
PurchasingDocumentType PurchasingDocumentType 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.

-- Document Condition Market Prices for PO
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PPAYTDOCCMMDTYPRCVALPO (
    CONDITIONTYPE,
    DOCITEMCOMMODITYPRICINGUUID,
    PREPAYMENTREFDOCCONDITION,
    PREPAYMENTREFDOCCONDITIONITEM,
    PURCHASINGDOCUMENT,
    BASISID,
    BASISTYPE,
    CALCULATIONPERIODENDDATE,
    COMPANYCODE,
    CONDITIONTERMRATECURRENCY,
    COUNTERPARTY,
    DERIVATIVECONTRSPECIFICATION,
    MARKETIDENTIFIERCODE,
    MATURITYKEYDATE,
    PRCGCNDNFMLACMMDTYQUANTITYUNIT,
    PRCGCNDNTERMCNVRSNSOURCECRCY,
    PRCGCNDNTERMCNVRSNTARGETCRCY,
    PRCGCNDNTERMFIXATIONOPTNSTATUS,
    PREPAYMENTREFDOCFIXEDPRICECRCY,
    PREPAYMENTWRKCTRDOCPRICINGOPTN,
    PURCHASINGDOCUMENTTYPE,
    PRIMARY KEY (CONDITIONTYPE, DOCITEMCOMMODITYPRICINGUUID, PREPAYMENTREFDOCCONDITION, PREPAYMENTREFDOCCONDITIONITEM, PURCHASINGDOCUMENT)
);

Learn More