TEXT_REXP_ITEM

Transparent Table Application Table
47 Fields 1 CDS Views

Raw Exposure Item

TEXT_REXP_ITEM is an SAP database table in S/4HANA. Raw Exposure Item. It contains 47 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RawExposureItem view from BASIC Raw Exposure Item

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY head_os_guid OS_GUID GUID
KEY item_id FTR_ITEM_ID Expos. LI ID
ext_item_no FTR_EXTERNAL_ITEM_NUMBER External Item No.
ext_item_id FTR_EXTERNAL_ITEM_ID External Item ID
planning_period TEM_PLANNING_PERIOD Period
planning_year FTR_PLANNING_YEAR Planning Year
due_date FTR_EXPOSURE_DATE Exp. Due Date
commodity_id TRCO_COMM_ID Cmdty ID (obsolete)
quantity FTR_EXPOSURE_QTY Qty
unit_of_measure TPM_CTY_UOM Unit of Measure
fix_var_ind FTR_FIX_VARIABLE_INDICATOR Fixed/Float Ind.
fix_var_ind_t FTR_FIX_VARIABLE_INDICATOR_T Fixed/Float Ind.
foreign_amt FTR_EXPOSURE_AMOUNT Exposure Amount
foreign_curr FTR_EXPOSURE_CURR Exposure Amt Crcy
target_curr FTR_EXPOSURE_CURRENCY_TARGET Target Currency
profit_center PRCTR Profit Center
plant WERKS_D Plant
matnr MATNR Material
batchnr CHARG_D Batch
attribute_li01 FTR_ATTRIBUTE_LONG Free Attr. (Char20)
attribute_li02 FTR_ATTRIBUTE_LONG Free Attr. (Char20)
attribute_li03 FTR_ATTRIBUTE_LONG Free Attr. (Char20)
attribute_li04 FTR_ATTRIBUTE_LONG Free Attr. (Char20)
attribute_mi01 FTR_ATTRIBUTE_MEDIUM Value of Free Attr.
attribute_mi02 FTR_ATTRIBUTE_MEDIUM Value of Free Attr.
attribute_si01 FTR_ATTRIBUTE_SHORT Value of Free Attr.
attribute_di01 FTR_ATTRIBUTE_DATE Free Attr. (Date)
rportb RPORTB Portfolio
kostl KOSTL Cost Center
gsber GSBER Business Area
ps_psp_pnr PS_PSP_PNR WBS Element
fb_segment FB_SEGMENT Segment
behalf_of_company TRBA_BEHALF_OF_COMPANY On Behalf of CoCode
archive_state FTR_ARCHIVE_STATE ArchiveStatus
payment_date FTR_PAYMENT_DATE Pymt Date
delivery_date FTR_DELIVERY_DATE Delivery Date
mp_exposure_rule FTR_MP_EXPOSURE_RULE Mkt Price Exp. Rule
condition_type FTR_CONDITION_TYPE Conditon Type
storage_location LGORT_D Location
var_price_cat FTR_VARIABLE_PRICE_CATEGORY Var. Price Cat.
prc_fixation_status CPET_PRCFIX_STATUS Price Fix. Status
prc_fixation_status_t FTR_PRC_FIXATION_STATUS_T Descr.St.PFix.Opt.
exer_date_earliest CPET_PRCFIX_EARLY_EXERCISEDATE Earliest Exc. Date
exer_date_latest CPET_PRCFIX_LATE_EXERCISEDATE Latest Exercise Date
pricing_component_grp FTR_PRICING_COMPONENT_GRP Grp for Pr. Fixation
raw_exp_descr FTR_TEX_DESCRIPTION Description

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.

