PROJ

Transparent Table Application Table
111 Fields 47 CDS Views

Project definition

PROJ is an SAP database table in S/4HANA. Project definition. It contains 111 fields. 47 CDS views read from this table.

CDS Views using this table (47)

ViewTypeJoinVDMDescription
Adk0_Dli_Wip_Detail_View view inner DLI WIP Detail View for WBS Elements
C_EntProjectProfnlSrvcVH view inner CONSUMPTION Enterprise Project for Professional Services
E_Project view from EXTENSION Project - Extension Include View
E_Project_2 view from EXTENSION Project - Extension Include
FCO_MIG_DERIV_P view left_outer CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields
FINOC_PCK_CPRJH view inner OrglChange: Customer Projects Header
FINOC_PCK_CPRJP view inner OrglChange: Customer Projects Project
FINOC_PCK_EPRJE view inner OrglChange: EPPM Project Element
FINOC_PCK_EPRJH view inner OrglChange: EPPM Project Header
FINOC_PCK_EPRJP view inner OrglChange: EPPM Projects from Runtime
FINOC_PCK_IPRJH view inner OrglChange: Internal Projects Header
FINOC_RULE_NWA_EXAMPLE view inner Organizational Change: Customer Rule NWA
FINOC_RULE_PRO_BASE view from Organizational Change: Base Rule Project
fins_prctr_of_object_acdoca view left_outer Derive PRCTR & PPRCTR for ACDOCA object
Fins_Trr_Acc_Ass_Obj_all view inner Account Assignment Object
FINS_TRR_ACC_ASS_OBJ_PROJ view inner Account Assignment Object
Fins_Trr_Acc_Ass_Obj_prps view inner Account Assignment Object
I_EnterpriseProject view inner BASIC Enterprise Project
I_MasterProjectCurrency view inner BASIC Get master Project Currency
I_Project view from BASIC Project Definition Details
I_ProjectBasicData view from BASIC Project Basic Data
I_ProjectByExternalID view from BASIC Project by formatted external ID
I_ProjectData view from BASIC Project Data
I_ProjectData_2 view from BASIC Appl interface for Project details
I_ProjectHierarchyRoot_2 view_entity from BASIC Project Hierarchy Root
I_ProjectResultAnalysisData view inner BASIC Result Analysis Data for Projects
I_ResponsiblePersonForProj view from BASIC Project Responsible Person
P_EntProjSdm238 view_entity inner BASIC SDM: Private CDS View for Project Name
P_ObjectStatus view left_outer BASIC
P_ONRPD view inner BASIC
P_Projectwiprevdetlbasic view inner BASIC
P_Ra_Objects view left_outer BASIC
pp_mrp_read_mfg_order view inner Read Manufacturing Order
pp_mrp_read_mfg_order_comp view inner Read Manufacturing Order Components
pp_mrp_read_outbound_deliv view inner Read Outbound Deliveries
pp_mrp_read_planned_order_comp view inner Read Planned Order Components
pp_mrp_read_purchase_req view inner Deprecated: Replaced by I_MRPPurchaseRequisition
pp_mrp_read_sales_order view inner Read Sales Order
R_EnterpriseProject view_entity inner BASIC Enterprise Project Internal
SHSM_CN_LDST_SH_PD view inner Operative Proj Definition via External Number
SHSM_CN_LDST_SH_PR view inner Search for Operative WBS Elements via External Number
SHSM_V_PRPMP view inner cds view for search help PRPMP
SHSM_V_PRSMP view inner cds view for search help PRSMP
SHSM_V_PRSMW view inner cds view for search help PRSMW
SHSM_WBS_WORK_PACK_V view inner cds view for search help H_WBS_WORK_PACKAGE
vfco_dll_cj8g_l1 view inner
vfco_dll_cjb1_l1 view inner

