PROJS

Transparent Table Application Table
78 Fields 5 CDS Views

Standard project definition

PROJS is an SAP database table in S/4HANA. Standard project definition. It contains 78 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 (78)

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.

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]
    PRIMARY KEY (MANDT, PSPNR)
);

Learn More