SAP Table CMP_VBRP

Extract from VBRP, Relevant Fields for Complaints Processing

CMP_VBRP (Extract from VBRP, Relevant Fields for Complaints Processing) 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 CMP_VBRP to other SAP tables.

CMP_VBRP table fields

Field Data element Checktable Datatype Length Decimals
VBELN Billing Document VBELN_VF VBUK CHAR 10 0
POSNR Billing item POSNR_VF VBUP NUMC 6 0
UEPOS Higher-level item in bill of material structures UEPOS VBUP NUMC 6 0
FKIMG Actual Invoiced Quantity FKIMG QUAN 13 3
VRKME Sales Unit CMP_VRKME T006 UNIT 3 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
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MATNR Material Number MATNR CHAR 18 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
MATKL Material Group MATKL T023 CHAR 9 0
PSTYV Sales document item category PSTYV CHAR 4 0
POSAR Item type POSAR CHAR 1 0
NULL 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 PRODH_D T179 CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
NTGEW Net weight NTGEW_15 QUAN 15 3
BRGEW Gross weight BRGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
NETWR Net value of the billing item in document currency NETWR_FP CURR 15 2
VBELV Originating document VBELV VBUK CHAR 10 0
POSNV Originating item POSNV VBUP NUMC 6 0
VGBEL Document number of the reference document VGBEL VBUK CHAR 10 0
VGPOS Item number of the reference item VGPOS VBUP NUMC 6 0
VGTYP Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
AUBEL Sales Document VBELN_VA VBUK CHAR 10 0
AUPOS Sales Document Item POSNR_VA VBUP NUMC 6 0
AUREF Sales document was created from reference AUREF CHAR 1 0
X Yes
NULL No
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
LGORT Storage Location LGORT_D T001L CHAR 4 0
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
MATWA Material entered MATWA CHAR 18 0
FKLMG Billing quantity in stockkeeping unit FKLMG QUAN 13 3
SPART Division SPART CHAR 2 0
COMPREAS Abbreviation for Complaints Reason CMP_COMPREAS CHAR 4 0
WAERK SD Document Currency WAERK CUKY 5 0

CMP_VBRP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CMP_VBRP AUBEL SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CMP_VBRP AUBEL CMP_VBRP AUBEL VBUK Sales Document: Header Status and Administrative Data VBELN
CMP_VBRP AUPOS CMP_VBRP AUBEL VBUP Sales Document: Item Status VBELN
CMP_VBRP AUPOS CMP_VBRP AUPOS VBUP Sales Document: Item Status POSNR
CMP_VBRP AUPOS SYST MANDT VBUP Sales Document: Item Status MANDT
CMP_VBRP GEWEI SYST MANDT T006 Units of Measurement MANDT
CMP_VBRP GEWEI CMP_VBRP GEWEI T006 Units of Measurement MSEHI
CMP_VBRP LGORT SYST MANDT T001L Storage Locations MANDT
CMP_VBRP LGORT CMP_VBRP WERKS T001L Storage Locations WERKS
CMP_VBRP LGORT CMP_VBRP LGORT T001L Storage Locations LGORT
CMP_VBRP MATKL SYST MANDT T023 Material Groups MANDT
CMP_VBRP MATKL CMP_VBRP MATKL T023 Material Groups MATKL
CMP_VBRP MEINS SYST MANDT T006 Units of Measurement MANDT
CMP_VBRP MEINS CMP_VBRP MEINS T006 Units of Measurement MSEHI
CMP_VBRP POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
CMP_VBRP POSNR CMP_VBRP VBELN VBUP Sales Document: Item Status VBELN
CMP_VBRP POSNR CMP_VBRP POSNR VBUP Sales Document: Item Status POSNR
CMP_VBRP POSNV SYST MANDT VBUP Sales Document: Item Status MANDT
CMP_VBRP POSNV CMP_VBRP VBELV VBUP Sales Document: Item Status VBELN
CMP_VBRP POSNV CMP_VBRP POSNV VBUP Sales Document: Item Status POSNR
CMP_VBRP PRODH SYST MANDT T179 Materials: Product Hierarchies MANDT
CMP_VBRP PRODH CMP_VBRP PRODH T179 Materials: Product Hierarchies PRODH
CMP_VBRP UEPOS CMP_VBRP UEPOS VBUP Sales Document: Item Status POSNR
CMP_VBRP UEPOS SYST MANDT VBUP Sales Document: Item Status MANDT
CMP_VBRP UEPOS CMP_VBRP VBELN VBUP Sales Document: Item Status VBELN
CMP_VBRP VBELN CMP_VBRP VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
CMP_VBRP VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CMP_VBRP VBELV SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CMP_VBRP VBELV CMP_VBRP VBELV VBUK Sales Document: Header Status and Administrative Data VBELN
CMP_VBRP VGBEL SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CMP_VBRP VGBEL CMP_VBRP VGBEL VBUK Sales Document: Header Status and Administrative Data VBELN
CMP_VBRP VGPOS SYST MANDT VBUP Sales Document: Item Status MANDT
CMP_VBRP VGPOS CMP_VBRP VGBEL VBUP Sales Document: Item Status VBELN
CMP_VBRP VGPOS CMP_VBRP VGPOS VBUP Sales Document: Item Status POSNR
CMP_VBRP VOLEH CMP_VBRP VOLEH T006 Units of Measurement MSEHI
CMP_VBRP VOLEH SYST MANDT T006 Units of Measurement MANDT
CMP_VBRP VRKME SYST MANDT T006 Units of Measurement MANDT
CMP_VBRP VRKME CMP_VBRP VRKME T006 Units of Measurement MSEHI
CMP_VBRP WERKS CMP_VBRP WERKS T001W Plants/Branches WERKS
CMP_VBRP WERKS SYST MANDT T001W Plants/Branches MANDT