TEXT_CTY_EXPOS - Commodity Price Exposure (obsolete)

Commodity Price Exposure (obsolete) information is stored in SAP table TEXT_CTY_EXPOS.
It is part of development package FTR_COMMODITY_EXPOSURE in software component LO-CMM-BF. This development package consists of objects that can be grouped under "Commodity Price Exposures".

Fields for table TEXT_CTY_EXPOS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
EXP_GRP_IND	Paper/Physical Indicator for Exposure Group	X	FTI_EXP_GROUP_INDICATOR	CHAR	2
COMPANY_CODE	Company Code	X	BUKRS	CHAR	8
EXPOSURE_ID	Commodity Price Exposure ID	X	FTR_CTY_EXPOS_ID	CHAR	26
ITEM_ID	Commodity Exposure Line Item ID	X	FTR_CTY_ITEM_ID	NUMC	10
SUBEXPOS_ID	Commodity Exposure Sub Item ID	X	FTR_CTY_SUBITEM_ID	NUMC	8
VERSION	Version of a Commodity Price Exposure	X	FTR_CTY_EXPOS_VERSION	NUMC	20
OS_GUID	Globally Unique Identifier		OS_GUID	RAW	16
.INCLUDE				TEXS_COEX_EXTERNAL_KEY	0
LOG_SYSTEM	Logical system		LOGSYS	CHAR	20	*
EXPOSURE_ORIGIN	Exposure Origin		FTR_EXPOSURE_ORIGIN	CHAR	10	*
ORIGIN_TSTMP	Origin Timestamp		FTR_ORIGIN_TSTMP	DEC	8
EXT_DOC_NO	External Document Number		FTR_EXTERNAL_DOC_NUMBER	CHAR	152
EXT_ITEM_ID	External Item ID		FTR_EXTERNAL_ITEM_ID	CHAR	80
REPORTING_DATE	Reporting Date		FTR_REPORTING_DATE	DATS	16
EXPOS_DUE_DATE	Date on which the exposure is due and expires		FTR_EXPOSURE_DATE	DATS	16
.INCLUDE				TEXS_COEX_COMMODITY	0
PHYS_COMM_ID	Commodity		TBA_STOEFFCHEN	CHAR	36
COMMODITY_ID	Commodity ID (obsolete)		TRCO_COMM_ID	CHAR	36
.INCLUDE				TEXS_COEX_PRICE_INDEX	0
DCS	Derivative Contract Specification ID		TBA_DCSID	CHAR	40
MIC	Market Identifier Code		TBA_MIC	CHAR	8
PRICE_TYPE	Type of Price Quotation		TBA_PRICETYPE	CHAR	4
TENOR	Time to Maturity		TBA_TENOR	CHAR	20
TIMING	Timing/Periodicity of Commodity Forward Indexes		TBA_TIMING	NUMC	4
KEYDATE	Maturity Key Date		TBA_KEYDATE	DATS	16
CONTRACT_CODE	Contract Maturity Code		TBA_CONTRACT_CODE	CHAR	26
.INCLUDE				TEXS_COEX_BASIS_PRICE	0
BASIS_CATEGORY	Basis Category		TBAC_BASIS_CAT	NUMC	6	*
BASIS_TYPE	Basis Type		TBAC_BASIS_TYPE	CHAR	6
BASIS_ID	Basis ID		TBAC_BASIS_ID	CHAR	36
ISSUE_DATE	Issue Date		FTR_ISSUE_DATE	DATS	16
PRICING_COMPONENT_GRP	Group for Price Fixation		FTR_PRICING_COMPONENT_GRP	NUMC	8
PRICING_STATUS	Future/Basis Price Fixation Status		CMM_FBFIX_STATUS	CHAR	4
FLG_DCS_DEP	DCS-Based		TBAC_FLG_DCS_DEP	CHAR	2
VAR_PRICE_CAT	Floating Price Category		FTR_VARIABLE_PRICE_CATEGORY	CHAR	2
.INCLUDE				TEXS_COEX_PLAN_PERIOD	0
PLANNING_PERIOD	Planning Period		TEM_PLANNING_PERIOD	CHAR	6	*
PLANNING_YEAR	Plan Year		TEM_PLANNING_YEAR	NUMC	8
REPORTING_PERIOD	Reporting Period		FTR_CTY_REPORTING_PERIOD	CHAR	6	*
REPORTING_YEAR	Reporting Year		FTR_CTY_REPORTING_YEAR	NUMC	8
.INCLUDE				TEXS_COEX_QUANTITY	0
BASE_QUANTITY	Base Quantity		FTR_EXPOSURE_BASE_QTY	QUAN	7
BASE_UOM	Base Unit of Measure for the Commodity		TPM_CTY_BASE_UOM	UNIT	6	*
QUANTITY	Quantity		FTR_EXPOSURE_QTY	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
NUMBER_OF_CONTRACTS	Number of Contracts		TB_CONTRACTS_NUMBER	DEC	8
MASS_QUANTITY	Mass		FTR_EXPOSURE_MASS_QTY	QUAN	7
MASS_UOM	Mass Unit of Measure for the Commodity		TPM_CTY_MASS_UOM	UNIT	6	*
VOLUME_QUANTITY	Volume		FTR_EXPOSURE_VOLUME_QTY	QUAN	7
VOLUME_UOM	Volume Unit of Measure for the Commodity		TPM_CTY_VOLUME_UOM	UNIT	6	*
.INCLUDE				TEXS_COEX_FIX_AMOUNT	0
FOREIGN_AMT	Exposure Amount		FTR_EXPOSURE_AMOUNT	CURR	9
FOREIGN_CURR	Exposure Amount Currency		FTR_EXPOSURE_CURR	CUKY	10	*
TARGET_CURR	Target Currency of Exposure		FTR_EXPOSURE_CURRENCY_TARGET	CUKY	10	*
.INCLUDE				TEXS_COEX_FLOAT_PRICE	0
PRICE	Exposure Amount		FTR_EXPOSURE_AMOUNT	CURR	9
PRICE_CURRENCY	Exposure Amount Currency		FTR_EXPOSURE_CURR	CUKY	10	*
PRICE_UNIT_QUOT	Price Unit of Quotation		FTR_PRICE_UNIT_OF_QUOT	DEC	3
PRICE_UOM	Price Unit of Measure for the Commodity		TPM_CTY_PRICE_UOM	UNIT	6	*
PRICE_DATE	Price Date		FTR_PRICE_DATE	DATS	16
PRICE_TIME	Price Quotation Time		FTR_QUOTATION_TIME	TIMS	12
.INCLUDE				TEXS_COEX_ADMIN	0
VALID_FROM_TST	Valid-From Timestamp of Commodity Derivative		FTR_VALID_FROM_STMP	DEC	8
VALID_TO_TST	Valid-To Timestamp of Commodity Derivative		FTR_VALID_TO_STMP	DEC	8
CREATION_IND	Raw Exposure Creation Indicator		FTR_CREATION_INDICATOR	CHAR	2
VALID_FROM_DATE	Valid-From Date of Exposure		FTR_VALID_FROM	DATS	16
VALID_FROM_TIME	Valid-From Time of Commodity Derivative		FTR_VALID_FROM_TIME	TIMS	12
VALID_TO_DATE	Valid-To Date of Commodity Derivative		FTR_VALID_TO	DATS	16
VALID_TO_TIME	Valid-To Time of Commodity Derivative		FTR_VALID_TO_TIME	TIMS	12
ORIGIN_TSTMP_TO	Origin Timestamp		FTR_ORIGIN_TSTMP	DEC	8
.INCLUDE				TEXS_COEX_ATTR	0
EXP_FLOW_TYPE	Exposure Activity Type		FTR_EXPOSURE_FLOW_TYPE	CHAR	10
P_TRANS_CAT	Exposure Category of Raw Exposure		FTR_RAWEXPOS_TRANSCAT	CHAR	4	*
TRANSACTIVITY	Exposure Activity		FTR_TRANSACT	NUMC	4	*
FIX_VAR_IND	Fixed/Floating Indicator		FTR_FIX_VARIABLE_INDICATOR	CHAR	2
FIXING_STATUS	Fixation Status		FTR_FIXING_STATUS	CHAR	2
SIDE	Direction of Transaction		TB_RKONDGR	NUMC	2
RISK_PROFILE_ID	Commodity Risk Profile ID		FTR_COEX_RISK_PROFILE_ID	CHAR	6	*
REPORTING_GRP	Exposure Reporting Group		FTR_CTY_EXP_REP_GRP	CHAR	4
PRC_FIXATION_STATUS	Status of Price Fixation Option		CPET_PRCFIX_STATUS	CHAR	2
EXER_DATE_EARLIEST	CPE Price Fixation - Earliest Exercise Date		CPET_PRCFIX_EARLY_EXERCISEDATE	DATS	16
EXER_DATE_LATEST	CPE Price Fixation - Latest Exercise Date		CPET_PRCFIX_LATE_EXERCISEDATE	DATS	16
.INCLUDE				TEXS_COEX_POS_ATTR	0
EXP_APPROACH_CAT	Commodity Exposure Approach Category		FTR_EXP_APPR_CAT	NUMC	2
EXP_TYPE	Exposure Position Type		FTR_EXPOSURE_TYPE	CHAR	10
.INCLUDE				TEXS_COEX_FTA_ATTR	0
PRODUCT_CAT	Product Category		SANLF	NUMC	6	*
PRODUCT_TYPE	Product Type		VVSART	CHAR	6
F_TRANS_CAT	Transaction Category		TB_SFGTYP	NUMC	6	*
TRANS_TYPE	Financial Transaction Type		TB_SFHAART	CHAR	6
TRANS_ACT_TYPE	Transaction Activity Category		TB_SFGZUTY	NUMC	4
TRANS_ID	Financial Transaction		TB_RFHA	CHAR	26
COUNTERPARTY_ID	Business Partner Number		TB_KUNNR_NEW	CHAR	20
EXT_ACCOUNT_ID	External Account		TPM_EXT_ACCOUNT	CHAR	20
FUTURES_ACCOUNT	Futures Account for Listed Options and Futures		TPM_POS_ACCOUNT_FUT	CHAR	20
DERIVATIVE_CONTRACT_ID	Contract for Listed Options and Futures		FTR_DERIVATIVE_CONTRACT_ID	CHAR	26
PORTFOLIO	Portfolio		RPORTB	CHAR	20
FINANCE_PROJECT	Finance Project		TB_TFPROJ	CHAR	26
ASSIGNMENT	Assignment		TB_ZUOND	CHAR	36
INTERNAL_REF	Internal Reference		TB_REFER	CHAR	32
CHARACTERISTICS	Characteristics		TB_MERKM	CHAR	50
CONTRACT_DATE	Contract Conclusion Date		TB_DVTRAB	DATS	16
START_TERM	Term Start		TB_DBLFZ	DATS	16
END_TERM	Term End		TB_DELFZ	DATS	16
.INCLUDE				TEXS_COEX_EXTDOC_ATTR	0
COUNTRY	Country/Region Key		LAND1	CHAR	6	*
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
PROFIT_CENTER	Profit Center		PRCTR	CHAR	20
PLANT	Plant		WERKS_D	CHAR	8
STORAGE_LOCATION	Storage location		LGORT_D	CHAR	8	*
MATNR	Material Number		MATNR	CHAR	80
BATCHNR	Batch Number		CHARG_D	CHAR	20	*
CONDITION_APPL	Application		KAPPL	CHAR	4	*
CONDITION_TYPE	Condition Type		FTR_CONDITION_TYPE	CHAR	8
PAYMENT_DATE	Date on which the Payment will be made		FTR_PAYMENT_DATE	DATS	16
DELIVERY_DATE	Delivery Date of a Commodity Derivative		FTR_DELIVERY_DATE	DATS	16
INVOICING_STATUS	Invoicing Status		FTR_INVOICING_STATUS	CHAR	2
DELIVERY_STATUS	Delivery Status		FTR_DELIVERY_STATUS	CHAR	2
ROOT_DOCUMENT_ID	Root Document ID		FTR_ROOT_DOCUMENT_ID	CHAR	152
REFERENCE_ID	Reference ID		FTR_REFERENCE_ID	CHAR	152
OBJTYP	Object Type		SWO_OBJTYP	CHAR	20	*
OBJID	Transaction ID		CMM_MTM_OBJID	CHAR	40
OBJITEMID	Item Number of Trading Contract		TPOSN	NUMC	12
OBJID_FISCYEAR	Fiscal Year		GJAHR	NUMC	8
REF_OBJTYP	Object Type		SWO_OBJTYP	CHAR	20	*
REF_OBJID	Transaction ID		CMM_MTM_OBJID	CHAR	40
REF_OBJITEMID	Item Number of Trading Contract		TPOSN	NUMC	12
REF_OBJID_FISCYEAR	Fiscal Year		GJAHR	NUMC	8
ROOT_OBJTYP	Object Type		SWO_OBJTYP	CHAR	20	*
ROOT_OBJID	Transaction ID		CMM_MTM_OBJID	CHAR	40
ROOT_OBJITEMID	Item Number of Trading Contract		TPOSN	NUMC	12
ROOT_OBJID_FISCYEAR	Fiscal Year		GJAHR	NUMC	8
.INCLUDE				TEXS_HEADER_FREE_ATTR	0
ATTRIBUTE_SH01	Value of a Free Attribute (Char4)		FTR_ATTRIBUTE_SHORT	CHAR	8	TEXC_ATTR_S
ATTRIBUTE_SH02	Value of a Free Attribute (Char4)		FTR_ATTRIBUTE_SHORT	CHAR	8	TEXC_ATTR_S
ATTRIBUTE_LH01	Value of a Free Attribute (Char 20)		FTR_ATTRIBUTE_LONG	CHAR	40	TEXC_ATTR_L
ATTRIBUTE_DH01	Value of a Free Attribute (Date)		FTR_ATTRIBUTE_DATE	DATS	16
.INCLUDE				TEXS_ITEM_FREE_ATTR	0
ATTRIBUTE_LI01	Value of a Free Attribute (Char 20)		FTR_ATTRIBUTE_LONG	CHAR	40	TEXC_ATTR_L
ATTRIBUTE_LI02	Value of a Free Attribute (Char 20)		FTR_ATTRIBUTE_LONG	CHAR	40	TEXC_ATTR_L
ATTRIBUTE_LI03	Value of a Free Attribute (Char 20)		FTR_ATTRIBUTE_LONG	CHAR	40	TEXC_ATTR_L
ATTRIBUTE_LI04	Value of a Free Attribute (Char 20)		FTR_ATTRIBUTE_LONG	CHAR	40	TEXC_ATTR_L
ATTRIBUTE_MI01	Value of a Free Attribute (Char10)		FTR_ATTRIBUTE_MEDIUM	CHAR	20	TEXC_ATTR_M
ATTRIBUTE_MI02	Value of a Free Attribute (Char10)		FTR_ATTRIBUTE_MEDIUM	CHAR	20	TEXC_ATTR_M
ATTRIBUTE_SI01	Value of a Free Attribute (Char4)		FTR_ATTRIBUTE_SHORT	CHAR	8	TEXC_ATTR_S
ATTRIBUTE_DI01	Value of a Free Attribute (Date)		FTR_ATTRIBUTE_DATE	DATS	16
.INCLUDE				TEXS_ATTRIBUTES_OE	0
RPORTB	Portfolio		RPORTB	CHAR	20	TWPOB
KOSTL	Cost Center		KOSTL	CHAR	20	CSKS
GSBER	Business Area		GSBER	CHAR	8	TGSB
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
FB_SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	FAGL_SEGM
BEHALF_OF_COMPANY	On Behalf of Company Code		TRBA_BEHALF_OF_COMPANY	CHAR	8	T001
.INCLUDE				TEXS_COEX_EOD	0
ENTITY_KEY	Key of an Business Entity requiring an End-of-day snapshot		CMM_DEND_ENTITY_KEY	RAW	20
OBJNR	Financial Object Number		FTR_OBJNR	CHAR	44