I_ACMTRDGCONTRPRCOVW_1

CDS View

Interface Layer for Trdg Contr Prc Ovw

I_ACMTRDGCONTRPRCOVW_1 is a CDS View in S/4HANA. Interface Layer for Trdg Contr Prc Ovw. It contains 47 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMMntnTrdgContrPrcgOvw_1 view_entity from COMPOSITE Mntn Trdg Contr Prc Ovw
I_ACMTrdgContrPrcFixDet view_entity from COMPOSITE Trading Contract PriceFix Detail
I_ACMTrdgContrPrcgDetsPrpsl_1 view_entity from COMPOSITE Trading Contract Price Fix Det Proposal

Fields (47)

KeyField CDS FieldsUsed in Views
KEY ACMPrcFixGrpID ACMPrcFixGrpID 3
KEY PrcFixGrpUUID PrcFixGrpUUID 3
KEY TradingContractItem TradingContractItem 3
KEY TradingContractNumber TradingContractNumber 3
KEY TrdgContrPrcgAspectDummyLotID TrdgContrPrcgAspectDummyLotID 2
KEY TrdgContrPrcgAspectSrceLotID TrdgContrPrcgAspectSrceLotID 3
ACMCmmdtyOrdReqExtDocID ACMCmmdtyOrdReqExtDocID 1
ACMDocPerQty ACMDocPerQty,ACMPrcgConditionPerUnitQty 3
ACMDocumentCurrency ACMDocumentCurrency,PrcgCndnTradingContrCurrency 2
ACMDocumentUnitOfMeasure ACMDocumentUnitOfMeasure,ACMPrcgTotAmtUnit 3
ACMIsOverfillPricingLot ACMIsOverfill,ACMIsOverfillPricingLot 3
ACMNumberOfVehicles ACMNumberOfVehicles 2
ACMPrcFixStsCode ACMPrcFixStsCode 1
ACMPrcgAspectType ACMPrcgAspectType 1
ACMPrcgCndnBasisFixedRate ACMPrcgCndnBasisFixedRate 2
ACMPrcgCndnBasisPrc ACMPrcgCndnBasisPrc 1
ACMPrcgCndnBasisRate ACMPrcgCndnBasisRate 1
ACMPrcgCndnCumBasisRate ACMPrcgCndnCumBasisRate 3
ACMPrcgCndnCumltvBasisCrcy ACMPrcgCndnCumltvBasisCrcy 2
ACMPrcgCndnCumltvBasisPrice ACMPrcgCndnCumltvBasisPrice 1
ACMPrcgCndnCumltvBasisPrUoM ACMPrcgCndnCumltvBasisPrUoM 2
ACMPrcgCndnCumltvBasisUnit ACMBasisPricingQuantity,ACMPrcgCndnCumltvBasisUnit,ACMPrcgCumltvPerUnitQuantity 2
ACMPrcgCndnFixedRateBasisUoM ACMPrcgCndnFixedRateBasisUoM 2
ACMPrcgCndnFlatPrice ACMPrcgCndnFlatPrice 1
ACMPrcgCndnFutrTrmUoM ACMPrcgCndnFixedRateFutureUoM,ACMPrcgFuturesPriceUnit 2
ACMPrcgCndnFuturePrice ACMPrcgCndnFuturePrice 1
ACMPrcgCndnFutureRate ACMFuturePricingQuantity,ACMPrcgCndnFutureRate 3
ACMPrcgCndnFutureTermCrcy ACMFuturesPriceCurrency,ACMPrcgCndnFutureTermCrcy 3
ACMPrcgCndnTotalNonHedgePrice ACMPrcgCndnTotalNonHedgePrice 1
ACMPriceFixationStatus ACMPrcgFixationStatus,ACMPriceFixationStatus 3
ACMPricingAspect ACMPricingAspect 3
ACMPricingAspectValue ACMPricingAspectValue 1
ACMPricingCancellationQuantity ACMPricingCancellationQuantity 1
ACMPricingMarketIdentifierCode ACMPricingMarketIdentifierCode 3
ACMSettledQuantity ACMSettledQuantity 2
CmmdtyPrcgPriceFixationSetUUID CmmdtyPrcgPriceFixationSetUUID 2
DerivativeContractMaturityCode ContrDrvtvContrMaturityCode,DerivativeContractMaturityCode 2
DerivativeContrSpecification DerivativeContrSpecification 3
FuturePrice ACMPrcgFuturesPrice,FuturePrice 2
MaturityKeyDate MaturityKeyDate 3
PrcFxtnDocumentRatePerQuantity PrcFxtnDocumentRatePerQuantity 1
PrcgCndnTradingContrCurrency ACMContrPrcgTotAmtCrcy,ACMPriceFixationCurrency,PrcgCndnTradingContrCurrency 2
PrcgConditionTermFixedRateCrcy PrcgConditionTermFixedRateCrcy 2
PriceLotQty ContractTradeQuantity,PriceLotQty,Quantity 3
PriceLotQtyUnit ContractTradeUnit,PriceLotQtyUnit,UnitOfMeasure 3
PricingApproach PricingApproach 1
Quantity Quantity 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.

-- Interface Layer for Trdg Contr Prc Ovw
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMTRDGCONTRPRCOVW_1 (
    ACMPRCFIXGRPID,
    PRCFIXGRPUUID,
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    TRDGCONTRPRCGASPECTDUMMYLOTID,
    TRDGCONTRPRCGASPECTSRCELOTID,
    ACMCMMDTYORDREQEXTDOCID,
    ACMDOCPERQTY,
    ACMDOCUMENTCURRENCY,
    ACMDOCUMENTUNITOFMEASURE,
    ACMISOVERFILLPRICINGLOT,
    ACMNUMBEROFVEHICLES,
    ACMPRCFIXSTSCODE,
    ACMPRCGASPECTTYPE,
    ACMPRCGCNDNBASISFIXEDRATE,
    ACMPRCGCNDNBASISPRC,
    ACMPRCGCNDNBASISRATE,
    ACMPRCGCNDNCUMBASISRATE,
    ACMPRCGCNDNCUMLTVBASISCRCY,
    ACMPRCGCNDNCUMLTVBASISPRICE,
    ACMPRCGCNDNCUMLTVBASISPRUOM,
    ACMPRCGCNDNCUMLTVBASISUNIT,
    ACMPRCGCNDNFIXEDRATEBASISUOM,
    ACMPRCGCNDNFLATPRICE,
    ACMPRCGCNDNFUTRTRMUOM,
    ACMPRCGCNDNFUTUREPRICE,
    ACMPRCGCNDNFUTURERATE,
    ACMPRCGCNDNFUTURETERMCRCY,
    ACMPRCGCNDNTOTALNONHEDGEPRICE,
    ACMPRICEFIXATIONSTATUS,
    ACMPRICINGASPECT,
    ACMPRICINGASPECTVALUE,
    ACMPRICINGCANCELLATIONQUANTITY,
    ACMPRICINGMARKETIDENTIFIERCODE,
    ACMSETTLEDQUANTITY,
    CMMDTYPRCGPRICEFIXATIONSETUUID,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    FUTUREPRICE,
    MATURITYKEYDATE,
    PRCFXTNDOCUMENTRATEPERQUANTITY,
    PRCGCNDNTRADINGCONTRCURRENCY,
    PRCGCONDITIONTERMFIXEDRATECRCY,
    PRICELOTQTY,
    PRICELOTQTYUNIT,
    PRICINGAPPROACH,
    QUANTITY,
    PRIMARY KEY (ACMPRCFIXGRPID, PRCFIXGRPUUID, TRADINGCONTRACTITEM, TRADINGCONTRACTNUMBER, TRDGCONTRPRCGASPECTDUMMYLOTID, TRDGCONTRPRCGASPECTSRCELOTID)
);