PSM_D_PCMTAD_ACT

Transparent Table Application Table
31 Fields 1 CDS Views

I_PUBSECPERIODICCMTMTADJTP

PSM_D_PCMTAD_ACT is an SAP database table in S/4HANA. I_PUBSECPERIODICCMTMTADJTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PubSecPeriodicCmtmtAdjTP view left_outer TRANSACTIONAL Periodic Commitment Adjustments

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY companycode BUKRS Company Code
KEY sourcereferencedocumenttype AWTYP Ref. procedure
KEY sourcereferencedocument AWREF Reference Doc.
KEY sourcereferencedocumentitem FINS_AWITEM Ref. Doc. Item
KEY accountassignmentnumber DZEKKN Account Assgmt No.
pubsecbudgetcnsmpntype PSM_BDGT_CNSMPN_TYPE Budget Consumption Type
purchasingdocument EBELN Purchasing Doc.
purchasingdocumentitem EBELP Item
formatteditemid CHAR30 30 Characters
fund BP_GEBER Fund
budgetperiod FM_BUDGET_PERIOD Budget Period
grantid GM_GRANT_NBR Grant
functionalarea FKBER Functional Area
chartofaccounts KTOPL Chart of Accts
glaccount SAKNR G/L Account
controllingarea KOKRS CO Area
financialmanagementarea FIKRS FM Area
costcenter KOSTL Cost Center
wbselementexternalid PS_POSID WBS Element
companycodecurrency FINS_CURRH CompanyCode Currency
totalamountincocodecrcy FINS_VHCUR12 Amnt in Comp Cd Crcy
job_name BTCJOB Job Name
job_run_count BTCJOBCNT Job No.
systemmessagetype BALMSGTY Message Type
systemmessageidentification BALMSGID Message Class
systemmessagenumber BALMSGNO Message Number
systemmessagevariable1 BALMSGV1 Message variable 1
systemmessagevariable2 BALMSGV2 Message variable 2
systemmessagevariable3 BALMSGV3 Message variable 3
systemmessagevariable4 BALMSGV4 Message variable 4

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.

-- I_PUBSECPERIODICCMTMTADJTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PSM_D_PCMTAD_ACT (
    MANDT,                        -- Client [MANDT]
    COMPANYCODE,                  -- Company Code [BUKRS]
    SOURCEREFERENCEDOCUMENTTYPE,  -- Ref. procedure [AWTYP]
    SOURCEREFERENCEDOCUMENT,      -- Reference Doc. [AWREF]
    SOURCEREFERENCEDOCUMENTITEM,  -- Ref. Doc. Item [FINS_AWITEM]
    ACCOUNTASSIGNMENTNUMBER,      -- Account Assgmt No. [DZEKKN]
    PUBSECBUDGETCNSMPNTYPE,       -- Budget Consumption Type [PSM_BDGT_CNSMPN_TYPE]
    PURCHASINGDOCUMENT,           -- Purchasing Doc. [EBELN]
    PURCHASINGDOCUMENTITEM,       -- Item [EBELP]
    FORMATTEDITEMID,              -- 30 Characters [CHAR30]
    FUND,                         -- Fund [BP_GEBER]
    BUDGETPERIOD,                 -- Budget Period [FM_BUDGET_PERIOD]
    GRANTID,                      -- Grant [GM_GRANT_NBR]
    FUNCTIONALAREA,               -- Functional Area [FKBER]
    CHARTOFACCOUNTS,              -- Chart of Accts [KTOPL]
    GLACCOUNT,                    -- G/L Account [SAKNR]
    CONTROLLINGAREA,              -- CO Area [KOKRS]
    FINANCIALMANAGEMENTAREA,      -- FM Area [FIKRS]
    COSTCENTER,                   -- Cost Center [KOSTL]
    WBSELEMENTEXTERNALID,         -- WBS Element [PS_POSID]
    COMPANYCODECURRENCY,          -- CompanyCode Currency [FINS_CURRH]
    TOTALAMOUNTINCOCODECRCY,      -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    JOB_NAME,                     -- Job Name [BTCJOB]
    JOB_RUN_COUNT,                -- Job No. [BTCJOBCNT]
    SYSTEMMESSAGETYPE,            -- Message Type [BALMSGTY]
    SYSTEMMESSAGEIDENTIFICATION,  -- Message Class [BALMSGID]
    SYSTEMMESSAGENUMBER,          -- Message Number [BALMSGNO]
    SYSTEMMESSAGEVARIABLE1,       -- Message variable 1 [BALMSGV1]
    SYSTEMMESSAGEVARIABLE2,       -- Message variable 2 [BALMSGV2]
    SYSTEMMESSAGEVARIABLE3,       -- Message variable 3 [BALMSGV3]
    SYSTEMMESSAGEVARIABLE4,       -- Message variable 4 [BALMSGV4]
    PRIMARY KEY (MANDT, COMPANYCODE, SOURCEREFERENCEDOCUMENTTYPE, SOURCEREFERENCEDOCUMENT, SOURCEREFERENCEDOCUMENTITEM, ACCOUNTASSIGNMENTNUMBER)
);

Learn More