I_PREAGRMTTRADINGCONTRACTITEM

CDS View
18 Fields 11 CDS Views

Trading Contract Items

I_PREAGRMTTRADINGCONTRACTITEM is a CDS View in S/4HANA. Trading Contract Items. It contains 18 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_PpaytDocCmmdtyPrcgData_1 view_entity inner COMPOSITE PPMT Document Commodity Pricing data
I_PrepayLinkAssignTrdCtrItem view_entity inner COMPOSITE Prepayment Assigned TC Item
I_PrepaymentRefDocTotalAmtCtr view_entity inner COMPOSITE Prepayment Document Total Amount
P_PpaytPrpsdLnkgContrAmt view inner COMPOSITE
P_PrepayBarterRefDocTotAmtTC view_entity inner COMPOSITE
P_PrepaymentCMMContractAmount view inner COMPOSITE
P_PrepaymentCPEContractAmount view inner COMPOSITE
P_PrepaymentDocContractAmount view inner COMPOSITE
P_PrepaymentDocumentFixedVal view inner COMPOSITE
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotalAmtTC view_entity inner COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ContractSubItem ContractSubItem 1
KEY TradingContract TradingContract 1
KEY TradingContractItem DocumentItemNumber,TradingContractItem 9
_Material _Material 1
_Plant _Plant 1
_StorageLocation _StorageLocation 1
_TradingContract _TradingContract 1
_TrdgContrItemQtyUnit _TrdgContrItemQtyUnit 1
Counterparty Counterparty 1
Material Material 7
Plant Plant 1
PrepaymentRefDocItmValdFromDte PrepaymentRefDocItmValdFromDte 7
PrepaymentRefDocItmValdToDte PrepaymentRefDocItmValdToDte 7
StorageLocation StorageLocation 1
TradingContractItemQuantity OrderQuantity,TradingContractItemQuantity 7
TrdgContractItemUnitOfMeasure OrderQuantityUnit,TrdgContractItemUnitOfMeasure 7
TrdgContrTotalNetAmount TrdgContrTotalNetAmount 1
TrdgContrTotalNetAmountCrcy PrepaymentTotalAmtCrcy,TrdgContrTotalNetAmountCrcy 7

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.

-- Trading Contract Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREAGRMTTRADINGCONTRACTITEM (
    CONTRACTSUBITEM,
    TRADINGCONTRACT,
    TRADINGCONTRACTITEM,
    _MATERIAL,
    _PLANT,
    _STORAGELOCATION,
    _TRADINGCONTRACT,
    _TRDGCONTRITEMQTYUNIT,
    COUNTERPARTY,
    MATERIAL,
    PLANT,
    PREPAYMENTREFDOCITMVALDFROMDTE,
    PREPAYMENTREFDOCITMVALDTODTE,
    STORAGELOCATION,
    TRADINGCONTRACTITEMQUANTITY,
    TRDGCONTRACTITEMUNITOFMEASURE,
    TRDGCONTRTOTALNETAMOUNT,
    TRDGCONTRTOTALNETAMOUNTCRCY,
    PRIMARY KEY (CONTRACTSUBITEM, TRADINGCONTRACT, TRADINGCONTRACTITEM)
);

Learn More