PSM_D_BM_AVC_SIT

Transparent Table Application Table
17 Fields 1 CDS Views

Table fo Situation Objects of Budget management AVC

PSM_D_BM_AVC_SIT is an SAP database table in S/4HANA. Table fo Situation Objects of Budget management AVC. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PubSecBdgtMgmtAvailyCtrlSitn view from BASIC PSM Anchor & Trigger Obj. for BMAVC SH B

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY controladdresshash PSM_S4C_FM_AVC_CHK_LVL_HASH B.A. Hash
company_code BUKRS Company Code
ctrlobjforfund PSM_S4C_FM_AVC_CTRL_OBJ_FU Control Object Fund
ctrlobjforfunctionalarea PSM_S4C_FM_AVC_CTRL_OBJ_FA Control Object Functional Area
ctrlobjforbudgetperiod PSM_S4C_FM_AVC_CTRL_OBJ_BP Control Object Budget Period
ctrlobjforcostcenter PSM_S4C_FM_AVC_CTRL_OBJ_CC Control Object Cost Center
ctrlobjforwbselement PSM_S4C_FM_AVC_CTRL_OBJ_WB Control Object WBS Element
ctrlobjforbudgetaccount PSM_S4C_FM_AVC_CTRL_OBJ_BA Control Object Budget Account
fm_area FIKRS FM Area
budget_consumption_year PSM_BDGT_CNSMPN_YEAR Year of Budget Consumption
currency FINS_CURRK Global Currency
consumed_budget FINS_VKCUR12 Amnt in Global Crcy
consumable_budget FINS_VKCUR12 Amnt in Global Crcy
current_usage_rate PSM_S4C_FM_AVC_CUR_USAGE_RATE Current Budget Threshold
previous_usage_rate PSM_S4C_FM_AVC_PREV_USAGE_RATE Previous Budget Threshold
available_budget FINS_VKCUR12 Amnt in Global Crcy

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.

-- Table fo Situation Objects of Budget management AVC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PSM_D_BM_AVC_SIT (
    CLIENT,                    -- Client [MANDT]
    CONTROLADDRESSHASH,        -- B.A. Hash [PSM_S4C_FM_AVC_CHK_LVL_HASH]
    COMPANY_CODE,              -- Company Code [BUKRS]
    CTRLOBJFORFUND,            -- Control Object Fund [PSM_S4C_FM_AVC_CTRL_OBJ_FU]
    CTRLOBJFORFUNCTIONALAREA,  -- Control Object Functional Area [PSM_S4C_FM_AVC_CTRL_OBJ_FA]
    CTRLOBJFORBUDGETPERIOD,    -- Control Object Budget Period [PSM_S4C_FM_AVC_CTRL_OBJ_BP]
    CTRLOBJFORCOSTCENTER,      -- Control Object Cost Center [PSM_S4C_FM_AVC_CTRL_OBJ_CC]
    CTRLOBJFORWBSELEMENT,      -- Control Object WBS Element [PSM_S4C_FM_AVC_CTRL_OBJ_WB]
    CTRLOBJFORBUDGETACCOUNT,   -- Control Object Budget Account [PSM_S4C_FM_AVC_CTRL_OBJ_BA]
    FM_AREA,                   -- FM Area [FIKRS]
    BUDGET_CONSUMPTION_YEAR,   -- Year of Budget Consumption [PSM_BDGT_CNSMPN_YEAR]
    CURRENCY,                  -- Global Currency [FINS_CURRK]
    CONSUMED_BUDGET,           -- Amnt in Global Crcy [FINS_VKCUR12]
    CONSUMABLE_BUDGET,         -- Amnt in Global Crcy [FINS_VKCUR12]
    CURRENT_USAGE_RATE,        -- Current Budget Threshold [PSM_S4C_FM_AVC_CUR_USAGE_RATE]
    PREVIOUS_USAGE_RATE,       -- Previous Budget Threshold [PSM_S4C_FM_AVC_PREV_USAGE_RATE]
    AVAILABLE_BUDGET,          -- Amnt in Global Crcy [FINS_VKCUR12]
    PRIMARY KEY (CLIENT, CONTROLADDRESSHASH)
);

Learn More