P_CMMDTYHDGFINTRANSUNTCNVRSN
Commodity Financial Transaction Conversion
P_CMMDTYHDGFINTRANSUNTCNVRSN is a CDS View in S/4HANA. Commodity Financial Transaction Conversion. It contains 30 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CmmdtyHdgFinTransUntCnvrsn | view_entity | from | COMPOSITE | Commodity Financial Trans Conversion |
| P_CmmdtyHdgCnstltnFinTrans | view | inner | COMPOSITE | CMM: HedgeConst based Deals with HRel |
Fields (30)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _Counterparty | _Counterparty | 1 | |
| _DCS | _DCS | 1 | |
| _ProductType | _ProductType | 1 | |
| _TimeZone | _TimeZone | 1 | |
| CmmdtyDealQtyInDCSUoM | Quantity | 1 | |
| Counterparty | Counterparty | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| DCSUnitOfMeasure | UnitOfMeasure | 1 | |
| DerivativeContrSpecification | DerivativeContrSpecification | 1 | |
| FinancialInstrProductCategory | FinancialInstrProductCategory | 1 | |
| FinancialInstrTransactionType | FinancialInstrTransactionType | 1 | |
| FinancialInstrumentProductType | FinancialInstrumentProductType | 1 | |
| FinancialTransactionDirection | FinancialTransactionDirection | 1 | |
| FinancialTransactionHedgeBook | FinancialTransactionHedgeBook | 1 | |
| FinInstrTransactionCategory | FinInstrTransactionCategory | 1 | |
| FinTransactionPricingEndDate | FinTransactionPricingEndDate | 1 | |
| FinTransactionPricingStartDate | FinTransactionPricingStartDate | 1 | |
| FinTransactionTermRiskEndDate | FinTransactionTermRiskEndDate | 1 | |
| FinTransacTradedPriceAmount | FinTransacTradedPriceAmount | 1 | |
| FinTransActyConclusionDate | FinTransActyConclusionDate | 1 | |
| FinTransActyConclusionTime | FinTransActyConclusionTime | 1 | |
| FinTransActyConclusionTimeZone | FinTransActyConclusionTimeZone | 1 | |
| FinTransContractDate | FinTransContractDate | 1 | |
| FinTransCreationDate | FinTransCreationDate | 1 | |
| FinTransFlowPaymentDate | FinTransFlowPaymentDate | 1 | |
| FinTransTermRiskStartDate | FinTransTermRiskStartDate | 1 | |
| FinTransTradedPriceCurrency | FinTransTradedPriceCurrency | 1 | |
| MarketIdentifierCode | MarketIdentifierCode | 1 | |
| TermEndDate | TermEndDate | 1 | |
| TermStartDate | TermStartDate | 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.
-- Commodity Financial Transaction Conversion
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CMMDTYHDGFINTRANSUNTCNVRSN (
_COUNTERPARTY,
_DCS,
_PRODUCTTYPE,
_TIMEZONE,
CMMDTYDEALQTYINDCSUOM,
COUNTERPARTY,
CREATEDBYUSER,
DCSUNITOFMEASURE,
DERIVATIVECONTRSPECIFICATION,
FINANCIALINSTRPRODUCTCATEGORY,
FINANCIALINSTRTRANSACTIONTYPE,
FINANCIALINSTRUMENTPRODUCTTYPE,
FINANCIALTRANSACTIONDIRECTION,
FINANCIALTRANSACTIONHEDGEBOOK,
FININSTRTRANSACTIONCATEGORY,
FINTRANSACTIONPRICINGENDDATE,
FINTRANSACTIONPRICINGSTARTDATE,
FINTRANSACTIONTERMRISKENDDATE,
FINTRANSACTRADEDPRICEAMOUNT,
FINTRANSACTYCONCLUSIONDATE,
FINTRANSACTYCONCLUSIONTIME,
FINTRANSACTYCONCLUSIONTIMEZONE,
FINTRANSCONTRACTDATE,
FINTRANSCREATIONDATE,
FINTRANSFLOWPAYMENTDATE,
FINTRANSTERMRISKSTARTDATE,
FINTRANSTRADEDPRICECURRENCY,
MARKETIDENTIFIERCODE,
TERMENDDATE,
TERMSTARTDATE
);
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