- Home
- Resources
- SAP Tables
- U_16028 - Generated Table for View
SAP Table U_16028
Generated Table for View
U_16028 (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link U_16028 to other SAP tables.
Source: U_16028 (Generated Table for View)
U_16028 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| VBELN |
Sales Document |
VBELN_VA |
VBUK
|
CHAR |
|
10 |
0 |
|
| POSNR |
Sales Document Item |
POSNR_VA |
VBUP
|
NUMC |
|
6 |
0 |
|
| ETENR |
Delivery Schedule Line Number |
ETENR |
|
NUMC |
|
4 |
0 |
|
| EDATU |
Schedule line date |
EDATU |
|
DATS |
|
8 |
0 |
|
| EZEIT |
Arrival time |
EZEIT_VBEP |
|
TIMS |
|
6 |
0 |
|
| ETTYP |
Schedule line category |
ETTYP |
TVEP
|
CHAR |
|
2 |
0 |
|
| LFREL |
Item is relevant for delivery |
LFREL |
|
CHAR |
|
1 |
0 |
Possible values
|
| WMENG |
Order quantity in sales units |
WMENG |
|
QUAN |
|
13 |
3 |
|
| BMENG |
Confirmed Quantity |
BMENG |
|
QUAN |
|
13 |
3 |
|
| VRKME |
Sales unit |
VRKME |
T006
|
UNIT |
|
3 |
0 |
|
| LMENG |
Required quantity for mat.management in stockkeeping units |
LMENG |
|
QUAN |
|
13 |
3 |
|
| MEINS |
Base Unit of Measure |
MEINS |
T006
|
UNIT |
|
3 |
0 |
|
| BDDAT |
Requirement date (deadline for procurement) |
BDDAT |
|
DATS |
|
8 |
0 |
|
| BDART |
Requirement type |
BDART |
|
CHAR |
|
2 |
0 |
|
| PLART |
Planning type |
PLART |
|
CHAR |
|
1 |
0 |
|
| RSDAT |
Earliest possible reservation date |
RSDAT |
|
DATS |
|
8 |
0 |
|
| BANFN |
Purchase Requisition Number |
BANFN |
|
CHAR |
|
10 |
0 |
|
| BSART |
Order Type (Purchasing) |
BSART |
T161
|
CHAR |
|
4 |
0 |
|
| BSTYP |
Purchasing Document Category |
BSTYP |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Request for quotation |
| B |
Purchase requisition |
| F |
Purchase order |
| I |
Info record |
| K |
Contract |
| L |
Scheduling agreement |
| Q |
Service entry sheet |
| W |
Source list |
|
| WEPOS |
Confirmation status of schedule line (incl.ALE) |
WEPOS_A |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Schedule line for ALE not relevant |
| A |
Schedule line not yet confirmed by MM |
| C |
Schedule line confirmed by MM |
|
| LRGDT |
Return date for returnable packaging |
LRGDT |
|
DATS |
|
8 |
0 |
|
| PRGRS |
Date type (day, week, month, interval) |
PRGRS |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Day |
| 2 |
Week |
| 3 |
Month |
| 4 |
Posting period |
| 5 |
Planning calendar period |
|
| TDDAT |
Transportation Planning Date |
TDDAT_D |
|
DATS |
|
8 |
0 |
|
| MBDAT |
Material Staging/Availability Date |
MBDAT |
|
DATS |
|
8 |
0 |
|
| LDDAT |
Loading Date |
LDDAT |
|
DATS |
|
8 |
0 |
|
| WADAT |
Goods Issue Date |
WADAT |
|
DATS |
|
8 |
0 |
|
| LIFSP |
Schedule line blocked for delivery |
LIFSP_EP |
TVLS
|
CHAR |
|
2 |
0 |
|
| UMVKZ |
Numerator (factor) for conversion of sales quantity into SKU |
UMVKZ |
|
DEC |
|
5 |
0 |
|
| UMVKN |
Denominator (Divisor) for Conversion of Sales Qty into SKU |
UMVKN |
|
DEC |
|
5 |
0 |
|
| VERFP |
Availability confirmed automatically |
VERFP_MAS |
|
CHAR |
|
1 |
0 |
Possible values
|
| BNFPO |
Item Number of Purchase Requisition |
BNFPO |
EBAN
|
NUMC |
|
5 |
0 |
|
| ETART |
Schedule line type EDI |
EDI_ETTYP |
TVET
|
CHAR |
|
1 |
0 |
|
| AUFNR |
Order Number |
AUFNR |
AUFK
|
CHAR |
|
12 |
0 |
|
| PLNUM |
Planned order number |
PLNUM |
PLAF
|
CHAR |
|
10 |
0 |
|
| SERNR |
BOM explosion number |
SERNR |
SNUM
|
CHAR |
|
8 |
0 |
|
U_16028 foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| U_16028 |
AUFNR |
U_16028 |
AUFNR |
AUFK |
Order master data |
AUFNR |
| U_16028 |
AUFNR |
U_16028 |
MANDT |
AUFK |
Order master data |
MANDT |
| U_16028 |
BNFPO |
U_16028 |
BNFPO |
EBAN |
Purchase Requisition |
BNFPO |
| U_16028 |
BNFPO |
U_16028 |
BANFN |
EBAN |
Purchase Requisition |
BANFN |
| U_16028 |
BNFPO |
U_16028 |
MANDT |
EBAN |
Purchase Requisition |
MANDT |
| U_16028 |
BSART |
U_16028 |
BSART |
T161 |
Purchasing Document Types |
BSART |
| U_16028 |
BSART |
U_16028 |
BSTYP |
T161 |
Purchasing Document Types |
BSTYP |
| U_16028 |
BSART |
U_16028 |
MANDT |
T161 |
Purchasing Document Types |
MANDT |
| U_16028 |
ETART |
U_16028 |
MANDT |
TVET |
Sched.line types for sched.agreements (e.g.backlog, provis.) |
MANDT |
| U_16028 |
ETART |
U_16028 |
ETART |
TVET |
Sched.line types for sched.agreements (e.g.backlog, provis.) |
ETART |
| U_16028 |
ETTYP |
U_16028 |
ETTYP |
TVEP |
Sales Document: Schedule Line Categories |
ETTYP |
| U_16028 |
ETTYP |
U_16028 |
MANDT |
TVEP |
Sales Document: Schedule Line Categories |
MANDT |
| U_16028 |
LIFSP |
U_16028 |
LIFSP |
TVLS |
Deliveries: Blocking Reasons/Criteria |
LIFSP |
| U_16028 |
LIFSP |
U_16028 |
MANDT |
TVLS |
Deliveries: Blocking Reasons/Criteria |
MANDT |
| U_16028 |
MANDT |
U_16028 |
MANDT |
T000 |
Clients |
MANDT |
| U_16028 |
MEINS |
U_16028 |
MANDT |
T006 |
Units of Measurement |
MANDT |
| U_16028 |
MEINS |
U_16028 |
MEINS |
T006 |
Units of Measurement |
MSEHI |
| U_16028 |
PLNUM |
U_16028 |
PLNUM |
PLAF |
Planned Order |
PLNUM |
| U_16028 |
PLNUM |
U_16028 |
MANDT |
PLAF |
Planned Order |
MANDT |
| U_16028 |
POSNR |
U_16028 |
POSNR |
VBUP |
Sales Document: Item Status |
POSNR |
| U_16028 |
POSNR |
U_16028 |
VBELN |
VBUP |
Sales Document: Item Status |
VBELN |
| U_16028 |
POSNR |
U_16028 |
MANDT |
VBUP |
Sales Document: Item Status |
MANDT |
| U_16028 |
SERNR |
U_16028 |
SERNR |
SNUM |
BOM explosion number |
SERNR |
| U_16028 |
SERNR |
U_16028 |
MANDT |
SNUM |
BOM explosion number |
MANDT |
| U_16028 |
VBELN |
U_16028 |
MANDT |
VBUK |
Sales Document: Header Status and Administrative Data |
MANDT |
| U_16028 |
VBELN |
U_16028 |
VBELN |
VBUK |
Sales Document: Header Status and Administrative Data |
VBELN |
| U_16028 |
VRKME |
U_16028 |
MANDT |
T006 |
Units of Measurement |
MANDT |
| U_16028 |
VRKME |
U_16028 |
VRKME |
T006 |
Units of Measurement |
MSEHI |
