I_ACMTRDGCONTRPRCOVW_1
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA