1. Home
  2. Resources
  3. SAP Tables
  4. KNTBL - Coding Block

SAP Table KNTBL

Coding Block

KNTBL (Coding Block) 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 KNTBL to other SAP tables.

KNTBL table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
GJAHR Fiscal Year GJAHR NUMC 4 0
MONAT Fiscal Period MONAT NUMC 2 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
BZDAT Asset value date BZDAT DATS 8 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
KOKRS Controlling Area KOKRS CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
VBUND Company ID of trading partner RASSC CHAR 6 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
SAKNR G/L Account Number SAKNR CHAR 10 0
HKONT General Ledger Account HKONT CHAR 10 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
AUFNR Order Number AUFNR_NEU CHAR 12 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
PERNR Personnel Number PERNR_D NUMC 8 0
MATNR Material Number MATNR CHAR 18 0
PRCTR Profit Center PRCTR CHAR 10 0
AWTYP Reference Transaction AWTYP CHAR 5 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
WWERT Translation Date WWERT_D DATS 8 0
WAERS Currency Key WAERS CUKY 5 0
VORGN Transaction Type for General Ledger VORGN CHAR 4 0
ANBWA Asset Transaction Type ANBWA CHAR 3 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
XSKST Indicator: Statistical posting to cost center XSKST CHAR 1 0
X Yes
NULL No
XSAUF Indicator: Posting to order is statistical XSAUF CHAR 1 0
X Yes
NULL No
XSPRO Indicator: Posting to project is statistical XSPRO CHAR 1 0
X Yes
NULL No
XSERG Indicator: Posting to prof.analysis is statistical XSERG CHAR 1 0
X Yes
NULL No
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
EGRUP Equity group JV_EGROUP T8JF CHAR 3 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0

KNTBL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KNTBL EGRUP KNTBL VNAME T8JF Investment Group VNAME
KNTBL EGRUP KNTBL EGRUP T8JF Investment Group EGRUP
KNTBL EGRUP SYST MANDT T8JF Investment Group MANDT
KNTBL EGRUP KNTBL BUKRS T8JF Investment Group BUKRS
KNTBL RECID SYST MANDT T8JJ Recovery Indicator MANDT
KNTBL RECID KNTBL BUKRS T8JJ Recovery Indicator BUKRS
KNTBL RECID KNTBL RECID T8JJ Recovery Indicator RECID
KNTBL VNAME SYST MANDT T8JV Joint Venture MANDT
KNTBL VNAME KNTBL BUKRS T8JV Joint Venture BUKRS
KNTBL VNAME KNTBL VNAME T8JV Joint Venture VNAME