SAP table CMP_VBRP (Extract from VBRP, Relevant Fields for Complaints Processing)

Field Description Data Type Length Decimals Checktable Data Element
VBELN Billing Document CHAR 10 0 VBELN_VF
POSNR Billing Item NUMC 6 0 POSNR_VF
UEPOS Higher-Level Item in Bill of Material Structures NUMC 6 0 UEPOS
FKIMG Actual billed quantity QUAN 13 3 FKIMG
VRKME Sales Unit UNIT 3 0 T006 CMP_VRKME
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
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MATNR Material Number CHAR 40 0 MATNR
ARKTX Short text for sales order item CHAR 40 0 ARKTX
MATKL Material Group CHAR 9 0 T023 MATKL
PSTYV Sales document item category CHAR 4 0 PSTYV
POSAR Item Type CHAR 1 0 POSAR
Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
PRODH Product hierarchy CHAR 18 0 T179 PRODH_D
WERKS Plant CHAR 4 0 T001W WERKS_D
NTGEW Net weight QUAN 15 3 NTGEW_15
BRGEW Gross weight QUAN 15 3 BRGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 VOLEH
NETWR Net Value of Billing item in Document Currency CURR 15 2 NETWR_FP
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VGTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
AUBEL Sales Document CHAR 10 0 VBELN_VA
AUPOS Sales Document Item NUMC 6 0 POSNR_VA
AUREF Sales document was created from reference CHAR 1 0 AUREF
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
LGORT Storage location CHAR 4 0 T001L LGORT_D
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
MATWA Material Entered CHAR 40 0 MATWA
FKLMG Billing quantity in stock keeping unit QUAN 13 3 FKLMG
SPART Division CHAR 2 0 SPART
COMPREAS Abbreviation for Complaints Reason CHAR 4 0 CMP_COMPREAS
WAERK SD Document Currency CUKY 5 0 WAERK

CMP_VBRP foreign key relationships

Table Field Check Table Check Field
0 CMP_VBRP GEWEI T006 Units of Measurement MANDT
0 CMP_VBRP GEWEI T006 Units of Measurement MSEHI
1 CMP_VBRP LGORT T001L Storage Locations MANDT
1 CMP_VBRP LGORT T001L Storage Locations WERKS
0 CMP_VBRP MATKL T023 Material Groups MATKL
1 CMP_VBRP MEINS T006 Units of Measurement MANDT
1 CMP_VBRP MEINS T006 Units of Measurement MSEHI
0 CMP_VBRP PRODH T179 Materials: Product Hierarchies PRODH
1 CMP_VBRP VOLEH T006 Units of Measurement MANDT
1 CMP_VBRP VOLEH T006 Units of Measurement MSEHI
0 CMP_VBRP VRKME T006 Units of Measurement MANDT
0 CMP_VBRP VRKME T006 Units of Measurement MSEHI
1 CMP_VBRP WERKS T001W Plants/Branches MANDT
1 CMP_VBRP WERKS T001W Plants/Branches WERKS