SAP S/4HANA Table List A to Z — Standard Tables Used in Our End-to-End Tests

Alphabetical list of the standard SAP tables we actually touched while running end-to-end tests (company codes CC10 / JNC2) on an S/4HANA sandbox — master data, purchasing, production, sales, costing, allocation cycles and the data dictionary itself.

Table descriptions and field texts come straight from the system DDIC (DD02T / DD03L / DD04T). Custom Z-tables are excluded. Last updated: 2026-08-27

A

Table	Description	Key fields	Important fields
ACDOCA	Universal Journal Entry Line Items	RLDNR / RBUKRS / GJAHR / BELNR / DOCLN	RLDNR (Ledger in General Ledger Accounting), RBUKRS (Company Code), RACCT (Account Number), RCNTR (Cost Center), RFAREA (Functional Area), BUDAT (Posting Date in the Document), BLART (Document Type), MATNR (Material Number), AUFNR (Order Number), KTOSL (Transaction Key), HSL (Amount in Company Code Currency), MSL (Quantity)
AFKO	Order Header Data PP Orders	AUFNR	AUFNR (Order Number), PLNBEZ (Material Number), GAMNG (Total Order Quantity), GMEIN (Base Unit of Measure), GSTRP (Basic Start Date), GLTRP (Basic finish date), IGMNG (Confirmed Yield Quantity From Order Confirmation), DISPO (MRP controller for the order)
AUFK	Order master data	AUFNR	AUFNR (Order Number), AUART (Order Type), KTEXT (Description), WERKS (Plant), KOKRS (Controlling Area), OBJNR (Object number), ERDAT (Created On), LOEKZ (Deletion Flag)

B

Table	Description	Key fields	Important fields
BKPF	Accounting Document Header	BUKRS / BELNR / GJAHR	BUKRS (Company Code), BELNR (Document Number of an Accounting Document), GJAHR (Fiscal Year), BLART (Document Type), BLDAT (Document Date in Document), BUDAT (Posting Date in the Document), TCODE (Transaction Code), XBLNR (Reference Document Number), AWTYP (Reference procedure), AWKEY (Reference Key), WAERS (Currency Key)
BSAS	G/L: Cleared Items (compatibility view) ※ Direct SELECT is a syntax error on S/4 — read via BSAS_VIEW	BUKRS / HKONT / AUGDT / AUGBL / ZUONR / GJAHR / BELNR / BUZEI	HKONT (G/L Account), AUGDT (Clearing Date), AUGBL (Clearing Document), BUDAT (Posting Date), SHKZG (Debit/Credit Indicator), DMBTR (Amount in Local Currency)
BSEG	Accounting Document Segment	BUKRS / BELNR / GJAHR / BUZEI	BUZEI (Number of Line Item Within Accounting Document), SHKZG (Debit/Credit Indicator), HKONT (General Ledger Account), DMBTR (Amount in local currency), KOSTL (Cost Center), AUFNR (Order Number), MATNR (Material Number), WERKS (Plant), KTOSL (Transaction Key), LIFNR (Account Number of Supplier), KUNNR (Customer Number)
BSIS	G/L: Open Items (compatibility view) ※ Direct SELECT is a syntax error on S/4 — read via BSIS_VIEW	BUKRS / HKONT / AUGDT / AUGBL / ZUONR / GJAHR / BELNR / BUZEI	HKONT (G/L Account), BUDAT (Posting Date), BLART (Document Type), SHKZG (Debit/Credit Indicator), DMBTR (Amount in Local Currency), WAERS (Currency Key)
BUT000	BP: General data I	PARTNER	PARTNER (Business Partner Number), TYPE (Business Partner Category), BU_GROUP (Business Partner Grouping), NAME_ORG1 (Name 1 of organization), NAME_LAST (Last name of business partner (person)), NAME_FIRST (First name of business partner (person)), NAME_GRP1 (Name 1 (group)), XDELE (Central Archiving Flag)

C