Fields (111)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pspnr PS_INTNR Project def.
pspid PS_PSPID Project def.
post1 PS_POST1 Description
objnr J_OBJNR Object number
ernam ERNAM Created By
erdat ERDAT Created On
aenam AENAM Changed By
aedat UPDAT Changed on
kimsk PS_KIMSK Mask short ID
autod PS_AUTOD Transfer to def
stspd PS_STSPD PD sts. profile
stspr PS_STSPR WBS sts. prof.
vernr PS_VERNR Pers.Resp.No.
verna PS_VERNA Pers.Resp.Name
astnr PS_ASTNR Applicant no.
astna PS_ASTNA Applicant
vbukr PS_VBUKR Company code
vgsbr PS_VGSBR Business area
vkokr PS_VKOKR CO area
prctr PRCTR Profit Center
pwhie PS_PWHIE Proj.currency
zuord PS_ZUORD Network asst
trmeq PS_TRMEQ Activity dates
plfaz PS_PLFAZ_CHG Start Date
plsez PS_PLSEZ_CHG Finish Date
werks WERKS_D Plant
kalid FABKL Factory Calend.
vgplf PS_VGPLF Plan.meth/basic
ewplf PS_EWPLF Plan.meth/fcst
zteht PS_ZTEHT Time unit
nzanz NETZOBERFL Displ.netwk hdr
plnaw PLNAW Application
vprof PROFIDNZPL Network Profile
profl PROFIDPROJ Project Profile
bprof BP_BPROFIL Budget Profile
txtsp SPRAS Language
kostl KOSTL Cost Center
ktrg KSTRG Cost Object
aedte PS_AEDTE Last basic schd
aedtp PS_AEDTP Last fcst sched
berst PS_BERST Mstr data auth.
bertr PS_BERTR Date auth.
berko PS_BERKO Costs/rev. auth
berbu PS_BERBU Budget auth.
spsnr PS_ISPSP Current proj.no
besta PS_BESTAND Project stock
scope SCOPE_CV Object Class
xstat PS_XSTAT Statistical
txjcd TXJCD Tax Jur.
zschm PS_ZSCHM Interest Prof.
scprf PS_SCHDPRF WBS sched. prof
imprf IM_PROFIL Invest. Profile
fmprf PSFM_PRF Pymt plan prof.
abgsl ABGR_SCHL RA Key
postu PS_POSTU Description
pprof BP_PPROFIL Plng Profile
plint PLINT Integ. Planning
loevm LOEVM Delete
inact PS_INACT inactive
kzbws KZBWS Valuation
smprf SIM_PROFIL Simulation prof
flgvrg PS_FLGVRG Calc. with act.
grtop GRONTOP Auto.rqmnts grp.
pgprf PGPROFID Distri. profile
stort PS_STORT Location
logsystem LOGSYSTEM Logical System
kzerb PS_KZERB Proj. summ. MastDa
pargr PARGR PartnDet.Proc.
func_area FKBER Functional Area
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
dppprof AD01PROFNR DIP Profile
vpkstu SEU_LEVEL Level
pspid_edit PS_PSPID_EDIT Project def.
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
etype JV_ETYPE Equity Type
otype JV_OTYPE JV Object Type
jibcl JV_JIBCL JIB/JIBE Class
jibsa JV_JIBSA JIB/JIBE SbClsA
eew_proj_ps_dummy DUMMY Dummy function in length 1
schtyp PS_SCHED_TYPE Sched. scenario
sprog PS_SPROG Fcst start date
eprog PS_EPROG Finish date (F)
order_proc_mode ORDERPROCMODE Procurement Mode
settlementtype PS_SETTLEMENTTYPE Settlement Type
slwid SLWID Field key
usr00 USRCHAR20 User field 20
usr01 USRCHAR20 User field 20
usr02 USRCHAR10 User-Def. Field
usr03 USRCHAR10 User-Def. Field
usr04 USRQUAN13 User field qty.
use04 USRUNIT User field unit
usr05 USRQUAN13 User field qty.
use05 USRUNIT User field unit
usr06 USRCURR13 User field valu
use06 USRCUKY User field unit
usr07 USRCURR13 User field valu
use07 USRCUKY User field unit
usr08 USRDATE User field date
usr09 USRDATE User field date
usr10 USRFLAG User field ind.
usr11 USRFLAG User field ind.
cpd_updat /CPD/PFP_SC_TSTMP Time Stamp
ferc_ind FE_IND Reg. indicator
avc_profile FCO_AVC_PROFILE Availy Ctrl Prfl
avc_active PS_S4_AVC_IND AVC is Active
cpcurr PS_S4_WAERS Custom Project Curr
proj_status ACTCMB_DELE Status Comb

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.

