PSM_D_BM_AVC_SIT

Transparent Table Application Table
11 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 11 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 (11)

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
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]
    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