1. Home
  2. Resources
  3. SAP Tables
  4. SINVT - Work Fields for Inventory Sampling

SAP Table SINVT

Work Fields for Inventory Sampling

SINVT (Work Fields for Inventory Sampling) 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 SINVT to other SAP tables.

SINVT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ZPSTI Text for inventory sampling method MBS_ZPSTIT CHAR 40 0
HOCHR Name of selected extrapolation procedure MBS_HOCHRT CHAR 40 0
SISTA Text for identification of an inventory sampling status MBS_SISTAT CHAR 40 0
BDSTI Name of selected area of inventory sampling MBS_BDSTIT CHAR 40 0
XISAP Text for identification of inventory sampling MBS_XISAPT CHAR 40 0
IGSCH Default key for inventory sampling profile MBS_IGSCH T159G CHAR 2 0
PLVER Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
PLSPR Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
PLSPE Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
ZUFTEXT Text for inventory sampling MBS_STEXT CHAR 40 0
PLGES Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKVER Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKVER_GEZ Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKVER_GEB Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKSPR Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKSPE Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKSPE_GEZ Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKSPE_GEB Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKGES Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKGES_GEZ Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
AKGES_GEB Numeric output field, 6 chars long MBS_OUTN6 NUMC 6 0
PREIS_ALT Upper price limit for sampling area MBS_PREIO CURR 11 2
PREIS_NEU Upper price limit for sampling area MBS_PREIO CURR 11 2
BUANF_ALT Upper value limit for sampling area MBS_WERTO CURR 13 2
BUANF_NEU Upper value limit for sampling area MBS_WERTO CURR 13 2
BUANF_DIF1 Initial book value MBS_BUANF CURR 13 2
BUANF_DIF2 Initial book value MBS_BUANF CURR 13 2
BUANF_DIF3 Initial book value MBS_BUANF CURR 13 2
PROZENT_NEU Percentage upper value limit MBS_PWERT NUMC 3 0
000 Percentage from 0 to 100
PROZENT_ALT Percentage upper value limit MBS_PWERT NUMC 3 0
000 Percentage from 0 to 100
XAKTU Text for identifying the update procedure MBS_XAKTUA CHAR 60 0

SINVT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SINVT IGSCH SINVT MANDT T159G Default Values for Inventory Sampling Profile MANDT
SINVT IGSCH SINVT IGSCH T159G Default Values for Inventory Sampling Profile IGSCH
SINVT MANDT SINVT MANDT T000 Clients MANDT