SAP ABAP Table LQUA_VB (Transfer structure LQUA + LQUA1 for function module)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ LVS (Package) Application development Warehouse Management (WM)
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ LVS (Package) Application development Warehouse Management (WM)
Basic Data
Table Category | INTTAB | Structure |
Structure | LQUA_VB | Table Relationship Diagram |
Short Description | Transfer structure LQUA + LQUA1 for function module |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Quants | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | LGNUM | LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | T300 | |
4 | LQNUM | LVS_LQNUM | LVS_LQNUM | NUMC | 10 | 0 | Quant | ||
5 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
6 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
7 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
8 | BESTQ | BESTQ | BESTQ | CHAR | 1 | 0 | Stock Category in the Warehouse Management System | ||
9 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
10 | SONUM | LVS_SONUM | LVS_SONUM | CHAR | 16 | 0 | Special Stock Number | ||
11 | LGTYP | LGTYP | LGTYP | CHAR | 3 | 0 | Storage Type | T301 | |
12 | LGPLA | LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | LAGP | |
13 | PLPOS | LVS_PLPOS | LVS_PLPOS | CHAR | 2 | 0 | Position in storage bin | ||
14 | SKZUE | LQUA_SKZUE | XFELD | CHAR | 1 | 0 | Blocking indicator: for putaways (user) | ||
15 | SKZUA | LQUA_SKZUA | XFELD | CHAR | 1 | 0 | Blocking Indicator: For Stock Removals (User) | ||
16 | SKZSE | LQUA_SKZSE | XFELD | CHAR | 1 | 0 | Blocking indicator: current placement into stock (system) | ||
17 | SKZSA | LQUA_SKZSA | XFELD | CHAR | 1 | 0 | Blocking Indicator: Current Stock Removal (System) | ||
18 | SKZSI | LQUA_SKZSI | XFELD | CHAR | 1 | 0 | Blocking Indicator: Current Inventory (System) | ||
19 | SPGRU | LVS_SPGRU | LVS_SPGRU | CHAR | 1 | 0 | Blocking reason | T330 | |
20 | ZEUGN | LVS_ZEUGN | LVS_ZEUGN | CHAR | 10 | 0 | Certificate Number | ||
21 | BDATU | LQUA_BDATU | DATUM | DATS | 8 | 0 | Date of last movement | ||
22 | BZEIT | LQUA_BZEIT | UZEIT | TIMS | 6 | 0 | Time of last movement | ||
23 | BTANR | LQUA_BTANR | TANUM | NUMC | 10 | 0 | Document Number of Last Stock Change in Quant | ||
24 | BTAPS | LQUA_BTAPS | TAPOS | NUMC | 4 | 0 | Item in transfer order of last stock transfer | ||
25 | EDATU | LQUA_EDATU | DATUM | DATS | 8 | 0 | Date of last placement into stock | ||
26 | EZEIT | LQUA_EZEIT | UZEIT | TIMS | 6 | 0 | Time of last placement into stock | ||
27 | ADATU | LQUA_ADATU | DATUM | DATS | 8 | 0 | Date of last stock removal | ||
28 | AZEIT | LQUA_AZEIT | UZEIT | TIMS | 6 | 0 | Time of last stock removal | ||
29 | ZDATU | LQUA_ZDATU | DATUM | DATS | 8 | 0 | Date of last addition to existing stock | ||
30 | WDATU | LVS_WDATU | DATUM | DATS | 8 | 0 | Date of goods receipt | ||
31 | WENUM | LVS_WENUM | BELNR | CHAR | 10 | 0 | Goods Receipt Number | ||
32 | WEPOS | LVS_WEPOS | MBLPO | NUMC | 4 | 0 | Goods receipt item | ||
33 | LETYP | LVS_LETYP | LVS_LETYP | CHAR | 3 | 0 | Storage Unit Type | T307 | |
34 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
35 | GESME | LQUA_GESME | MENSH | QUAN | 13 | 3 | Total Quantity | ||
36 | VERME | LQUA_VERME | MENSH | QUAN | 13 | 3 | Available stock | ||
37 | EINME | LQUA_EINME | MENSH | QUAN | 13 | 3 | Stock for putaway | ||
38 | AUSME | LQUA_AUSME | MENSH | QUAN | 13 | 3 | Quantity to remove | ||
39 | MGEWI | LQUA_MGEWI | DEC8_3 | DEC | 11 | 3 | Weight of material | ||
40 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
41 | TBNUM | TBNUM | TBNUM | NUMC | 10 | 0 | Transfer Requirement Number | * | |
42 | IVNUM | LVS_IVNUM | BELNR | CHAR | 10 | 0 | Number of system inventory record | ||
43 | IVPOS | LVS_IVPOS | LVS_IVPOS | NUMC | 4 | 0 | Item number in inventory document | ||
44 | BETYP | LVS_BETYP | LVS_BETYP | CHAR | 1 | 0 | Requirement Type | * | |
45 | BENUM | LVS_BENUM | LVS_BENUM | CHAR | 10 | 0 | Requirement Number | ||
46 | LENUM | LENUM | LENUM | CHAR | 20 | 0 | Storage Unit Number | LEIN | |
47 | QPLOS | QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | * | |
48 | VFDAT | VFDAT | DATUM | DATS | 8 | 0 | Shelf Life Expiration or Best-Before Date | ||
49 | QKAPV | LQUA_QKAPV | DEC8_3 | DEC | 11 | 3 | Capacity usage of quant | ||
50 | KOBER | KOBER | KOBER | CHAR | 3 | 0 | Picking Area | * | |
51 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
52 | VIRGO | LQUA_VIRGO | XFELD | CHAR | 1 | 0 | Quant does not contain GR data | ||
53 | TRAME | LQUA_TRAME | MENSH | QUAN | 13 | 3 | Open Transfer Quantity | ||
54 | KZHUQ | LQUA_KZHUQ | XFELD | CHAR | 1 | 0 | Indicator: Quant is on a handling unit | ||
55 | VBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
56 | POSNR | POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
57 | IDATU | LQUA_IDATU | DATUM | DATS | 8 | 0 | Date of last inventory of quant | ||
58 | MSR_INSP_GUID | MSR_INSP_GUID | RAW | 16 | 0 | Inspection GUID | |||
59 | .INCLUDE | 0 | 0 | Help fields for loop processing of LQUA segments | |||||
60 | KZTYP | LTAP1KZTYP | XFELD | CHAR | 1 | 0 | Internal marker | ||
61 | SELKZ | LVS_SELKZ | XFELD | CHAR | 1 | 0 | Selection for list displays | ||
62 | SELMG | LQUA_VERME | MENSH | QUAN | 13 | 3 | Available stock | ||
63 | DAUER | RL03TDAUER | RL03TDAUER | NUMC | 3 | 0 | Length of time of material in this bin (in days) | ||
64 | VBLCH | LTAP_VBLCH | XFELD | CHAR | 1 | 0 | Blocks with mixed batches SOURCE | ||
65 | VSUMM | LTAP_VSUMM | T331BSUMME | CHAR | 1 | 0 | Level of totals information SOURCE | ||
66 | LGPLA2 | LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | * | |
67 | CHARG2 | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
68 | SELML | LQUA1SELML | MENG13 | QUAN | 13 | 3 | Selected quantity in stockkeeping unit | ||
69 | VERML | LQUA1VERML | MENSH | QUAN | 13 | 3 | Available stock in stockkeeping unit | ||
70 | KZNEU | LQUA1KZNEU | XFELD | CHAR | 1 | 0 | Indicator new quant | ||
71 | ZUSTD | DZUSTD | XFELD | CHAR | 1 | 0 | Batch in Restricted-Use Stock | ||
72 | LPTYP | LVS_LPTYP | LVS_LPTYP | CHAR | 2 | 0 | Storage bin type | * | |
73 | SKZUAP | LAGP_SKZUA | XFELD | CHAR | 1 | 0 | Blocking Indicator: For Stock Removals (User) | ||
74 | SKZUEP | LAGP_SKZUE | XFELD | CHAR | 1 | 0 | Blocking indicator: for putaways (user) | ||
75 | SKZSAP | LAGP_SKZSA | XFELD | CHAR | 1 | 0 | Blocking Indicator: Current Stock Removal (System) | ||
76 | SKZSEP | LAGP_SKZSE | XFELD | CHAR | 1 | 0 | Blocking indicator: current stock placement (system) | ||
77 | SKZSIP | LAGP_SKZSI | XFELD | CHAR | 1 | 0 | Blocking indicator: current inventory (system) | ||
78 | SPGRUP | LVS_SPGRU | LVS_SPGRU | CHAR | 1 | 0 | Blocking reason | * | |
79 | LGEWIP | LAGP_LGEWI | DEC8_3 | DEC | 11 | 3 | Load Capacity of Storage Bin | ||
80 | GEWEIP | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
81 | MGEWIP | LAGP_MGEWI | DEC8_3 | DEC | 11 | 3 | Weight of materials in storage bin | ||
82 | RKAPVP | LAGP_RKAPV | LAGP_RKAPV | DEC | 11 | 3 | Available capacity in storage bin | ||
83 | LKAPVP | LAGP_LKAPV | DEC8_3 | DEC | 11 | 3 | Total capacity of storage bin | ||
84 | SKZUAL | LEIN_SKZUA | XFELD | CHAR | 1 | 0 | Blocking Indicator: For Stock Removals (User) | ||
85 | SKZUEL | LEIN_SKZUE | XFELD | CHAR | 1 | 0 | Blocking indicator: for putaways (user) | ||
86 | SPGRUL | LVS_SPGRU | LVS_SPGRU | CHAR | 1 | 0 | Blocking reason | * | |
87 | STATUL | LEIN_STATU | LEIN_STATU | CHAR | 1 | 0 | Status of Storage Unit | ||
88 | WESTAL | LEIN_WESTA | LEIN_WESTA | CHAR | 1 | 0 | Goods Movement Status for Storage Bin |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LQUA_VB | LENUM | LEIN | LENUM | |||
2 | LQUA_VB | LETYP | T307 | LETYP | |||
3 | LQUA_VB | LGNUM | T300 | LGNUM | |||
4 | LQUA_VB | LGORT | T001L | LGORT | |||
5 | LQUA_VB | LGPLA | LAGP | LGPLA | |||
6 | LQUA_VB | LGTYP | T301 | LGTYP | |||
7 | LQUA_VB | MATNR | MARA | MATNR | |||
8 | LQUA_VB | SOBKZ | T148 | SOBKZ | |||
9 | LQUA_VB | SPGRU | T330 | SPGRU | |||
10 | LQUA_VB | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |