SAP ABAP View U_16054 (Customer Complaint Order Item)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   CA (Application Component) Cross-Application Components
     UUDM (Package) EDM: Data Modeler (General)
Basic Data
View Type D Database View 
Database View U_16054  
Short Description Customer Complaint Order Item    
Root table VBAP   Sales Document: Item Data 
Entity TypeDM02L 
Short text Customer complaint order item
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VBAP VBAP
2 VBUP  
3 VBKD  
4 VBUK  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VBUP MANDT JL EQ 0 0
2 VBAP MANDT JR EQ AND 0 0
3 VBUP VBELN JL EQ 0 0
4 VBAP VBELN JR EQ AND 0 0
5 VBUP POSNR JL EQ 0 0
6 VBAP POSNR JR EQ AND 0 0
7 VBUP MANDT JL EQ 0 0
8 VBKD MANDT JR EQ AND 0 0
9 VBUP VBELN JL EQ 0 0
10 VBKD VBELN JR EQ AND 0 0
11 VBUP POSNR JL EQ 0 0
12 VBKD POSNR JR EQ AND 0 0
13 VBUK MANDT JL EQ 0 0
14 VBKD MANDT JR EQ AND 0 0
15 VBUK VBELN JL EQ 0 0
16 VBKD VBELN JR EQ AND 0 0
17 VBUK VBTYP EQ 'H' OR 0 0
18 VBUK VBTYP EQ 'I' OR 0 0
19 VBUK VBTYP EQ 'K' OR 0 0
20 VBUK VBTYP EQ 'L' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VBAP MANDT   MANDT Client
2 VBELN VBAP VBELN   VBELN_VA Sales Document
3 POSNR VBAP POSNR   POSNR_VA Sales Document Item
4 MATNR VBAP MATNR   MATNR Material Number
5 SPART VBAP SPART   SPART Division
6 WERKS VBAP WERKS   WERKS_EXT Plant (Own or External)
7 LGORT VBAP LGORT   LGORT_D Storage location
8 VSTEL VBAP VSTEL   VSTEL Shipping Point/Receiving Point
9 ROUTE VBAP ROUTE   ROUTE Route
10 MATWA VBAP MATWA   MATWA Material entered
11 PMATN VBAP PMATN   PMATN Pricing Reference Material
12 CHARG VBAP CHARG   CHARG_D Batch Number
13 MATKL VBAP MATKL   MATKL Material Group
14 ARKTX VBAP ARKTX   ARKTX Short text for sales order item
15 PSTYV VBAP PSTYV   PSTYV Sales document item category
16 POSAR VBAP POSAR   POSAR Item type
17 LFREL VBAP LFREL   LFREL_AP Item is relevant for delivery
18 FKREL VBAP FKREL   FKREL Relevant for Billing
19 GRPOS VBAP GRPOS   GRPOS Item for which this item is an alternative
20 PRODH VBAP PRODH   PRODH_D Product Hierarchy
21 ZMENG VBAP ZMENG   DZMENG Target quantity in sales units
22 ZIEME VBAP ZIEME   DZIEME Target quantity UoM
23 UMZIZ VBAP UMZIZ   UMZIZ Factor for converting sales units to base units (target qty)
24 UMZIN VBAP UMZIN   UMZIN Factor for converting sales units to base units (target qty)
25 MEINS VBAP MEINS   MEINS Base Unit of Measure
26 SMENG VBAP SMENG   SMENG Scale quantity in base unit of measure
27 ABLFZ VBAP ABLFZ   ABLFZ Rounding quantity for delivery
28 POSEX VBAP POSEX   POSEX Item Number of the Underlying Purchase Order
29 KDMAT VBAP KDMAT   MATNR_KU Customer Material Number
30 GRKOR VBAP GRKOR   GRKOR Delivery group (items are delivered together)
31 FMENG VBAP FMENG   FMENG Quantity is fixed
32 UEBTK VBAP UEBTK   UEBTK_V Unlimited overdelivery allowed
33 UEBTO VBAP UEBTO   UEBTO Overdelivery Tolerance Limit
34 UNTTO VBAP UNTTO   UNTTO Underdelivery Tolerance Limit
35 FAKSP VBAP FAKSP   FAKSP_AP Billing block for item
36 ATPKZ VBAP ATPKZ   ATPKZ Replacement part
37 GSBER VBAP GSBER   GSBER Business Area
38 NETWR VBAP NETWR   NETWR_AP Net value of the order item in document currency
39 WAERK VBAP WAERK   WAERK SD document currency
40 ANTLF VBAP ANTLF   ANTLF Maximum number of partial deliveries allowed per item
41 KZTLF VBAP KZTLF   KZTLF Partial delivery at item level
42 CHSPL VBAP CHSPL   CHSPL Batch split allowed
43 KWMENG VBAP KWMENG   KWMENG Cumulative order quantity in sales units
44 LSMENG VBAP LSMENG   LSMENG Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
45 KBMENG VBAP KBMENG   KBMENG Cumulative confirmed quantity in sales unit
46 KLMENG VBAP KLMENG   KLMENG Cumulative Confirmed Quantity in Base Unit of Measure
47 VRKME VBAP VRKME   VRKME Sales unit
48 UMVKZ VBAP UMVKZ   UMVKZ Numerator (factor) for conversion of sales quantity into SKU
49 UMVKN VBAP UMVKN   UMVKN Denominator (divisor) for conversion of sales qty. into SKU
50 BRGEW VBAP BRGEW   BRGEW_AP Gross weight of item
51 NTGEW VBAP NTGEW   NTGEW_AP Net weight of item
52 GEWEI VBAP GEWEI   GEWEI Weight Unit
53 VOLUM VBAP VOLUM   VOLUM_AP Volume of the item
54 VOLEH VBAP VOLEH   VOLEH Volume unit
55 VGBEL VBAP VGBEL   VGBEL Document number of the reference document
56 VGPOS VBAP VGPOS   VGPOS Item number of the reference item
57 VOREF VBAP VOREF   VOREF Complete reference indicator
58 UPFLU VBAP UPFLU   UPFLV Update indicator for sales document document flow
59 LPRIO VBAP LPRIO   LPRIO Delivery priority
60 STKEY VBAP STKEY   STKEY Origin of the bill of material
61 STDAT VBAP STDAT   STDAT Date of Bill of Material
62 STLNR VBAP STLNR   STNUM Bill of Material
63 ERDAT VBAP ERDAT   ERDAT Date on which the record was created
64 ERNAM VBAP ERNAM   ERNAM Name of Person who Created the Object
65 ERZET VBAP ERZET   ERZET Entry time
66 TAXM1 VBAP TAXM1   TAXMT Tax classification material
67 TAXM2 VBAP TAXM2   TAXMT Tax classification material
68 TAXM3 VBAP TAXM3   TAXMT Tax classification material
69 TAXM4 VBAP TAXM4   TAXMT Tax classification material
70 TAXM5 VBAP TAXM5   TAXMT Tax classification material
71 TAXM6 VBAP TAXM6   TAXMT Tax classification material
72 TAXM7 VBAP TAXM7   TAXMT Tax classification material
73 TAXM8 VBAP TAXM8   TAXMT Tax classification material
74 TAXM9 VBAP TAXM9   TAXMT Tax classification material
75 VBEAF VBAP VBEAF   VBEAF Fixed shipping processing time in days (= setup time)
76 VBEAV VBAP VBEAV   VBEAV Variable shipping processing time in days
77 VGREF VBAP VGREF   VGREF Preceding document has resulted from reference
78 NETPR VBAP NETPR   NETPR Net price
79 KPEIN VBAP KPEIN   KPEIN Condition pricing unit
80 KMEIN VBAP KMEIN   KMEIN Condition Unit
81 SHKZG VBAP SHKZG   SHKZG_VA Returns Item
82 SKTOF VBAP SKTOF   SKTOF Cash discount indicator
83 MTVFP VBAP MTVFP   MTVFP Checking Group for Availability Check
84 SUMBD VBAP SUMBD   SUMBD Summing up of requirements
85 KONDM VBAP KONDM   KONDM Material Pricing Group
86 KTGRM VBAP KTGRM   KTGRM Account assignment group for this material
87 BONUS VBAP BONUS   BONUS Volume rebate group
88 PROVG VBAP PROVG   PROVG Commission group
89 PRSOK VBAP PRSOK   PRSOK Pricing is OK
90 BWTAR VBAP BWTAR   BWTAR_D Valuation type
91 BWTEX VBAP BWTEX   BWTEX Indicator: Separate valuation
92 XCHPF VBAP XCHPF   XCHPF Batch management requirement indicator
93 XCHAR VBAP XCHAR   XCHAR Batch management indicator (internal)
94 LFMNG VBAP LFMNG   MINLF Minimum delivery quantity in delivery note processing
95 STAFO VBAP STAFO   STAFO Update group for statistics update
96 WAVWR VBAP WAVWR   WAVWR Cost in document currency
97 KZWI1 VBAP KZWI1   KZWI1 Subtotal 1 from pricing procedure for condition
98 KZWI2 VBAP KZWI2   KZWI2 Subtotal 2 from pricing procedure for condition
99 KZWI3 VBAP KZWI3   KZWI3 Subtotal 3 from pricing procedure for condition
100 KZWI4 VBAP KZWI4   KZWI4 Subtotal 4 from pricing procedure for condition
101 KZWI5 VBAP KZWI5   KZWI5 Subtotal 5 from pricing procedure for condition
102 KZWI6 VBAP KZWI6   KZWI6 Subtotal 6 from pricing procedure for condition
103 STCUR VBAP STCUR   STCUR_AP Exchange rate for statistics (Exch.rate at time of creation)
104 AEDAT VBAP AEDAT   AEDAT Last Changed On
105 EAN11 VBAP EAN11   EAN11 International Article Number (EAN/UPC)
106 FIXMG VBAP FIXMG   FIXMG Delivery date and quantity fixed
107 PRCTR VBAP PRCTR   PRCTR Profit Center
108 MVGR1 VBAP MVGR1   MVGR1 Material group 1
109 MVGR2 VBAP MVGR2   MVGR2 Material group 2
110 MVGR3 VBAP MVGR3   MVGR3 Material group 3
111 MVGR4 VBAP MVGR4   MVGR4 Material group 4
112 MVGR5 VBAP MVGR5   MVGR5 Material group 5
113 KMPMG VBAP KMPMG   KMPMG Component Quantity
114 SUGRD VBAP SUGRD   SUGRD Reason for material substitution
115 SOBKZ VBAP SOBKZ   SOBKZ Special Stock Indicator
116 VPZUO VBAP VPZUO   VPZUO Allocation Indicator
117 PAOBJNR VBAP PAOBJNR   RKEOBJNR Profitability Segment Number (CO-PA)
118 PS_PSP_PNR VBAP PS_PSP_PNR   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
119 AUFNR VBAP AUFNR   AUFNR Order Number
120 SERNR VBAP SERNR   SERNR BOM explosion number
121 OBJNR VBAP OBJNR   OBJPO Object number at item level
122 ABGRS VBAP ABGRS   ABGR_SCHL Results Analysis Key
123 BEDAE VBAP BEDAE   BEDAE Requirements type
124 CMPRE VBAP CMPRE   CMPRE Item credit price
125 CMTFG VBAP CMTFG   CMTFG ID for partial release of order item, credit block
126 CMPNT VBAP CMPNT   CMPNT ID: Item with active credit function / relevant for credit
127 CMKUA VBAP CMKUA   CMKUA Credit data exchange rate for requested delivery date
128 CUOBJ VBAP CUOBJ   CUOBJ_VA Configuration
129 CUOBJ_CH VBAP CUOBJ_CH   CUOBJ_CH Internal object number of the batch classification
130 CEPOK VBAP CEPOK   CEPOK Status expected price
131 KOUPD VBAP KOUPD   KOUPD Condition update
132 SERAIL VBAP SERAIL   SERAIL Serial Number Profile
133 ANZSN VBAP ANZSN   ANZSN Number of serial numbers
134 NACHL VBAP NACHL   NACHL Customer has not posted goods receipt
135 MAGRV VBAP MAGRV   MAGRV Material Group: Packaging Materials
136 MPROK VBAP MPROK   MPROK Status manual price change
137 VGTYP VBAP VGTYP   VBTYP_V Document category of preceding SD document
138 PROSA VBAP PROSA   PROSA ID for material selection - active
139 UEPVW VBAP UEPVW   UEPVW ID for higher-level item usage
140 KALNR VBAP KALNR   CK_KALNR Cost Estimate Number for Cost Est. w/o Qty Structure
141 KLVAR VBAP KLVAR   CK_KLVAR Costing Variant
142 SPOSN VBAP SPOSN   SPOSN BOM Item Number
143 KOWRR VBAP KOWRR   KOWRR Statistical values
144 STADAT VBAP STADAT   STADAT Statistics date
145 EXART VBAP EXART   EXART Business Transaction Type for Foreign Trade
146 PREFE VBAP PREFE   PREFE Preference indicator in export/import
147 KNUMH VBAP KNUMH   KNUMH_CH Number of condition record from batch determination
148 CLINT VBAP CLINT   CLINT Internal Class Number
149 CHMVS VBAP CHMVS   CHMVS Batches: Exit to quantity proposal
150 STLTY VBAP STLTY   STLTY BOM Category
151 STLKN VBAP STLKN   STLKN BOM Item Node Number
152 STPOZ VBAP STPOZ   CIM_COUNT Internal counter
153 STMAN VBAP STMAN   CUINK Inconsistent configuration
154 ZSCHL_K VBAP ZSCHL_K   AUFZSCHL Overhead key
155 KALSM_K VBAP KALSM_K   AUFKALSM Costing Sheet
156 KALVAR VBAP KALVAR   CK_KLVAR Costing Variant
157 KONDA VBKD KONDA   KONDA Price Group (Customer)
158 KDGRP VBKD KDGRP   KDGRP Customer group
159 BZIRK VBKD BZIRK   BZIRK Sales district
160 PLTYP VBKD PLTYP   PLTYP Price list type
161 INCO1 VBKD INCO1   INCO1 Incoterms (part 1)
162 INCO2 VBKD INCO2   INCO2 Incoterms (part 2)
163 KZAZU VBKD KZAZU   KZAZU_D Order combination indicator
164 PERFK VBKD PERFK   PERFK Invoice dates (calendar identification)
165 PERRL VBKD PERRL   PERRL Invoice list schedule (calendar identification)
166 MRNKZ VBKD MRNKZ   MRNKZ Manual invoice maintenance
167 KURRF VBKD KURRF   KURRF Exchange rate for FI postings
168 VALTG VBKD VALTG   VALTG Additional value days
169 VALDT VBKD VALDT   VALDT Fixed value date
170 ZTERM VBKD ZTERM   DZTERM Terms of payment key
171 ZLSCH VBKD ZLSCH   SCHZW_BSEG Payment Method
172 KTGRD VBKD KTGRD   KTGRD Account assignment group for this customer
173 KURSK VBKD KURSK   KURSK Exchange Rate for Pricing and Statistics
174 PRSDT VBKD PRSDT   PRSDT Date for pricing and exchange rate
175 FKDAT VBKD FKDAT   FKDAT Billing date for billing index and printout
176 FBUDA VBKD FBUDA   FBUDA Date When Services Rendered
177 GJAHR VBKD GJAHR   GJAHR Fiscal Year
178 POPER VBKD POPER   POPER Posting period
179 MSCHL VBKD MSCHL   MSCHL Dunning key
180 MANSP VBKD MANSP   MANSP Dunning block
181 FPLNR VBKD FPLNR   FPLNR Billing plan number / invoicing plan number
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20140121 
SAP Release Created in