SAP table U_16028 (Generated Table for View)

SAP table U_16028 has 4 primary key fields being MANDT,VBELN,POSNR,ETENR.

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 T000 MANDT
VBELN Sales Document CHAR 10 0 VBELN_VA
POSNR Sales Document Item NUMC 6 0 POSNR_VA
ETENR Schedule Line Number NUMC 4 0 ETENR
EDATU Schedule line date DATS 8 0 EDATU
EZEIT Arrival time TIMS 6 0 EZEIT_VBEP
ETTYP Schedule line category CHAR 2 0 TVEP ETTYP
LFREL Item is relevant for delivery CHAR 1 0 LFREL
WMENG Order Quantity in Sales Units QUAN 13 3 WMENG
BMENG Confirmed Quantity QUAN 13 3 BMENG
VRKME Sales unit UNIT 3 0 T006 VRKME
LMENG Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
BDDAT Requirement date (deadline for procurement) DATS 8 0 BDDAT
BDART Requirement type CHAR 2 0 BDART
PLART Planning type CHAR 1 0 PLART
RSDAT Earliest possible reservation date DATS 8 0 RSDAT
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BSART Order Type (Purchasing) CHAR 4 0 T161 BSART
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
WEPOS Confirmation status of schedule line (incl.ALE) CHAR 1 0 WEPOS_A
LRGDT Return date for returnable packaging DATS 8 0 LRGDT
PRGRS Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
TDDAT Transportation Planning Date DATS 8 0 TDDAT_D
MBDAT Material Staging/Availability Date DATS 8 0 MBDAT
LDDAT Loading Date DATS 8 0 LDDAT
WADAT Goods Issue Date DATS 8 0 WADAT
LIFSP Schedule Line Blocked for Delivery CHAR 2 0 TVLS LIFSP_EP
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
VERFP Availability confirmed automatically CHAR 1 0 VERFP_MAS
BNFPO Item number of purchase requisition NUMC 5 0 EBAN BNFPO
ETART Schedule line type EDI CHAR 1 0 TVET EDI_ETTYP
AUFNR Order Number CHAR 12 0 AUFK AUFNR
PLNUM Planned Order CHAR 10 0 PLAF PLNUM
SERNR BOM explosion number CHAR 8 0 SNUM SERNR

U_16028 foreign key relationships

Table Field Check Table Check Field
0 U_16028 AUFNR AUFK Order master data AUFNR
1 U_16028 BNFPO EBAN Purchase Requisition BANFN
1 U_16028 BNFPO EBAN Purchase Requisition BNFPO
0 U_16028 BSART T161 Purchasing Document Types MANDT
1 U_16028 ETART TVET Sched.line types for sched.agreements (e.g.backlog, provis.) MANDT
0 U_16028 ETTYP TVEP Sales Document: Schedule Line Categories ETTYP
1 U_16028 LIFSP TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 U_16028 LIFSP TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 U_16028 MANDT T000 Clients MANDT
1 U_16028 MEINS T006 Units of Measurement MANDT
1 U_16028 MEINS T006 Units of Measurement MSEHI
0 U_16028 PLNUM PLAF Planned Order MANDT
1 U_16028 SERNR SNUM BOM explosion number MANDT
0 U_16028 VRKME T006 Units of Measurement MANDT
0 U_16028 VRKME T006 Units of Measurement MSEHI