SAP TABLES | Project System | Structures | Operative Structures(PS-ST-OPR) SAP PS

PROJ SAP Project definition Table and data







PROJ is a standard SAP Table which is used to store Project definition data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP PROJ Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP PROJ Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
PSPNRPS_INTNRNUMC8 Project definition (internal)KONPD
.INCLUDEPROJ_INC PS: Data portion of project definition Include
PSPIDPS_PSPIDCHAR24 Project DefinitionABPSN
.INCLUDEPROJ2_INC PS: Data portion of project definition include
POST1PS_POST1CHAR40 PS: Short description (1st text line)
OBJNRJ_OBJNRCHAR22 ONR00Object number
ERNAMERNAMCHAR12 Name of Person who Created the Object
ERDATERDATDATS8 Date on Which Record Was Created
AENAMAENAMCHAR12 Name of Person Who Changed Object
AEDATUPDATDATS8 Date on which object was last changed
KIMSKPS_KIMSKCHAR24 Selection mask for WBS element short IDs
AUTODPS_AUTODCHAR1 Automatic value transfer from WBS element to project def.
STSPDPS_STSPDCHAR8 TJ20Status profile for project definition
STSPRPS_STSPRCHAR8 TJ20Status profile for WBS element
VERNRPS_VERNRNUMC8 TCJ04Number of the responsible person (project manager)
VERNAPS_VERNACHAR25 Name of responsible person (Project manager)
ASTNRPS_ASTNRNUMC8 TCJ05Applicant number
ASTNAPS_ASTNACHAR25 Applicant
VBUKRPS_VBUKRCHAR4 T001Company code for the project
VGSBRPS_VGSBRCHAR4 TGSBBusiness area for the project
VKOKRPS_VKOKRCHAR4 TKA01Controlling area for the project
PRCTRPRCTRCHAR10 CEPCProfit CenterALPHA
PWHIEPS_PWHIECUKY5 TCURCWBS currency (project definition)
ZUORDPS_ZUORDNUMC1 Network assignment
TRMEQPS_TRMEQCHAR1 Indicator: WBS dates detailed by activity dates
PLFAZPS_PLFAZDATS8 Project planned start date
PLSEZPS_PLSEZDATS8 Project planned finish date
WERKSWERKS_DCHAR4 T001WPlant
KALIDFABKLCHAR2 TFACDFactory calendar key
VGPLFPS_VGPLFNUMC1 Planning method for project basic dates
EWPLFPS_EWPLFNUMC1 Planning method for project forecast dates
ZTEHTPS_ZTEHTUNIT3 T006Time unit in time schedulingCUNIT
NZANZNETZOBERFLCHAR1 Indicator: Network header visible to end user
PLNAWPLNAWCHAR1 TCA09Application of the task list
VPROFPROFIDNZPLCHAR7 TCN41Network profile
PROFLPROFIDPROJCHAR7 TCJ41Project Profile
BPROFBP_BPROFILCHAR6 TBP1CBudget Profile
TXTSPSPRASLANG1 T002Language KeyISOLA


