SAP table J_1ASNR (Branch number)
SAP table J_1ASNR has 5 primary key fields being MANDT,BUKRS,J_1ASNR,J_1ADOCCLS,J_1APRTCHR.
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
BUKRS
Company Code
CHAR
4
0
T001
BUKRS
J_1ASNR
Branch Number
CHAR
4
0
J_1ABRNCH
J_1ADOCCLS
Document Class
CHAR
1
0
J_1ADOCCLS
J_1ADOCCL_
J_1APRTCHR
Character to be printed on the document
CHAR
1
0
J_1APRTCHR
J_1APCHAR
EBRCH
CAE Electronic Branch
CHAR
1
0
J_1AEBRCH
ANX3_DATE
Date of Annexure III generation
DATS
8
0
J_1AANX3DT
ANX3_SALES_DATE
Stores the last sent document date in Annexure 3 for Sales
DATS
8
0
J_1AANX3SALESDT
ANX3_SERV_DATE
Stores the last sent document date in Annexure 3 for Service
DATS
8
0
J_1AANX3SERVDT
SALES_SERV_IND
Goods or Service Invoices
CHAR
1
0
J_1ASALSERIND
Possible values
1
Export of Goods
2
Export of Services
3
Goods or Services
4
Export others
S
Goods
V
Service
WSBRNCH
CAE WebService Branch
CHAR
1
0
J_1AWSBRCH
Possible values
Not applicable for webservice
X
Webservice Branch
CONT_BRANCH
Contingency Branch
CHAR
4
0
J_1ACONBRNCH
RELEASE_SD
Automatic release of SD documents
CHAR
1
0
J_1AWSRELEASE
Possible values
EDOC_MIGRATION
eDocument Migration Actived
CHAR
1
0
J_1AEDOC_MIGRATION
Possible values
Not using edocument
X
Using Edocument
J_1ASNR foreign key relationships
Table
Field
Check Table
Check Field
0 J_1ASNR
BUKRS
T001
Company Codes
BUKRS
1 J_1ASNR
J_1ADOCCLS
J_1ADOCCLS
Official document class for Argentina
MANDT
1 J_1ASNR
J_1ADOCCLS
J_1ADOCCLS
Official document class for Argentina
J_1ACOCCLS
0 J_1ASNR
J_1APRTCHR
J_1APRTCHR
Printing characters for Argentina
MANDT
0 J_1ASNR
J_1APRTCHR
J_1APRTCHR
Printing characters for Argentina
J_1APRTCHR
1 J_1ASNR
MANDT
T000
Clients
MANDT