TEXT_CTY_EXPOS SAP (Commodity Price Exposure) Table details

Dictionary Type: Table
Description: Commodity Price Exposure




ABAP Code to SELECT data from TEXT_CTY_EXPOS
Related tables to TEXT_CTY_EXPOS
Access table TEXT_CTY_EXPOS




Table field list including key, data, relationships and ABAP select examples

TEXT_CTY_EXPOS is a standard SAP Table which is used to store Commodity Price Exposure data and is available within R/3 SAP systems depending on the version and release level.

The TEXT_CTY_EXPOS table consists of various fields, each holding specific information or linking keys about Commodity Price Exposure data available in SAP. These include EXP_GRP_IND (Paper/Physical Indicator for Exposure Group), COMPANY_CODE (Company Code), EXPOSURE_ID (Commodity Price Exposure ID), ITEM_ID (Commodity Exposure Line Item ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TEXT_CTY_EXPOS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
EXP_GRP_INDPaper/Physical Indicator for Exposure Group FTI_EXP_GROUP_INDICATORCHAR1FTI_EXP_GROUP_INDICATOR
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
EXPOSURE_IDCommodity Price Exposure ID FTR_CTY_EXPOS_IDCHAR13ALPHAFTR_CTY_EXPOS_ID
ITEM_IDCommodity Exposure Line Item ID FTR_CTY_ITEM_IDNUMC5FTR_CTY_ITEM_ID
SUBEXPOS_IDCommodity Exposure Sub Item ID FTR_CTY_SUBITEM_IDNUMC4FTR_CTY_SUBITEM_ID
VERSIONVersion of a Commodity Price Exposure FTR_CTY_EXPOS_VERSIONNUMC10FTR_CTY_EXPOS_VERSION
OS_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
LOG_SYSTEMLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
EXPOSURE_ORIGINExposure Origin FTR_EXPOSURE_ORIGINCHAR5Assigned to domainTEM_EXPOSURE_ORIGIN
EXT_DOC_NOExternal Document Number FTR_EXTERNAL_DOC_NUMBERCHAR75FTR_EXTERNAL_DOC_NUMBER
EXT_ITEM_IDExternal Item ID FTR_EXTERNAL_ITEM_IDCHAR40FTR_EXTERNAL_ITEM_ID
REPORTING_DATEReporting Date FTR_REPORTING_DATEDATS8FTR_REPORTING_DATE
EXPOS_DUE_DATEDate on Which Exposure Is Due / Expires FTR_EXPOSURE_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
PHYS_COMM_IDPhysical Commodity TBA_STOEFFCHENCHAR18Assigned to domainTBA_STOEFFCHEN
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
DCSDerivative Contract Specification ID TBA_DCSIDCHAR6Assigned to domainTBA_DCSIDTBA_DCSIDTBAH_DCS
MICMarket Identifier Code TBA_MICCHAR4Assigned to domainTBA_MICTBA_MICTBAH_MIC
PRICE_TYPEType of Price Quotation TBA_PRICETYPECHAR2Assigned to domainVVSKURSARTRATETYPE_F4
TENORTime to Maturity TBA_TENORCHAR10Assigned to domainTBA_TENORTBAH_TENOR
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
PLANNING_PERIODPlanning Period TEM_PLANNING_PERIODCHAR3Assigned to domainTEM_PLANNING_PERIOD
PLANNING_YEARPlan Year TEM_PLANNING_YEARNUMC4GJAHRGJAHR
REPORTING_PERIODReporting Period FTR_CTY_REPORTING_PERIODCHAR3Assigned to domainTEM_PLANNING_PERIOD
REPORTING_YEARReporting Year FTR_CTY_REPORTING_YEARNUMC4GJAHRGJAHR
BASE_QUANTITYBasis Quantity FTR_EXPOSURE_BASE_QTYQUAN13(3) FTR_EXPOSURE_QTY
BASE_UOMBasis Unit of Measure for the Commodity TPM_CTY_BASE_UOMUNIT3Assigned to domainCUNITMEINS
QUANTITYQuantity FTR_EXPOSURE_QTYQUAN13(3) FTR_EXPOSURE_QTY
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
NUMBER_OF_CONTRACTSNumber of Contracts TB_CONTRACTS_NUMBERDEC15(5) ASTUECK
FOREIGN_AMTExposure Amount FTR_EXPOSURE_AMOUNTCURR17(2) FTR_EXPOSURE_AMOUNT
FOREIGN_CURRExposure Amount Currency FTR_EXPOSURE_CURRCUKY5Assigned to domainWAERS
TARGET_CURRTarget Currency of Exposure FTR_EXPOSURE_CURRENCY_TARGETCUKY5Assigned to domainWAERS
PRICEExposure Amount FTR_EXPOSURE_AMOUNTCURR17(2) FTR_EXPOSURE_AMOUNT
PRICE_CURRENCYExposure Amount Currency FTR_EXPOSURE_CURRCUKY5Assigned to domainWAERS
PRICE_UNIT_QUOTPrice Unit of Quotation FTR_PRICE_UNIT_OF_QUOTDEC5FTR_PRICE_UNIT_OF_QUOT
PRICE_UOMPrice Unit of Measure for the Commodity TPM_CTY_PRICE_UOMUNIT3Assigned to domainCUNITMEINS
PRICE_DATEPrice Date FTR_PRICE_DATEDATS8FTR_PRICE_DATE
PRICE_TIMEPrice Quotation Time FTR_QUOTATION_TIMETIMS6TIME
VALID_FROM_TSTValid From Timestamp FTR_VALID_FROM_STMPDEC15TZNTSTMPS
VALID_TO_TSTValid To Timestamp FTR_VALID_TO_STMPDEC15TZNTSTMPS
CREATION_INDRaw Exposure Creation Indicator FTR_CREATION_INDICATORCHAR1FTR_CREATION_INDICATOR
VALID_FROM_DATEValid From Date FTR_VALID_FROMDATS8FTR_VALID_FROM
VALID_FROM_TIMEValid From Time FTR_VALID_FROM_TIMETIMS6FTR_VALID_FROM_TIME
VALID_TO_DATEValid To Date FTR_VALID_TODATS8FTR_VALID_TO
VALID_TO_TIMEValid To Time FTR_VALID_TO_TIMETIMS6FTR_VALID_TO_TIME
EXP_FLOW_TYPEExposure Activity Type FTR_EXPOSURE_FLOW_TYPECHAR5Assigned to domainFTR_EXPOSURE_FLOW_TYPETEXH_F4_ACTIVITY_TYPE
P_TRANS_CATExposure Category of Raw Exposure FTR_RAWEXPOS_TRANSCATCHAR2Assigned to domainFTR_RAWEXPOS_TRANSCAT
TRANSACTIVITYExposure Activity FTR_TRANSACTNUMC2Assigned to domainFTR_TRANSACT
FIX_VAR_INDFixed/Floating Indicator FTR_FIX_VARIABLE_INDICATORCHAR1FTR_FIX_VARIABLE_INDICATOR
FIXING_STATUSFixing Status FTR_FIXING_STATUSCHAR1FTR_FIXING_STATUS
SIDEDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
RISK_PROFILE_IDCommodity Risk Profile ID FTR_COEX_RISK_PROFILE_IDCHAR3Assigned to domainFTR_COEX_RISK_PROFILE_ID
REPORTING_GRPExposure Reporting Group FTR_CTY_EXP_REP_GRPCHAR2FTR_CTY_EXP_REP_GRP
PRC_FIXATION_STATUSStatus of Price Fixation Option CPET_PRCFIX_STATUSCHAR1STATV
EXER_DATE_EARLIESTCPE Price Fixation - Earliest Exercise Date CPET_PRCFIX_EARLY_EXERCISEDATEDATS8DATE
EXER_DATE_LATESTCPE Price Fixation - Latest Exercise Date CPET_PRCFIX_LATE_EXERCISEDATEDATS8DATE
EXP_APPROACH_CATCommodity Exposure Approach Category FTR_EXP_APPR_CATNUMC1FTR_EXP_APPR_CAT
EXP_TYPEExposure Position Type FTR_EXPOSURE_TYPECHAR5Assigned to domainFTR_EXPOSURE_TYPETEXH_F4_EXP_TYPE
PRODUCT_CATProduct Category SANLFNUMC3Assigned to domainVVSANLF
PRODUCT_TYPEProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
F_TRANS_CATTransaction Category TB_SFGTYPNUMC3Assigned to domainT_SFGTYP
TRANS_TYPEFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
TRANS_ACT_TYPETransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
TRANS_IDFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
COUNTERPARTY_IDBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
EXT_ACCOUNT_IDExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
FUTURES_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
DERIVATIVE_CONTRACT_IDContract for Listed Options and Futures FTR_DERIVATIVE_CONTRACT_IDCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
FINANCE_PROJECTFinance Project TB_TFPROJCHAR13T_TFPROJ
ASSIGNMENTAssignment TB_ZUONDCHAR18TEXT18
INTERNAL_REFInternal Reference TB_REFERCHAR16CHAR16
CHARACTERISTICSCharacteristics TB_MERKMCHAR25CHAR25
CONTRACT_DATEContract Conclusion Date TB_DVTRABDATS8DATUM
START_TERMTerm Start TB_DBLFZDATS8DATUM
END_TERMTerm End TB_DELFZDATS8DATUM
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
PROFIT_CENTERProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
STORAGE_LOCATIONStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BATCHNRBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
CONDITION_APPLApplication KAPPLCHAR2Assigned to domainKAPPLKAP
CONDITION_TYPECondition Type FTR_CONDITION_TYPECHAR4FTR_CONDITION_TYPE
PAYMENT_DATEDate on which the Payment will be made FTR_PAYMENT_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
DELIVERY_DATEDate on which the Item will be delivered FTR_DELIVERY_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
INVOICING_STATUSInvoicing Status FTR_INVOICING_STATUSCHAR1FTR_INVOICING_STATUS
DELIVERY_STATUSDelivery Status FTR_DELIVERY_STATUSCHAR1FTR_DELIVERY_STATUS
ROOT_DOCUMENT_IDRoot Document ID FTR_ROOT_DOCUMENT_IDCHAR75FTR_ROOT_DOCUMENT_ID
REFERENCE_IDReference ID FTR_REFERENCE_IDCHAR75FTR_REFERENCE_ID
ATTRIBUTE_SH01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4TEXC_ATTR_SFTR_ATTRIBUTE_SHORT
ATTRIBUTE_SH02Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4TEXC_ATTR_SFTR_ATTRIBUTE_SHORT
ATTRIBUTE_LH01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_DH01Value of a free attribute (Date) FTR_ATTRIBUTE_DATEDATS8FTR_ATTRIBUTE_DATE
ATTRIBUTE_LI01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_LI02Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_LI03Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_LI04Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_MI01Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10TEXC_ATTR_MFTR_ATTRIBUTE_MEDIUM
ATTRIBUTE_MI02Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10TEXC_ATTR_MFTR_ATTRIBUTE_MEDIUM
ATTRIBUTE_SI01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4TEXC_ATTR_SFTR_ATTRIBUTE_SHORT
ATTRIBUTE_DI01Value of a free attribute (Date) FTR_ATTRIBUTE_DATEDATS8FTR_ATTRIBUTE_DATE

Key field Non-key field



How do I retrieve data from SAP table TEXT_CTY_EXPOS using ABAP code

The following ABAP code Example will allow you to do a basic selection on TEXT_CTY_EXPOS to SELECT all data from the table
DATA: WA_TEXT_CTY_EXPOS TYPE TEXT_CTY_EXPOS.

SELECT SINGLE *
FROM TEXT_CTY_EXPOS
INTO CORRESPONDING FIELDS OF WA_TEXT_CTY_EXPOS
WHERE...

How to access SAP table TEXT_CTY_EXPOS

Within an ECC or HANA version of SAP you can also view further information about TEXT_CTY_EXPOS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!