PROJS

Transparent Table Application Table
101 Fields 5 CDS Views

Standard project definition

PROJS is an SAP database table in S/4HANA. Standard project definition. It contains 101 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_Standardproject view from BASIC Standard Project Version
I_StandardProject_2 view from BASIC Standard Project Details
SHSM_CN_LDST_SH_PS view inner Search for Operative Project Definitions via External Number
SHSM_CN_LDST_SH_PT view inner Search for Standard WBS Elements via External Number
SHSM_V_PRSSW view inner cds view for search help PRSSW

Fields (101)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pspnr PS_ISPSP Current proj.no
pspid PS_SPDID Std. proj. 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 Start date
plsez PS_PLSEZ 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
flgwbs PS_FLGWBS Schedul. method
flgvrg PS_FLGVRG Calc. with act.
grtop GRONTOP Auto.rqmnts grp.
pgprf PGPROFID Distri. profile
stort PS_STORT Location
flgsd PS_FLGSD SD/PS assignmnt
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
schtyp PS_SCHED_TYPE Sched. scenario
pspid_edit PS_SPDID_EDIT Std. Proj. 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
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.

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.

-- Standard project definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROJS (
    MANDT,       -- Client [MANDT]
    PSPNR,       -- Current proj.no [PS_ISPSP]
    PSPID,       -- Std. proj. def. [PS_SPDID]
    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]
    PLSEZ,       -- Finish date [PS_PLSEZ]
    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]
    FLGWBS,      -- Schedul. method [PS_FLGWBS]
    FLGVRG,      -- Calc. with act. [PS_FLGVRG]
    GRTOP,       -- Auto.rqmnts grp. [GRONTOP]
    PGPRF,       -- Distri. profile [PGPROFID]
    STORT,       -- Location [PS_STORT]
    FLGSD,       -- SD/PS assignmnt [PS_FLGSD]
    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]
    SCHTYP,      -- Sched. scenario [PS_SCHED_TYPE]
    PSPID_EDIT,  -- Std. Proj. Def. [PS_SPDID_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]
    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]
    PRIMARY KEY (MANDT, PSPNR)
);

Learn More