SAP table T186 has 2 primary key fields being MANDT,PROFILNAME.
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
*
MANDT
PROFILNAME
Name of profile for generating a delivery list
CHAR
4
0
SHP_VL10_LIST_PROFILNAME
SELEKTIONEN
Description of documents to be selected
CHAR
20
0
SHP_VL10_SELEKTIONEN
1
Sales orders
12
Sales orders and purchase orders
123
Sales orders and purchase orders and deliveries
13
Sales orders and deliveries
2
Purchase orders
23
Purchase orders and deliveries
3
Deliveries
LIST_TYPE
Type of Delivery List (Index Data or Document Data)
CHAR
1
0
SHP_VL10_LIST_TYPE
1
Index list (fast display)
2
Document list (item display/sched. line display)
LIST_CONTROL
Use ALV List Control
CHAR
1
0
SHP_VL10_LIST_CONTOL
ONELINE_PER_ITEM
One List Line per Document Item
CHAR
1
0
SHP_VL10_ONE_LINE_PER_ITEM
DARSTELLUNG
Layout of shipping due list
CHAR
1
0
SHP_VL10_DARSTELLUNG
1
Sequential
2
Hierarchical
KEY_TYPE
Type of Foreign Key for the Shipping Due List, ALV
CHAR
1
0
SHP_VL10_KEY_TYPE
1
Ship-to party and source document
2
Source document item
3
Ship-to party
4
Source document
5
Release numbers of the customer & the source document
6
Source document schedule line
7
Delivery
8
Causative Document Schedule Line & Delivery Item
9
User Exit LV50R_VIEWG10
G
Outbound Delivery Groups
CHECK_AUTHORITY
Authorization check for display auth. in delivery list
CHAR
1
0
SHP_VL10_BERECHTIGUNG
ENQUE
Include Only Blocked Items in Shipping Due List
CHAR
1
0
SHP_VL10_ENQUE
Construct list without document block
1
List contains only blocked orders
SELKZ_HEAD
Selection indicator at header level (otherwise item level)
CHAR
1
0
SHP_VL10_SELKZ_HEAD
EXPAND
Expand by hierarchical list
CHAR
1
0
SHP_VL10_EXPAND
AMPEL
Number of Days in Critical Period
NUMC
2
0
SHP_VL10_AMPEL3
OPEN_DELIVERIES
Restriction for selected/displayed deliveries
CHAR
1
0
SHP_VL10_OPEN_DELIVERIES
All deliveries
X
All open deliveries
EXTENDED_SHIP_TO
Extended data selection for ship-to party (Name)
CHAR
1
0
SHP_VL10_EXTENDED_SHIP_TO
EXTENDED_STOCK
Extended Data Selection for Stock
CHAR
1
0
SHP_VL10_EXTENDED_STOCK
LEDAT_RULE
Rule for determining default value for deliv. creation date
CHAR
1
0
SHP_VL10_LEDAT_RULE
All Up To Maximum Number of Days
1
Due for shipment today
2
Today and tomorrow
3
Due for shipment by the end of next week (+ past-due delivs)
4
Due for shipment tomorrow (includes past-due deliveries)
9
User exit
KUMNG_RULE
Rule for Calculation of Quantity to Be Delivered
CHAR
1
0
SHP_VL10_KUMNG_RULE
1
Cumulation of open delivery quantities in all schedule lines
2
Cumulatn of open deliv. qtys of sched. lines at select time
3
Open delivery quantity in the (last) schedule line
4
Similar to 1, but with no rounding acc. to sched. agreement
5
Similar to 2, but with no rounding acc. to sched. agreement
6
Similar to 3, but with no rounding acc. to sched. agreement
7
Cumulation of backlogged sched. lines/indiv. for future ones
8
Similar to 7, but with no rounding
9
User Exit LV50R_VIEWH19
SELKZ_RULE
Choose Rule on Initial Output of the List
CHAR
1
0
SHP_VL10_SELKZ_RULE
1
Select nothing
2
Select all
3
Select only when deliv. creation date is in selection range
SPLIT_RULE
Rule for Creating One Delivery Item per Schedule Line