SAP table JITCU (Customer data)
SAP table JITCU has 2 primary key fields being MANDT,CUSTO.
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
CUSTO
JIT Customer
CHAR
4
0
JIT_CUSTO
KUNNR
Sold-to Party
CHAR
10
0
KNA1
KUNAG
KNREF
Customer description of partner (plant, storage location)
CHAR
30
0
V_JITKNVP
KNREF
ABRVW
Usage Indicator
CHAR
3
0
TVLV
ABRVW
TZONE
Time zone of customer plant
CHAR
6
0
TTZZ
JIT_TZONE
FPROF
Determ.profile for comp.group
CHAR
8
0
CJIT08
JIT_FPROF
VATYP
Proposal call type
CHAR
1
0
JIT_VATYP
IMPAC
Signal Monitor Active
CHAR
1
0
JIT_IMPAC
MTMOD
Maintenance Mode Sequenced JIT Calls
CHAR
1
0
JIT_MAINT_MODE
Possible values
1
EDI
2
Assemblies
3
Discrete Material/SumJC
DON_PROFIL
Control Profile for Summarized JIT Calls (SumJC)
CHAR
12
0
CJIT13
JIT_DON_PROFIL
LPROF
Control Profile for the Delivery Creation
CHAR
8
0
CJIT14
JIT_LPROF
JITCU foreign key relationships
Table
Field
Check Table
Check Field
0 JITCU
ABRVW
TVLV
Check table for release orders: Usage ID
ABRVW
1 JITCU
DON_PROFIL
CJIT13
SumJC: JIT Customer Dependent Profile Settings
PROFIL
0 JITCU
KNREF
V_JITKNVP
Generated Table for View
KUNNR
0 JITCU
KNREF
V_JITKNVP
Generated Table for View
KNREF
0 JITCU
KNREF
V_JITKNVP
Generated Table for View
VKORG
0 JITCU
KNREF
V_JITKNVP
Generated Table for View
VTWEG
0 JITCU
KNREF
V_JITKNVP
Generated Table for View
SPART
1 JITCU
KUNNR
KNA1
General Data in Customer Master
MANDT
1 JITCU
KUNNR
KNA1
General Data in Customer Master
KUNNR
0 JITCU
MANDT
T000
Clients
MANDT
1 JITCU
TZONE
TTZZ
Time zones
TZONE