I_ACMCONTRACTCOMMODITYSUBITEM

CDS View
31 Fields 7 CDS Views

Baisc View on Trading Contract: commodity sub items

I_ACMCONTRACTCOMMODITYSUBITEM is a CDS View in S/4HANA. Baisc View on Trading Contract: commodity sub items. It contains 31 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ACMTrdgContrItemForPrcgOvw view inner COMPOSITE Trading Contract Item Details for pricing overviews
I_ACMTrdgContrItemForPrcgOvw_1 view inner COMPOSITE Trading Contract Item Details for pricing overviews
I_ACMTrdgContrMnlSelection view inner COMPOSITE Interface layer of Trading Contracts for manual selection
I_itemcommodity view inner COMPOSITE Commodity item
I_TradingContractItemOverview view inner COMPOSITE Interface View For Contract Item Overview
P_ACMTrdgContrPrcOvw view inner COMPOSITE
P_TrdgContrPricingOverview view inner COMPOSITE

Fields (31)

KeyField CDS FieldsUsed in Views
KEY TradingContractItem TradingContractItem 2
KEY TrdgContrCommoditySubitem TrdgContrCommoditySubitem 2
ACMCmmdtyItmCat ACMCmmdtyItmCat 1
ACMCmmdtyItmExtIdfr ACMCmmdtyItmExtIdfr 1
ACMCmmdtyItmPrpty ACMCmmdtyItmPrpty 1
ACMCmmdtySubItmClosed ACMCmmdtySubItmClosed 1
ACMCommodityUUID ACMCommodityUUID 1
ACMDummySubAccountExtn ACMDummySubAccountExtn 1
ACMPricingCancellationQuantity ACMPricingCancellationQuantity,ACMPricingItemQuantity,CommodityQuantity,TradingContractItemQuantity 5
ACMSettlementDocReferenceParty ACMSettlementDocReferenceParty 1
ACMTrdgContrAssgmtRlvt ACMTrdgContrAssgmtRlvt 1
ACMTrdgContrCreatedOnDate ACMTrdgContrCreatedOnDate 1
ACMTrdgContrFutureAttrib ACMTrdgContrFutureAttrib 1
BaseUnitofMeasure BaseUnitofMeasure 1
Batch Batch 1
ContractMaterial ContractMaterial 1
CustomerNum CustomerNum 1
DataAgingObject DataAgingObject 1
Denominator Denominator 1
LastChangeTime LastChangeTime 1
Numerator Numerator 1
Side Side 4
TimeOfCreation TimeOfCreation 1
TradingContractChangedBy TradingContractChangedBy 1
TradingContractChangedOnDate TradingContractChangedOnDate 1
TradingContractCreatedBy TradingContractCreatedBy 1
TradingContractItemCategory TradingContractItemCategory 1
TradingContractNumber TradingContractNumber 1
TrdgContractCreditSalesToDate ActualStartDateTo,CmmdtyDealDetEffectiveToDate,TrdgContractCreditSalesToDate 7
TrdgContractItemUnitOfMeasure TrdgContractItemUnitOfMeasure,UnitOfMeasure 5
TrdgContrCreditSalesFromDate ActualStartDateFrom,CmmdtyDealDetEffectiveFromDate,TrdgContrCreditSalesFromDate 5

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.

-- Baisc View on Trading Contract: commodity sub items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMCONTRACTCOMMODITYSUBITEM (
    TRADINGCONTRACTITEM,
    TRDGCONTRCOMMODITYSUBITEM,
    ACMCMMDTYITMCAT,
    ACMCMMDTYITMEXTIDFR,
    ACMCMMDTYITMPRPTY,
    ACMCMMDTYSUBITMCLOSED,
    ACMCOMMODITYUUID,
    ACMDUMMYSUBACCOUNTEXTN,
    ACMPRICINGCANCELLATIONQUANTITY,
    ACMSETTLEMENTDOCREFERENCEPARTY,
    ACMTRDGCONTRASSGMTRLVT,
    ACMTRDGCONTRCREATEDONDATE,
    ACMTRDGCONTRFUTUREATTRIB,
    BASEUNITOFMEASURE,
    BATCH,
    CONTRACTMATERIAL,
    CUSTOMERNUM,
    DATAAGINGOBJECT,
    DENOMINATOR,
    LASTCHANGETIME,
    NUMERATOR,
    SIDE,
    TIMEOFCREATION,
    TRADINGCONTRACTCHANGEDBY,
    TRADINGCONTRACTCHANGEDONDATE,
    TRADINGCONTRACTCREATEDBY,
    TRADINGCONTRACTITEMCATEGORY,
    TRADINGCONTRACTNUMBER,
    TRDGCONTRACTCREDITSALESTODATE,
    TRDGCONTRACTITEMUNITOFMEASURE,
    TRDGCONTRCREDITSALESFROMDATE,
    PRIMARY KEY (TRADINGCONTRACTITEM, TRDGCONTRCOMMODITYSUBITEM)
);

Learn More