SAP table J_1AAWAYBL (Way Bills for asset movements)

SAP table J_1AAWAYBL has 2 primary key fields being MANDT,WBLNR.

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 * MANDT
WBLNR Internal Number for asset movement way bills CHAR 8 0 J_1AAWBLNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
J_1ASNR Branch of sender object CHAR 4 0 J_1ASNR J_1AASESNR
J_1APRTCHR Character to be printed on the document CHAR 1 0 J_1APRTCHR J_1APCHAR
J_1ADOCCLS Document Class CHAR 1 0 J_1ADOCCLS J_1ADOCCL_
J_1AOFFNUM Official document number for Argentina CHAR 8 0 J_1AOFFNUM
REASON Type of movement - reason for numbering CHAR 1 0 J_1AAREASN
1 Movement to other location
2 Asset transfer to an other asset
3 Transfer with movement
4 other reasons
SANLN1 Sender asset main number CHAR 12 0 ANLH J_1AASANL1
SANLN2 Sender Asset Sub number CHAR 4 0 ANLA J_1AASANL2
SINVNR Inventory Number CHAR 25 0 INVNR_ANLA
STXT50 Asset Description CHAR 50 0 TXA50_ANLT
STEXT Error message text - long text of the error CHAR 70 0 TEXT70
MOVDT Document date for way bill DATS 8 0 J_1AAMOVDT
RBUKRS Receiver company code CHAR 4 0 T001 J_1AARBUKR
J_1ARNR Branch of receiver object CHAR 4 0 J_1BBRANCH J_1AARCSNR
RANLN1 Receiver Asset main number CHAR 12 0 ANLH J_1AARANL1
RANLN2 Receiver Asset sub number CHAR 4 0 ANLA J_1AARANL2
RINVNR Inventory Number CHAR 25 0 INVNR_ANLA
RTXT50 Asset Description CHAR 50 0 TXA50_ANLT
RTEXT Error message text - long text of the error CHAR 70 0 TEXT70
GJAHR Fiscal Year NUMC 4 0 GJAHR
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
CHANGENR Change Number of Document CHAR 10 0 CDCHANGENR
TEXT70 Error message text - long text of the error CHAR 70 0 TEXT70
ANRED Title CHAR 15 0 ANRED
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSTLZ Postal Code CHAR 10 0 PSTLZ
REGIO Region (State, Province, County) CHAR 3 0 * REGIO
LAND1 Country/Region Key CHAR 3 0 * LAND1_GP
J_1ATODC Tax Number Type CHAR 2 0 * J_1ATOID
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
J_1AFOP Tax Code for Foreign Nationals CHAR 13 0 * J_1AFOPID
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
J_1AFITP Tax type CHAR 2 0 * J_1AFITP_D
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
PRDAT Printing date for asset accounting way bill DATS 8 0 J_1AAPRTDT
XLOEV Deletion flag CHAR 1 0 J_1AAXLOEV
LIFNR Forwarding agent/carrier CHAR 10 0 LFA1 J_1ACAREER

J_1AAWAYBL foreign key relationships

Table Field Check Table Check Field
0 J_1AAWAYBL BUKRS T001 Company Codes BUKRS
1 J_1AAWAYBL J_1ADOCCLS J_1ADOCCLS Official document class for Argentina MANDT
1 J_1AAWAYBL J_1ADOCCLS J_1ADOCCLS Official document class for Argentina J_1ACOCCLS
0 J_1AAWAYBL J_1APRTCHR J_1APRTCHR Printing characters for Argentina MANDT
0 J_1AAWAYBL J_1APRTCHR J_1APRTCHR Printing characters for Argentina J_1APRTCHR
1 J_1AAWAYBL J_1ARNR J_1BBRANCH Business Place BUKRS
1 J_1AAWAYBL J_1ARNR J_1BBRANCH Business Place BRANCH
1 J_1AAWAYBL J_1ARNR J_1BBRANCH Business Place BUPLA_TYPE
0 J_1AAWAYBL J_1ASNR J_1ASNR Branch number BUKRS
1 J_1AAWAYBL LIFNR LFA1 Supplier Master (General Section) MANDT
1 J_1AAWAYBL LIFNR LFA1 Supplier Master (General Section) LIFNR
0 J_1AAWAYBL RANLN1 ANLH Main asset number BUKRS
0 J_1AAWAYBL RANLN1 ANLH Main asset number ANLN1
1 J_1AAWAYBL RANLN2 ANLA Asset Master Record Segment BUKRS
1 J_1AAWAYBL RANLN2 ANLA Asset Master Record Segment ANLN1
1 J_1AAWAYBL RANLN2 ANLA Asset Master Record Segment ANLN2
0 J_1AAWAYBL RBUKRS T001 Company Codes BUKRS
1 J_1AAWAYBL SANLN1 ANLH Main asset number BUKRS
1 J_1AAWAYBL SANLN1 ANLH Main asset number ANLN1
0 J_1AAWAYBL SANLN2 ANLA Asset Master Record Segment BUKRS
0 J_1AAWAYBL SANLN2 ANLA Asset Master Record Segment ANLN1
0 J_1AAWAYBL SANLN2 ANLA Asset Master Record Segment ANLN2