I_PREAGRMTTRADINGCONTRACTITEM

CDS View
18 Fields 9 CDS Views

Trading Contract Items

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

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_PrepayLinkAssignTrdCtrItem view_entity inner COMPOSITE Prepayment Assigned Trading Contract Itm
P_PpaytPrpsdLnkgContrAmt view inner COMPOSITE Prepayment Proposed Contract Amount
P_PrepayBarterRefDocTotAmtTC view_entity inner COMPOSITE Prepayment Barter Document Total Amount
P_PrepaymentCMMContractAmount view inner COMPOSITE Prepayment Contract CMM Amount
P_PrepaymentCPEContractAmount view inner COMPOSITE Prepayment Contract CPE Amount
P_PrepaymentDocContractAmount view inner COMPOSITE Prepayment Contract Document Amount
P_PrepaymentDocumentFixedVal view inner COMPOSITE Document Fixed Pricing
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotalAmtTC view_entity inner COMPOSITE Prepayment Document Total Amount

Fields (18)

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

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