- Home
- Resources
- SAP Tables
- PLAB - Relationships
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.
Source: PLAB (Relationships)
PLAB table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| 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 |
Possible values
|
| 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 |
Possible values
|
| NCVOR |
Indicates whether data after predecessor is maintained |
NACH_VORG |
|
CHAR |
|
1 |
0 |
Possible values
|
| LOEKZ |
Asset class marked for deletion |
LOEKZ |
|
CHAR |
|
1 |
0 |
Possible values
|
| 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 |
Possible values
| NULL |
Absolute (standard) |
| 1 |
% duration of predecessor |
| 2 |
% duration of successor |
|
| 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 |
MANDT |
T006 |
Units of Measurement |
MANDT |
| PLAB |
ZEINH |
PLAB |
ZEINH |
T006 |
Units of Measurement |
MSEHI |
