queryviz
tables/relationship path
open in builder
T002
SPRAS
CEPC
PRCTR
MARC
MATNR
MARA
MATNR
VBAP

VBAP

sales document: item data
sd25f · 2k · 9r
Unchanged in S/4
No structural change in S/4HANA. VBAP remains the sales order item table.
key differences:
  • •Table structure unchanged in S/4HANA
  • •Some fields deprecated but table remains primary sales item

fields (25)

fieldtypelengthkeydescription
POSNRnumc6pksales document item number (e.g., 000010, 000020)
VBELNchar10pksales document number
ABGRUchar2reason for rejection (e.g., 01=customer request, 02=price)
ARKTXchar40short text for sales order item (can differ from material description)
KDMATchar35customer material number
KMEINunit3condition unit in pricing
KNUMVchar10condition record number for item (links to konv for item conditions)
KPEINdec5condition pricing unit
KWMENGquan15cumulative order quantity in sales unit
LGORTchar4storage location
MATNRchar18material number
MTVFPchar2checking rule for availability check
MVGR1char3material group 1 (pricing/statistics group)
NETPRcurr15net price (per pricing unit)
NETWRcurr15net value of the order item in document currency
PSTYVchar4sales document item category (tan=standard, tann=free-of-charge, etc.)
ROUTEchar6route for shipping
SHKZGchar1returns item flag (x=returns item)
SPARTchar2division for item
UEPOSnumc6higher-level item in bill of material structures
VKORGchar4sales organization
VRKMEunit3sales unit of measure
VTWEGchar2distribution channel
WAERKcuky5document currency
WERKSchar4plant (delivering plant)

relationships (9)

master lookup

reference to master data

references
MARA
MATNRMATNR
N:1
referenced by
LIPS
VBELNVGBEL
POSNRVGPOS
N:1
MVKE
MATNRMATNR
VKORGVKORG
VTWEGVTWEG
1:N
header / item

parent-child document structure

references
VBUP
VBELNVBELN
POSNRPOSNR
1:1
VBAK
VBELNVBELN
N:1
VBEP
VBELNVBELN
POSNRPOSNR
1:N
referenced by
VBAK
VBELNVBELN
1:N
history

historical/audit records

references
VBFA
VBELNVBELV
POSNRPOSNV
1:N
configuration

reference to config tables

references
T001W
WERKSWERKS
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms