CMM_VLOGP
Version Table
CMM_VLOGP is an SAP database table in S/4HANA. Version Table. It contains 271 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_VersionedLogisticDocument | view | from | EXTENSION | Extension inc. view for log. documents |
| I_ACMTrdgContrPrcgVersionDets | view | from | BASIC | Interface view for Trading Contract Pricing Vesrion Details |
| I_ACMVersionedLogisticDocument | view | from | BASIC | Versioned pricing data of logistic docs |
| I_ContrVersionedLogPrcDoc | view | from | BASIC | ACM Versioned Log Pricing Documents |
| I_VersionedLogcDocument | view | from | BASIC | Versioned pricing data of logistic docs |
| I_VersionedLogisticDocument | view | from | BASIC | Versioned pricing data of logistic docs |
| P_ACMVersionedLogisticDocument | view | from | BASIC | |
| P_Vlogp_Curves | view | from | BASIC | |
| P_VlogpMaxVersion | view | from | BASIC |
Fields (271)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | pricing_key | CMM_VLOGP_PRICING_KEY | Pricing Key | |||
| KEY | version | CMM_MTM_VERSION | Version | |||
| KEY | kposn | KPOSN | Item | |||
| KEY | kschl | KSCHL | Condition Type | |||
| KEY | kschl_subkey | CMM_VLOGP_SUBKEY | Subkey | |||
| document_char10 | CMM_VLOGP_DOCUMENT_CHAR10 | Document | ||||
| document | CMM_VLOGP_DOCUMENT | Document | ||||
| document_type | CMM_VLOGP_DOC_TYPE | Doc (BOR) Obj. Type | ||||
| valid_from_tst | CMM_MTM_VALID_FROM_TST | Valid-From Tstmp | ||||
| valid_to_tst | CMM_MTM_VALID_TO_TST | Valid-To Tstmp | ||||
| valid_from_date | CMM_MTM_VALID_FROM_DATE | Valid From | ||||
| valid_from_time | CMM_MTM_VALID_FROM_TIME | From Time | ||||
| valid_to_date | CMM_MTM_VALID_TO_DATE | Valid To | ||||
| valid_to_time | CMM_MTM_VALID_TO_TIME | To Time | ||||
| version_max | CMM_MTM_VERSION_MAX | Highest Version | ||||
| belnr | VBELN | SD Document | ||||
| vkorg | VKORG | Sales Org. | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| bzirk | BZIRK | Sales District | ||||
| vkgrp | VKGRP | Sales Group | ||||
| brsch | BRSCH | Industry | ||||
| vkbur | VKBUR | Sales Office | ||||
| aland | ALAND | Dep. Ctry/Reg. | ||||
| bukrs | BUKRS | Company Code | ||||
| gsber | GSBER | Business Area | ||||
| waerk | WAERK | Doc. Currency | ||||
| kunnr | KUNAG | Sold-to Party | ||||
| kunwe | KUNWE | Ship-to Party | ||||
| lifnr | ELIFN | Supplier | ||||
| kappl | KAPPL | Application | ||||
| kalsm | KALSM_D | Procedure | ||||
| erdat | ERDAT | Created On | ||||
| inco1 | INCO1 | Incoterms | ||||
| inco2 | INCO2 | Incoterms 2 | ||||
| land1 | LLAND | Dest. Ctry/Reg | ||||
| ekorg | EKORG | Purchasing Org. | ||||
| ext_number | CMM_VLOGP_SOURCE_DOC_EX | Ext. Doc. No. | ||||
| mirror_value | CMM_MTM_MIRROR | Mirrored Value | ||||
| entity_key | CMM_DEND_ENTITY_KEY | Entity | ||||
| record_type | CMM_VLOGP_REC_TYPE | Type of Data Record | ||||
| pricing_key_xml | CMM_VLOGP_STOCK_PRICING_KEYXML | Pricing Key Stk XML | ||||
| root_doc_char10 | CMM_VLOGP_ROOT_CHAR10 | Root Document | ||||
| root_doc | CMM_VLOGP_ROOT | Root Document | ||||
| root_doc_type | CMM_VLOGP_ROOT_DOCTYP | Root (BOR) Obj. Type | ||||
| root_doc_itm | CMM_VLOGP_ROOT_ITEM | Root Document Item | ||||
| predecessor_doc | CMM_VLOGP_PREDECESSOR | Predecessor Doc. | ||||
| predecessor_doc_type | CMM_VLOGP_PREDECESSOR_DOCTYP | Pred(BOR) Object Typ | ||||
| predecessor_doc_itm | CMM_VLOGP_PREDECESSOR_ITEM | Predec. Doc. Item | ||||
| document_item | CMM_DOC_ITEM | Document Item Number | ||||
| matnr | MATNR | Material | ||||
| charg | CHARG_D | Batch | ||||
| werks | WERKS_D | Plant | ||||
| mglme | CMM_MTM_MENGE_D_BASE | Qty Base UoM | ||||
| lagme | LAGME | Base Unit | ||||
| mgame | CMM_MTM_MENGE_D | Quantity | ||||
| vrkme | VRKME | Sales Unit | ||||
| spart | SPART | Division | ||||
| prctr | PRCTR | Profit Center | ||||
| matkl | MATKL | Material Group | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| root_ext_number | CMM_VLOGP_ROOT_DOC_EX | Root Doc. Number | ||||
| predecessor_ext_number | CMM_VLOGP_REF_DOC_EX | Predecessor Doc. No. | ||||
| realized | CMM_VLOGP_REALIZED | MtM Value Realized | ||||
| executed | CMM_VLOGP_EXECUTED | Executed | ||||
| completed | CMM_VLOGP_COMPLETED | Complete | ||||
| mglme_adj | CMM_MTM_MENGE_D_ADJ_BASE | O.Qty Base UoM | ||||
| mgame_adj | CMM_MTM_MENGE_D_ADJ | Open Quantity | ||||
| lgort | LGORT_D | Location | ||||
| stock_key_xml | CMM_VLOGP_STOCK_KEY_XML | Stock Key in XML | ||||
| stock_key | CMM_STOCK_KEY | Stock Key | ||||
| inter_company | CMM_VLOGP_INTERCOMPANY | Cross Company | ||||
| zaehk | DZAEHK | Counter | ||||
| kdatu | KDATU | CndnPricingDate | ||||
| krech | KRECH | Calculat.Type | ||||
| kawrt | KAWRT | Cond.Basis | ||||
| kbetr | KBETR | Amount | ||||
| koein | KOEIN | Unit | ||||
| waers | WAERS | Currency | ||||
| kpein | KPEIN | Pricing Unit | ||||
| kmein | KVMEI | Condition Unit | ||||
| kwert | CMM_MTM_KWERT | Condition Value | ||||
| kumza | KUMZA | Numer.for Conv. | ||||
| kumne | KUMNE | Den. for Conv. | ||||
| formid | CPET_FORMID | Formula Key | ||||
| formcurr | CPET_FORMCURR | Formula Currency | ||||
| formprun | CPET_FORMPRUN | Formula Price Unit | ||||
| formuom | CPET_FORMUOM | Formula UoM | ||||
| formcommquan | CPET_FORMCOMMQUAN | Comm.Qty Item | ||||
| formcommquan_adj | CPET_FORMCOMMQUAN | Comm.Qty Item | ||||
| formcommuom | CPET_FORMCOMMUOM | Commodity UoM | ||||
| formcombrout | CPET_COMBROUT | Combination Routine | ||||
| formstatus | CPET_FORMSTATUS | Status Formula Eval. | ||||
| termno | CPET_TERMNO | Term Number | ||||
| root_termno | CPET_TERMNO | Term Number | ||||
| termid | CPET_TERMID | Term Key | ||||
| termrate | CMM_TERMRATE | Term Rate | ||||
| termcurr | CPET_TERMCURR | Term Currency | ||||
| termprun | CPET_TERMPRUN | Term Price Unit | ||||
| termuom | CPET_TERMUOM | Term UoM | ||||
| termval | CPET_TERMVAL | Term Value | ||||
| termtext | BEZEI40 | Description | ||||
| termstatus | CPET_TERMSTATUS | Term Status | ||||
| term_extension_usage | CPET_EXTENSION_USAGE | Extension Usage | ||||
| termfactor_combrout_num | CMM_VLOGP_QUANTERMFACT_NUM | Term factor num | ||||
| termfactor_combrout_deno | CMM_VLOGP_QUANTERMFACT_DENO | Term factor deno | ||||
| latest_eval_keydate | CPET_LATEST_EVAL_KEYDATE | Latest Eval. Date | ||||
| latest_evaluation_date | CMM_LATEST_EVAL_DATE | Evaluation Date | ||||
| quot_timeseries_key | CMM_VLOGP_TIMESERIES_KEY | Date list key | ||||
| quotperiod_begin | CMM_VLOGP_QUOTPERIOD_BEGIN | Start Date of Period | ||||
| quotperiod_end | CMM_VLOGP_QUOTPERIOD_END | End Date of Period | ||||
| quotgroup | CMM_QUOTGROUP | Quotation Group | ||||
| quotgroup_op | CMM_QUOTGROUP_OP | Operation | ||||
| quotation_crcy | CMM_QUOTATION_CURR | Quotation Currency | ||||
| quotation_uom | CMM_QUOT_UNIT_OF_MEASURE | Quot Unit of Measure | ||||
| dcsid | TBA_DCSID | DCS ID | ||||
| mic | TBA_MIC | MIC | ||||
| tenor | TBA_TENOR | Time to Maturity | ||||
| contract_code | TBA_CONTRACT_CODE | Contr. Maturity Code | ||||
| instrument | CMM_VLOGP_INSTR | Differentiator | ||||
| pricetype | TBA_PRICETYPE | Price Type | ||||
| keydate | TBA_KEYDATE | Maturity Key Date | ||||
| timing | TBA_TIMING | Timing | ||||
| dcs_selection_type | CPET_KEYDATE_SELECTION_TYPE | Maturity Sel. Type | ||||
| riskquantity | CPET_RISKQUANTITY | Qty for Risk Calc. | ||||
| riskuom | CPET_RISKUOM | UoM for Risk Calc. | ||||
| risk_mass_qty | CMM_VLOGP_RISK_MASS_QTY | Mass | ||||
| commodity_mass_adj | CMM_MTM_QUAN_COMM_MASS | Quantity in Mass UoM | ||||
| risk_mass_uom | CMM_VLOGP_RISK_MASS_UOM | Mass UoM | ||||
| risk_volume_quantity | CMM_VLOGP_RISK_VOLUME_QUANTITY | Qty/Volume | ||||
| commodity_volume_adj | CMM_MTM_QUAN_COMM_VOLUME | Quantity in Vol UoM | ||||
| risk_volume_uom | CMM_VLOGP_RISK_VOLUME_UOM | Volume UoM | ||||
| basis_type | TBAC_BASIS_TYPE | Basis Type | ||||
| basis_id | TBAC_BASIS_ID | Basis ID | ||||
| date_delivery | CMM_VLOGP_DELIVERY_DATE | Delivery Date | ||||
| date_reference | CMM_VLOGP_REFERENCE_DATE | Valuation Ref Date | ||||
| quotkey | CPET_QUOTKEY_ALL | Quot. Key Type | ||||
| dcs_type | TBA_DERIVATIVETYPE | Derivative Category | ||||
| curve_dcsid | TBA_DCSID | DCS ID | ||||
| curve_mic | TBA_MIC | MIC | ||||
| curve_type | TBA_CURVETYPE | Cty Curve Type | ||||
| curve_commodity_id | TBA_CTY_ID | Cmdty | ||||
| curve_reading_date | CPET_CURVE_READING_DATE | Reading Date | ||||
| curve | CMM_GMDACC_KEY | Curve | ||||
| fixgroup_status | CMM_FBFIX_STATUS | Price Fix. Status | ||||
| fixation_id | CPET_TERMNO | Term Number | ||||
| rate_fix_date | CMM_VLOGP_RATE_FIX_DATE | Rate Fixation Date | ||||
| rate_fix_time | CMM_VLOGP_RATE_FIX_TIME | Rate Fixation Time | ||||
| fx_fix_date | CMM_VLOGP_FX_FIX_DATE | FX Fixation Date | ||||
| fx_fix_time | CMM_VLOGP_FX_FIX_TIME | FX Fixation Time | ||||
| date_fwd_fx_freeze | CMM_VLOGP_DATE_FWD_FX_FREEZE | FWD FX freeze Date | ||||
| date_fwd_fx_maturity | CMM_MATURITY_DATE | Maturity Date | ||||
| commodity_adj_in_termuom | CDS_CMMDTYQTY_IN_TERMUOM | Qty in Price Unit | ||||
| keydate_selection_rout | CPET_KEYDATE_SELECTION_ROUT | Maturity Sel. Rt. | ||||
| dcs_period_type | TBA_PERIODTYPE | Period Type | ||||
| provis | CPET_PROVIS | ProvPricing only | ||||
| provtermno | CPET_PROVTERMNO | Prov.Term No. | ||||
| implicit_fixation_rel | CMM_VLOGP_IMP_FIX_REL | Imp Fix Relevant | ||||
| calcmin | CMM_CALCMIN | Minimum Rate | ||||
| calcmax | CMM_CALCMAX | Maximum Rate | ||||
| calcmmcurr | CPET_CALCMMCURR | Curr. of Limits | ||||
| calcmmprun | CPET_CALCMMPRUN | PUnit of Limits | ||||
| calcmmuom | CPET_CALCMMUOM | UoM:Rate Limits | ||||
| psmguid | CPET_PSMGUID | PSM GUID | ||||
| psmethod | CPET_PSMETHOD | Price Setting Method | ||||
| psmstatus | CPET_PSMSTATUS | PSM Status | ||||
| commoditysubaccount | CMMFSA_SUBACCOUNTID | Subaccount ID | ||||
| number_of_lots | CPET_NUMBER_OF_LOTS | Lots | ||||
| fillpacketuuid | CPET_FILL_PACKET_UUID | Fill Packet UUID | ||||
| kwert_adj | CMM_MTM_KWERT_ADJ | Adjusted Cond. Amnt | ||||
| kwert_adj_stwae | CMM_MTM_KWERT_STWAE | Con. Val. (St. Crcy) | ||||
| kbetr_stwae | CMM_MTM_RATE | Rate | ||||
| commodity_quan | CMM_MTM_QUAN_COMM | Cmdty Quantity | ||||
| commodity_adj | CMM_MTM_QUAN_COMM_ADJ | Open Cmdty Qty | ||||
| commodity_uom | CMM_MTM_QUAN_COMMUOM | Cmdty UoM | ||||
| commodity_rf_uom | REFME_WS | Ref. UoM | ||||
| dcs_reporting_date | TBA_REPORTING_DATE | Reporting Date | ||||
| date_discounting | CMM_MTM_DATE_DISC | Disc. Date | ||||
| date_pymnt | CMM_MTM_DATE_PYMNT | Payment Date | ||||
| cgroup | CMM_MTM_CGROUP | Condition Group | ||||
| cgroup_cat | CMM_MTM_CGROUP_CAT | Category | ||||
| calc_group | CMM_VLOGP_CALC_GRP | Calc.Group | ||||
| kschl_m | CMM_VLOGP_KSCHL_M | Mkt Price Condition | ||||
| commodity | TBA_STOEFFCHEN | Commodity | ||||
| stwae | STWAE | Stats. Currency | ||||
| stwae_kurst | KURST | Exch. Rate Type | ||||
| signage_qty | CMM_VLOGP_SIGNAGE_QTY | Sign of Quantity | ||||
| signage_val | CMM_VLOGP_SIGNAGE_VAL | Sign of Amount | ||||
| fixed | CMM_VLOGP_FIXATION | Fixed Term | ||||
| fixed_fx | CMM_VLOGP_FIXATION_FX | Fixed FX | ||||
| round_rate | CMM_VLOGP_ROUND_RATE | Rate Rounded | ||||
| numdec_rate | CMM_VLOGP_NUMDEC_RATE | Decim. Calctd. Rate | ||||
| factor_num | CMM_VLOGP_FACTOR_NUM | Rate factor num | ||||
| factor_denom | CMM_VLOGP_FACTOR_DENOM | Rate factor denom | ||||
| adjustment_type | CMM_VLOGP_ADJUSTMENT_TYPE | Adjustment Type | ||||
| termno_l | CPET_TERMNO | Term Number | ||||
| entity_key_mkt | CMM_MKT_ENTITY_KEY | Entity Key Mkt Norm | ||||
| period_start_mkt | CMM_MKT_PERIODSTART | Delivery Per. Start | ||||
| period_end_mkt | CMM_MKT_PERIODEND | Delivery Period End | ||||
| key_struct_mkt | CMM_MKT_KEYSTRUCT | Key Struct. Mkt.Norm | ||||
| entity_key_sprd | CMM_DEND_SPREAD_ENTITY_KEY | Entity Key Sprd | ||||
| futures_ref_mic | TBA_MIC | MIC | ||||
| termcurr_m | CMM_VLOGP_TERMCURR_M | Market Term Currency | ||||
| keydate1_sprd | TBA_KEYDATE | Maturity Key Date | ||||
| keydate2_sprd | CMM_DEND_SPREAD_KEYDATE2 | Maturity Key Date 2 | ||||
| inverse_fix_sprd | CMM_DEND_INV_FIXSPRD | InvFixSrd | ||||
| futures_ref_timeseries | CMM_VLOGP_TIMESERIES_KEY | Date list key | ||||
| skip_reporting | CMM_VLOGP_SKIP_REPORTING | Skip reporting | ||||
| quotperdays | abap.int2 | |||||
| sgsart | VVSART | Product Type | ||||
| sfhaart | TB_SFHAART | Transactn Type | ||||
| kontrh | CMM_TB_KUNNR_NEW | Partner | ||||
| ranl | VVRANLW | Security Class | ||||
| astueck | TB_ASTUECK | Number of Units | ||||
| posacc | CMM_POS_ACCOUNT_FUT | Futures Acct | ||||
| rantyp | RANTYP | Contract Type | ||||
| sshlng | CMM_JBSSHLNG | Short/Long | ||||
| sv_state_id | CMM_VLOGP_JBRSVSTATEID | Save ID | ||||
| bp_eval_prd_start | CMM_BP_EVAL_START_DATE | Ref. Eval. Date | ||||
| bp_eval_period | CMM_SRP_EVAL_PERIOD | Eval Period | ||||
| event | CMM_EVENT | Event Type | ||||
| previous_version | CMM_MTM_VERSION | Version | ||||
| previous_subkey | CMM_VLOGP_SUBKEY | Subkey | ||||
| previous_fixed | CMM_VLOGP_FIXATION | Fixed Term | ||||
| previous_implc_fixed | CMM_VLOGP_IMP_FIX_REL | Imp Fix Relevant | ||||
| previous_fixed_fx | CMM_VLOGP_FIXATION_FX | Fixed FX | ||||
| previous_commodity_adj | CMM_MTM_QUAN_COMM_ADJ | Open Cmdty Qty | ||||
| previous_comm_adj_in_termuom | CDS_CMMDTYQTY_IN_TERMUOM | Qty in Price Unit | ||||
| previous_signage_qty | CMM_VLOGP_SIGNAGE_QTY | Sign of Quantity | ||||
| previous_termrate | CMM_TERMRATE | Term Rate | ||||
| previous_termcurr | CPET_TERMCURR | Term Currency | ||||
| previous_waerk | WAERK | Doc. Currency | ||||
| previous_md_factor_from | CPET_FACTORFROM | From-Fctr Conv. | ||||
| previous_md_factor_to | CPET_FACTORTO | To-Fctr Conv. | ||||
| previous_ds_factor_from | CPET_FACTORFROM | From-Fctr Conv. | ||||
| previous_ds_factor_to | CPET_FACTORTO | To-Fctr Conv. | ||||
| previous_termval | CPET_TERMVAL | Term Value | ||||
| previous_kbetr | KBETR | Amount | ||||
| previous_dcsid | TBA_DCSID | DCS ID | ||||
| previous_mic | TBA_MIC | MIC | ||||
| previous_contract_code | TBA_CONTRACT_CODE | Contr. Maturity Code | ||||
| previous_keydate | TBA_KEYDATE | Maturity Key Date | ||||
| previous_fixgroup_status | CMM_FBFIX_STATUS | Price Fix. Status | ||||
| previous_termfact_comb_num | CMM_VLOGP_QUANTERMFACT_NUM | Term factor num | ||||
| previous_termfact_comb_deno | CMM_VLOGP_QUANTERMFACT_DENO | Term factor deno | ||||
| previous_calcmin | CMM_CALCMIN | Minimum Rate | ||||
| previous_calcmax | CMM_CALCMAX | Maximum Rate | ||||
| previous_pricetype | TBA_PRICETYPE | Price Type | ||||
| previous_curve | CMM_GMDACC_KEY | Curve | ||||
| previous_quotgroup | CMM_QUOTGROUP | Quotation Group | ||||
| previous_dcs_period | TBA_PERIODTYPE | Period Type | ||||
| previous_dcs_sel | CPET_KEYDATE_SELECTION_TYPE | Maturity Sel. Type | ||||
| previous_keydt_sel_rout | CPET_KEYDATE_SELECTION_ROUT | Maturity Sel. Rt. | ||||
| previous_quot_timeseries | CMM_VLOGP_TIMESERIES_KEY | Date list key | ||||
| previous_quot_per_beg | CMM_VLOGP_QUOTPERIOD_BEGIN | Start Date of Period | ||||
| previous_quot_per_end | CMM_VLOGP_QUOTPERIOD_END | End Date of Period | ||||
| previous_root_doc | CMM_VLOGP_PREV_REFDOC | Previous Root Doc | ||||
| previous_root_doc_itm | CMM_VLOGP_PREV_REFDOC_ITEM | Prev Root Doc Item | ||||
| fx_fix_calctype_term_to_doc | CMM_FIXED_CALC_TYPE | Fixed Fx Calc Type | ||||
| fx_fix_factor_from_term_to_doc | CMM_FIXED_FACTOR_FROM | Fixed Frm-Fctr Conv. | ||||
| fx_fix_factor_to_term_to_doc | CMM_FIXED_FACTOR_TO | Fxd Term To-Fct Conv | ||||
| fx_mrkt_to_term_fx_ratetype | CMM_MRKT_TO_TERM_FX_RATETYPE | Mkt to Term Crcy Cnv | ||||
| fx_cond_to_doc_fxratetype | CMM_COND_TO_DOC_FXRATETYPE | Cnd to Doc Crcy Conv | ||||
| fx_doc_to_stat_fxratetype | CMM_DOC_TO_STAT_FXRATETYPE | Doc to Stat Crcy Cnv | ||||
| fx_cond_to_stat_fxratetype | CMM_COND_TO_STAT_FXRATETYPE | Cnd to Stat Crcy Cnv | ||||
| uom_quot_to_term_factor_from | CMM_QUOT_TO_TERM_FACTOR_FROM | Quot To Term UoM | ||||
| uom_quot_to_term_factor_to | CMM_QUOT_TO_TERM_FACTOR_TO | Factorto Quot to Trm | ||||
| fx_exch_rate_maturity_date | CMM_EXCH_RATE_MATURITY_DATE | Exch Rate Mat. Date | ||||
| sdm_version | CMM_VLOGP_SDM_VERSION | SDM Version | ||||
| uom_comm_to_term_factor_num | CMM_COMM_TO_TERM_FACTOR_FROM | Commodty To Term UoM | ||||
| uom_comm_to_term_factor_den | CMM_COMM_TO_TERM_FACTOR_TO | Commodty To Term UoM |
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.
-- Version Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_VLOGP (
MANDT, -- Client [MANDT]
PRICING_KEY, -- Pricing Key [CMM_VLOGP_PRICING_KEY]
VERSION, -- Version [CMM_MTM_VERSION]
KPOSN, -- Item [KPOSN]
KSCHL, -- Condition Type [KSCHL]
KSCHL_SUBKEY, -- Subkey [CMM_VLOGP_SUBKEY]
DOCUMENT_CHAR10, -- Document [CMM_VLOGP_DOCUMENT_CHAR10]
DOCUMENT, -- Document [CMM_VLOGP_DOCUMENT]
DOCUMENT_TYPE, -- Doc (BOR) Obj. Type [CMM_VLOGP_DOC_TYPE]
VALID_FROM_TST, -- Valid-From Tstmp [CMM_MTM_VALID_FROM_TST]
VALID_TO_TST, -- Valid-To Tstmp [CMM_MTM_VALID_TO_TST]
VALID_FROM_DATE, -- Valid From [CMM_MTM_VALID_FROM_DATE]
VALID_FROM_TIME, -- From Time [CMM_MTM_VALID_FROM_TIME]
VALID_TO_DATE, -- Valid To [CMM_MTM_VALID_TO_DATE]
VALID_TO_TIME, -- To Time [CMM_MTM_VALID_TO_TIME]
VERSION_MAX, -- Highest Version [CMM_MTM_VERSION_MAX]
BELNR, -- SD Document [VBELN]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
BZIRK, -- Sales District [BZIRK]
VKGRP, -- Sales Group [VKGRP]
BRSCH, -- Industry [BRSCH]
VKBUR, -- Sales Office [VKBUR]
ALAND, -- Dep. Ctry/Reg. [ALAND]
BUKRS, -- Company Code [BUKRS]
GSBER, -- Business Area [GSBER]
WAERK, -- Doc. Currency [WAERK]
KUNNR, -- Sold-to Party [KUNAG]
KUNWE, -- Ship-to Party [KUNWE]
LIFNR, -- Supplier [ELIFN]
KAPPL, -- Application [KAPPL]
KALSM, -- Procedure [KALSM_D]
ERDAT, -- Created On [ERDAT]
INCO1, -- Incoterms [INCO1]
INCO2, -- Incoterms 2 [INCO2]
LAND1, -- Dest. Ctry/Reg [LLAND]
EKORG, -- Purchasing Org. [EKORG]
EXT_NUMBER, -- Ext. Doc. No. [CMM_VLOGP_SOURCE_DOC_EX]
MIRROR_VALUE, -- Mirrored Value [CMM_MTM_MIRROR]
ENTITY_KEY, -- Entity [CMM_DEND_ENTITY_KEY]
RECORD_TYPE, -- Type of Data Record [CMM_VLOGP_REC_TYPE]
PRICING_KEY_XML, -- Pricing Key Stk XML [CMM_VLOGP_STOCK_PRICING_KEYXML]
ROOT_DOC_CHAR10, -- Root Document [CMM_VLOGP_ROOT_CHAR10]
ROOT_DOC, -- Root Document [CMM_VLOGP_ROOT]
ROOT_DOC_TYPE, -- Root (BOR) Obj. Type [CMM_VLOGP_ROOT_DOCTYP]
ROOT_DOC_ITM, -- Root Document Item [CMM_VLOGP_ROOT_ITEM]
PREDECESSOR_DOC, -- Predecessor Doc. [CMM_VLOGP_PREDECESSOR]
PREDECESSOR_DOC_TYPE, -- Pred(BOR) Object Typ [CMM_VLOGP_PREDECESSOR_DOCTYP]
PREDECESSOR_DOC_ITM, -- Predec. Doc. Item [CMM_VLOGP_PREDECESSOR_ITEM]
DOCUMENT_ITEM, -- Document Item Number [CMM_DOC_ITEM]
MATNR, -- Material [MATNR]
CHARG, -- Batch [CHARG_D]
WERKS, -- Plant [WERKS_D]
MGLME, -- Qty Base UoM [CMM_MTM_MENGE_D_BASE]
LAGME, -- Base Unit [LAGME]
MGAME, -- Quantity [CMM_MTM_MENGE_D]
VRKME, -- Sales Unit [VRKME]
SPART, -- Division [SPART]
PRCTR, -- Profit Center [PRCTR]
MATKL, -- Material Group [MATKL]
BWTAR, -- Valuation Type [BWTAR_D]
ROOT_EXT_NUMBER, -- Root Doc. Number [CMM_VLOGP_ROOT_DOC_EX]
PREDECESSOR_EXT_NUMBER, -- Predecessor Doc. No. [CMM_VLOGP_REF_DOC_EX]
REALIZED, -- MtM Value Realized [CMM_VLOGP_REALIZED]
EXECUTED, -- Executed [CMM_VLOGP_EXECUTED]
COMPLETED, -- Complete [CMM_VLOGP_COMPLETED]
MGLME_ADJ, -- O.Qty Base UoM [CMM_MTM_MENGE_D_ADJ_BASE]
MGAME_ADJ, -- Open Quantity [CMM_MTM_MENGE_D_ADJ]
LGORT, -- Location [LGORT_D]
STOCK_KEY_XML, -- Stock Key in XML [CMM_VLOGP_STOCK_KEY_XML]
STOCK_KEY, -- Stock Key [CMM_STOCK_KEY]
INTER_COMPANY, -- Cross Company [CMM_VLOGP_INTERCOMPANY]
ZAEHK, -- Counter [DZAEHK]
KDATU, -- CndnPricingDate [KDATU]
KRECH, -- Calculat.Type [KRECH]
KAWRT, -- Cond.Basis [KAWRT]
KBETR, -- Amount [KBETR]
KOEIN, -- Unit [KOEIN]
WAERS, -- Currency [WAERS]
KPEIN, -- Pricing Unit [KPEIN]
KMEIN, -- Condition Unit [KVMEI]
KWERT, -- Condition Value [CMM_MTM_KWERT]
KUMZA, -- Numer.for Conv. [KUMZA]
KUMNE, -- Den. for Conv. [KUMNE]
FORMID, -- Formula Key [CPET_FORMID]
FORMCURR, -- Formula Currency [CPET_FORMCURR]
FORMPRUN, -- Formula Price Unit [CPET_FORMPRUN]
FORMUOM, -- Formula UoM [CPET_FORMUOM]
FORMCOMMQUAN, -- Comm.Qty Item [CPET_FORMCOMMQUAN]
FORMCOMMQUAN_ADJ, -- Comm.Qty Item [CPET_FORMCOMMQUAN]
FORMCOMMUOM, -- Commodity UoM [CPET_FORMCOMMUOM]
FORMCOMBROUT, -- Combination Routine [CPET_COMBROUT]
FORMSTATUS, -- Status Formula Eval. [CPET_FORMSTATUS]
TERMNO, -- Term Number [CPET_TERMNO]
ROOT_TERMNO, -- Term Number [CPET_TERMNO]
TERMID, -- Term Key [CPET_TERMID]
TERMRATE, -- Term Rate [CMM_TERMRATE]
TERMCURR, -- Term Currency [CPET_TERMCURR]
TERMPRUN, -- Term Price Unit [CPET_TERMPRUN]
TERMUOM, -- Term UoM [CPET_TERMUOM]
TERMVAL, -- Term Value [CPET_TERMVAL]
TERMTEXT, -- Description [BEZEI40]
TERMSTATUS, -- Term Status [CPET_TERMSTATUS]
TERM_EXTENSION_USAGE, -- Extension Usage [CPET_EXTENSION_USAGE]
TERMFACTOR_COMBROUT_NUM, -- Term factor num [CMM_VLOGP_QUANTERMFACT_NUM]
TERMFACTOR_COMBROUT_DENO, -- Term factor deno [CMM_VLOGP_QUANTERMFACT_DENO]
LATEST_EVAL_KEYDATE, -- Latest Eval. Date [CPET_LATEST_EVAL_KEYDATE]
LATEST_EVALUATION_DATE, -- Evaluation Date [CMM_LATEST_EVAL_DATE]
QUOT_TIMESERIES_KEY, -- Date list key [CMM_VLOGP_TIMESERIES_KEY]
QUOTPERIOD_BEGIN, -- Start Date of Period [CMM_VLOGP_QUOTPERIOD_BEGIN]
QUOTPERIOD_END, -- End Date of Period [CMM_VLOGP_QUOTPERIOD_END]
QUOTGROUP, -- Quotation Group [CMM_QUOTGROUP]
QUOTGROUP_OP, -- Operation [CMM_QUOTGROUP_OP]
QUOTATION_CRCY, -- Quotation Currency [CMM_QUOTATION_CURR]
QUOTATION_UOM, -- Quot Unit of Measure [CMM_QUOT_UNIT_OF_MEASURE]
DCSID, -- DCS ID [TBA_DCSID]
MIC, -- MIC [TBA_MIC]
TENOR, -- Time to Maturity [TBA_TENOR]
CONTRACT_CODE, -- Contr. Maturity Code [TBA_CONTRACT_CODE]
INSTRUMENT, -- Differentiator [CMM_VLOGP_INSTR]
PRICETYPE, -- Price Type [TBA_PRICETYPE]
KEYDATE, -- Maturity Key Date [TBA_KEYDATE]
TIMING, -- Timing [TBA_TIMING]
DCS_SELECTION_TYPE, -- Maturity Sel. Type [CPET_KEYDATE_SELECTION_TYPE]
RISKQUANTITY, -- Qty for Risk Calc. [CPET_RISKQUANTITY]
RISKUOM, -- UoM for Risk Calc. [CPET_RISKUOM]
RISK_MASS_QTY, -- Mass [CMM_VLOGP_RISK_MASS_QTY]
COMMODITY_MASS_ADJ, -- Quantity in Mass UoM [CMM_MTM_QUAN_COMM_MASS]
RISK_MASS_UOM, -- Mass UoM [CMM_VLOGP_RISK_MASS_UOM]
RISK_VOLUME_QUANTITY, -- Qty/Volume [CMM_VLOGP_RISK_VOLUME_QUANTITY]
COMMODITY_VOLUME_ADJ, -- Quantity in Vol UoM [CMM_MTM_QUAN_COMM_VOLUME]
RISK_VOLUME_UOM, -- Volume UoM [CMM_VLOGP_RISK_VOLUME_UOM]
BASIS_TYPE, -- Basis Type [TBAC_BASIS_TYPE]
BASIS_ID, -- Basis ID [TBAC_BASIS_ID]
DATE_DELIVERY, -- Delivery Date [CMM_VLOGP_DELIVERY_DATE]
DATE_REFERENCE, -- Valuation Ref Date [CMM_VLOGP_REFERENCE_DATE]
QUOTKEY, -- Quot. Key Type [CPET_QUOTKEY_ALL]
DCS_TYPE, -- Derivative Category [TBA_DERIVATIVETYPE]
CURVE_DCSID, -- DCS ID [TBA_DCSID]
CURVE_MIC, -- MIC [TBA_MIC]
CURVE_TYPE, -- Cty Curve Type [TBA_CURVETYPE]
CURVE_COMMODITY_ID, -- Cmdty [TBA_CTY_ID]
CURVE_READING_DATE, -- Reading Date [CPET_CURVE_READING_DATE]
CURVE, -- Curve [CMM_GMDACC_KEY]
FIXGROUP_STATUS, -- Price Fix. Status [CMM_FBFIX_STATUS]
FIXATION_ID, -- Term Number [CPET_TERMNO]
RATE_FIX_DATE, -- Rate Fixation Date [CMM_VLOGP_RATE_FIX_DATE]
RATE_FIX_TIME, -- Rate Fixation Time [CMM_VLOGP_RATE_FIX_TIME]
FX_FIX_DATE, -- FX Fixation Date [CMM_VLOGP_FX_FIX_DATE]
FX_FIX_TIME, -- FX Fixation Time [CMM_VLOGP_FX_FIX_TIME]
DATE_FWD_FX_FREEZE, -- FWD FX freeze Date [CMM_VLOGP_DATE_FWD_FX_FREEZE]
DATE_FWD_FX_MATURITY, -- Maturity Date [CMM_MATURITY_DATE]
COMMODITY_ADJ_IN_TERMUOM, -- Qty in Price Unit [CDS_CMMDTYQTY_IN_TERMUOM]
KEYDATE_SELECTION_ROUT, -- Maturity Sel. Rt. [CPET_KEYDATE_SELECTION_ROUT]
DCS_PERIOD_TYPE, -- Period Type [TBA_PERIODTYPE]
PROVIS, -- ProvPricing only [CPET_PROVIS]
PROVTERMNO, -- Prov.Term No. [CPET_PROVTERMNO]
IMPLICIT_FIXATION_REL, -- Imp Fix Relevant [CMM_VLOGP_IMP_FIX_REL]
CALCMIN, -- Minimum Rate [CMM_CALCMIN]
CALCMAX, -- Maximum Rate [CMM_CALCMAX]
CALCMMCURR, -- Curr. of Limits [CPET_CALCMMCURR]
CALCMMPRUN, -- PUnit of Limits [CPET_CALCMMPRUN]
CALCMMUOM, -- UoM:Rate Limits [CPET_CALCMMUOM]
PSMGUID, -- PSM GUID [CPET_PSMGUID]
PSMETHOD, -- Price Setting Method [CPET_PSMETHOD]
PSMSTATUS, -- PSM Status [CPET_PSMSTATUS]
COMMODITYSUBACCOUNT, -- Subaccount ID [CMMFSA_SUBACCOUNTID]
NUMBER_OF_LOTS, -- Lots [CPET_NUMBER_OF_LOTS]
FILLPACKETUUID, -- Fill Packet UUID [CPET_FILL_PACKET_UUID]
KWERT_ADJ, -- Adjusted Cond. Amnt [CMM_MTM_KWERT_ADJ]
KWERT_ADJ_STWAE, -- Con. Val. (St. Crcy) [CMM_MTM_KWERT_STWAE]
KBETR_STWAE, -- Rate [CMM_MTM_RATE]
COMMODITY_QUAN, -- Cmdty Quantity [CMM_MTM_QUAN_COMM]
COMMODITY_ADJ, -- Open Cmdty Qty [CMM_MTM_QUAN_COMM_ADJ]
COMMODITY_UOM, -- Cmdty UoM [CMM_MTM_QUAN_COMMUOM]
COMMODITY_RF_UOM, -- Ref. UoM [REFME_WS]
DCS_REPORTING_DATE, -- Reporting Date [TBA_REPORTING_DATE]
DATE_DISCOUNTING, -- Disc. Date [CMM_MTM_DATE_DISC]
DATE_PYMNT, -- Payment Date [CMM_MTM_DATE_PYMNT]
CGROUP, -- Condition Group [CMM_MTM_CGROUP]
CGROUP_CAT, -- Category [CMM_MTM_CGROUP_CAT]
CALC_GROUP, -- Calc.Group [CMM_VLOGP_CALC_GRP]
KSCHL_M, -- Mkt Price Condition [CMM_VLOGP_KSCHL_M]
COMMODITY, -- Commodity [TBA_STOEFFCHEN]
STWAE, -- Stats. Currency [STWAE]
STWAE_KURST, -- Exch. Rate Type [KURST]
SIGNAGE_QTY, -- Sign of Quantity [CMM_VLOGP_SIGNAGE_QTY]
SIGNAGE_VAL, -- Sign of Amount [CMM_VLOGP_SIGNAGE_VAL]
FIXED, -- Fixed Term [CMM_VLOGP_FIXATION]
FIXED_FX, -- Fixed FX [CMM_VLOGP_FIXATION_FX]
ROUND_RATE, -- Rate Rounded [CMM_VLOGP_ROUND_RATE]
NUMDEC_RATE, -- Decim. Calctd. Rate [CMM_VLOGP_NUMDEC_RATE]
FACTOR_NUM, -- Rate factor num [CMM_VLOGP_FACTOR_NUM]
FACTOR_DENOM, -- Rate factor denom [CMM_VLOGP_FACTOR_DENOM]
ADJUSTMENT_TYPE, -- Adjustment Type [CMM_VLOGP_ADJUSTMENT_TYPE]
TERMNO_L, -- Term Number [CPET_TERMNO]
ENTITY_KEY_MKT, -- Entity Key Mkt Norm [CMM_MKT_ENTITY_KEY]
PERIOD_START_MKT, -- Delivery Per. Start [CMM_MKT_PERIODSTART]
PERIOD_END_MKT, -- Delivery Period End [CMM_MKT_PERIODEND]
KEY_STRUCT_MKT, -- Key Struct. Mkt.Norm [CMM_MKT_KEYSTRUCT]
ENTITY_KEY_SPRD, -- Entity Key Sprd [CMM_DEND_SPREAD_ENTITY_KEY]
FUTURES_REF_MIC, -- MIC [TBA_MIC]
TERMCURR_M, -- Market Term Currency [CMM_VLOGP_TERMCURR_M]
KEYDATE1_SPRD, -- Maturity Key Date [TBA_KEYDATE]
KEYDATE2_SPRD, -- Maturity Key Date 2 [CMM_DEND_SPREAD_KEYDATE2]
INVERSE_FIX_SPRD, -- InvFixSrd [CMM_DEND_INV_FIXSPRD]
FUTURES_REF_TIMESERIES, -- Date list key [CMM_VLOGP_TIMESERIES_KEY]
SKIP_REPORTING, -- Skip reporting [CMM_VLOGP_SKIP_REPORTING]
QUOTPERDAYS, -- abap.int2
SGSART, -- Product Type [VVSART]
SFHAART, -- Transactn Type [TB_SFHAART]
KONTRH, -- Partner [CMM_TB_KUNNR_NEW]
RANL, -- Security Class [VVRANLW]
ASTUECK, -- Number of Units [TB_ASTUECK]
POSACC, -- Futures Acct [CMM_POS_ACCOUNT_FUT]
RANTYP, -- Contract Type [RANTYP]
SSHLNG, -- Short/Long [CMM_JBSSHLNG]
SV_STATE_ID, -- Save ID [CMM_VLOGP_JBRSVSTATEID]
BP_EVAL_PRD_START, -- Ref. Eval. Date [CMM_BP_EVAL_START_DATE]
BP_EVAL_PERIOD, -- Eval Period [CMM_SRP_EVAL_PERIOD]
EVENT, -- Event Type [CMM_EVENT]
PREVIOUS_VERSION, -- Version [CMM_MTM_VERSION]
PREVIOUS_SUBKEY, -- Subkey [CMM_VLOGP_SUBKEY]
PREVIOUS_FIXED, -- Fixed Term [CMM_VLOGP_FIXATION]
PREVIOUS_IMPLC_FIXED, -- Imp Fix Relevant [CMM_VLOGP_IMP_FIX_REL]
PREVIOUS_FIXED_FX, -- Fixed FX [CMM_VLOGP_FIXATION_FX]
PREVIOUS_COMMODITY_ADJ, -- Open Cmdty Qty [CMM_MTM_QUAN_COMM_ADJ]
PREVIOUS_COMM_ADJ_IN_TERMUOM, -- Qty in Price Unit [CDS_CMMDTYQTY_IN_TERMUOM]
PREVIOUS_SIGNAGE_QTY, -- Sign of Quantity [CMM_VLOGP_SIGNAGE_QTY]
PREVIOUS_TERMRATE, -- Term Rate [CMM_TERMRATE]
PREVIOUS_TERMCURR, -- Term Currency [CPET_TERMCURR]
PREVIOUS_WAERK, -- Doc. Currency [WAERK]
PREVIOUS_MD_FACTOR_FROM, -- From-Fctr Conv. [CPET_FACTORFROM]
PREVIOUS_MD_FACTOR_TO, -- To-Fctr Conv. [CPET_FACTORTO]
PREVIOUS_DS_FACTOR_FROM, -- From-Fctr Conv. [CPET_FACTORFROM]
PREVIOUS_DS_FACTOR_TO, -- To-Fctr Conv. [CPET_FACTORTO]
PREVIOUS_TERMVAL, -- Term Value [CPET_TERMVAL]
PREVIOUS_KBETR, -- Amount [KBETR]
PREVIOUS_DCSID, -- DCS ID [TBA_DCSID]
PREVIOUS_MIC, -- MIC [TBA_MIC]
PREVIOUS_CONTRACT_CODE, -- Contr. Maturity Code [TBA_CONTRACT_CODE]
PREVIOUS_KEYDATE, -- Maturity Key Date [TBA_KEYDATE]
PREVIOUS_FIXGROUP_STATUS, -- Price Fix. Status [CMM_FBFIX_STATUS]
PREVIOUS_TERMFACT_COMB_NUM, -- Term factor num [CMM_VLOGP_QUANTERMFACT_NUM]
PREVIOUS_TERMFACT_COMB_DENO, -- Term factor deno [CMM_VLOGP_QUANTERMFACT_DENO]
PREVIOUS_CALCMIN, -- Minimum Rate [CMM_CALCMIN]
PREVIOUS_CALCMAX, -- Maximum Rate [CMM_CALCMAX]
PREVIOUS_PRICETYPE, -- Price Type [TBA_PRICETYPE]
PREVIOUS_CURVE, -- Curve [CMM_GMDACC_KEY]
PREVIOUS_QUOTGROUP, -- Quotation Group [CMM_QUOTGROUP]
PREVIOUS_DCS_PERIOD, -- Period Type [TBA_PERIODTYPE]
PREVIOUS_DCS_SEL, -- Maturity Sel. Type [CPET_KEYDATE_SELECTION_TYPE]
PREVIOUS_KEYDT_SEL_ROUT, -- Maturity Sel. Rt. [CPET_KEYDATE_SELECTION_ROUT]
PREVIOUS_QUOT_TIMESERIES, -- Date list key [CMM_VLOGP_TIMESERIES_KEY]
PREVIOUS_QUOT_PER_BEG, -- Start Date of Period [CMM_VLOGP_QUOTPERIOD_BEGIN]
PREVIOUS_QUOT_PER_END, -- End Date of Period [CMM_VLOGP_QUOTPERIOD_END]
PREVIOUS_ROOT_DOC, -- Previous Root Doc [CMM_VLOGP_PREV_REFDOC]
PREVIOUS_ROOT_DOC_ITM, -- Prev Root Doc Item [CMM_VLOGP_PREV_REFDOC_ITEM]
FX_FIX_CALCTYPE_TERM_TO_DOC, -- Fixed Fx Calc Type [CMM_FIXED_CALC_TYPE]
FX_FIX_FACTOR_FROM_TERM_TO_DOC, -- Fixed Frm-Fctr Conv. [CMM_FIXED_FACTOR_FROM]
FX_FIX_FACTOR_TO_TERM_TO_DOC, -- Fxd Term To-Fct Conv [CMM_FIXED_FACTOR_TO]
FX_MRKT_TO_TERM_FX_RATETYPE, -- Mkt to Term Crcy Cnv [CMM_MRKT_TO_TERM_FX_RATETYPE]
FX_COND_TO_DOC_FXRATETYPE, -- Cnd to Doc Crcy Conv [CMM_COND_TO_DOC_FXRATETYPE]
FX_DOC_TO_STAT_FXRATETYPE, -- Doc to Stat Crcy Cnv [CMM_DOC_TO_STAT_FXRATETYPE]
FX_COND_TO_STAT_FXRATETYPE, -- Cnd to Stat Crcy Cnv [CMM_COND_TO_STAT_FXRATETYPE]
UOM_QUOT_TO_TERM_FACTOR_FROM, -- Quot To Term UoM [CMM_QUOT_TO_TERM_FACTOR_FROM]
UOM_QUOT_TO_TERM_FACTOR_TO, -- Factorto Quot to Trm [CMM_QUOT_TO_TERM_FACTOR_TO]
FX_EXCH_RATE_MATURITY_DATE, -- Exch Rate Mat. Date [CMM_EXCH_RATE_MATURITY_DATE]
SDM_VERSION, -- SDM Version [CMM_VLOGP_SDM_VERSION]
UOM_COMM_TO_TERM_FACTOR_NUM, -- Commodty To Term UoM [CMM_COMM_TO_TERM_FACTOR_FROM]
UOM_COMM_TO_TERM_FACTOR_DEN, -- Commodty To Term UoM [CMM_COMM_TO_TERM_FACTOR_TO]
PRIMARY KEY (MANDT, PRICING_KEY, VERSION, KPOSN, KSCHL, KSCHL_SUBKEY)
);
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