SAP ABAP Table U_16810 (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | U_16810 |
|
| Short Description | Generated Table for View |
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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
ABELN | ABELN | CHAR | 10 | 0 | Allocation Table Number | AUKO | |
| 3 | |
ABELP | ABELP | NUMC | 5 | 0 | Item number of allocation table | AUPO | |
| 4 | |
ABELG | ABELG | NUMC | 5 | 0 | Sub-item no. of plant group (alloc tbl) | AUFG | |
| 5 | |
ABELF | ABELF | NUMC | 5 | 0 | Sub.item no. of plant (alloc. tbl) | ||
| 6 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
| 7 | |
FIWRK | WERKS | CHAR | 4 | 0 | Store as plant | T001W | |
| 8 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 9 | |
EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
| 10 | |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 11 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 12 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 13 | |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
| 14 | |
LFNRU | LIFNR | CHAR | 10 | 0 | Account no. of vendor / creditor of sub-item | LFA1 | |
| 15 | |
PMNGU | MENG13 | QUAN | 13 | 3 | Planned qty of sub-item | ||
| 16 | |
IMNGU | MENG13 | QUAN | 13 | 3 | Confirmed qty of plant | ||
| 17 | |
MMNGU | MENG13 | QUAN | 13 | 3 | Minimum Quantity of Plant in Plant Group | ||
| 18 | |
WMNGE | MENG13 | QUAN | 13 | 3 | Quantity requested by store | ||
| 19 | |
AUFME | MEINS | UNIT | 3 | 0 | Allocation Unit | T006 | |
| 20 | |
LIEFW | CHAR1 | CHAR | 1 | 0 | Flag: delivery phase exists | ||
| 21 | |
EBLNU | EBELN | CHAR | 10 | 0 | Purchase Order Generated for Vendor | ||
| 22 | |
EBLPU | EBELP | NUMC | 5 | 0 | Generated purchase order item | ||
| 23 | |
UBSTN | EBELN | CHAR | 10 | 0 | Generated warehouse order | ||
| 24 | |
UBSTP | EBELP | NUMC | 5 | 0 | Generated stock transport order item | ||
| 25 | |
VBLNU | VBELN | CHAR | 10 | 0 | Generated delivery number | ||
| 26 | |
VBLPU | POSNR | NUMC | 6 | 0 | Generated delivery note item | ||
| 27 | |
BEDAT | DATUM | DATS | 8 | 0 | Purchase Order Date | ||
| 28 | |
PRGRS | PRGRS | CHAR | 1 | 0 | Date type (day, week, month, interval) | ||
| 29 | |
VKIDT | DATUM | DATS | 8 | 0 | Date of start of sales at plant | ||
| 30 | |
PRGRS | PRGRS | CHAR | 1 | 0 | Date type (day, week, month, interval) | ||
| 31 | |
LEWED | DATUM | DATS | 8 | 0 | Latest Possible Goods Receipt | ||
| 32 | |
VZENT | KUNNR | CHAR | 10 | 0 | Distribution center (as customer) | KNA1 | |
| 33 | |
VZWRK | WERKS | CHAR | 4 | 0 | Distribution center as plant | T001W | |
| 34 | |
LIFNR_WK | LIFNR | CHAR | 10 | 0 | Vendor number of plant | LFA1 | |
| 35 | |
AAVIT | AAVIT | CHAR | 4 | 0 | Notification Category Allocation: Info Exchance HQ - Plant | T626 | |
| 36 | |
PLIFZ | DEC3 | DEC | 3 | 0 | Planned delivery time in days | ||
| 37 | |
WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
| 38 | |
AFIDT | DATUM | DATS | 8 | 0 | Confirmation request date | ||
| 39 | |
PRGRS | PRGRS | CHAR | 1 | 0 | Date type (day, week, month, interval) | ||
| 40 | |
PSTAB | PSTAK | CHAR | 1 | 0 | Maint. status of plant | ||
| 41 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | ||
| 42 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | ||
| 43 | |
SPART | SPART | CHAR | 2 | 0 | Division | ||
| 44 | |
BSTMG | MENG13 | QUAN | 13 | 3 | Purchase Order Quantity | ||
| 45 | |
BSTME | MEINS | UNIT | 3 | 0 | Order unit | T006 | |
| 46 | |
BSTMG | MENG13 | QUAN | 13 | 3 | Purchase Order Quantity | ||
| 47 | |
BSTME | MEINS | UNIT | 3 | 0 | Order unit | T006 | |
| 48 | |
EFMNG | MENG13 | QUAN | 13 | 3 | GR qty assigned after alloc tbl adjustment made | ||
| 49 | |
VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
| 50 | |
SPBTR | SPERR_A | CHAR | 1 | 0 | Blocking flag, plant | T629 | |
| 51 | |
VQUOT | VQUOT | NUMC | 13 | 0 | Quotas (Base for qty calculation) | ||
| 52 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 53 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 54 | |
VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | TVST | |
| 55 | |
LPRIO | LPRIO | NUMC | 2 | 0 | Delivery priority | TPRIO | |
| 56 | |
ROUTE | ROUTE | CHAR | 6 | 0 | Route | TVRO | |
| 57 | |
FILNR | KUNNR | CHAR | 10 | 0 | Customer no. of plant | ||
| 58 | |
KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | ||
| 59 | |
SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | LFA1 | |
| 60 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 61 | |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | U_16810 | AAVIT | |
|
|||
| 2 | U_16810 | ABELG | |
|
KEY | 1 | CN |
| 3 | U_16810 | ABELN | |
|
KEY | 1 | N |
| 4 | U_16810 | ABELP | |
|
KEY | 1 | CN |
| 5 | U_16810 | AUFME | |
|
REF | 1 | N |
| 6 | U_16810 | BSTME | |
|
REF | 1 | CN |
| 7 | U_16810 | EKGRP | |
|
|||
| 8 | U_16810 | EKORG | |
|
|||
| 9 | U_16810 | FILNR | |
|
REF | 1 | N |
| 10 | U_16810 | FIWRK | |
|
KEY | 1 | CN |
| 11 | U_16810 | LFNRU | |
|
REF | C | N |
| 12 | U_16810 | LPRIO | |
|
KEY | 1 | CN |
| 13 | U_16810 | MANDT | |
|
KEY | 1 | N |
| 14 | U_16810 | ROUTE | |
|
KEY | 1 | CN |
| 15 | U_16810 | SPDNR | |
|
KEY | 1 | CN |
| 16 | U_16810 | SPERR | |
|
REF | 1 | CN |
| 17 | U_16810 | UMLME | |
|
REF | 1 | CN |
| 18 | U_16810 | VRKME | |
|
REF | 1 | CN |
| 19 | U_16810 | VSTEL | |
|
KEY | 1 | CN |
| 20 | U_16810 | VZENT | |
|
|||
| 21 | U_16810 | VZLFR | |
|
REF | 1 | CN |
| 22 | U_16810 | VZWRK | |
|
|||
| 23 | U_16810 | WERKS | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |