browse tables
explore SAP table structures and relationships
universal journal entry line items
universal journal entry line items (plan data)
address management - central address repository (cross-module)
change master
production order settlement rules
production order sequences
order header data pp orders
order item
production order confirmations
production order operations
production order operation scheduling values and quantities
asset classes — description and configuration
asset master record — general data
asset master record — depreciation area data
asset master record — cumulative depreciation values
asset master record — history of changes
asset periodic posting values — depreciation line items
asset master record — time-dependent organizational assignments
order master data
characteristic values (classification system)
accounting document header
bank master data
accounting: secondary index for customers (cleared items)
accounting: secondary index for vendors (cleared items)
accounting: secondary index for g/l accounts (cleared items)
accounting document segment
tax data for fi document line items
accounting: secondary index for customers (open items)
accounting: secondary index for vendors (open items)
accounting: secondary index for g/l accounts (open items)
business partner - central data (s/4hana master data hub)
business partner: address assignments
business partner: relationships
asset transaction types — definition and control
production order master view (aufk + afko join view)
change document header (cross-module change tracking)
change document items
profit center master data. stores profit center definitions including validity dates, hierarchy assignment, and organizational attributes. central table for profit center accounting in co-pca.
profit center texts. language-dependent descriptions for profit centers defined in cepc.
material ledger: currency and valuation data per period. stores actual costs, price differences, and exchange rate differences for each material per period and currency type.
material ledger: material header. stores the material ledger settings and control data for each material/valuation area combination. mandatory in s/4hana for actual costing.
co document header
co actual line items for orders/projects. stores detailed actual cost line items posted to internal orders, production orders, maintenance orders, and wbs elements. similar to coep but specifically for order-type co objects.
co object: line items (by period)
co plan line items. stores planned cost line items for co objects including cost centers, internal orders, and wbs elements. the planning counterpart to coep/coej for actual data.
co object: cost totals for external postings
co object: cost totals for internal postings
work center capacity assignment
work center header
cost elements (chart of accounts)
cost elements (controlling area)
cost center master data
cost center texts
activity type master data. stores activity types used in cost center accounting for internal activity allocation, such as machine hours, labor hours, and service units.
activity type texts. language-dependent descriptions for activity types defined in csla.
purchase requisition
purchasing info record: general data
purchasing info record: purchasing org. data
history per purchasing document
scheduling agreement schedule lines
purchasing document header
partner roles in purchasing
purchasing document item
purchasing source list
account assignment in purchasing document
new general ledger: actual line items
new general ledger: totals
electronic bank statement line items
billing plan header (milestone/periodic billing)
billing plan schedule lines (milestone/periodic billing)
ec-pca: actual line items for profit center accounting. stores actual posting line items allocated to profit centers in the classic (ecc) profit center accounting component.
om - objects (organizational management)
om - relationships (organizational management)
header: physical inventory document
internal object numbers (classification header link)
physical inventory document items
individual object status. stores both system and user status values for any sap object (orders, wbs elements, networks, maintenance orders, etc.) identified by its object number (objnr).
status object information. stores the status profile and object type for each object with status management. provides the link between an object and its allowed status transitions.
capacity header
product cost estimate header. stores the header data for standard cost estimates, including material, plant, costing type, lot size, and costing dates. central table for product costing in co-pc.
cost component split for cost estimates. stores the itemized cost breakdown (material, labor, overhead, etc.) for each product cost estimate in keko.
customer master (general section)
customer master (company code)
customer master - dunning data (per company code and dunning area)
customer hierarchy per sales area
customer master - contact persons
customer master - partner functions per sales area
customer master sales data
conditions - item data for condition records (condition master)
conditions (transaction data)
vendor master (general section)
vendor master (company code)
vendor master – purchasing organization data
sd document: delivery header data
sd document: delivery item data
material descriptions
assignment of task lists to materials
material master: general data
material master: plant data
material master: storage location data
units of measure for material
material valuation
batches
batch stocks
mrp document header
mrp table (mrp elements / planning situation)
header: material document
tax classification of material
document segment: material
sales data for material
message status records (output determination)
number range intervals
general object number
hr master data - infotype 0000 (actions)
hr master data - infotype 0001 (organizational assignment)
hr master data - infotype 0002 (personal data)
hr master data - infotype 0003 (payroll status)
hr master data - infotype 0006 (addresses)
hr master data - infotype 0007 (planned working time)
hr master data - infotype 0008 (basic pay)
hr master data - infotype 0009 (bank details)
hr master data - infotype 0014 (recurring payments/deductions)
hr master data - infotype 0015 (additional payments)
hr master data - infotype 0105 (communication)
hr time management - infotype 2001 (absences)
hr time management - infotype 2002 (attendances)
payment medium file (check/transfer information)
planned independent requirements data (pir line items)
planned independent requirements header (pir header)
hr payroll cluster table 1 (time data)
hr payroll cluster table 2 (payroll results)
planned orders
routing sequences (parallel and alternative sequences)
routing header (task list header)
routing operations (task list operations)
document header: incoming invoice
settlement data from payment program (payment run header)
processed items from payment program (payment run line items)
reservation / dependent requirements
document item: incoming invoice
g/l account master (chart of accounts)
g/l account master record (chart of accounts: description)
g/l account master (company code)
bill of materials header
bom item
sapscript text headers
sapscript text lines
clients (sap mandants)
company codes
permitted posting periods
valuation areas
storage locations
plants/branches
language keys (component bc-i18)
document types
directory of charts of accounts
countries
country names (language-dependent)
units of measure
units of measure texts
fiscal year variants
fiscal year variant periods
house bank master — company code level
house bank account master — account level details
purchasing organizations
gl account determination — automatic posting configuration
terms of payment
depreciation areas — definition and configuration
depreciation areas — company code assignment
movement type
personnel areas
pay scale groups (tariff tables)
pay scale types
pay scale areas
wage type texts
title keys
organizational units (pa - organizational assignment)
jobs (positions - organizational management)
hr time/measurement units
payroll areas
ledger master — ledger definitions for new gl
posting key
task list types
currency codes
exchange rates
currency decimal places
functional areas
business area master — description table
system status texts. language-dependent descriptions for sap system status codes used across all modules with status management.
controlling area master data. central configuration table defining controlling areas with their fiscal year variant, currency, and chart of accounts assignment.
controlling area assignment to company code. maps which company codes are assigned to each controlling area.
message programs – output type program assignment
business partner: functions
organizational unit: sales divisions
organizational unit: sales organizations
organizational unit: distribution channels
sales document: header data
sales document: item data
sales document: schedule line data
sales document flow