SAP Table P3000

Work Center: Infotype 3000 - PP Basic Data

P3000 (Work Center: Infotype 3000 - PP Basic Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link P3000 to other SAP tables.

P3000 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PLVAR Plan Version PLVAR T778P CHAR 2 0
OTYPE Object Type OTYPE T778O CHAR 2 0
OBJID Object ID OBJEKTID NUMC 8 0
INFTY Infotype INFOTYP T778T CHAR 4 0
SUBTY Subtype SUBTYP T778U CHAR 4 0
ISTAT Planning Status ISTAT_D T778S CHAR 1 0
PRIOX Priority PRIOX CHAR 2 0
BEGDA Start Date BEGDATUM DATS 8 0
ENDDA End Date ENDDATUM DATS 8 0
VARYF Variation Field for File PLOG VARYF CHAR 10 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed on AEDTM DATS 8 0
UNAME User Name USRNAME CHAR 12 0
REASN Reason REASN CHAR 2 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
ARBPL Work center ARBPL CHAR 8 0
WERKS Plant WERKS_D T001W CHAR 4 0
VERWE Work Center Category AP_VERWE TC30 CHAR 4 0
LVORM Deletion flag for work center AP_LOEVORM CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PAR01 First work center parameter (for formulas) AP_PAR01 TC20 CHAR 6 0
PAR02 Second work center parameter (for formulas) AP_PAR02 TC20 CHAR 6 0
PAR03 Third work center parameter (for formulas) AP_PAR03 TC20 CHAR 6 0
PAR04 Fourth work center parameter (for formulas) AP_PAR04 TC20 CHAR 6 0
PAR05 Fifth work center parameter (for formulas) AP_PAR05 TC20 CHAR 6 0
PAR06 Sixth work center parameter (for formulas) AP_PAR06 TC20 CHAR 6 0
PARU1 Parameter unit AP_PARUNIT T006 UNIT 3 0
PARU2 Parameter unit AP_PARUNIT T006 UNIT 3 0
PARU3 Parameter unit AP_PARUNIT T006 UNIT 3 0
PARU4 Parameter unit AP_PARUNIT T006 UNIT 3 0
PARU5 Parameter unit AP_PARUNIT T006 UNIT 3 0
PARU6 Parameter unit AP_PARUNIT T006 UNIT 3 0
PARV1 Parameter value AP_PARVAL QUAN 9 3
PARV2 Parameter value AP_PARVAL QUAN 9 3
PARV3 Parameter value AP_PARVAL QUAN 9 3
PARV4 Parameter value AP_PARVAL QUAN 9 3
PARV5 Parameter value AP_PARVAL QUAN 9 3
PARV6 Parameter value AP_PARVAL QUAN 9 3
PLANV Key for task list usage AP_PLANV TC23 CHAR 3 0
STAND Work center location AP_STAND T499S CHAR 10 0
VERAN Person responsible for the work center AP_VERAN TC24 CHAR 3 0
VGWTS Standard value key VORGSCHL TC21 CHAR 4 0
VGM01 Rule for standard value maintenance AP_VGW_MES CHAR 1 0
NULL no checking
0 may not be entered
1 should not be entered
2 should be entered
3 must be entered
VGM02 Rule for standard value maintenance AP_VGW_MES CHAR 1 0
NULL no checking
0 may not be entered
1 should not be entered
2 should be entered
3 must be entered
VGM03 Rule for standard value maintenance AP_VGW_MES CHAR 1 0
NULL no checking
0 may not be entered
1 should not be entered
2 should be entered
3 must be entered
VGM04 Rule for standard value maintenance AP_VGW_MES CHAR 1 0
NULL no checking
0 may not be entered
1 should not be entered
2 should be entered
3 must be entered
VGM05 Rule for standard value maintenance AP_VGW_MES CHAR 1 0
NULL no checking
0 may not be entered
1 should not be entered
2 should be entered
3 must be entered
VGM06 Rule for standard value maintenance AP_VGW_MES CHAR 1 0
NULL no checking
0 may not be entered
1 should not be entered
2 should be entered
3 must be entered
XDEFA Indicator: Work center for default values AP_DEFAULT CHAR 1 0
X Yes
NULL No
XKOST Indicator: Work center is maintained for costing AP_XKOST CHAR 1 0
X Yes
NULL No
XSPRR Indicator: Work center is locked AP_XSPRR CHAR 1 0
X Yes
NULL No
XTERM Indicator: Work center is maintained for scheduling AP_XTERM CHAR 1 0
X Yes
NULL No
ZGR01 Key for performance efficiency rate IDZEITGRAD TC31 CHAR 3 0
ZGR02 Key for performance efficiency rate IDZEITGRAD TC31 CHAR 3 0
ZGR03 Key for performance efficiency rate IDZEITGRAD TC31 CHAR 3 0
ZGR04 Key for performance efficiency rate IDZEITGRAD TC31 CHAR 3 0
ZGR05 Key for performance efficiency rate IDZEITGRAD TC31 CHAR 3 0
ZGR06 Key for performance efficiency rate IDZEITGRAD TC31 CHAR 3 0
ZGR01_REF Field is referenced AP_KZREF CHAR 1 0
X Yes
NULL No
ZGR02_REF Field is referenced AP_KZREF CHAR 1 0
X Yes
NULL No
ZGR03_REF Field is referenced AP_KZREF CHAR 1 0
X Yes
NULL No
ZGR04_REF Field is referenced AP_KZREF CHAR 1 0
X Yes
NULL No
ZGR05_REF Field is referenced AP_KZREF CHAR 1 0
X Yes
NULL No
ZGR06_REF Field is referenced AP_KZREF CHAR 1 0
X Yes
NULL No
PRVBE Production Supply Area PRVBE PVBE CHAR 10 0
SUBSYS Subsystem Identifier for QM Subsystem Interface QEIFSUBSYS QISUB CHAR 6 0
BDEGR Grouping for Connection to Subsystem BDEGR CHAR 3 0
RGEKZ Indicator: Backflushing RGEKZAP CHAR 1 0
X Yes
NULL No
BDEFLG Dummy data element for reference structure CYFLAG CHAR 1 0
X
NULL
STOBJ Object number J_OBJNR CHAR 22 0
RESGR Matrix identification MATRIX_ID TCYMI CHAR 8 0
LGORT_RES Storage location storage resource LGORT_RES T001L CHAR 4 0
MIXMAT Indicator: mixing of material allowed MIXMAT CHAR 1 0
X Yes
NULL No
ISTBED_KZ Calculation of actual capacity requirements CY_ISTBEDKZ CHAR 1 0
NULL No actual cap. reqs.
1 Actual cap. req. from work center formula
2 Actual cap. req. from activities
SRTYPE Shift Report Type COCF_SR_SRTYPE COCF_CU_SRTYPE CHAR 10 0
SNTYPE Shift Note Type COCF_SN_SNTYPE TQ80 CHAR 2 0

P3000 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P3000 INFTY P3000 INFTY T778T Infotypes INFTY
P3000 INFTY P3000 MANDT T778T Infotypes MANDT
P3000 ISTAT P3000 MANDT T778S Planning Status MANDT
P3000 ISTAT P3000 ISTAT T778S Planning Status ISTAT
P3000 LGORT_RES P3000 MANDT T001L Storage Locations MANDT
P3000 LGORT_RES P3000 WERKS T001L Storage Locations WERKS
P3000 LGORT_RES P3000 LGORT_RES T001L Storage Locations LGORT
P3000 MANDT P3000 MANDT T000 Clients MANDT
P3000 OTYPE P3000 MANDT T778O Object Types MANDT
P3000 OTYPE P3000 OTYPE T778O Object Types OTYPE
P3000 PAR01 P3000 PAR01 TC20 "Formula Parameters" PARID
P3000 PAR01 SYST MANDT TC20 "Formula Parameters" MANDT
P3000 PAR02 SYST MANDT TC20 "Formula Parameters" MANDT
P3000 PAR02 P3000 PAR02 TC20 "Formula Parameters" PARID
P3000 PAR03 SYST MANDT TC20 "Formula Parameters" MANDT
P3000 PAR03 P3000 PAR03 TC20 "Formula Parameters" PARID
P3000 PAR04 P3000 PAR04 TC20 "Formula Parameters" PARID
P3000 PAR04 SYST MANDT TC20 "Formula Parameters" MANDT
P3000 PAR05 SYST MANDT TC20 "Formula Parameters" MANDT
P3000 PAR05 P3000 PAR05 TC20 "Formula Parameters" PARID
P3000 PAR06 SYST MANDT TC20 "Formula Parameters" MANDT
P3000 PAR06 P3000 PAR06 TC20 "Formula Parameters" PARID
P3000 PARU1 P3000 PARU1 T006 Units of Measurement MSEHI
P3000 PARU1 SYST MANDT T006 Units of Measurement MANDT
P3000 PARU2 SYST MANDT T006 Units of Measurement MANDT
P3000 PARU2 P3000 PARU2 T006 Units of Measurement MSEHI
P3000 PARU3 SYST MANDT T006 Units of Measurement MANDT
P3000 PARU3 P3000 PARU3 T006 Units of Measurement MSEHI
P3000 PARU4 SYST MANDT T006 Units of Measurement MANDT
P3000 PARU4 P3000 PARU4 T006 Units of Measurement MSEHI
P3000 PARU5 SYST MANDT T006 Units of Measurement MANDT
P3000 PARU5 P3000 PARU5 T006 Units of Measurement MSEHI
P3000 PARU6 P3000 PARU6 T006 Units of Measurement MSEHI
P3000 PARU6 SYST MANDT T006 Units of Measurement MANDT
P3000 PLANV SYST MANDT TC23 Key for use of the work center in the task lists MANDT
P3000 PLANV P3000 PLANV TC23 Key for use of the work center in the task lists PLANV
P3000 PLVAR P3000 MANDT T778P Plan Versions MANDT
P3000 PLVAR P3000 PLVAR T778P Plan Versions PLVAR
P3000 PRVBE P3000 WERKS PVBE Production Supply Area WERKS
P3000 PRVBE P3000 PRVBE PVBE Production Supply Area PRVBE
P3000 PRVBE P3000 MANDT PVBE Production Supply Area MANDT
P3000 RESGR P3000 MANDT TCYMI Matrix identifications MANDT
P3000 RESGR P3000 WERKS TCYMI Matrix identifications WERKS
P3000 RESGR P3000 RESGR TCYMI Matrix identifications MATRIX_ID
P3000 SNTYPE P3000 MANDT TQ80 Notification Types MANDT
P3000 SNTYPE P3000 SNTYPE TQ80 Notification Types QMART
P3000 SRTYPE P3000 MANDT COCF_CU_SRTYPE Shift Report Type - Definition MANDT
P3000 SRTYPE P3000 SRTYPE COCF_CU_SRTYPE Shift Report Type - Definition SRTYPE
P3000 STAND SYST MANDT T499S Location MANDT
P3000 STAND P3000 WERKS T499S Location WERKS
P3000 STAND P3000 STAND T499S Location STAND
P3000 SUBSYS SYST MANDT QISUB Subsytems for recording measured value data in QM MANDANT
P3000 SUBSYS P3000 SUBSYS QISUB Subsytems for recording measured value data in QM SUBSYS
P3000 SUBTY P3000 MANDT T778U Subtypes MANDT
P3000 SUBTY P3000 INFTY T778U Subtypes INFTY
P3000 SUBTY P3000 SUBTY T778U Subtypes SUBTY
P3000 VERAN P3000 WERKS TC24 Person responsible for the work center WERKS
P3000 VERAN P3000 VERAN TC24 Person responsible for the work center VERAN
P3000 VERAN SYST MANDT TC24 Person responsible for the work center MANDT
P3000 VERWE SYST MANDT TC30 Work center category MANDT
P3000 VERWE P3000 VERWE TC30 Work center category VERWE
P3000 VGWTS SYST MANDT TC21 Standard value key MANDT
P3000 VGWTS P3000 VGWTS TC21 Standard value key VGWTS
P3000 WERKS SYST MANDT T001W Plants/Branches MANDT
P3000 WERKS P3000 WERKS T001W Plants/Branches WERKS
P3000 ZGR01 SYST MANDT TC31 Performance Efficiency Rate Key MANDT
P3000 ZGR01 P3000 ZGR01 TC31 Performance Efficiency Rate Key ID
P3000 ZGR02 SYST MANDT TC31 Performance Efficiency Rate Key MANDT
P3000 ZGR02 P3000 ZGR02 TC31 Performance Efficiency Rate Key ID
P3000 ZGR03 SYST MANDT TC31 Performance Efficiency Rate Key MANDT
P3000 ZGR03 P3000 ZGR03 TC31 Performance Efficiency Rate Key ID
P3000 ZGR04 P3000 ZGR04 TC31 Performance Efficiency Rate Key ID
P3000 ZGR04 SYST MANDT TC31 Performance Efficiency Rate Key MANDT
P3000 ZGR05 SYST MANDT TC31 Performance Efficiency Rate Key MANDT
P3000 ZGR05 P3000 ZGR05 TC31 Performance Efficiency Rate Key ID
P3000 ZGR06 SYST MANDT TC31 Performance Efficiency Rate Key MANDT
P3000 ZGR06 P3000 ZGR06 TC31 Performance Efficiency Rate Key ID