FXEMT_EXPOSURE

Transparent Table Application Table
28 Fields 1 CDS Views

Definition of an FX Exposure

FXEMT_EXPOSURE is an SAP database table in S/4HANA. Definition of an FX Exposure. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FXExposure view_entity from BASIC FX Exposure

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY fx_exposure_uuid FXEM_FX_EXPOSURE_UUID Exposure Techn. ID
fx_exposure_id FXEM_FX_EXPOSURE_ID FX Exposure ID
fx_exposure_type FXEM_FX_EXPOSURE_TYPE FX Exposure Type
company_code BUKRS Company Code
portfolio FXEM_FX_EXPOSURE_PORTFOLIO Portfolio
cost_center KOSTL Cost Center
profit_center PRCTR Profit Center
country LAND1 Country/Reg.
wbs_element FXEM_FX_EXPOSURE_WBS_ELEMENT WBS Element
on_behalf_of_comp_code TRBA_BEHALF_OF_COMPANY On Behalf of CoCode
segment FB_SEGMENT Segment
valid_from FXEM_FX_EXPOSURE_VALID_FROM Valid Date From
due_date FXEM_FX_EXPOSURE_DUE_DATE Due Date
amount FXEM_FX_EXPOSURE_AMOUNT FX Exposure Amount
risk_currency FXEM_FX_EXPOSURE_RISK_CURRENCY FX Exposure Crcy
target_currency FXEM_FX_EXPOSURE_TARG_CURRENCY Target Currency
direction FXEM_FX_EXPOSURE_DIRECTION Exposure Direction
status FXEM_FX_EXPOSURE_STATUS Exposure Status
external_id FXEM_FX_EXPOSURE_EXTERNAL_ID External ID
fx_exposure_creation_mode FXEM_FX_EXPOSURE_CREATION_MODE Creation Mode
createdby FXEM_FX_EXPOSURE_CREATED_BY Created By
createdat FXEM_FX_EXPOSURE_CREATED_AT Created At
lastchangedby FXEM_FX_EXPOSURE_LST_CHANGE_BY Last Changed By
lastchangedat FXEM_FX_EXPOSURE_LST_CHANGE_AT Last Changed At
local_last_change_datetime FXEM_FX_EXPOSURE_LST_CHANGE_AT Last Changed At
changedoc_object_id CDOBJECTV Object Value
exp_status_change_reason FXEM_FX_EXPOSURE_STATUS_REASON Status Change Reason

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.

-- Definition of an FX Exposure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FXEMT_EXPOSURE (
    CLIENT,                      -- Client [MANDT]
    FX_EXPOSURE_UUID,            -- Exposure Techn. ID [FXEM_FX_EXPOSURE_UUID]
    FX_EXPOSURE_ID,              -- FX Exposure ID [FXEM_FX_EXPOSURE_ID]
    FX_EXPOSURE_TYPE,            -- FX Exposure Type [FXEM_FX_EXPOSURE_TYPE]
    COMPANY_CODE,                -- Company Code [BUKRS]
    PORTFOLIO,                   -- Portfolio [FXEM_FX_EXPOSURE_PORTFOLIO]
    COST_CENTER,                 -- Cost Center [KOSTL]
    PROFIT_CENTER,               -- Profit Center [PRCTR]
    COUNTRY,                     -- Country/Reg. [LAND1]
    WBS_ELEMENT,                 -- WBS Element [FXEM_FX_EXPOSURE_WBS_ELEMENT]
    ON_BEHALF_OF_COMP_CODE,      -- On Behalf of CoCode [TRBA_BEHALF_OF_COMPANY]
    SEGMENT,                     -- Segment [FB_SEGMENT]
    VALID_FROM,                  -- Valid Date From [FXEM_FX_EXPOSURE_VALID_FROM]
    DUE_DATE,                    -- Due Date [FXEM_FX_EXPOSURE_DUE_DATE]
    AMOUNT,                      -- FX Exposure Amount [FXEM_FX_EXPOSURE_AMOUNT]
    RISK_CURRENCY,               -- FX Exposure Crcy [FXEM_FX_EXPOSURE_RISK_CURRENCY]
    TARGET_CURRENCY,             -- Target Currency [FXEM_FX_EXPOSURE_TARG_CURRENCY]
    DIRECTION,                   -- Exposure Direction [FXEM_FX_EXPOSURE_DIRECTION]
    STATUS,                      -- Exposure Status [FXEM_FX_EXPOSURE_STATUS]
    EXTERNAL_ID,                 -- External ID [FXEM_FX_EXPOSURE_EXTERNAL_ID]
    FX_EXPOSURE_CREATION_MODE,   -- Creation Mode [FXEM_FX_EXPOSURE_CREATION_MODE]
    CREATEDBY,                   -- Created By [FXEM_FX_EXPOSURE_CREATED_BY]
    CREATEDAT,                   -- Created At [FXEM_FX_EXPOSURE_CREATED_AT]
    LASTCHANGEDBY,               -- Last Changed By [FXEM_FX_EXPOSURE_LST_CHANGE_BY]
    LASTCHANGEDAT,               -- Last Changed At [FXEM_FX_EXPOSURE_LST_CHANGE_AT]
    LOCAL_LAST_CHANGE_DATETIME,  -- Last Changed At [FXEM_FX_EXPOSURE_LST_CHANGE_AT]
    CHANGEDOC_OBJECT_ID,         -- Object Value [CDOBJECTV]
    EXP_STATUS_CHANGE_REASON,    -- Status Change Reason [FXEM_FX_EXPOSURE_STATUS_REASON]
    PRIMARY KEY (CLIENT, FX_EXPOSURE_UUID)
);

Learn More