KOSTLKOSTLCHAR10 CSKSCost CenterALPHA
KTRGKSTRGCHAR12 CKPHCost Object
AEDTEPS_AEDTEDATS8 Date of last scheduling of the overall network (basic dates)
AEDTPPS_AEDTPDATS8 Date of last scheduling of the overall network (forecast)
BERSTPS_BERSTCHAR16 Authorization key for project master data
BERTRPS_BERTRCHAR16 Authorization key for project dates (WBS)
BERKOPS_BERKOCHAR16 Authorization key for costs and revenues
BERBUPS_BERBUCHAR16 Authorization key for project budget
SPSNRPS_ISPSPNUMC8 PROJSCurrent number for standard projectKONPS
BESTAPS_BESTANDCHAR1 Project stock
SCOPESCOPE_CVCHAR2 Object ClassSCOPE
XSTATPS_XSTATCHAR1 Statistical WBS element
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
ZSCHMPS_ZSCHMCHAR7 TPI01Interest Profile for Project/Order Interest Calculation
SCPRFPS_SCHDPRFCHAR12 TCXPSProfile for WBS scheduling
IMPRFIM_PROFILCHAR6 TAPRFInvestment measure profile
FMPRFPSFM_PRFCHAR6 TBP1CPayment plan profile
ABGSLABGR_SCHLCHAR6 TKKAAResults Analysis Key
POSTUPS_POSTUCHAR40 PS: Short description (1st text line) in all caps
PPROFBP_PPROFILCHAR6 TBP1CPlanning profile
PLINTPLINTCHAR1 Indicator for Integrated Planning
LOEVMLOEVMCHAR1 Deletion Indicator
INACTPS_INACTCHAR1 Indicator: Project definition inactive
KZBWSKZBWSCHAR1 Valuation of Special Stock
SMPRFSIM_PROFILCHAR7 TCN54Simulation profile
FLGVRGPS_FLGVRGCHAR1 Indicator: Bottom-up calculation with activity dates
GRTOPGRONTOPCHAR1 Indicator: Automatic requirements grouping
PGPRFPGPROFIDCHAR6 TPGPRFDistribution profile
STORTPS_STORTCHAR10 T499SLocation
LOGSYSTEMLOGSYSTEMCHAR10
*
Logical SystemALPHA
KZERBPS_KZERBCHAR1 Indicator: Project summarization via master data charact.
PARGRPARGRCHAR4 V_TVPG_SPartner Determination Procedure
FUNC_AREAFKBERCHAR16 TFKBFunctional Area
VKORGVKORGCHAR4 TVKOSales Organization
VTWEGVTWEGCHAR2 TVKOVDistribution Channel
SPARTSPARTCHAR2 TVTADivision
DPPPROFAD01PROFNRCHAR8 AD01C_PROFDynamic Item Processor Profile
VPKSTUSEU_LEVELNUMC2 Node level
PSPID_EDITPS_PSPID_EDITCHAR24 Project Number (External) Edited


.INCLUDEGJV_DATA_3 JV data: (vname,recid,etype),otype,jibcl,jibsa
.INCLUDEGJV_DATA_0 General assignments of application objects
VNAMEJV_NAMECHAR6 T8JVJoint VentureALPHA
RECIDJV_RECINDCHAR2 T8JJRecovery IndicatorALPHA
ETYPEJV_ETYPECHAR3 T8JEEquity typeALPHA
OTYPEJV_OTYPECHAR4 Joint Venture Object TypeALPHA
JIBCLJV_JIBCLCHAR3 T8J6AJIB/JIBE Class
JIBSAJV_JIBSACHAR5 T8J6CJIB/JIBE Subclass A
ZFILEPATHCHAR40CHAR40 Character field of length 40
ZFILE1NAMECHAR20CHAR20 Char 20
ZFILE1EXTECHAR3CHAR3 3-Byte field
ZFILE2NAMECHAR20CHAR20 Char 20
ZFILE2EXTECHAR3CHAR3 3-Byte field
ZFILE3NAMECHAR20CHAR20 Char 20
ZFILE3EXTECHAR3CHAR3 3-Byte field
SCHTYPPS_SCHED_TYPECHAR1 Scheduling scenario
SPROGPS_SPROGDATS8 Forecast start date of project definition
EPROGPS_EPROGDATS8 Forecast finish date for project definition
.APPEND/CPD/PFP_PROJ_TIMESTMP Time stamp for created on and changed on time
CPD_UPDAT/CPD/PFP_TSTMPDEC15 Time StampTSTLC
.APPENDFERC_PROJ Append structure for Regulatory Reporting
FERC_INDFE_INDCHAR4 FERC_C7Regulatory indicatorALPHA
.APPENDPROJ_STATUS Project Leading Status
PROJ_STATUSACTCMB_DELEINT13 ACTCMB_TABStatus Combination



Key field
Non-key field

PROJ relationships with other tables


STREENODE-Description of a Hierarchy Node
     RAIPATTR-Attributes for item, measure or appropriation req.
     RIPASW-Values for Reporting for Programs
     BPGE_IM-Budgeting/planning: total values
     BPJA_IM-Budgeting/planning: annual values
     RAIMACT-Actual values
     IMTP-Investment programs
          IMPR-Investment Program Positions
               AUFKV-Table Generated for View AUFKV
               PROJ-Project definition
                    PRPS-PSP (project structure plan) element master data
               IMAK-Appropriation requests - general data
                    RIMAKPGES-Appropriation request: Percentage distribution (t)
                    RAIPWI-Key figs for preinvestment analysis per plan ver.
                    RAIPPASC-Data for partner determination procedure
                    AUFKV_REQ-Order for appropriation request
                    PROJ_REQ-Project definition for appropriation request
                         PRPS_REQ-WBS element for appropriation request


ARKOPF-Archiving run header data
     VSKOPF-Version: Header - general data for a
          RSTHIE-BRST structure of the hierarchy table
               PSDYRH-LDB PSJ: Dummy structure under RSTHIE
          PROJ-Project definition
               PSDYPD-LDB PSJ: Dummy structure under PROJ
          VBAK-Sales Document: Header Data
               VBUK-Sales Doc.: Header Status and Administrative Data
               VBKD-Sales Document: Business Data
               VBAP-Sales Document: Item Data
                    VBUP-Sales Document: Item Status
                    VBKDPO-Sales document: Business item data (POSNR > 0)
                         FPLA-Billing plan
                              FPLT-Billing Plan: Dates
                    PSDYVB-LDB PSJ: Dummy structure under VBAP
               PSDYVK-LDB PSJ: Dummy structure under VBAK
          PRPS_R-Project Hierarchy Reporting Structure
               PRTE-Scheduling Data for Project Item
               PSMLST-Milestone I/O Table
               PSTX-PS Texts (Header)
               PLAF-Planned order
               PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements
                    KBED04-Capacity Requirement Recs for Planned Orders (LDB)
                    RESB04-Reservation/dependent reqs for plan order (LDB)
               PSDYPR-LDB PSJ: Dummy structure under PRPS_R
          AUFK-Order master data
               AFKO-Order Header Data PP Orders
                    AFPO-Order Item
                    AFFL-Work order sequence
                         ACT01-Activity for LDB 01
                              AFAB01-Network Relationship (for LDB) - 01
                              MLSTD-Milestone I/O Table
                              PSTX1-PS Texts (Header) for Activity (1)
                              AFFH01-Order PRT Data (for LDB) - 01
                              KBED01-Capacity Requirement Records (for LDB) - 01
                                   KBEZ-Additional data for table KBED (for ind.req/split)
                                        KPER-Additional data for KBEZ (person split in days)
                                   AFRU02-Order Confirmations (for LDB) -02
                              RESB01-Reservation/Dependent Requirement for LDB-01
                                   PSDYOK-LDB PSJ: Dummy structure under RESB01
                              AFRU01-Order Confirmations (for LDB) - 01
                              PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity
                              PSDYNV-LDB PSJ: Dummy structure under ACT01
               AFIH-Maintenance order header
               PSDYNP-LDB PSJ: Dummy structure under AUFK
          IMTP-Investment programs
               IMPR-Investment Program Positions
                    PSDYIP-LDB PSJ: Dummy structure under IMPR
               PSDYPG-LDB PSJ: Dummy structure under IMTP
          PEGOB-Peg (master data of the CO object)
               PEGQTY-Assigned pegging object quantities
               PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB
          ELM_PS-Additional data for hierarchy nodes (LDB PSJ)
               JSTO-Status object information
                    PSTAT-Condensed status display
                    JCDO-Change Documents for Status Object (Table JSTO)
                    JEST-Individual Status per Object
                         JCDS-Change docs. for system/user status (table JEST)
               ONR00-General Object Number
                    RPSCO1-Summarization Table for Project Reporting
                    RPSQT-Summarization table for project reporting (quants)
                    EVOP (EV_PARAM)-Object parameters for earned value analysis
                    EVPOC_RPSQT (EV_POC)-Earned value analysis: percentage of completion
                    EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value
                    COBRA-Settlement Rule for Order Settlement
                         COBRB-Distribution rules for sett. rule for order sett.
                    BPHI1-Cross-hierarchy data Control
                    BPTR1-Object Data Control
                         BPGE1-Totals record total value Control
                              BPVG1-Table Generated for View BPVG1
                              BKHS1-Header - Unit Costing (Control + Totals)
                                   HEAD10-SAPscript: Text Header
                                        LINE10-SAPscript: Text Lines
                                   BKHT1-Texts for CKHS
                                   BKIS1-Individual calculation/verification item gen.
                                        BKIT1-Texts for CKIS
                                   BKIP1-Periodic Values for Unit Costing Item
                         BPJA1-Totals record for total year value Control
                              BPVJ1-Table Generated for View BPVJ1
                              BKHS2-Header - Unit Costing (Control + Totals)
                                   HEAD20-SAPscript: Text Header
                                        LINE20-SAPscript: Text Lines
                                   BKHT2-Texts for CKHS
                                   BKIS2-Individual calculation/verification item gen.
                                        BKIT2-Texts for CKIS
                                   BKIP2-Periodic Values for Unit Costing Item
                         BPPE1-Totals Record for Period Values Control
                              BPVP1-Table Generated for View BPVP1
                         BPIG1-Budget Object Index (Overall Budget)
                         BPIJ1-Budget Object Index (Annual Budget)
                    COKA1-CO Object: Cost Element Control Data
                    COKP1-CO Object: Primary Planning Control Data
                         HEAD11-SAPscript: Text Header
                              LINE11-SAPscript: Text Lines
                         CKHS1-Header - Unit Costing (Control + Totals)
                              CKHT1-Texts for CKHS
                              HEAD12-SAPscript: Text Header
                                   LINE12-SAPscript: Text Lines
                              CKIS1-Individual calculation/verification item gen.
                                   CKIT1-Texts for CKIS
                              CKIP1-Periodic Values for Unit Costing Item
                    COSP1-CO Object: Cost Totals for External Postings
                         COVP11-CO object: Line items with doc. header (by period)
                              COEPD11-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR11-CO Object: Valuated Line Item Settlement
                         COVJ11-CO object: Line items with doc header (by year)
                         COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
                    COSPD1-CO object: External cost totals - calculated
                    COSPP-Transfer of Order in the COSP Table to the Project
                    COKS1-CO Object: Control Data for Secondary Planning
                         HEAD13-SAPscript: Text Header
                              LINE13-SAPscript: Text Lines
                    COSS1-CO Object: Cost Totals for Internal Postings
                         COVP12-CO object: Line items with doc. header (by period)
                              COEPD12-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR12-CO Object: Valuated Line Item Settlement
                         COVJ12-CO object: Line items with doc header (by year)
                         COVO12-CO object: Fxd price agreement commitment ln items
                    COSSD1-CO object: Internal cost totals - calculated
                    COSSP-Transfer of the Order COSS Table to the Project
                    COKR1-CO Object: Control Data for Statistical Key Figs
                         HEAD14-SAPscript: Text Header
                              LINE14-SAPscript: Text Lines
                    COSR1-CO Object: Statistical Key Figure Totals
                         COVPR1-CO object: Stat. key figure line items by period
                         COVJR1-CO object: Line items stat. key figures (by year)
                    COSL1-CO Object: Activity Type Totals
                         COVPL1-CO object: Activity type line items by period
                         COVJL1-CO object: Line items for acty types (by year)
                    COSLD-CO object: Activity type sums - calculated
                    COSB1-CO Object: Total Variances/Results Analyses
                         COVPB1-CO object: Variance/accrual line items by period
                    COSBD1-CO object: Sums of variance/accrual - calculated
                    ANIA1-Depr. simulation for invest. projects
                         ANIB1-Invest. projects: Depr. simulation analysis report
                    ANLI1-Link table for capital investment measure -> AuC
                    FMSU1-FM totals records for financial data
                         COVFP1-CO object: Financial data line items with doc. hdr
                    TPI031-CO Objects: Date of Last Interest Run
               EKKO-Purchasing Document Header
                    EKPO-Purchasing Document Item
                         EKET-Scheduling Agreement Schedule Lines
                         EKKN-Account Assignment in Purchasing Document
                         EKBE-Purchasing Document History
               EBAN-Purchase requisition
                    EBKN-Purchase Requisition Account Assignment
               FPLA (FPLAPS)-Billing plan for PSP network plan
                    FPLT (FPLTPS)-Billing plan for PSP/network (dates)
               LIKP-SD Document: Delivery Header Data
                    LIPS-SD document: Delivery: Item data
               PSMERK-Characteristics for summarization wo.classificatn
               DRAD-Document-object link