Table	Description	Key fields	Important fields
CE1JNC2	JNC #2 Operating Con	PALEDGER / VRGAR / VERSI / PERIO / PAOBJNR / PASUBNR / BELNR / POSNR	PALEDGER (Currency type for an operating concern), VRGAR (Record Type), PERIO (Period/Year), BELNR (Document number of line item in Profitability Analysis), KNDNR (Customer), ARTNR (Product number), VKORG (Sales Organization), WERKS (Plant), ABSMG (Sales quantity), REC_WAERS (Currency of the data record)
CE1OC10	Operating Concern 10	PALEDGER / VRGAR / VERSI / PERIO / PAOBJNR / PASUBNR / BELNR / POSNR	PALEDGER (Currency type for an operating concern), VRGAR (Record Type), PERIO (Period/Year), BELNR (Document number of line item in Profitability Analysis), KNDNR (Customer), ARTNR (Product number), VKORG (Sales Organization), WERKS (Plant), ABSMG (Sales quantity), REC_WAERS (Currency of the data record)
CKIS	Items Unit Costing/Itemization Product Costing	LEDNR / BZOBJ / KALNR / KALKA / KADKY / TVERS / BWVAR / KKZMA / POSNR	KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), KADKY (Costing Date (Key)), TVERS (Costing Version), POSNR (Unit Costing Line Item Number), TYPPS (Item Category), MATNR (Material Number), KOSTL (Cost Center), LSTAR (Activity Type), KSTAR (Cost Element), MENGE (Quantity), MEEHT (Base Unit of Measure), WERTN (Value in Controlling Area Currency)
CKMLCR	Material Ledger: Period Totals Records Values	KALNR / BDATJ / POPER / UNTPER / CURTP	KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), BDATJ (Posting Date YYYY), POPER (Posting period), CURTP (Currency Type), STPRS (Standard Price), PVPRS (Periodic Unit Price), PEINH (Price Unit), SALK3 (Value of Total Valuated Inventory), SALKV (Value Based on Periodic Unit Price (with Price Ctrl S Only))
CKMLPP	Material Ledger Period Totals Records Quantity	KALNR / BDATJ / POPER / UNTPER	KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), BDATJ (Posting Date YYYY), POPER (Posting period), STATUS (Material Ledger Period Status), MEINS (Unit of Measure for Material Valuation), LBKUM (Total Valuated Stock), ZUKUMO (Total Quantity of Goods Received in Period), ABKUMO (Beginning Inventory: Quantity at Start of Period)
CSKB	Cost Elements (Data Dependent on Controlling Area)	KOKRS / KSTAR / DATBI	KOKRS (Controlling Area), KSTAR (Cost Element), DATBI (Valid To Date), DATAB (Valid-From Date), KATYP (Cost element category)
CSKS	Cost Center Master Record	KOKRS / KOSTL / DATBI	KOKRS (Controlling Area), KOSTL (Cost Center), DATBI (Valid To Date), DATAB (Valid-From Date), BUKRS (Company Code), KOSAR (Cost Center Category), VERAK (Person Responsible), FUNC_AREA (Functional Area)
CSKT	Cost Center Texts	SPRAS / KOKRS / KOSTL / DATBI	KOKRS (Controlling Area), KOSTL (Cost Center), DATBI (Valid To Date), KTEXT (General Name), LTEXT (Description)
CSKU	Cost Element Texts	SPRAS / KTOPL / KSTAR	KTOPL (Chart of Accounts), KSTAR (Cost Element), KTEXT (General Name), LTEXT (Description)
CSLA	Activity master	KOKRS / LSTAR / DATBI	KOKRS (Controlling Area), LSTAR (Activity Type), DATBI (Valid To Date), LEINH (Activity Unit), VKSTA (Allocation Cost Element), LATYP (Activity Type Category)
CSLT	Activity type texts	SPRAS / KOKRS / LSTAR / DATBI	KOKRS (Controlling Area), LSTAR (Activity Type), DATBI (Valid To Date), KTEXT (General Name), LTEXT (Description)
CVI_CUST_LINK	Assignment Between Customer and Business Partner	PARTNER_GUID	PARTNER_GUID (Business Partner GUID), CUSTOMER (Customer Number)
CVI_VEND_LINK	Assignment Between Vendor and Business Partner	PARTNER_GUID	PARTNER_GUID (Business Partner GUID), VENDOR (Account Number of Supplier)

D

