1. Home
  2. Resources
  3. SAP Tables
  4. SGNBU - GNBU Interface

SAP Table SGNBU

GNBU Interface

SGNBU (GNBU Interface) 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 SGNBU to other SAP tables.

SGNBU table fields

Field Data element Checktable Datatype Length Decimals
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
BDIFP Stock correction tolerance BDIFP DEC 5 2
BUKRS Company Code BUKRS CHAR 4 0
BWAER Currency Key WAERS CUKY 5 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
DMBTR Amount in Local Currency DMBTR CURR 13 2
KUFIX Indicator: Fixing of Exchange Rate KUFIX CHAR 1 0
X Yes
NULL No
KURSF Exchange rate KURSF DEC 9 5
MATNR Material Number MATNR CHAR 18 0
MENGE Quantity MENGE_D QUAN 13 3
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
NPEINH New price unit NPEINH DEC 5 0
NPREI New price NPREI CURR 11 2
POSNR Item number of the SD document POSNR NUMC 6 0
PRAVT Price change: carried over from previous to current period PRAVT CHAR 1 0
X Yes
NULL No
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PWAER Currency Key WAERS CUKY 5 0
REMNG Quantity invoiced REMNG QUAN 13 3
RETPO Returns Item RETPO CHAR 1 0
X Yes
NULL No
REWRT Invoice value in local currency REWRT CURR 13 2
REWWR Invoice Amount in Foreign Currency REWWR CURR 13 2
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
TBTKZ Indicator: subsequent debit/credit TBTKZ CHAR 1 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
WAART Indicates that material is a value-only material WAART CHAR 1 0
X Yes
NULL No
REPDAT Invoice Verification date REPDAT DATS 8 0
WAERS Currency Key WAERS CUKY 5 0
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
WEWRT Value of goods received in local currency WEWRT CURR 13 2
WEWWR Value of goods received in foreign currency WEWWR CURR 13 2
XEKBZ Indicator: Update Purchase Order Delivery Costs XEKBZ CHAR 1 0
X Yes
NULL No
XRUEJ Indicator: post to previous year XRUEJ CHAR 1 0
X Yes
NULL No
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1 0
X Yes
NULL No
WRBTR Amount in document currency WRBTR CURR 13 2
EREKZ Final Invoice Indicator EREKZ CHAR 1 0
X Yes
NULL No
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
LEBRE Indicator for Service-Based Invoice Verification LEBRE CHAR 1 0
X Yes
NULL No
WEREC Clearing Indicator for GR/IR Posting for External Services MMWEREC CHAR 1 0
X Yes
NULL No
IVTYP Origin of a Logistics Invoice Verification Document IVTYP CHAR 1 0
NULL Online
1 ERS
2 ERS Zero Document
3 Batch Run
4 EDI
5 Cancellation
6 Invoicing Plan
7 Transfer Prices
8 Revaluation
9 WEB Invoice
B BAPI Invoice
A Invoice from Parking Function
C Account Maintenance
D SRM Invoice
E BAPI Account Maintenance
G SOA A2A
H SOA B2B
I Ariba Invoice
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
MENGE_F Quantity (Floating Point Number - Internal Field) MENGE_F FLTP 16 16
REMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
WEMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
VRTKZ Distribution indicator for multiple account assignment VRTKZ CHAR 1 0
NULL Single account assignment
1 Distrib. on quantity basis
2 Distribution by percentage
PRDIF00 Amount in Local Currency DMBTR CURR 13 2
WKURS_GR Exchange Rate WKURS DEC 9 5
WKURS_IR Exchange Rate WKURS DEC 9 5
KUDIF_GR Exchange Rate Difference Amount KUDIF CURR 13 2
KUDIF_IR Exchange Rate Difference Amount KUDIF CURR 13 2
REWRT_10 Invoice value in local currency REWRT CURR 13 2
WEWRT_10 Value of goods received in local currency WEWRT CURR 13 2
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
BWKRS Field for entering valuation area BWKRS CHAR 4 0
WWERT Translation Date WWERT_D DATS 8 0
OICIMAP Change internal moving average price OIA_CIMAP CHAR 1 0
1 Do not revalue logical inventory
2 Revalue logical inventory using new phys. inventory price
3 Revalue log. inventory only (using old phys.inventory price)
4 Revalue log. inventory only (using new entered price)
OIWEEDWR Excise duty value - goods receipt OIH_WEEDWR CURR 13 2
OINEGPSTG Negative posting line (exchange fees) OIA_NGPSTL CHAR 1 0
X Yes
NULL No
OIREEDWR Excise duty value - invoice receipt OIH_REEDWR CURR 13 2
OIOPREI Old Price OIA_OPREI CURR 11 2