SAP Table LDLBH (Line balance/planned rate header record)
SAP table LDLBH has 3 primary key fields being MANDT,LNID,LBVER.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
T000
MANDT
LNID
Object ID of the resource
NUMC
8
0
CRID
CR_OBJID
LBVER
Line balancing version
NUMC
4
0
LD_LBVER
STATU
Status of line balance
CHAR
1
0
LD_STATU
Possible values
LD_PERST
Period start
DATS
8
0
LD_PERST
LD_PERED
Period end
DATS
8
0
LD_PERED
LRATE
Planned rate for production line
QUAN
13
3
LD_LRATE_PLAN
LANTU
Number of Time Units
QUAN
5
2
LD_LANTU
TKZTI
Takt time (in seconds)
DEC
8
0
LD_TKZTI
LBTXT
Line balance description
CHAR
40
0
LD_LBTXT
RIDVN
Start of period for reqmts/receipt determination
DATS
8
0
LD_DPRVN
RIDBS
End of period for reqmts/receipt determination
DATS
8
0
LD_DPRBS
AENNR
Change Number
CHAR
12
0
AENR
AENNR
ANDAT
Date Record Created On
DATS
8
0
ANDAT
ANNAM
User who created record
CHAR
12
0
ANNAM
AEDAT
Last Changed On
DATS
8
0
AEDAT
AENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
LBAL_MAX
Indicator: balance line to max. load utiliz. of prod. line
CHAR
1
0
LD_LBAL_MAX
TKTAG
Takt comparison for line
DEC
5
2
LD_TKTAG
LDLBH foreign key relationships
Table
Field
Check Table
Check Field
0 LDLBH
AENNR
AENR
Change Master
AENNR
1 LDLBH
LNID
CRID
CIM Resource - Entities
MANDT
1 LDLBH
LNID
CRID
CIM Resource - Entities
OBJID
0 LDLBH
MANDT
T000
Clients
MANDT