Table	Description	Key fields	Important fields
DD02T	SAP DD: SAP Table Texts	TABNAME / DDLANGUAGE / AS4LOCAL / AS4VERS	TABNAME (Table Name), DDLANGUAGE (Language Key), DDTEXT (Short Description of Repository Objects)
DD03L	Table Fields	TABNAME / FIELDNAME / AS4LOCAL / AS4VERS / POSITION	TABNAME (Table Name), FIELDNAME (Field Name), POSITION (Position of the field in the table), KEYFLAG (Identifies a key field of a table), ROLLNAME (Data element (semantic domain)), CHECKTABLE (Check table name of the foreign key), DOMNAME (Domain name)
DD07T	DD: Texts for Domain Fixed Values (Language-Dependent)	DOMNAME / DDLANGUAGE / AS4LOCAL / VALPOS / AS4VERS	DOMNAME (Domain name), DDLANGUAGE (Language Key), DOMVALUE_L (Values for Domains: Single Value/Lower Limit), DDTEXT (Short Text for Fixed Values)
DD25L	Aggregate Header (Views, MC Objects, Lock Objects)	VIEWNAME / AS4LOCAL / AS4VERS	VIEWNAME (Name of SAP Table View), AGGTYPE (Aggregate Type), ROOTTAB (Primary table of an aggregate)

E

