PPS_PROF_I_D

Transparent Table Application Table
35 Fields 2 CDS Views

Draft table for entity R_PPSENTITYPROFILEITEMTP

PPS_PROF_I_D is an SAP database table in S/4HANA. Draft table for entity R_PPSENTITYPROFILEITEMTP. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PPSEntityProfileItemDraft view_entity from EXTENSION PPS Profile Item - Extn
R_PPSEntityProfileItemDraft view_entity from BASIC Entity Profile Item - Draft

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ppsentityprofileitemuuid PPS_E_PROFILE_ITEM_UUID Prof. Item Key
ppsentityprofileuuid PPS_E_PROFILE_UUID Profile Key
plant WERKS_D Plant
purchasingorganization EKORG Purchasing Org.
purchasinggroup EKGRP Purch. Group
accountassignmentcategory KNTTP Acct Assgmt Cat
masterfixedasset ANLN1 Asset
fixedasset ANLN2 Subnumber
companycode BUKRS Company Code
costcenter KOSTL Cost Center
fundscenter FISTL Funds Center
grantid GM_GRANT_NBR Grant
projectnetwork NPLNR Network
currency WAERS_CURC Currency
goodsmovementtype BWART Movement Type
ppspricingarrangementtype PPS_E_PA_ARRANGEMENT_ID Pricing Arrangement Type
ppsdeliverytolerancekey PPS_E_TOLERANCE_KEY Tolerance Key
wbselement PS_POSID_EDIT WBS Element
ppswarrantlimit PPS_E_WARRANT_ID Warrant Limit
dummy_profileitem_incl_eew_ps CFD_DUMMY Dummy
ppsentityprofileitemfieldname PPS_E_FIELDNAME Attribute Name
ppsentityprofileitemfieldvalue FIELDVALUE Field_value
ppsentityattributeisexcluded PPS_E_IS_EXCLUDED Is excluded
ppsentityattributeisdefault PPS_E_IS_DEFAULT Set as Default
createdatdatetime PPS_E_CREATEDATETIME Created On
lastchangedatdatetime PPS_E_CHANGEDATETIME Last Changed On
createdbyuser PPS_E_CREATED_BY Created By
changedby PPS_E_CHANGED_BY Last Changed By
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_PPSENTITYPROFILEITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PROF_I_D (
    MANDT,                           -- Client [MANDT]
    PPSENTITYPROFILEITEMUUID,        -- Prof. Item Key [PPS_E_PROFILE_ITEM_UUID]
    PPSENTITYPROFILEUUID,            -- Profile Key [PPS_E_PROFILE_UUID]
    PLANT,                           -- Plant [WERKS_D]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    PURCHASINGGROUP,                 -- Purch. Group [EKGRP]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [KNTTP]
    MASTERFIXEDASSET,                -- Asset [ANLN1]
    FIXEDASSET,                      -- Subnumber [ANLN2]
    COMPANYCODE,                     -- Company Code [BUKRS]
    COSTCENTER,                      -- Cost Center [KOSTL]
    FUNDSCENTER,                     -- Funds Center [FISTL]
    GRANTID,                         -- Grant [GM_GRANT_NBR]
    PROJECTNETWORK,                  -- Network [NPLNR]
    CURRENCY,                        -- Currency [WAERS_CURC]
    GOODSMOVEMENTTYPE,               -- Movement Type [BWART]
    PPSPRICINGARRANGEMENTTYPE,       -- Pricing Arrangement Type [PPS_E_PA_ARRANGEMENT_ID]
    PPSDELIVERYTOLERANCEKEY,         -- Tolerance Key [PPS_E_TOLERANCE_KEY]
    WBSELEMENT,                      -- WBS Element [PS_POSID_EDIT]
    PPSWARRANTLIMIT,                 -- Warrant Limit [PPS_E_WARRANT_ID]
    DUMMY_PROFILEITEM_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PPSENTITYPROFILEITEMFIELDNAME,   -- Attribute Name [PPS_E_FIELDNAME]
    PPSENTITYPROFILEITEMFIELDVALUE,  -- Field_value [FIELDVALUE]
    PPSENTITYATTRIBUTEISEXCLUDED,    -- Is excluded [PPS_E_IS_EXCLUDED]
    PPSENTITYATTRIBUTEISDEFAULT,     -- Set as Default [PPS_E_IS_DEFAULT]
    CREATEDATDATETIME,               -- Created On [PPS_E_CREATEDATETIME]
    LASTCHANGEDATDATETIME,           -- Last Changed On [PPS_E_CHANGEDATETIME]
    CREATEDBYUSER,                   -- Created By [PPS_E_CREATED_BY]
    CHANGEDBY,                       -- Last Changed By [PPS_E_CHANGED_BY]
    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, PPSENTITYPROFILEITEMUUID)
);

Learn More