/RPM/CAP_B_PLAN

Transparent Table Application Table
13 Fields 1 CDS Views

Demand planning for buckets periodic values

/RPM/CAP_B_PLAN is an SAP database table in S/4HANA. Demand planning for buckets periodic values. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrjPrtfloBcktCapPlan view_entity from BASIC Capacity Plan Buckets Periodic Values

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid /RPM/TV_GUID GUID
KEY plan_type /RPM/TV_PLAN_TYPE_CHAR Plan Type
KEY period /RPM/TV_START_DATE Start Date
changed_on /RPM/TV_TIMESTAMP Time Stamp
amount /RPM/TV_CAPACITY Capacity Amt.
unit /RPM/TV_UNIT Capacity Unit
changed_by RPM_TV_CHANGED_BY Last Changed By
fiscalyearvariant PERIV FY Variant
fiscalyear GJAHR_POS G/L Fiscal Year
fiscalperiod FINS_FISCALPERIOD Fiscal Period
fiscalyearperiod JAHRPER Period/Year
periodstartdate /RPM/TV_START_DATE Start Date

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.

-- Demand planning for buckets periodic values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /RPM/CAP_B_PLAN (
    CLIENT,             -- Client [MANDT]
    GUID,               -- GUID [/RPM/TV_GUID]
    PLAN_TYPE,          -- Plan Type [/RPM/TV_PLAN_TYPE_CHAR]
    PERIOD,             -- Start Date [/RPM/TV_START_DATE]
    CHANGED_ON,         -- Time Stamp [/RPM/TV_TIMESTAMP]
    AMOUNT,             -- Capacity Amt. [/RPM/TV_CAPACITY]
    UNIT,               -- Capacity Unit [/RPM/TV_UNIT]
    CHANGED_BY,         -- Last Changed By [RPM_TV_CHANGED_BY]
    FISCALYEARVARIANT,  -- FY Variant [PERIV]
    FISCALYEAR,         -- G/L Fiscal Year [GJAHR_POS]
    FISCALPERIOD,       -- Fiscal Period [FINS_FISCALPERIOD]
    FISCALYEARPERIOD,   -- Period/Year [JAHRPER]
    PERIODSTARTDATE,    -- Start Date [/RPM/TV_START_DATE]
    PRIMARY KEY (CLIENT, GUID, PLAN_TYPE, PERIOD)
);

Learn More