-- Raw Exposure Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TEXT_REXP_ITEM (
    MANDT,                  -- Client [MANDT]
    HEAD_OS_GUID,           -- GUID [OS_GUID]
    ITEM_ID,                -- Expos. LI ID [FTR_ITEM_ID]
    EXT_ITEM_NO,            -- External Item No. [FTR_EXTERNAL_ITEM_NUMBER]
    EXT_ITEM_ID,            -- External Item ID [FTR_EXTERNAL_ITEM_ID]
    PLANNING_PERIOD,        -- Period [TEM_PLANNING_PERIOD]
    PLANNING_YEAR,          -- Planning Year [FTR_PLANNING_YEAR]
    DUE_DATE,               -- Exp. Due Date [FTR_EXPOSURE_DATE]
    COMMODITY_ID,           -- Cmdty ID (obsolete) [TRCO_COMM_ID]
    QUANTITY,               -- Qty [FTR_EXPOSURE_QTY]
    UNIT_OF_MEASURE,        -- Unit of Measure [TPM_CTY_UOM]
    FIX_VAR_IND,            -- Fixed/Float Ind. [FTR_FIX_VARIABLE_INDICATOR]
    FIX_VAR_IND_T,          -- Fixed/Float Ind. [FTR_FIX_VARIABLE_INDICATOR_T]
    FOREIGN_AMT,            -- Exposure Amount [FTR_EXPOSURE_AMOUNT]
    FOREIGN_CURR,           -- Exposure Amt Crcy [FTR_EXPOSURE_CURR]
    TARGET_CURR,            -- Target Currency [FTR_EXPOSURE_CURRENCY_TARGET]
    PROFIT_CENTER,          -- Profit Center [PRCTR]
    PLANT,                  -- Plant [WERKS_D]
    MATNR,                  -- Material [MATNR]
    BATCHNR,                -- Batch [CHARG_D]
    ATTRIBUTE_LI01,         -- Free Attr. (Char20) [FTR_ATTRIBUTE_LONG]
    ATTRIBUTE_LI02,         -- Free Attr. (Char20) [FTR_ATTRIBUTE_LONG]
    ATTRIBUTE_LI03,         -- Free Attr. (Char20) [FTR_ATTRIBUTE_LONG]
    ATTRIBUTE_LI04,         -- Free Attr. (Char20) [FTR_ATTRIBUTE_LONG]
    ATTRIBUTE_MI01,         -- Value of Free Attr. [FTR_ATTRIBUTE_MEDIUM]
    ATTRIBUTE_MI02,         -- Value of Free Attr. [FTR_ATTRIBUTE_MEDIUM]
    ATTRIBUTE_SI01,         -- Value of Free Attr. [FTR_ATTRIBUTE_SHORT]
    ATTRIBUTE_DI01,         -- Free Attr. (Date) [FTR_ATTRIBUTE_DATE]
    RPORTB,                 -- Portfolio [RPORTB]
    KOSTL,                  -- Cost Center [KOSTL]
    GSBER,                  -- Business Area [GSBER]
    PS_PSP_PNR,             -- WBS Element [PS_PSP_PNR]
    FB_SEGMENT,             -- Segment [FB_SEGMENT]
    BEHALF_OF_COMPANY,      -- On Behalf of CoCode [TRBA_BEHALF_OF_COMPANY]
    ARCHIVE_STATE,          -- ArchiveStatus [FTR_ARCHIVE_STATE]
    PAYMENT_DATE,           -- Pymt Date [FTR_PAYMENT_DATE]
    DELIVERY_DATE,          -- Delivery Date [FTR_DELIVERY_DATE]
    MP_EXPOSURE_RULE,       -- Mkt Price Exp. Rule [FTR_MP_EXPOSURE_RULE]
    CONDITION_TYPE,         -- Conditon Type [FTR_CONDITION_TYPE]
    STORAGE_LOCATION,       -- Location [LGORT_D]
    VAR_PRICE_CAT,          -- Var. Price Cat. [FTR_VARIABLE_PRICE_CATEGORY]
    PRC_FIXATION_STATUS,    -- Price Fix. Status [CPET_PRCFIX_STATUS]
    PRC_FIXATION_STATUS_T,  -- Descr.St.PFix.Opt. [FTR_PRC_FIXATION_STATUS_T]
    EXER_DATE_EARLIEST,     -- Earliest Exc. Date [CPET_PRCFIX_EARLY_EXERCISEDATE]
    EXER_DATE_LATEST,       -- Latest Exercise Date [CPET_PRCFIX_LATE_EXERCISEDATE]
    PRICING_COMPONENT_GRP,  -- Grp for Pr. Fixation [FTR_PRICING_COMPONENT_GRP]
    RAW_EXP_DESCR,          -- Description [FTR_TEX_DESCRIPTION]
    PRIMARY KEY (MANDT, HEAD_OS_GUID, ITEM_ID)
);

Learn More