SAP Table PLAB
Relationships
PLAB (Relationships) 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 PLAB to other SAP tables.
PLAB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
PLNTY
Task List Type
|
PLNTY |
CHAR
|
1 | 0 | ||||||||||
|
PLNNR
Number of the Standard Network
|
AOB_PLNNR |
CHAR
|
8 | 0 | ||||||||||
|
PLNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||
|
PLNKN
Number of the task list node
|
PLNKN |
NUMC
|
8 | 0 | ||||||||||
|
PLNRN
Number of the Standard Network
|
AOB_PLNNR |
CHAR
|
8 | 0 | ||||||||||
|
ALNRN
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||
|
KNNRN
Number of the task list node
|
PLNKN |
NUMC
|
8 | 0 | ||||||||||
|
AOBAR
Type of relationship
|
AOBAR |
CHAR
|
2 | 0 | ||||||||||
|
MIMAX
Indicates whether maximum time interval will be considered
|
DAUMIMAX |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||
|
DATUV
Valid-from date
|
CIM_DATE |
DATS
|
8 | 0 | ||||||||||
|
TECHV
Technical status from
|
TECHV |
CHAR
|
12 | 0 | ||||||||||
|
AENNR
Change Number
|
AENNR | AENR |
CHAR
|
12 | 0 | |||||||||
|
ZEINH
Unit for the time interval between relationships
|
AOBDAUEH | T006 |
UNIT
|
3 | 0 | |||||||||
|
DAUER
Time interval between relationships
|
AOBDAUER |
QUAN
|
5 | 1 | ||||||||||
|
DAUKZ
Indicator for the duration of the relationship
|
AOBDAUKZ |
CHAR
|
1 | 0 | ||||||||||
|
VORNC
Indicator: maintained after successor
|
VORG_NACH |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
NCVOR
Indicates whether data after predecessor is maintained
|
NACH_VORG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LOEKZ
Asset class marked for deletion
|
LOEKZ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
KALID
Factory Calendar
|
WFCID | TFACD |
CHAR
|
2 | 0 | |||||||||
|
PRZNT
% used to calc. time interval between predecessor/successor
|
AOB_PRZNT |
NUMC
|
3 | 0 | ||||||||||
|
PROVG
Key for defining time intervals in a relationship
|
AOB_PROVG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ARBID
Object ID
|
OBJEKTID |
NUMC
|
8 | 0 | ||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||
|
ANDAT
Date record created on
|
ANDAT |
DATS
|
8 | 0 | ||||||||||
|
ANNAM
User who created record
|
ANNAM |
CHAR
|
12 | 0 | ||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||
|
DAUERMAX
Maximum time interval for relationship
|
AOBDAUERM |
QUAN
|
5 | 1 | ||||||||||
PLAB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PLAB | AENNR | PLAB | MANDT |
AENR
Change Master
|
MANDT |
| PLAB | AENNR | PLAB | AENNR |
AENR
Change Master
|
AENNR |
| PLAB | KALID | PLAB | KALID |
TFACD
Factory calendar definition
|
IDENT |
| PLAB | MANDT | PLAB | MANDT |
T000
Clients
|
MANDT |
| PLAB | WERKS | PLAB | MANDT |
T001W
Plants/Branches
|
MANDT |
| PLAB | WERKS | PLAB | WERKS |
T001W
Plants/Branches
|
WERKS |
| PLAB | ZEINH | PLAB | ZEINH |
T006
Units of Measurement
|
MSEHI |
| PLAB | ZEINH | PLAB | MANDT |
T006
Units of Measurement
|
MANDT |