SAP table VC_T186V (Generated Table for View)

SAP table VC_T186V has 2 primary key fields being MANDT,SZENARIO.

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
SZENARIO Shipping due date processing scenario CHAR 4 0 SHP_VL10_SZENARIO
0001 Sales Orders
0002 Purchase Orders
0003 Sales Orders and Purchase Orders
0101 Sales Order Items
0102 Purchase Order Items
0103 Sales Order Items and Purchase Order Items
0201 Sales Order Schedule Lines
0202 Purchase order item schedule line
0203 Schedule Lines for Sales Orders and Purchase Orders
1001 Cross-System Deliveries
2000 Confirm Transfer Orders
500B Schedule Background Processing (3 Tabs)
500C Schedule Background Processing (6 Tabs)
DELG Outbound Delivery Groups
HCO1 Plan HUs (Packing Planning - Production Order)
HCO2 Pack HUs (Pack - Production Order)
HMF1 Plan HUs (Packing Planning - Repetitive Manufacturing)
HMF2 Pack HUs (Pack - Repetitive Manufacturing)
HST1 Plan HUs (Packing Planning - Stock)
HST2 Pack HUs (Pack - Stock)
PDON Deliver Scheduling Agreement with DON (Not Implemented Yet)
QM01 Create Delivery from Quality Notification
STOA Automatic Delivery Creation for STO
UNCO Check and Combine Unchecked Deliveries
VL04 Scenario for Transaction VL04 (Upgrade - Only Release 4.6)
VL10 Default Scenario for Transaction VL10
VLHU Deliver Handling Units
PROFILNAME Name of profile for generating a delivery list CHAR 4 0 T186 SHP_VL10_LIST_PROFILNAME
VTEXT Description CHAR 40 0 BEZEI40
SEL_SCREEN Selection screen variant for extended delivery due list CHAR 1 0 SHP_VL10_SEL_SCREEN
1 Documents due for delivery (obsolete)
2 Documents due for delivery (obsolete)
3 Documents due for delivery
4 Use RV50SBT1 (upgrade VL04, only Release 4.6)
5 Schedule batch jobs without tab
6 Schedule batch jobs (3 tabs)
7 Schedule batch jobs (6 tabs)
9 User exit 9
A Selection screens for production scenarios
Y User exit Y
Z User exit Z
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)
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
SHOW_0_QUAN_BLOC Display Schedule Lines Blocked for Delivery that Have Qty 0 CHAR 1 0 SHP_VL10_SHOW_0_QUAN_BLOCKED
SHOW_SCHED_LINE Allow Constraints on Schedule Line Level CHAR 10 0 SHP_VL10_SHOW_SCHEDULE_LINE
Do not allow any schedule line constraints
1 Allow 1 restriction according to due date
12 1 and 2
123 1, 2 and 3
13 1 and 3
2 Allow 2 restrictions according to route schedule
23 2 and 3
3 Allow 3 restrictions according to planned goods issue time
TCODE_STOCK Transaction for Extended Stock Display CHAR 20 0 SHP_VL10_FCODE_STOCK
CO06 Backorder processing
CO09 Availability overview
MD04 Requirements/stock overview
MMBE Plant stocks
PROT1_SHOW Log display mode following delivery creation CHAR 1 0 SHP_VL10_PROT1_SHOW
PROT2_SHOW User Must Request Log Display Mode ("Display Log" Function) CHAR 1 0 SHP_VL10_PROT2_SHOW
LOES_MODE Batch Input Mode for Deleting Delivery CHAR 1 0 SHP_VL10_LOES_MODE
GUI_STATUS GUI status for shipping due list processing CHAR 20 0 SHP_VL10_GUI_STATUS
FCODE_PROFIL Profile Name for Function Codes for Current List Profile CHAR 4 0 SHP_VL10_FCODE_PROFIL
0001 Display Delivery List
2001 Display Delivery Due List with Handling Units
200H Create HUs Without Displaying Delivery Due List
3001 Check and Combine Unchecked Deliveries
5001 Run Delivery List
Z001 User Exit 1
Z002 User Exit 2
Z003 User Exit 3
FCODE_ALLOW_PRF Profile name for specification of allowed Fcodes on status CHAR 4 0 * SHP_VL10_FCODE_ALLOW_PROFIL
CREATE_PROFIL Name of Profile for Creating Deliveries CHAR 4 0 * SHP_VL10_CREAT_PROFILNAME

VC_T186V foreign key relationships

Table Field Check Table Check Field
0 VC_T186V PROFILNAME T186 Delivery List Profile MANDT