SAP table V_U444B (Generated Table for View)
SAP table V_U444B has 4 primary key fields being MANDT,TGROUP,UNAME,NAVNR.
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
TGROUP
Transaction group
CHAR
4
0
TGROUP
Possible values
MD
MRP evaluation transactions
UNAME
User Name
CHAR
12
0
UNAME
NAVNR
Sequence number for transaction calls
NUMC
2
0
NAVNR
TCODE
Transaction code
CHAR
20
0
TSTC
NAV_TCODE
TEXT
Menu text
CHAR
40
0
NAV_TEXT
ICON_ID
Icon (symbol)
CHAR
4
0
ICON
NAV_ICONID
ICON_TEXT
Icon text
CHAR
40
0
NAV_ICONTEXT
QUICKINFO
Text for Quickinfo
CHAR
60
0
NAV_QUICK
ICON_NAME
Icon (symbol)
CHAR
30
0
NAV_ICON
ANFBD
Transaction call with initial screen
CHAR
1
0
ANFBD
PID01
Parameter ID 1 for Defaults for Required Entry Fields
CHAR
20
0
NAV_PID
PIDV1
Parameter Value for Parameter ID 1
CHAR
40
0
NAV_PARVAL
PID02
Parameter ID 2 for Defaults for Required Entry Fields
CHAR
20
0
NAV_PID2
PIDV2
Parameter Value for Parameter ID 2
CHAR
40
0
NAV_PARVAL2
PID03
Parameter ID 3 for Defaults for Required Entry Fields
CHAR
20
0
NAV_PID3
PIDV3
Parameter Value for Parameter ID 3
CHAR
40
0
NAV_PARVAL3
BESKZ
Condition for procurement type
CHAR
1
0
BESKZ_IF
MTART
Condition for material type
CHAR
4
0
T134
MTART_IF
DISGR
Condition for MRP group
CHAR
4
0
DISGR_IF
DISMM
Condition for MRP type
CHAR
2
0
T438A
DISMM_IF
TRANS
Application component for transaction
CHAR
1
0
TRANS_IF
AEXTS
Transaction Call in an External System
CHAR
1
0
AEXTS
ANMOD
Transaction Call in New Session
CHAR
1
0
ANMOD
V_U444B foreign key relationships
Table
Field
Check Table
Check Field
0 V_U444B
DISMM
T438A
MRP Type
MANDT
0 V_U444B
DISMM
T438A
MRP Type
DISMM
1 V_U444B
ICON_ID
ICON
Icons table
ID
0 V_U444B
MANDT
T000
Clients
MANDT
1 V_U444B
MTART
T134
Material Types
MANDT
1 V_U444B
MTART
T134
Material Types
MTART
0 V_U444B
TCODE
TSTC
SAP Transaction Codes
TCODE