1. Home
  2. Resources
  3. SAP Tables
  4. SNIWE - Transfer Structure for Lowest Value Determination

SAP Table SNIWE

Transfer Structure for Lowest Value Determination

SNIWE (Transfer Structure for Lowest Value Determination) 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 SNIWE to other SAP tables.

SNIWE table fields

Field Data element Checktable Datatype Length Decimals
TCODE Transaction Code TCODE CHAR 20 0
NIWEX Indicates lowest value method used MY_NIWEX CHAR 2 0
00 Market price method
10 Range of coverage method
20 Movement rate method
30 Loss-Free Valuation
90 Balance sheet valuation result
F1 FIFO valuation
L1 LIFO valuation for single materials
L2 LIFO valuation for pools
PRGID Balance Sheet Valuation Program ID MY_PROGID CHAR 2 0
N0 Lowest value determination based on market prices
N1 Flat-rate reductions based on range of coverage
N2 Flat-rate reductions based on rate of movement
N3 Loss-free valuation
N8 Price variances
N9 Balance sheet values by account
L1 LIFO valuation for single materials
L2 LIFO valuation for pools
L3 LIFO lowest value comparison
L4 Display of LIFO results for single materials
L5 Display of LIFO results for pools
L6 Select LIFO-relevant materials
L7 Analyze composition of pools
L8 Create LIFO base layer
L9 Create LIFO receipts from document extract
LA Check LIFO indicator
LB Delete LIFO data
LC Adopt LIFO or FIFO data from external source
LD Transfer lowest prices to LIFO table
LE Pool splitting method
LF Copy LIFO layer version
LG Aggregate LIFO layers
LH Change LIFO/FIFO valuation level
LI Allocate pool numbers
LJ Delete LIFO or FIFO data
LK Modify units of measure in LIFO/FIFO tables
LL Reassign LIFO layer
32 Change LIFO data
33 Display LIFO data
39 Display LIFO change documents
F1 Execute FIFO valuation
F2 Display FIFO change documents
F3 Create FIFO receipts from document extract
F4 Select FIFO-relevant materials
F5 Delete FIFO data
34 Change FIFO data
35 Display FIFO data
X0 Collective maint. of phys. inven. prices (material master)
X1 Average receipt price
X2 Transfer physical inventory prices to price table
ML Program from Material Ledger
M1 Cumulation of Periodic Receipt Values from Material Ledger
MD Manual Correction of Per. Receipt Values from Matl Ledger
MK Customer-Specific Correction of Per. Receipt Values from ML
MS Receipt Values from Material Ledger Period-End Closing
PRCID Price Identified for Balance Sheet Valuation Procedure MY_PROCID CHAR 2 0
N0 Price from lowest value determination by market prices
N1 Price from devaluation by range of coverage
N2 Price from devaluation by rate of movement
N3 Price from loss-free valuation
N9 Balance sheet price
L4 Price from LIFO valuation for single materials
L5 Price from LIFO valuation for pools
F1 Price for FIFO valuation
X1 Average receipt price
REPID ABAP Program: Current Main Program SYREPID CHAR 40 0
SLSET Used Selection Screen Variant SYSLSET CHAR 14 0
UPDAT Update Results MY_UPDT CHAR 1 0
X Yes
NULL No
ACTVT Activity ACTIV_AUTH CHAR 2 0
MYKEY_CUS Balance Sheet Valuation Level MYKEY_CUS CHAR 1 0
1 Valuation area
2 Company code
BUKRS Company Code BUKRS CHAR 4 0
STDAT Balance Sheet Key Date MY_STDAT DATS 8 0
BTITLE Lowest value determination: free text for column heading NW_TITLE CHAR 18 0
BMATP Base price: current material price MY_BMATP CHAR 1 0
X Yes
NULL No
BVMMP Base price: material price of previous month MY_BVMMP CHAR 1 0
X Yes
NULL No
BVJMP Base price: material price of previous year MY_BVJMP CHAR 1 0
X Yes
NULL No
BSTPS Base Price: Current Standard Price MY_BSTPS CHAR 1 0
X Yes
NULL No
BVMSP Base price: standard price from previous month MY_BVMSP CHAR 1 0
X Yes
NULL No
BVJSP Base price: standard price from previous year MY_BVJSP CHAR 1 0
X Yes
NULL No
BVERP Base Price: Current Moving Average Price MY_BVERP CHAR 1 0
X Yes
NULL No
BVMVP Nase price: moving average price from previous month MY_BVMVP CHAR 1 0
X Yes
NULL No
BVJVP Base price: moving average price of previous year MY_BVJVP CHAR 1 0
X Yes
NULL No
BBPRS Base price: tax valuation price 1 MY_BBPRS CHAR 1 0
X Yes
NULL No
BBPS1 Base price: tax valuation price 2 MY_BBPS1 CHAR 1 0
X Yes
NULL No
BVJBS Base price: tax valuation price 3 MY_BVJBS CHAR 1 0
X Yes
NULL No
BBPRH Base price: commercial valuation price 1 MY_BBPRH CHAR 1 0
X Yes
NULL No
BBPH1 Base price: commercial valuation price 2 MY_BBPH1 CHAR 1 0
X Yes
NULL No
BVJBH Base price: commercial valuation price 3 MY_BVJBH CHAR 1 0
X Yes
NULL No
BMYMP Base price: average delivered price MY_BMYMP CHAR 1 0
X Yes
NULL No
BMYD1 Select from Posting Date (incl.) BUDAT_VON DATS 8 0
BMYD2 Select Up to Posting Date (Incl.) BUDAT_BIS DATS 8 0
BNOPR Lowest Price Determination without Comparison Price NO_PRICE CHAR 1 0
X Yes
NULL No
BCCP1 Base Price at CCode Level: Lowest Price of All Val. Areas MY_BCCP1 CHAR 1 0
X Yes
NULL No
BCCP2 Base Price at Company Code Level: Average of All Val. Areas MY_BCCP2 CHAR 1 0
X Yes
NULL No
BCCP3 Base Price at Company Code Level: Split by Val. Area MY_BCCP3 CHAR 1 0
X Yes
NULL No
UBPRS Update of tax valuation price 1 KZ_BWPRS CHAR 1 0
X Yes
NULL No
UBPS1 Update of tax valuation price 2 KZ_BWPRS1 CHAR 1 0
X Yes
NULL No
UVJBS Update of tax valuation price 3 U_BWPRS CHAR 1 0
X Yes
NULL No
UBPRH Update of commercial valuation price 1 KZ_BWPRH CHAR 1 0
X Yes
NULL No
UBPH1 Update of commercial valuation price 2 KZ_BWPRH1 CHAR 1 0
X Yes
NULL No
UVJBH Update of commercial valuation price 3 U_BWPRH CHAR 1 0
X Yes
NULL No
UPLP1 Update future planned price 1 MY_UPLP1 CHAR 1 0
X Yes
NULL No
UPLD1 Date from Which Future Planned Price 1 Is Valid DZPLD1 DATS 8 0
UPLP2 Update future planned price 2 MY_UPLP2 CHAR 1 0
X Yes
NULL No
UPLD2 Date from Which Future Planned Price 2 Is Valid DZPLD2 DATS 8 0
UPLP3 Update future planned price 3 MY_UPLP3 CHAR 1 0
X Yes
NULL No
UPLD3 Date from Which Future Planned Price 3 Is Valid DZPLD3 DATS 8 0
UABWK Update Devaluation Indicator MY_UABWK CHAR 1 0
X Yes
NULL No
PRCHA Automatic Material Price Change: Direct Update MY_PRCHA CHAR 1 0
X Yes
NULL No
BTCIN Automatic Material Price Change via Batch Input KZ_BTCI CHAR 1 0
X Yes
NULL No
NOCHA No Price Update Using Batch Input or Direct Update MY_NOCHA CHAR 1 0
X Yes
NULL No
BIDAT Posting date for automatic price change MR21_DATUM DATS 8 0
BIMAP Name of batch input session for price change MY_BIMAP CHAR 12 0
DBPRS Reset tax valuation price 1 MY_DBPRS CHAR 1 0
X Yes
NULL No
DBPS1 Reset tax valuation price 2 MY_DBPS1 CHAR 1 0
X Yes
NULL No
DVJBS Reset Tax Valuation Price 3 MY_DVJBS CHAR 1 0
X Yes
NULL No
DBPRH Reset commercial valuation price 1 MY_DBPRH CHAR 1 0
X Yes
NULL No
DBPH1 Reset commercial valuation price 2 MY_DBPH1 CHAR 1 0
X Yes
NULL No
DVJBH Reset commercial valuation price 3 MY_DVJBH CHAR 1 0
X Yes
NULL No
CUSTX User text for log (lowest value determination) NW_CUSTX CHAR 18 0
NORED Natural Number INT4 INT4 10 0
BNIWE Lowest Price = Lowest of Market and Comparison Price MY_BNIWE CHAR 1 0
X Yes
NULL No
BREPV Comparison Price as Replacement Value for Market Price MY_BREPV CHAR 1 0
X Yes
NULL No
BKTXT Document Header Text BKTXT CHAR 25 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
CHDOC Create Change Documents? MY_CHDOC CHAR 1 0
X Yes
NULL No
BLART Document Type BLART CHAR 2 0
ACC_PRINCIPLE Accounting Principle ACCOUNTING_PRINCIPLE CHAR 4 0
DELPO Make Delta Posting MY_DELPO CHAR 1 0
X Yes
NULL No
NODEL Do Not Make Delta Posting MY_NODEL CHAR 1 0
X Yes
NULL No
DLDAT Posting Date (for Delta Posting) MY_DLDAT DATS 8 0
KOMOK Account Modification KOMOK CHAR 3 0
LAUFID ID of Delta Valuation Run LAUFID CHAR 8 0
PERIOD Balance Sheet Valuation Period (YYYYPP) MY_PERIOD ACCP 6 0
DELTATST Test Run XTESTRUN CHAR 1 0
X Yes
NULL No