PSM_D_AVC_PRF_AS

Transparent Table Customizing Table

PSM Availability Control Profile Assignment

PSM_D_AVC_PRF_AS is an SAP database table in S/4HANA. PSM Availability Control Profile Assignment. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PubSecCtrlObjProfileCurDate1 view inner BASIC

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY company_code BUKRS Company Code
KEY year_from PSM_BDGT_CNSMPN_YEAR Year of Budget Consumption
KEY budget_scenario PSM_S4C_BUDGET_SCENARIO Budgeting Scenario
profile FCO_AVC_PROFILE Availy Ctrl Prfl

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.

-- PSM Availability Control Profile Assignment
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PSM_D_AVC_PRF_AS (
    CLIENT,           -- Client [MANDT]
    COMPANY_CODE,     -- Company Code [BUKRS]
    YEAR_FROM,        -- Year of Budget Consumption [PSM_BDGT_CNSMPN_YEAR]
    BUDGET_SCENARIO,  -- Budgeting Scenario [PSM_S4C_BUDGET_SCENARIO]
    PROFILE,          -- Availy Ctrl Prfl [FCO_AVC_PROFILE]
    PRIMARY KEY (CLIENT, COMPANY_CODE, YEAR_FROM, BUDGET_SCENARIO)
);