Table	Description	Key fields	Important fields
EBAN	Purchase Requisition	BANFN / BNFPO	BANFN (Purchase Requisition Number), BNFPO (Item number of purchase requisition), MATNR (Material Number), WERKS (Plant), MENGE (Purchase requisition quantity), MEINS (Purchase requisition unit of measure), LFDAT (Item delivery date), EBELN (Purchase order number), LOEKZ (Deletion Indicator in Purchasing Document), STATU (Processing status of purchase requisition)
EBKN	Purchase Requisition Account Assignment	BANFN / BNFPO / ZEBKN	BANFN (Purchase Requisition Number), BNFPO (Item number of purchase requisition), ZEBKN (Serial number for PReq account assignment segment), KOSTL (Cost Center), AUFNR (Order Number), SAKTO (G/L Account Number)
EINA	Purchasing Info Record: General Data	INFNR	INFNR (Number of purchasing info record), MATNR (Material Number), LIFNR (Vendor's account number), LOEKZ (Purchasing info: General data flagged for deletion)
EKBE	History per Purchasing Document	EBELN / EBELP / ZEKKN / VGABE / GJAHR / BELNR / BUZEI	EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), VGABE (Transaction/event type, purchase order history), GJAHR (Material Document Year), BELNR (Number of Material Document), BUZEI (Item in Material Document), BWART (Movement type (inventory management)), MENGE (Quantity), DMBTR (Amount in Local Currency), BUDAT (Posting Date in the Document)
EKKO	Purchasing Document Header	EBELN	EBELN (Purchasing Document Number), BUKRS (Company Code), BSART (Purchasing Document Type), LIFNR (Vendor's account number), EKORG (Purchasing organization), EKGRP (Purchasing Group), BEDAT (Purchasing Document Date), WAERS (Currency Key), LOEKZ (Deletion Indicator in Purchasing Document)
EKPO	Purchasing Document Item	EBELN / EBELP	EBELP (Item Number of Purchasing Document), MATNR (Material Number), WERKS (Plant), LGORT (Storage location), MENGE (Purchase Order Quantity), MEINS (Purchase Order Unit of Measure), NETPR (Net Price in Purchasing Document (in Document Currency)), NETWR (Net Order Value in PO Currency), ELIKZ ("Delivery Completed" Indicator), EREKZ (Final Invoice Indicator), LOEKZ (Deletion Indicator in Purchasing Document)

K

Table	Description	Key fields	Important fields
KEKO	Product Costing - Header Data	BZOBJ / KALNR / KALKA / KADKY / TVERS / BWVAR / KKZMA	KALNR (Cost Estimate Number - Product Costing), KALKA (Costing Type), KADKY (Costing Date (Key)), TVERS (Costing Version), MATNR (Material Number), WERKS (Plant), FREIG (Release of Standard Cost Estimate), LOSGR (Lot Size for Product Costing), MEINS (Valuation Unit of Measure), KOKRS (Controlling Area)
KNA1	General Data in Customer Master	KUNNR	KUNNR (Customer Number), NAME1 (Name 1), LAND1 (Country/Region Key), ORT01 (City), KTOKD (Customer Account Group)
KNB1	Customer Master (Company Code)	KUNNR / BUKRS	KUNNR (Customer Number), BUKRS (Company Code), AKONT (Reconciliation Account in General Ledger), ZTERM (Terms of payment key)

L

Table	Description	Key fields	Important fields
LFA1	Supplier Master (General Section)	LIFNR	LIFNR (Account Number of Supplier), NAME1 (Name 1), LAND1 (Country/Region Key), ORT01 (City), KTOKK (Vendor account group)
LFB1	Vendor Master (Company Code)	LIFNR / BUKRS	LIFNR (Account Number of Supplier), BUKRS (Company Code), AKONT (Reconciliation Account in General Ledger), ZTERM (Terms of payment key)

M

Table	Description	Key fields	Important fields
MAKT	Material Descriptions	MATNR / SPRAS	MATNR (Material Number), SPRAS (Language Key), MAKTX (Material Description)
MAPL	Assignment of Task Lists to Materials	MATNR / WERKS / PLNTY / PLNNR / PLNAL / ZKRIZ / ZAEHL	MATNR (Material Number), WERKS (Plant), PLNTY (Task List Type), PLNNR (Key for Task List Group), PLNAL (Group Counter), LOEKZ (Deletion Indicator)
MARA	General Material Data	MATNR	MATNR (Material Number), MTART (Material type), MATKL (Material Group), MEINS (Base Unit of Measure), LVORM (Flag Material for Deletion at Client Level)
MARC	Plant Data for Material	MATNR / WERKS	MATNR (Material Number), WERKS (Plant), BESKZ (Procurement Type), SOBSL (Special procurement type), DISMM (MRP Type), EKGRP (Purchasing Group), LVORM (Flag Material for Deletion at Plant Level)
MARD	Storage Location Data for Material	MATNR / WERKS / LGORT	MATNR (Material Number), WERKS (Plant), LGORT (Storage location), LABST (Valuated Unrestricted-Use Stock), INSME (Stock in Quality Inspection), SPEME (Blocked Stock), UMLME (Stock in transfer (from one storage location to another)), RETME (Blocked Stock Returns)
MAST	Material to BOM Link	MATNR / WERKS / STLAN / STLNR / STLAL	MATNR (Material Number), WERKS (Plant), STLAN (BOM Usage), STLNR (Bill of Material), STLAL (Alternative BOM)
MBEW	Material Valuation	MATNR / BWKEY / BWTAR	MATNR (Material Number), BWKEY (Valuation area), VPRSV (Price control indicator), STPRS (Standard price), VERPR (Moving Average Price/Periodic Unit Price), PEINH (Price unit), LBKUM (Total Valuated Stock), SALK3 (Value of Total Valuated Stock), BKLAS (Valuation Class)
MBEWH	Material Valuation: History	MATNR / BWKEY / BWTAR / LFGJA / LFMON	MATNR (Material Number), BWKEY (Valuation area), LFGJA (Fiscal Year of Current Period), LFMON (Current period (posting period)), LBKUM (Total Valuated Stock), SALK3 (Value of Total Valuated Stock), STPRS (Standard price), VERPR (Moving Average Price/Periodic Unit Price)
MKAL	Production Versions of Material	MATNR / WERKS / VERID	MATNR (Material Number), WERKS (Plant), VERID (Production Version), TEXT1 (Short Text for Production Version), ADATU (Valid-From Date of Production Version), BDATU (Valid-To Date of Production Version)
MKPF	Header: Material Document	MBLNR / MJAHR	MBLNR (Number of Material Document), MJAHR (Material Document Year), BLDAT (Document Date in Document), BUDAT (Posting Date in the Document), XBLNR (Reference Document Number)
MSEG	Document Segment: Material	MBLNR / MJAHR / ZEILE	ZEILE (Item in Material Document), BWART (Movement type (inventory management)), SHKZG (Debit/Credit Indicator), MATNR (Material Number), WERKS (Plant), LGORT (Storage location), MENGE (Quantity), MEINS (Base Unit of Measure), DMBTR (Amount in Local Currency), AUFNR (Order Number), EBELN (Purchase order number)

R

Table	Description	Key fields	Important fields
RFDT	Accounting Data (INDX Structure)	RELID / SRTFD / SRTF2	RELID (CHAR02 data element for SYST), SRTFD (Character 22), SRTF2 (BIN4 data element for SYST), CLUSTR (BIN2 data element for SYST), CLUSTD (Data field for IMPORT/EXPORT database tables)

S

Table	Description	Key fields	Important fields
SETHEADER	Set Header and Directory	SETCLASS / SUBCLASS / SETNAME	SETCLASS (Set Class), SUBCLASS (Organizational Unit as Set Subclass), SETNAME (Set Name)
SETHEADERT	Short Description of Sets	SETCLASS / SUBCLASS / SETNAME / LANGU	SETCLASS (Set Class), SUBCLASS (Organizational Unit as Set Subclass), SETNAME (Set Name), LANGU (Language Key), DESCRIPT (Short Description of a Set)
SKA1	G/L Account Master (Chart of Accounts)	KTOPL / SAKNR	KTOPL (Chart of Accounts), SAKNR (G/L Account Number), KTOKS (G/L Account Group), XBILK (Indicator: Account is a balance sheet account?), GVTYP (P&L statement account type)
SKAT	G/L Account Master Record (Chart of Accounts: Description)	SPRAS / KTOPL / SAKNR	KTOPL (Chart of Accounts), SAKNR (G/L Account Number), TXT20 (G/L Account Short Text), TXT50 (G/L Account Long Text)
SKB1	G/L account master (company code)	BUKRS / SAKNR	BUKRS (Company Code), SAKNR (G/L Account Number), XOPVW (Indicator: Open Item Management?), MITKZ (Account is Reconciliation Account), FSTAG (Field status group), WAERS (Account Currency)
STKO	BOM Header	STLTY / STLNR / STLAL / STKOZ	STLTY (BOM category), STLNR (Bill of Material), STLAL (Alternative BOM), BMENG (Base quantity), BMEIN (Base Unit of Measure for BOM)
STPO	BOM item	STLTY / STLNR / STLKN / STPOZ	STLKN (BOM item node number), POSNR (BOM Item Number), IDNRK (BOM component), MENGE (Component Quantity), MEINS (Component Unit of Measure), POSTP (Item category (bill of material))

T

Table	Description	Key fields	Important fields
T001	Company Codes	BUKRS	BUKRS (Company Code), BUTXT (Name of Company Code or Company), LAND1 (Country/Region Key), WAERS (Currency Key), KTOPL (Chart of Accounts)
T001K	Valuation area	BWKEY	BWKEY (Valuation area), BUKRS (Company Code)
T001L	Storage Locations	WERKS / LGORT	WERKS (Plant), LGORT (Storage location), LGOBE (Description of Storage Location)
T001W	Plants/Branches	WERKS	WERKS (Plant), NAME1 (Name), BWKEY (Valuation area)
T811C	Allocations: Cycles	TAB / CYCLE / SDATE	TAB (Table Name), CYCLE (Allocation/cycle), SDATE (Start Date), EDATE (End Date), ALART (Type of Allocation), ITERFLAG (Allocation Processing Indicator), LASTEXEC (Date of the last execution), PUSER (Entered By)
T811F	Allocations: Element Table	TAB / CYCLE / SDATE / SEQNR / SRFLAG / FPOS	SEQNR (Segment number within a cycle), SRFLAG (Single-Character Flag), FPOS (Sequence Number), ELEMENT1 (Element), VALUE (Value)
T811K	Allocations: Key Fields	TAB / CYCLE / SDATE / SEQNR / SETKIND / POS	SEQNR (Segment number within a cycle), SETKIND (Type of Set), POS (Sequence Number of Allocation Document), FIELD (DB Field Name), SETID (Identification of a Set), SETNAME (Set ID), VALMIN (From Value), VALMAX (To Value)
T811L	Assessments/Distributions: Long Text	LANGU / TAB / CYCLE / SDATE / SEQNR	SEQNR (Segment number within a cycle), TXT (Text (30 Characters))
T811M	Allocations: Text for Field Groups	LANGU / TAB / FNAME	FNAME (Data Field Definition), DTEXT1 (Row Text), DTEXT2 (Column Text)
T811S	Allocations: Segments	TAB / CYCLE / SDATE / SEQNR	SEQNR (Segment number within a cycle), NAME (Name of a Segment in Assessment/Distribution), SRULE (Assessment/Distribution Rule Sender), RRULE (Assessment/Distribution Rule Receiver), SPERCENT (Sender Percentage), RCDATA (Data Field Definition), ASACC (Assessment Cost Element), ABSCH (Allocation Structure for Settlement/Assessment), NEGTEST (Indicator: Scale Negative Tracing Factors)
TFKBT	Name of the functional areas	SPRAS / FKBER	FKBER (Functional Area), FKBTX (Name of the functional area)
TKA01	Controlling Areas	KOKRS	KOKRS (Controlling Area), BEZEI (Name of the controlling area), WAERS (Currency Key), KTOPL (Chart of Accounts), ERKRS (Operating concern)
TKA02	Controlling area assignment	BUKRS / GSBER	BUKRS (Company Code), GSBER (Business Area), KOKRS (Controlling Area)
TKB5A	Allocation structure	ABSCH	ABSCH (Allocation Structure for Settlement/Assessment)
TKB5AL	Allocation: Assessement Cost Elements for Alloc. Structure	ABSCH / ABZUO / KOKRS	ABSCH (Allocation Structure for Settlement/Assessment), ABZUO (Assignment), KOKRS (Controlling Area), ASACC (Assessment Cost Element), KSTARGER (Cost-Element-Based Assessment)
TKB5B	Text Table for allocation Structure	SPRAS / ABSCH	ABSCH (Allocation Structure for Settlement/Assessment), STEXT (Text (30 Characters))
TKB5C	Settlement Assignment	ABSCH / ABZUO	ABSCH (Allocation Structure for Settlement/Assessment), ABZUO (Assignment)
TKB5D	Text Table for Settlement Assignment	SPRAS / ABSCH / ABZUO	ABSCH (Allocation Structure for Settlement/Assessment), ABZUO (Assignment), ZTEXT (Text (30 Characters))
TKB5E	Allocation structure	ABSCH / ABZUO / KOKRS / FNAME	ABSCH (Allocation Structure for Settlement/Assessment), ABZUO (Assignment), KOKRS (Controlling Area), FNAME (Source), SETNR (Cost Element Group), KSTAR_MIN (Cost Element), KSTAR_MAX (Cost Element)
TKT03	Stat. key figure texts	SPRAS / KOKRS / STAGR	KOKRS (Controlling Area), STAGR (Statistical key figure), BEZEI (Long Text)
TSTC	SAP Transaction Codes	TCODE	TCODE (Transaction Code), PGMNA (Program Name), DYPNO (Screen number), CINFO (HEX01 data element for SYST)
TSTCP	Parameters for Transactions	TCODE	TCODE (Transaction Code), PARAM (Parameters for transactions)
TSTCT	Transaction Code Texts	SPRSL / TCODE	TCODE (Transaction Code), TTEXT (Transaction text)
TVKO	Organizational Unit: Sales Organizations	VKORG	VKORG (Sales Organization), BUKRS (Company code of the sales organization), WAERS (Statistics currency)

V

Table	Description	Key fields	Important fields
VBAK	Sales Document: Header Data	VBELN	VBELN (Sales Document), AUART (Sales Document Type), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division), KUNNR (Sold-to Party), ERDAT (Date on which the record was created), NETWR (Net Value of the Sales Order in Document Currency), WAERK (SD Document Currency)
VBAP	Sales Document: Item Data	VBELN / POSNR	POSNR (Sales Document Item), MATNR (Material Number), WERKS (Plant (Own or External)), KWMENG (Cumulative order quantity in sales units), VRKME (Sales unit), NETWR (Net Value of the Order Item in Document Currency), LFSTA (Delivery Status (Item)), FKSAA (Order-Related Billing Status (Item)), GBSTA (Overall Processing Status (Item)), ABGRU (Reason for Rejection of Sales Documents)