SAP table CVLC12 (VELO : Status - Availability, Locations, Planned Dely Time)

SAP table CVLC12 has 4 primary key fields being MANDT,CNTRL,AKTION,STATU_NEW.

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 CVLC11 VLC_CNTRL
AKTION Action CHAR 4 0 CVLC11 VLC_ACTION
STATU_NEW New Vehicle Status CHAR 4 0 CVLC02 VLC_STATU_NEW
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

CVLC12 foreign key relationships

Table Field Check Table Check Field
0 CVLC12 AKTION CVLC11 VELO : Availability, Locations, Planned Delivery Time CNTRL
0 CVLC12 AKTION CVLC11 VELO : Availability, Locations, Planned Delivery Time AKTION
1 CVLC12 AVAIL CVLC10 VELO : Availability Status AVAIL
0 CVLC12 CNTRL CVLC11 VELO : Availability, Locations, Planned Delivery Time CNTRL
0 CVLC12 CNTRL CVLC11 VELO : Availability, Locations, Planned Delivery Time AKTION
1 CVLC12 LOCTN CVLC06 VELO : Current Location LOCTN
0 CVLC12 MANDT T000 Clients MANDT
1 CVLC12 STATU_NEW CVLC02 VELO : Vehicle Status STATU