SAP table CVLC11 (VELO : Availability, Locations, Planned Delivery Time)

SAP table CVLC11 has 3 primary key fields being MANDT,CNTRL,AKTION.

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
CNTRL Action Control CHAR 4 0 CVLC01 VLC_CNTRL
AKTION Action CHAR 4 0 CVLC03 VLC_ACTION
AVAIL Availability Status CHAR 2 0 CVLC10 VLC_AVAILABILITY
REMAININGTIME Days Remaining until Delivery INT2 5 0 VLC_REMAININGTIME
TERMBASIS Start Date for Scheduling CHAR 1 0 VLC_TERMBASIS
Current date
1 Production date
2 Conf. Delivery Date
LOCTN VMS-Vehicle Location CHAR 10 0 CVLC06 VLC_LOCTN
LOCTNSOURCE Source for Automatic Address Determination CHAR 2 0 VLC_LOCTNSOURCE
01 Customer Master Record
02 Vendor Master Record
03 End Customer

CVLC11 foreign key relationships

Table Field Check Table Check Field
0 CVLC11 AVAIL CVLC10 VELO : Availability Status AVAIL
1 CVLC11 LOCTN CVLC06 VELO : Current Location LOCTN
0 CVLC11 MANDT T000 Clients MANDT