I_ACMCONTRACTITEMADDLDATA

CDS View

Basic View on ACM Contract Item (WBHI Additional Data)

I_ACMCONTRACTITEMADDLDATA is a CDS View in S/4HANA. Basic View on ACM Contract Item (WBHI Additional Data). It contains 32 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMContrPaytTrm view_entity from COMPOSITE Trading Contract Payment Term
I_ACMTrdgContrPaytTrmDet view from COMPOSITE Trading Contract Payment Term
I_SUBACCOUNT view inner COMPOSITE Sub Account
I_TradingContractItemOverview view left_outer COMPOSITE Interface View For Contract Item Overview

Fields (32)

KeyField CDS FieldsUsed in Views
KEY TradingContractItem TradingContractItem 3
KEY TradingContractNumber TradingContractNumber 3
ACMCmmdtySubAccountStatus ACMCmmdtySubAccountStatus 1
ACMCmmdtySubAccountStatusRsn ACMCmmdtySubAccountStatusRsn 1
ACMContrCmmdtySubAccountMirror ACMContrCmmdtySubAccountMirror 1
ACMDerivativeContrSpec ACMDerivativeContrSpec 1
ACMDummySubAccountExtn ACMDummySubAccountExtn 1
ACMHasEndDate ACMHasEndDate 1
ACMHasStartDate ACMHasStartDate 1
ACMHierTSW ACMHierTSW 1
ACMIncludeQtyBased ACMIncludeQtyBased 1
ACMMarketIdentifierCode ACMMarketIdentifierCode 1
ACMPrcgIntendedPrcType ACMPrcgIntendedPrcType 1
ACMPricingApproach ACMPricingApproach 1
ACMTrdgContrCmmdtySubAccountId ACMTrdgContrCmmdtySubAccountId 1
ACMTrdgContrSubAccountName ACMTrdgContrSubAccountName 1
ACMWgtTypePricing ACMWgtTypePricing 1
AlternatePaymentTerm AlternatePaymentTerm,DeferredPaymentTerm 3
AlternatePaymentType AlternatePaymentType 1
CommodityMirrorSubAccountName CommodityMirrorSubAccountName 1
CommoditySubAccountUUID CommoditySubAccountUUID 1
CompanyCode CompanyCode 1
ContractSubItem ContractSubItem 1
FuturesAccount FuturesAccount 1
PaymentDate PaymentDate,PaymentDeferDate 3
PhysicalCommodity PhysicalCommodity 1
Portfolio Portfolio 1
ReferenceBrokerAccount ReferenceBrokerAccount 1
StorageFreeDaysValue StorageFreeDaysValue 1
StorageRatesLockedValue StorageRatesLockedValue 1
ValuationPoint ValuationPoint 2
WBSElementProfitCenter WBSElementProfitCenter 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 ACM Contract Item (WBHI Additional Data)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMCONTRACTITEMADDLDATA (
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    ACMCMMDTYSUBACCOUNTSTATUS,
    ACMCMMDTYSUBACCOUNTSTATUSRSN,
    ACMCONTRCMMDTYSUBACCOUNTMIRROR,
    ACMDERIVATIVECONTRSPEC,
    ACMDUMMYSUBACCOUNTEXTN,
    ACMHASENDDATE,
    ACMHASSTARTDATE,
    ACMHIERTSW,
    ACMINCLUDEQTYBASED,
    ACMMARKETIDENTIFIERCODE,
    ACMPRCGINTENDEDPRCTYPE,
    ACMPRICINGAPPROACH,
    ACMTRDGCONTRCMMDTYSUBACCOUNTID,
    ACMTRDGCONTRSUBACCOUNTNAME,
    ACMWGTTYPEPRICING,
    ALTERNATEPAYMENTTERM,
    ALTERNATEPAYMENTTYPE,
    COMMODITYMIRRORSUBACCOUNTNAME,
    COMMODITYSUBACCOUNTUUID,
    COMPANYCODE,
    CONTRACTSUBITEM,
    FUTURESACCOUNT,
    PAYMENTDATE,
    PHYSICALCOMMODITY,
    PORTFOLIO,
    REFERENCEBROKERACCOUNT,
    STORAGEFREEDAYSVALUE,
    STORAGERATESLOCKEDVALUE,
    VALUATIONPOINT,
    WBSELEMENTPROFITCENTER,
    PRIMARY KEY (TRADINGCONTRACTITEM, TRADINGCONTRACTNUMBER)
);