PPS_PC_GMACCT_D

Transparent Table Application Table
38 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRACCTASSIGNMENTTP

PPS_PC_GMACCT_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRACCTASSIGNMENTTP. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurConGartdMinAcctAsgtD view_entity from BASIC PPS PC Guranteed Minimum Acct - Draft

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasecontract EBELN Purchasing Doc.
KEY purchasecontractitem EBELP Item
KEY commitmentplanitemnumber CPITEM Comm. Plan Item
KEY accountassignmentnumber DZEKKN Account Assgmt No.
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
documentcurrency WAERS Currency
purgdocnetamount CP_ACCOUNT_VALUE Net Value
commitmentitemshortid FMIS_CI_INTERNALNAME Commitment Item Short ID
fundscenter FISTL Funds Center
functionalarea FKBER Functional Area
grantid GM_GRANT_NBR Grant
fund BP_GEBER Fund
glaccount SAKNR G/L Account
earmarkedfundsdocument KBLNR Earmarked Funds
earmarkedfundsdocumentitem KBLPOS Document Item
networknumberforacctassgmt NPLNR Network
networkactivity PS_S4_VORNR Oper./Act.
productionorder AUFNR Order
costcenter KOSTL Cost Center
controllingarea KOKRS CO Area
businessarea GSBER Business Area
wbselementinternalid PS_S4_PSPNR WBS Internal ID
deletionindicator KLOEK Deletion Ind.
fundedprogram FM_MEASURE Funded Program
fundsmgmtperiodofperfstartdate FM_PEROP_LOW Per. of Perf. Start
fundsmgmtperiodofperfenddate FM_PEROP_HIGH Per. of Perf. End
budgetperiod FM_BUDGET_PERIOD Budget Period
emrkdfndsacctassgmtchangeable FM_ACCHANG AcctAss.Change.
financialmanagementarea FIKRS FM Area
purchasecontractdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_PPS_PURCONTRACCTASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_GMACCT_D (
    MANDT,                           -- Client [MANDT]
    PURCHASECONTRACT,                -- Purchasing Doc. [EBELN]
    PURCHASECONTRACTITEM,            -- Item [EBELP]
    COMMITMENTPLANITEMNUMBER,        -- Comm. Plan Item [CPITEM]
    ACCOUNTASSIGNMENTNUMBER,         -- Account Assgmt No. [DZEKKN]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    PURGDOCNETAMOUNT,                -- Net Value [CP_ACCOUNT_VALUE]
    COMMITMENTITEMSHORTID,           -- Commitment Item Short ID [FMIS_CI_INTERNALNAME]
    FUNDSCENTER,                     -- Funds Center [FISTL]
    FUNCTIONALAREA,                  -- Functional Area [FKBER]
    GRANTID,                         -- Grant [GM_GRANT_NBR]
    FUND,                            -- Fund [BP_GEBER]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [KBLNR]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [KBLPOS]
    NETWORKNUMBERFORACCTASSGMT,      -- Network [NPLNR]
    NETWORKACTIVITY,                 -- Oper./Act. [PS_S4_VORNR]
    PRODUCTIONORDER,                 -- Order [AUFNR]
    COSTCENTER,                      -- Cost Center [KOSTL]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    BUSINESSAREA,                    -- Business Area [GSBER]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    DELETIONINDICATOR,               -- Deletion Ind. [KLOEK]
    FUNDEDPROGRAM,                   -- Funded Program [FM_MEASURE]
    FUNDSMGMTPERIODOFPERFSTARTDATE,  -- Per. of Perf. Start [FM_PEROP_LOW]
    FUNDSMGMTPERIODOFPERFENDDATE,    -- Per. of Perf. End [FM_PEROP_HIGH]
    BUDGETPERIOD,                    -- Budget Period [FM_BUDGET_PERIOD]
    EMRKDFNDSACCTASSGMTCHANGEABLE,   -- AcctAss.Change. [FM_ACCHANG]
    FINANCIALMANAGEMENTAREA,         -- FM Area [FIKRS]
    PURCHASECONTRACTDRAFTUUID,       -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASECONTRACT, PURCHASECONTRACTITEM, COMMITMENTPLANITEMNUMBER, ACCOUNTASSIGNMENTNUMBER, DRAFTUUID)
);

Learn More