SAP table J_2GLPLEGDOC (Legal printed documents)
SAP table J_2GLPLEGDOC has 5 primary key fields being MANDT,DOCUCATEG,SAPDOC,GJAHR,GIDOC.
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
Client
CLNT
3
0
T000
MANDT
Document category
CHAR
1
0
J_2GLPDOCCATG
Possible values
B
Billing documents
D
Delivery documents
F
FI documents
M
Material documents
S
Settlement Document
SAP document
CHAR
10
0
J_2GLPSAPDOC
Fiscal Year
NUMC
4
0
GJAHR
Number of Material Document
CHAR
10
0
MBLNR
POSTDATE
Posting Date in the Document
DATS
8
0
BUDAT
BUKRS
Company Code
CHAR
4
0
T001
BUKRS
PRNTSK
Print Task code
CHAR
5
0
J_2GLPP1
J_2GLPPRNTSK
LOGKIND
Logical Kind for printing SD/MM documents
CHAR
15
0
J_2GLPLK
J_2GLPLOGKIND
LEGALDOC
Reference Document Number
CHAR
16
0
XBLNR
XBLNRUPDT
XBLNR was updated ( yes/no )
CHAR
1
0
J_2GLPXBLNRUP
Possible values
PRUSER
Last user who printed the document
CHAR
12
0
J_2GLPPRUSER
PRDATE
Last date the document was print
DATS
8
0
J_2GLPPRDATE
ERNAM
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
ERDAT
Date on which the record was created
DATS
8
0
ERDAT
STEXT
Series prefix text
CHAR
6
0
*
J_2GLPSTEXT
SERIES
Series
CHAR
6
0
J_2GLPSERIES
NUMBR
Counter ( the last number used )
NUMC
9
0
J_2GLPCOUNTER
J_2GLPLEGDOC foreign key relationships
Table
Field
Check Table
Check Field
0 J_2GLPLEGDOC
BUKRS
T001 Company Codes
BUKRS
1 J_2GLPLEGDOC
MANDT
T000 Clients
MANDT
0 J_2GLPLEGDOC
PRNTSK
J_2GLPP1 Table for print task codes
BUKRS
0 J_2GLPLEGDOC
PRNTSK
J_2GLPP1 Table for print task codes
PRNTSK