SAP Table

VALW Delivery Plan: Definition of Route Schedule

SAP table VALW has 2 primary key fields being MANDT,AULWE.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

VALW columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyAULWE Route Schedule CHAR 10 0 AULWE
ROUTE Route CHAR 6 0 TVRO ROUTE
PRIOA Period type: day CHAR 3 0 TVPO PRIOA
PERI_AUSPR Goods issue day CHAR 3 0 PERI_AUSPR
W_ZEIT Goods issue time TIMS 6 0 W_ZEIT
V_TAGE Processing lead time - in days NUMC 5 0 V_TAGE
V_STUNDE Processing lead time - in hours NUMC 2 0 V_STUNDE
V_MINUTEN Processing lead time - in minutes NUMC 2 0 V_MINUTEN
AV_TAGE Call lead time - no. of days NUMC 5 0 AV_TAGE
AV_STUNDEN Call lead time - no. of hours NUMC 2 0 AV_STUNDEN
AV_MINUTEN Call lead time - no. of minutes NUMC 2 0 AV_MINUTEN
ID_INT Internal Route Schedule ID CHAR 22 0 * BORRTTS_GUID
SUBID Schedule Item Number CHAR 4 0 BORRT_SUBID
/ Relationships

VALW foreign keys.

Table Field Check Table Description Check Field
VALW MANDT T000 Clients MANDT
VALW PRIOA TVPO Daily Period Types MANDT
VALW ROUTE TVRO Routes MANDT
VALW ROUTE TVRO Routes ROUTE