I_ACMTRADINGCONTRACTITEMDATA

CDS View
15 Fields 15 CDS Views

Basic View on Contract Item

I_ACMTRADINGCONTRACTITEMDATA is a CDS View in S/4HANA. Basic View on Contract Item. It contains 15 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_ACMTradingContractItemOvw view from COMPOSITE Interface for Contract Item Overview
I_ACMTrdgContractItemDetails view from COMPOSITE Interface view for Trading Contract Item Details
I_ACMTrdgContrHdrForPrcgCndn view from COMPOSITE Trading Contract Header Details for Pricing Condition
I_ACMTrdgContrItemForPrcgOvw view from COMPOSITE Trading Contract Item Details for pricing overviews
I_ACMTrdgContrItemForPrcgOvw_1 view from COMPOSITE Trading Contract Item Details for pricing overviews
I_ACMTrdgContrItmDelivDteDet view from COMPOSITE Contract Delivery Date Calculation
I_ACMTrdgContrItmDet view from COMPOSITE Trading Contract Item
I_ACMTrdgContrItmDlvDet view from COMPOSITE Contract Delivery Date Calculation
I_ACMTrdgContrItmExtn view from COMPOSITE Trading Contract Item
I_ACMTrdgContrItmInfo view inner COMPOSITE Interface view for Tradg Cont Item Info
I_ACMTrdgContrMnlSelection view inner COMPOSITE Interface layer of Trading Contracts for manual selection
I_ContItem view inner COMPOSITE Contract Item
I_TradingContractItemOverview view from COMPOSITE Interface View For Contract Item Overview
P_ACMTrdgContrPrcOvw view inner COMPOSITE
P_TrdgContrPricingOverview view inner COMPOSITE

Fields (15)

KeyField CDS FieldsUsed in Views
KEY TradingContractItem TradingContractItem 12
KEY TradingContractNumber TradingContractNumber 8
KEY TrdgContrCommoditySubitem TrdgContrCommoditySubitem 2
ACMDocumentUnitOfMeasure ACMDocumentUnitOfMeasure 1
BaseUnit BaseUnit 1
Commodity Commodity 1
ContractMaterial ContractMaterial 7
ContractPlant ContractPlant 11
ContractStorageLocation ContractStorageLocation 4
PrcgCndnTradingContrCurrency PrcgCndnTradingContrCurrency 4
ProfitCenter ProfitCenter 1
TradingContractSalesCurrency TradingContractSalesCurrency 2
TrdgContrPurgQuantity TrdgContrPurgQuantity 1
TrdgContrSalesQuantity TrdgContrSalesQuantity 3
TrdgContrSlsQuantityUnit TrdgContrSlsQuantityUnit 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.

-- Basic View on Contract Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMTRADINGCONTRACTITEMDATA (
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    TRDGCONTRCOMMODITYSUBITEM,
    ACMDOCUMENTUNITOFMEASURE,
    BASEUNIT,
    COMMODITY,
    CONTRACTMATERIAL,
    CONTRACTPLANT,
    CONTRACTSTORAGELOCATION,
    PRCGCNDNTRADINGCONTRCURRENCY,
    PROFITCENTER,
    TRADINGCONTRACTSALESCURRENCY,
    TRDGCONTRPURGQUANTITY,
    TRDGCONTRSALESQUANTITY,
    TRDGCONTRSLSQUANTITYUNIT,
    PRIMARY KEY (TRADINGCONTRACTITEM, TRADINGCONTRACTNUMBER, TRDGCONTRCOMMODITYSUBITEM)
);

Learn More