I_CMMDTYHDGTARGETQUOTAPOSITION

CDS View
16 Fields 15 CDS Views

Commodity Hedge Target Quota Positions

I_CMMDTYHDGTARGETQUOTAPOSITION is a CDS View in S/4HANA. Commodity Hedge Target Quota Positions. It contains 16 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_CmmdtyHdgTgtQtaPosVersion view from CONSUMPTION Cmmdty Hdg Tgt Quota Position Versions
I_CmmdtyHdgTgtQtaPosComposite view inner COMPOSITE Combined Target Quota
I_CmmdtyHdgTgtQtaPosDetail view inner COMPOSITE Commodity Hdg TQ Position Details
I_CmmdtyHdgTgtQtaPosVersion view_entity from COMPOSITE Target Quota Position Version
I_CmmdtyHdgTrdOrdCkptExposure view inner COMPOSITE Exposure for Trader Order Cockpit
I_CmmdtyTrdOrdCkptTargetQuota view inner COMPOSITE Exposure Details for Trade Order
P_CmmdtyHdgSpecTargetQuotaMap view inner COMPOSITE Commodity Hedge Target Details Mapping
P_CmmdtyHdgTgtQtaExpsrMapPerd view inner COMPOSITE TgtQta to Expsr Period mapping
P_CmmdtyHdgTgtQtaMaxChangedAt view inner COMPOSITE Commodity Hedge Target Quota Maximum Changed Position
P_CmmdtyHdgTgtQtaPosComposite view inner COMPOSITE Max Version TgtQta Position
P_CmmdtyHdgTgtQtaPosMaxValdFrm view_entity from COMPOSITE
P_CmmdtyHdgTrdOrdCkptTgtQtaPos view_entity from COMPOSITE
P_CmmdtyHedgeCalcExpsrDealQuan view inner COMPOSITE
P_CmmdtyTgtQtaReldHdgBookInit view inner COMPOSITE Target Quota with Hedge Book Details
R_CmmdtyHdgTgtQuotaPositionTP view_entity from TRANSACTIONAL Commodity Hedge Target Quota Position

Fields (16)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHdgTgtQuotaPositionUUID CmmdtyHdgTgtQuotaPositionUUID 3
CmmdtyHdgAcctgUprLmtInPercent CmmdtyHdgAcctgUprLmtInPercent,CmmdtyHdgUtilznTgtQtaAcctgPct 7
CmmdtyHdgTgtQtaPosChgDateTime CmmdtyHdgTgtQtaPosChgDateTime 2
CmmdtyHdgTgtQtaPosChgdByUser CmmdtyHdgTgtQtaPosChgdByUser 2
CmmdtyHdgTgtQtaPosCrtedByUser CmmdtyHdgTgtQtaPosCrtedByUser 2
CmmdtyHdgTgtQtaPosCrtnDateTime CmmdtyHdgTgtQtaPosCrtnDateTime 2
CmmdtyHdgTgtQtaPosValdDate CmmdtyHdgTgtQtaPosValdDate 1
CmmdtyHdgTgtQtaPosValdDateTime CmmdtyHdgTgtQtaPosValdDateTime 3
CmmdtyHdgTgtQtaUprLmtInPercent CmmdtyHdgTgtQtaUprLmtInPercent 5
CmmdtyHdgTgtQuotaPeriodClass CmmdtyHdgTgtQuotaPeriodClass 1
CmmdtyHdgTgtQuotaPeriodNumber CmmdtyHdgTgtQuotaPeriodNumber 8
CmmdtyHdgTgtQuotaPositionYear CmmdtyHdgTgtQuotaPositionYear 8
CmmdtyHedgeTargetQuotaUUID CmmdtyHedgeTargetQuotaUUID 2
CommodityHedgePercentageUnit CommodityHedgePercentageUnit 1
CommodityHedgeRemarkNote CmmdtyHdgTradeOrderRemarkNote,CommodityHedgeRemarkNote 2
IsActive IsActive 1

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.

-- Commodity Hedge Target Quota Positions
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYHDGTARGETQUOTAPOSITION (
    CMMDTYHDGTGTQUOTAPOSITIONUUID,
    CMMDTYHDGACCTGUPRLMTINPERCENT,
    CMMDTYHDGTGTQTAPOSCHGDATETIME,
    CMMDTYHDGTGTQTAPOSCHGDBYUSER,
    CMMDTYHDGTGTQTAPOSCRTEDBYUSER,
    CMMDTYHDGTGTQTAPOSCRTNDATETIME,
    CMMDTYHDGTGTQTAPOSVALDDATE,
    CMMDTYHDGTGTQTAPOSVALDDATETIME,
    CMMDTYHDGTGTQTAUPRLMTINPERCENT,
    CMMDTYHDGTGTQUOTAPERIODCLASS,
    CMMDTYHDGTGTQUOTAPERIODNUMBER,
    CMMDTYHDGTGTQUOTAPOSITIONYEAR,
    CMMDTYHEDGETARGETQUOTAUUID,
    COMMODITYHEDGEPERCENTAGEUNIT,
    COMMODITYHEDGEREMARKNOTE,
    ISACTIVE,
    PRIMARY KEY (CMMDTYHDGTGTQUOTAPOSITIONUUID)
);

Learn More