TEXT_CTY_EXPOS

Commodity Price Exposure (obsolete) | #obsolete | Component: Basic Functions
Column Name Description
MANDT Client
EXP_GRP_IND Paper/Physical Indicator for Exposure Group Show values
COMPANY_CODE Company Code
EXPOSURE_ID Commodity Price Exposure ID
ITEM_ID Commodity Exposure Line Item ID
SUBEXPOS_ID Commodity Exposure Sub Item ID
VERSION Version of a Commodity Price Exposure
Column Name Description
💲 Exposure Amount Currency (FOREIGN_CURR):
FOREIGN_AMT Exposure Amount
💲 Exposure Amount Currency (PRICE_CURRENCY):
PRICE Exposure Amount
Column Name Description
📏 Base Unit of Measure for the Commodity (BASE_UOM):
BASE_QUANTITY Base Quantity
📏 Unit of Measure for the Commodity (UNIT_OF_MEASURE):
QUANTITY Quantity
📏 Mass Unit of Measure for the Commodity (MASS_UOM):
MASS_QUANTITY Mass
📏 Volume Unit of Measure for the Commodity (VOLUME_UOM):
VOLUME_QUANTITY Volume
Column Name Description
REPORTING_DATE Reporting Date
EXPOS_DUE_DATE Date on which the exposure is due and expires
KEYDATE Maturity Key Date
ISSUE_DATE Issue Date
PRICE_DATE Price Date
PRICE_TIME Price Quotation Time
VALID_FROM_DATE Valid-From Date of Exposure
VALID_FROM_TIME Valid-From Time of Commodity Derivative
VALID_TO_DATE Valid-To Date of Commodity Derivative
VALID_TO_TIME Valid-To Time of Commodity Derivative
EXER_DATE_EARLIEST CPE Price Fixation - Earliest Exercise Date
EXER_DATE_LATEST CPE Price Fixation - Latest Exercise Date
CONTRACT_DATE Contract Conclusion Date
START_TERM Term Start
END_TERM Term End
PAYMENT_DATE Date on which the Payment will be made
DELIVERY_DATE Delivery Date of a Commodity Derivative
ATTRIBUTE_DH01 Value of a Free Attribute (Date)
ATTRIBUTE_DI01 Value of a Free Attribute (Date)
Column Name Description
EXP_GRP_IND Paper/Physical Indicator for Exposure Group Show values
TIMING Timing/Periodicity of Commodity Forward Indexes Show values
PRICING_STATUS Future/Basis Price Fixation Status Show values
FLG_DCS_DEP DCS-Based Show values
VAR_PRICE_CAT Floating Price Category Show values
CREATION_IND Raw Exposure Creation Indicator Show values
FIX_VAR_IND Fixed/Floating Indicator Show values
FIXING_STATUS Fixation Status Show values
SIDE Direction of Transaction Show values
REPORTING_GRP Exposure Reporting Group Show values
PRC_FIXATION_STATUS Status of Price Fixation Option Show values
EXP_APPROACH_CAT Commodity Exposure Approach Category Show values
INVOICING_STATUS Invoicing Status Show values
DELIVERY_STATUS Delivery Status Show values
Column Name Description Domain name
OS_GUID Globally Unique Identifier SYSUUID
LOG_SYSTEM Logical system LOGSYS
EXPOSURE_ORIGIN Exposure Origin TEM_EXPOSURE_ORIGIN
ORIGIN_TSTMP Origin Timestamp TZNTSTMPS
EXT_DOC_NO External Document Number FTR_EXTERNAL_DOC_NUMBER
EXT_ITEM_ID External Item ID FTR_EXTERNAL_ITEM_ID
PHYS_COMM_ID Commodity TBA_STOEFFCHEN
COMMODITY_ID Commodity ID (obsolete) TPM_CTY_ID
DCS Derivative Contract Specification ID TBA_DCSID
MIC Market Identifier Code TBA_MIC
PRICE_TYPE Type of Price Quotation VVSKURSART
TENOR Time to Maturity TBA_TENOR
CONTRACT_CODE Contract Maturity Code TBA_CONTRACT_CODE
BASIS_CATEGORY Basis Category TBAC_BASIS_CAT
BASIS_TYPE Basis Type TBAC_BASIS_TYPE
BASIS_ID Basis ID TBAC_BASIS_ID
PRICING_COMPONENT_GRP Group for Price Fixation FTR_PRICING_COMPONENT_GRP
PLANNING_PERIOD Planning Period TEM_PLANNING_PERIOD
PLANNING_YEAR Plan Year GJAHR
REPORTING_PERIOD Reporting Period TEM_PLANNING_PERIOD
REPORTING_YEAR Reporting Year GJAHR
NUMBER_OF_CONTRACTS Number of Contracts ASTUECK
PRICE_UNIT_QUOT Price Unit of Quotation FTR_PRICE_UNIT_OF_QUOT
VALID_FROM_TST Valid-From Timestamp of Commodity Derivative TZNTSTMPS
VALID_TO_TST Valid-To Timestamp of Commodity Derivative TZNTSTMPS
ORIGIN_TSTMP_TO Origin Timestamp TZNTSTMPS
EXP_FLOW_TYPE Exposure Activity Type FTR_EXPOSURE_FLOW_TYPE
P_TRANS_CAT Exposure Category of Raw Exposure FTR_RAWEXPOS_TRANSCAT
TRANSACTIVITY Exposure Activity FTR_TRANSACT
RISK_PROFILE_ID Commodity Risk Profile ID FTR_COEX_RISK_PROFILE_ID
EXP_TYPE Exposure Position Type FTR_EXPOSURE_TYPE
PRODUCT_CAT Product Category VVSANLF
PRODUCT_TYPE Product Type VVSART
F_TRANS_CAT Transaction Category T_SFGTYP
TRANS_TYPE Financial Transaction Type T_SFHAART
TRANS_ACT_TYPE Transaction Activity Category T_SFGZUTY
TRANS_ID Financial Transaction T_RFHA
COUNTERPARTY_ID Business Partner Number BU_PARTNER
EXT_ACCOUNT_ID External Account TPM_EXT_ACCOUNT
FUTURES_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
DERIVATIVE_CONTRACT_ID Contract for Listed Options and Futures WP_RANL
PORTFOLIO Portfolio RPORTB
FINANCE_PROJECT Finance Project T_TFPROJ
ASSIGNMENT Assignment TEXT18
INTERNAL_REF Internal Reference CHAR16
CHARACTERISTICS Characteristics CHAR25
COUNTRY Country/Region Key LAND1
PROFIT_CENTER Profit Center PRCTR
PLANT Plant WERKS
STORAGE_LOCATION Storage location LGORT
MATNR Material Number MATNR
BATCHNR Batch Number CHARG
CONDITION_APPL Application KAPPL
CONDITION_TYPE Condition Type FTR_CONDITION_TYPE
ROOT_DOCUMENT_ID Root Document ID FTR_ROOT_DOCUMENT_ID
REFERENCE_ID Reference ID FTR_REFERENCE_ID
OBJTYP Object Type OJ_NAME
OBJID Transaction ID CMM_MTM_OBJID
OBJITEMID Item Number of Trading Contract TPOSN
OBJID_FISCYEAR Fiscal Year GJAHR
REF_OBJTYP Object Type OJ_NAME
REF_OBJID Transaction ID CMM_MTM_OBJID
REF_OBJITEMID Item Number of Trading Contract TPOSN
REF_OBJID_FISCYEAR Fiscal Year GJAHR
ROOT_OBJTYP Object Type OJ_NAME
ROOT_OBJID Transaction ID CMM_MTM_OBJID
ROOT_OBJITEMID Item Number of Trading Contract TPOSN
ROOT_OBJID_FISCYEAR Fiscal Year GJAHR
ENTITY_KEY Key of an Business Entity requiring an End-of-day snapshot
OBJNR Financial Object Number J_OBJNR
Master Data Relations Join Conditions
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_LH01 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_LI01 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_LI02 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_LI03 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_LI04 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char10)
  • ?
  • Value of a Free Attribute (Char10)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_M.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_MI01 == TEXC_ATTR_M.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_M.MANDT
Value of a Free Attribute (Char10)
  • ?
  • Value of a Free Attribute (Char10)
  • Client
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_M.ATTRIBUTE_SUFFIX
  • TEXT_CTY_EXPOS.ATTRIBUTE_MI02 == TEXC_ATTR_M.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_M.MANDT
Value of a Free Attribute (Char4)
  • Value of a Free Attribute (Char4)
  • ?
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_S.MANDT
  • TEXT_CTY_EXPOS.ATTRIBUTE_SH01 == TEXC_ATTR_S.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX
Value of a Free Attribute (Char4)
  • Value of a Free Attribute (Char4)
  • ?
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_S.MANDT
  • TEXT_CTY_EXPOS.ATTRIBUTE_SH02 == TEXC_ATTR_S.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX
Value of a Free Attribute (Char4)
  • Value of a Free Attribute (Char4)
  • ?
  • TEXT_CTY_EXPOS.MANDT == TEXC_ATTR_S.MANDT
  • TEXT_CTY_EXPOS.ATTRIBUTE_SI01 == TEXC_ATTR_S.ATTRIBUTE_VALUE
  • TEXT_CTY_EXPOS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX
On Behalf of Company Code
  • TEXT_CTY_EXPOS.MANDT == T001.MANDT
  • TEXT_CTY_EXPOS.BEHALF_OF_COMPANY == T001.BUKRS
Segment for Segmental Reporting
Business Area
  • TEXT_CTY_EXPOS.MANDT == TGSB.MANDT
  • TEXT_CTY_EXPOS.GSBER == TGSB.GSBER
Controlling Area
  • TEXT_CTY_EXPOS.MANDT == TKA01.MANDT
  • TEXT_CTY_EXPOS.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • ?
  • TEXT_CTY_EXPOS.MANDT == CSKS.MANDT
  • TEXT_CTY_EXPOS.[column in domain "DATBI"] == CSKS.DATBI
  • TEXT_CTY_EXPOS.KOSTL == CSKS.KOSTL
  • TEXT_CTY_EXPOS.[column in domain "KOKRS"] == CSKS.KOKRS
Portfolio
  • ?
  • Portfolio
  • Client
  • TEXT_CTY_EXPOS.[column in domain "BUKRS"] == TWPOB.BUKRS
  • TEXT_CTY_EXPOS.RPORTB == TWPOB.RPORTB
  • TEXT_CTY_EXPOS.MANDT == TWPOB.MANDT