CMMT_FCP_HREQ
Offsetting FX Hedge Requests for Fixed Commodity Prices
CMMT_FCP_HREQ is an SAP database table in S/4HANA. Offsetting FX Hedge Requests for Fixed Commodity Prices. It contains 13 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CmmdtyHdgOffstgFXHdgRequest | view_entity | from | BASIC | Basic for Offsetting FX Hedge Requests |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | abap.clnt | ||||
| KEY | hreq_group_uuid | CMM_HREQ_GROUP_UUID | HReq Group UUID | |||
| KEY | hedge_request_id | TOE_REQUEST_ID | Hedge Request ID | |||
| run_uuid | CMM_FCP_RUN_UUID | Offs. FX Run UUID | ||||
| dcsid | TBA_DCSID | DCS ID | ||||
| hedge_book | CMM_HEDGE_BOOK | Hedge Book | ||||
| on_behalf_of_company | TRBA_BEHALF_OF_COMPANY | On Behalf of CoCode | ||||
| value_date | TB_DZTERM | Payment Date | ||||
| portfolio | RPORTB | Portfolio | ||||
| exposure_item_id | TOE_EXPOSURE_ITEM_ID | Exposure Item ID | ||||
| ext_hedge_request_id | CMM_EXT_HREQ_ID | Ext. Hedge Request | ||||
| withdraw_date | DATS | Date | ||||
| deal_id | TB_RFHA | Transaction |
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.
-- Offsetting FX Hedge Requests for Fixed Commodity Prices
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_FCP_HREQ (
CLIENT, -- abap.clnt
HREQ_GROUP_UUID, -- HReq Group UUID [CMM_HREQ_GROUP_UUID]
HEDGE_REQUEST_ID, -- Hedge Request ID [TOE_REQUEST_ID]
RUN_UUID, -- Offs. FX Run UUID [CMM_FCP_RUN_UUID]
DCSID, -- DCS ID [TBA_DCSID]
HEDGE_BOOK, -- Hedge Book [CMM_HEDGE_BOOK]
ON_BEHALF_OF_COMPANY, -- On Behalf of CoCode [TRBA_BEHALF_OF_COMPANY]
VALUE_DATE, -- Payment Date [TB_DZTERM]
PORTFOLIO, -- Portfolio [RPORTB]
EXPOSURE_ITEM_ID, -- Exposure Item ID [TOE_EXPOSURE_ITEM_ID]
EXT_HEDGE_REQUEST_ID, -- Ext. Hedge Request [CMM_EXT_HREQ_ID]
WITHDRAW_DATE, -- Date [DATS]
DEAL_ID, -- Transaction [TB_RFHA]
PRIMARY KEY (CLIENT, HREQ_GROUP_UUID, HEDGE_REQUEST_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA