/SAPAPO/RESDIM

Transparent Table Application Table
21 Fields 1 CDS Views

Dimensions and Capacity of a Resource

/SAPAPO/RESDIM is an SAP database table in S/4HANA. Dimensions and Capacity of a Resource. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RsceCapacityDimensions view from BASIC Resource Capacities and Dimensions

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt /SAPAPO/CLNTAPO_MANDT Client
KEY resuid /SAPAPO/RESUID Internal Resrce
KEY simversid /SAPAPO/CRES_GUID GUID
KEY simsessid /SAPAPO/CRES_GUID GUID
KEY dimension /SAPAPO/CRES_DIMID Continuous Dim.
KEY dimension_bucket /SAPAPO/CRES_DIMID_BUCKET Bucket Dimensn
KEY dimcount /SAPAPO/CRES_DIMCNT DimCounter
dimresid /SAPAPO/RESUID Internal Resrce
tstreamid /SAPAPO/CRES_TSTREAMUID APO-Internal Number (GUID) for Time Stream
noindivres /SAPAPO/CRES_NOINDIVRES Capacity
noindivres_unit /SAPAPO/CRES_NOINDIVRES_UNIT Unit
capacity_a /SAPAPO/CRES_CAPACITYV1_DISP Bucket Capacity
capacity_a_unit /SAPAPO/CRES_CAPACITYV_UNIT Unit
num_of_periods /SAPAPO/CRES_NUM_OF_PERIODS No. of Periods
period /SAPAPO/CRES_PERIOD Period Type
dim_storage /SAPAPO/CRES_DIMENSION_STORAGE Storage Dimnsn
min_storage /SAPAPO/CRES_MIN_STORAGE Min. Production Qty
max_storage /SAPAPO/CRES_MAX_STORAGE Max.Stock Level
min_replenishmnt /SAPAPO/CRES_MIN_REPLENISHMENT Perm.Remain.Qty
storage_unit /SAPAPO/CRES_STORAGE_UNIT Stock Unit
zero_threshold /SAPAPO/CRES_ZERO_THRESHOLD Threshold

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.

-- Dimensions and Capacity of a Resource
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPAPO/RESDIM (
    MANDT,             -- Client [/SAPAPO/CLNTAPO_MANDT]
    RESUID,            -- Internal Resrce [/SAPAPO/RESUID]
    SIMVERSID,         -- GUID [/SAPAPO/CRES_GUID]
    SIMSESSID,         -- GUID [/SAPAPO/CRES_GUID]
    DIMENSION,         -- Continuous Dim. [/SAPAPO/CRES_DIMID]
    DIMENSION_BUCKET,  -- Bucket Dimensn [/SAPAPO/CRES_DIMID_BUCKET]
    DIMCOUNT,          -- DimCounter [/SAPAPO/CRES_DIMCNT]
    DIMRESID,          -- Internal Resrce [/SAPAPO/RESUID]
    TSTREAMID,         -- APO-Internal Number (GUID) for Time Stream [/SAPAPO/CRES_TSTREAMUID]
    NOINDIVRES,        -- Capacity [/SAPAPO/CRES_NOINDIVRES]
    NOINDIVRES_UNIT,   -- Unit [/SAPAPO/CRES_NOINDIVRES_UNIT]
    CAPACITY_A,        -- Bucket Capacity [/SAPAPO/CRES_CAPACITYV1_DISP]
    CAPACITY_A_UNIT,   -- Unit [/SAPAPO/CRES_CAPACITYV_UNIT]
    NUM_OF_PERIODS,    -- No. of Periods [/SAPAPO/CRES_NUM_OF_PERIODS]
    PERIOD,            -- Period Type [/SAPAPO/CRES_PERIOD]
    DIM_STORAGE,       -- Storage Dimnsn [/SAPAPO/CRES_DIMENSION_STORAGE]
    MIN_STORAGE,       -- Min. Production Qty [/SAPAPO/CRES_MIN_STORAGE]
    MAX_STORAGE,       -- Max.Stock Level [/SAPAPO/CRES_MAX_STORAGE]
    MIN_REPLENISHMNT,  -- Perm.Remain.Qty [/SAPAPO/CRES_MIN_REPLENISHMENT]
    STORAGE_UNIT,      -- Stock Unit [/SAPAPO/CRES_STORAGE_UNIT]
    ZERO_THRESHOLD,    -- Threshold [/SAPAPO/CRES_ZERO_THRESHOLD]
    PRIMARY KEY (MANDT, RESUID, SIMVERSID, SIMSESSID, DIMENSION, DIMENSION_BUCKET, DIMCOUNT)
);

Learn More