PPS_T_PROF_I

Transparent Table Application Table
29 Fields 2 CDS Views

Profile Item

PPS_T_PROF_I is an SAP database table in S/4HANA. Profile Item. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PPSEntityProfileItem view_entity from EXTENSION PPS Profile Item - Extn
I_PPSEntityProfileItem view_entity from BASIC Entity Profile Item

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pps_profile_item_uuid PPS_E_PROFILE_ITEM_UUID Prof. Item Key
pps_profile_uuid PPS_E_PROFILE_UUID Profile Key
werks WERKS_D Plant
ekorg EKORG Purchasing Org.
ekgrp EKGRP Purch. Group
knttp KNTTP Acct Assgmt Cat
anln2 ANLN2 Subnumber
bukrs BUKRS Company Code
kostl KOSTL Cost Center
fictr FISTL Funds Center
grant_nbr GM_GRANT_NBR Grant
nplnr NPLNR Network
waers WAERS_CURC Currency
bwart BWART Movement Type
pps_arrangement_id PPS_E_PA_ARRANGEMENT_ID Pricing Arrangement Type
tolerance_key PPS_E_TOLERANCE_KEY Tolerance Key
posid PS_POSID WBS Element
anln1 ANLN1 Asset
warrant_id PPS_E_WARRANT_ID Warrant Limit
fieldname PPS_E_FIELDNAME Attribute Name
fieldvalue FIELDVALUE Field_value
pps_is_excluded PPS_E_IS_EXCLUDED Is excluded
pps_is_default PPS_E_IS_DEFAULT Set as Default
dummy_profileitem_incl_eew_ps CFD_DUMMY Dummy
created_at PPS_E_CREATEDATETIME Created On
changed_at PPS_E_CHANGEDATETIME Last Changed On
created_by PPS_E_CREATED_BY Created By
changed_by PPS_E_CHANGED_BY Last Changed By

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.

-- Profile Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_T_PROF_I (
    MANDT,                          -- Client [MANDT]
    PPS_PROFILE_ITEM_UUID,          -- Prof. Item Key [PPS_E_PROFILE_ITEM_UUID]
    PPS_PROFILE_UUID,               -- Profile Key [PPS_E_PROFILE_UUID]
    WERKS,                          -- Plant [WERKS_D]
    EKORG,                          -- Purchasing Org. [EKORG]
    EKGRP,                          -- Purch. Group [EKGRP]
    KNTTP,                          -- Acct Assgmt Cat [KNTTP]
    ANLN2,                          -- Subnumber [ANLN2]
    BUKRS,                          -- Company Code [BUKRS]
    KOSTL,                          -- Cost Center [KOSTL]
    FICTR,                          -- Funds Center [FISTL]
    GRANT_NBR,                      -- Grant [GM_GRANT_NBR]
    NPLNR,                          -- Network [NPLNR]
    WAERS,                          -- Currency [WAERS_CURC]
    BWART,                          -- Movement Type [BWART]
    PPS_ARRANGEMENT_ID,             -- Pricing Arrangement Type [PPS_E_PA_ARRANGEMENT_ID]
    TOLERANCE_KEY,                  -- Tolerance Key [PPS_E_TOLERANCE_KEY]
    POSID,                          -- WBS Element [PS_POSID]
    ANLN1,                          -- Asset [ANLN1]
    WARRANT_ID,                     -- Warrant Limit [PPS_E_WARRANT_ID]
    FIELDNAME,                      -- Attribute Name [PPS_E_FIELDNAME]
    FIELDVALUE,                     -- Field_value [FIELDVALUE]
    PPS_IS_EXCLUDED,                -- Is excluded [PPS_E_IS_EXCLUDED]
    PPS_IS_DEFAULT,                 -- Set as Default [PPS_E_IS_DEFAULT]
    DUMMY_PROFILEITEM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    CREATED_AT,                     -- Created On [PPS_E_CREATEDATETIME]
    CHANGED_AT,                     -- Last Changed On [PPS_E_CHANGEDATETIME]
    CREATED_BY,                     -- Created By [PPS_E_CREATED_BY]
    CHANGED_BY,                     -- Last Changed By [PPS_E_CHANGED_BY]
    PRIMARY KEY (MANDT, PPS_PROFILE_ITEM_UUID)
);

Learn More