-- Project definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROJ (
    MANDT,              -- Client [MANDT]
    PSPNR,              -- Project def. [PS_INTNR]
    PSPID,              -- Project def. [PS_PSPID]
    POST1,              -- Description [PS_POST1]
    OBJNR,              -- Object number [J_OBJNR]
    ERNAM,              -- Created By [ERNAM]
    ERDAT,              -- Created On [ERDAT]
    AENAM,              -- Changed By [AENAM]
    AEDAT,              -- Changed on [UPDAT]
    KIMSK,              -- Mask short ID [PS_KIMSK]
    AUTOD,              -- Transfer to def [PS_AUTOD]
    STSPD,              -- PD sts. profile [PS_STSPD]
    STSPR,              -- WBS sts. prof. [PS_STSPR]
    VERNR,              -- Pers.Resp.No. [PS_VERNR]
    VERNA,              -- Pers.Resp.Name [PS_VERNA]
    ASTNR,              -- Applicant no. [PS_ASTNR]
    ASTNA,              -- Applicant [PS_ASTNA]
    VBUKR,              -- Company code [PS_VBUKR]
    VGSBR,              -- Business area [PS_VGSBR]
    VKOKR,              -- CO area [PS_VKOKR]
    PRCTR,              -- Profit Center [PRCTR]
    PWHIE,              -- Proj.currency [PS_PWHIE]
    ZUORD,              -- Network asst [PS_ZUORD]
    TRMEQ,              -- Activity dates [PS_TRMEQ]
    PLFAZ,              -- Start Date [PS_PLFAZ_CHG]
    PLSEZ,              -- Finish Date [PS_PLSEZ_CHG]
    WERKS,              -- Plant [WERKS_D]
    KALID,              -- Factory Calend. [FABKL]
    VGPLF,              -- Plan.meth/basic [PS_VGPLF]
    EWPLF,              -- Plan.meth/fcst [PS_EWPLF]
    ZTEHT,              -- Time unit [PS_ZTEHT]
    NZANZ,              -- Displ.netwk hdr [NETZOBERFL]
    PLNAW,              -- Application [PLNAW]
    VPROF,              -- Network Profile [PROFIDNZPL]
    PROFL,              -- Project Profile [PROFIDPROJ]
    BPROF,              -- Budget Profile [BP_BPROFIL]
    TXTSP,              -- Language [SPRAS]
    KOSTL,              -- Cost Center [KOSTL]
    KTRG,               -- Cost Object [KSTRG]
    AEDTE,              -- Last basic schd [PS_AEDTE]
    AEDTP,              -- Last fcst sched [PS_AEDTP]
    BERST,              -- Mstr data auth. [PS_BERST]
    BERTR,              -- Date auth. [PS_BERTR]
    BERKO,              -- Costs/rev. auth [PS_BERKO]
    BERBU,              -- Budget auth. [PS_BERBU]
    SPSNR,              -- Current proj.no [PS_ISPSP]
    BESTA,              -- Project stock [PS_BESTAND]
    SCOPE,              -- Object Class [SCOPE_CV]
    XSTAT,              -- Statistical [PS_XSTAT]
    TXJCD,              -- Tax Jur. [TXJCD]
    ZSCHM,              -- Interest Prof. [PS_ZSCHM]
    SCPRF,              -- WBS sched. prof [PS_SCHDPRF]
    IMPRF,              -- Invest. Profile [IM_PROFIL]
    FMPRF,              -- Pymt plan prof. [PSFM_PRF]
    ABGSL,              -- RA Key [ABGR_SCHL]
    POSTU,              -- Description [PS_POSTU]
    PPROF,              -- Plng Profile [BP_PPROFIL]
    PLINT,              -- Integ. Planning [PLINT]
    LOEVM,              -- Delete [LOEVM]
    INACT,              -- inactive [PS_INACT]
    KZBWS,              -- Valuation [KZBWS]
    SMPRF,              -- Simulation prof [SIM_PROFIL]
    FLGVRG,             -- Calc. with act. [PS_FLGVRG]
    GRTOP,              -- Auto.rqmnts grp. [GRONTOP]
    PGPRF,              -- Distri. profile [PGPROFID]
    STORT,              -- Location [PS_STORT]
    LOGSYSTEM,          -- Logical System [LOGSYSTEM]
    KZERB,              -- Proj. summ. MastDa [PS_KZERB]
    PARGR,              -- PartnDet.Proc. [PARGR]
    FUNC_AREA,          -- Functional Area [FKBER]
    VKORG,              -- Sales Org. [VKORG]
    VTWEG,              -- Distr. Channel [VTWEG]
    SPART,              -- Division [SPART]
    DPPPROF,            -- DIP Profile [AD01PROFNR]
    VPKSTU,             -- Level [SEU_LEVEL]
    PSPID_EDIT,         -- Project def. [PS_PSPID_EDIT]
    VNAME,              -- Joint venture [JV_NAME]
    RECID,              -- Recovery Ind. [JV_RECIND]
    ETYPE,              -- Equity Type [JV_ETYPE]
    OTYPE,              -- JV Object Type [JV_OTYPE]
    JIBCL,              -- JIB/JIBE Class [JV_JIBCL]
    JIBSA,              -- JIB/JIBE SbClsA [JV_JIBSA]
    EEW_PROJ_PS_DUMMY,  -- Dummy function in length 1 [DUMMY]
    SCHTYP,             -- Sched. scenario [PS_SCHED_TYPE]
    SPROG,              -- Fcst start date [PS_SPROG]
    EPROG,              -- Finish date (F) [PS_EPROG]
    ORDER_PROC_MODE,    -- Procurement Mode [ORDERPROCMODE]
    SETTLEMENTTYPE,     -- Settlement Type [PS_SETTLEMENTTYPE]
    SLWID,              -- Field key [SLWID]
    USR00,              -- User field 20 [USRCHAR20]
    USR01,              -- User field 20 [USRCHAR20]
    USR02,              -- User-Def. Field [USRCHAR10]
    USR03,              -- User-Def. Field [USRCHAR10]
    USR04,              -- User field qty. [USRQUAN13]
    USE04,              -- User field unit [USRUNIT]
    USR05,              -- User field qty. [USRQUAN13]
    USE05,              -- User field unit [USRUNIT]
    USR06,              -- User field valu [USRCURR13]
    USE06,              -- User field unit [USRCUKY]
    USR07,              -- User field valu [USRCURR13]
    USE07,              -- User field unit [USRCUKY]
    USR08,              -- User field date [USRDATE]
    USR09,              -- User field date [USRDATE]
    USR10,              -- User field ind. [USRFLAG]
    USR11,              -- User field ind. [USRFLAG]
    CPD_UPDAT,          -- Time Stamp [/CPD/PFP_SC_TSTMP]
    FERC_IND,           -- Reg. indicator [FE_IND]
    AVC_PROFILE,        -- Availy Ctrl Prfl [FCO_AVC_PROFILE]
    AVC_ACTIVE,         -- AVC is Active [PS_S4_AVC_IND]
    CPCURR,             -- Custom Project Curr [PS_S4_WAERS]
    PROJ_STATUS,        -- Status Comb [ACTCMB_DELE]
    PRIMARY KEY (MANDT, PSPNR)
);

Learn More