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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
VGM02 | Rule for standard value maintenance | AP_VGW_MES | CHAR | 1 | 0 |
Possible values
|
||||||||||||
VGM03 | Rule for standard value maintenance | AP_VGW_MES | CHAR | 1 | 0 |
Possible values
|
||||||||||||
VGM04 | Rule for standard value maintenance | AP_VGW_MES | CHAR | 1 | 0 |
Possible values
|
||||||||||||
VGM05 | Rule for standard value maintenance | AP_VGW_MES | CHAR | 1 | 0 |
Possible values
|
||||||||||||
VGM06 | Rule for standard value maintenance | AP_VGW_MES | CHAR | 1 | 0 |
Possible values
|
||||||||||||
XDEFA | Indicator: Work center for default values | AP_DEFAULT | CHAR | 1 | 0 |
Possible values
|
||||||||||||
XKOST | Indicator: Work center is maintained for costing | AP_XKOST | CHAR | 1 | 0 |
Possible values
|
||||||||||||
XSPRR | Indicator: Work center is locked | AP_XSPRR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
XTERM | Indicator: Work center is maintained for scheduling | AP_XTERM | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
ZGR02_REF | Field is referenced | AP_KZREF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
ZGR03_REF | Field is referenced | AP_KZREF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
ZGR04_REF | Field is referenced | AP_KZREF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
ZGR05_REF | Field is referenced | AP_KZREF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
ZGR06_REF | Field is referenced | AP_KZREF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
BDEFLG | Dummy data element for reference structure | CYFLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
ISTBED_KZ | Calculation of actual capacity requirements | CY_ISTBEDKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |