overview of sap table

Upload: mauriciogasparini6221

Post on 02-Jun-2018

256 views

Category:

Documents


2 download

TRANSCRIPT

  • 8/10/2019 Overview of SAP Table

    1/23

    Overview of (almost) all SAP Tables

    (Although not underlined as a link, you can click on each line of the table ofcontents to jump to the subject)

    Please note that several modules use the same tables. So sometimes youcan find information under an other chapter.Example: PS and PP (and others) are using the same tables as CO-OPA(internal orders). Like AUFK for order master, AFVC for activities/operationsand COEP for postings.

  • 8/10/2019 Overview of SAP Table

    2/23

    1 Customising

    1.1 General sett ing s

    1.1.1 Countries

    1.1.2 Currency

    1.1.3 Unit of measure1.1.4 Calend ar funct io ns

    1.2 Enterprise struc ture

    1.2.1 Definit ion

    1.2.2 Assignment

    1.3 Financia l accoun t ing

    1.3.1 Company cod e

    1.3.2 Fi do cumen t

    1.4 Not catego rized

    2 Basic data / administration

    2.1 Workb ench related tables

    2.1.1 Data dic t ion ary tables

    2.1.2 Workbench

    2.2 Administrat ion

    2.2.1 User adm inis trat ion

    2.2.2 Batch inpu t queue

    2.2.3 Job proc essing

    2.2.4 Spool

    2.2.5 Run time errors2.2.6 Message co ntro l

    2.2.7 EDI

    2.2.8 Change doc uments

    2.2.9 Repor t ing tree table

    2.2.10 LIS stru ctu re/contr ol tables

    3 Master Data

    3.1 Material master

    3.1.1 Basic data text (sap script)

    3.1.2 Batches

    3.2 Customer

    3.3 Vendor

    3.4 Customermaterial info record

    3.5 Bank data

    4 Characteristics

    http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Customisinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Customisinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Customisinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_generalhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_Currencyhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_Currencyhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_UOMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_calendarhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_enterprisehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_ES_definitionshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_ES_assignmenthttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FIhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FI_CChttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FI_fidochttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FI_notcathttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_basichttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_workbenchhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_DD%20tableshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_Workbench_2http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_administrationhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_user_adminhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_BIMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_jobshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_spoolhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_runtiehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_messagehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_edihttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_changedocshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_reportingtreehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_LIShttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Master_Datahttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_materialhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_basicdatahttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_batcheshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_customerhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_Vendorhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_cust_matinfohttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_cust_matinfohttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_cust_matinfohttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_bankhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Characteristicshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Characteristicshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_bankhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_bankhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_cust_matinfohttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_Vendorhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_customerhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_batcheshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_batcheshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_basicdatahttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MD_materialhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Master_Datahttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_LIShttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_reportingtreehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_changedocshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_edihttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_messagehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_runtiehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_spoolhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_jobshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_BIMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_user_adminhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_administrationhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_Workbench_2http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_DD%20tableshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_workbenchhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_workbenchhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_basichttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FI_notcathttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FI_fidochttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FI_CChttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_FIhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_ES_assignmenthttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_ES_definitionshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_enterprisehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_calendarhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_UOMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_Currencyhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_Currencyhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_generalhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Cust_generalhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Customising
  • 8/10/2019 Overview of SAP Table

    3/23

    4.1 Characteris t ics

    4.2 Class types and objects

    4.3 Links

    5 FI/CO

    5.1 FI

    5.1.1 Master data

    5.1.2 Accounting documents // indices

    5.1.3 Payment run

    5.1.4 Dunning run

    5.2 CO

    5.2.1 Controlling general

    5.2.2 Cost center accounting5.2.3 COPA

    5.2.4 Profit center accounting

    5.2.5 Others

    6 Sales and Distribution (SD)

    6.1 Sales ord er

    6.2 Bi l l ing doc ument

    6.3 Shipping

    6.4 Delivery

    6.5 Pricing6.6 Contracts

    7 Material Management (MM)

    7.1 Materia l doc ument

    7.2 Purchasing

    8 Warehouse Management (WM)

    8.1 Transfer requirement

    8.2 Transfer ord er8.3 Master data - stock pos it ions

    8.4 Inventory do cum ents in WM

    9 Quality Management (QM)

    9.1 Insp ect ion lot / info record

    9.2 Qual i ty not i f icat ion

    9.3 Cert if icate pro fi le

    10 Production Planning (PP)

    http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#characteristics2http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Chars_clastypeshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Chars_linkshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICOhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FIhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FIMDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FI_docshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FI_dunnhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FI_dunnhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Characteristicshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_KPLhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_PCAhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_PCAhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_Othershttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_SOhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_BILhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_SHIPhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_Delivhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_pricinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_contractshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MM_dochttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MM_purchasinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_transreqhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_transorderhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_MDStockhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_invdocshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_inslothttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_notifhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_certprofhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PPhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PPhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PPhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PPhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_certprofhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_notifhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_inslothttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QM_inslothttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#QMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_invdocshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_MDStockhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_transorderhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_transreqhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WM_transreqhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#WMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MM_purchasinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MM_dochttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MM_dochttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#MMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_contractshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_pricinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_Delivhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_SHIPhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_BILhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SD_SOhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#SDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_Othershttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_PCAhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_PCAhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_CO_KPLhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Characteristicshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FI_dunnhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FI_dunnhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FI_docshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FIMDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICO_FIhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#FICOhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Chars_linkshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#Chars_clastypeshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#characteristics2
  • 8/10/2019 Overview of SAP Table

    4/23

    10.1 Wor k center

    10.2 Rout ings/operat ions

    10.3 Bil l of material

    10.4 Produ ct ion orders

    10.5 Planned ord ers

    10.6 KANBAN10.7 Reservations

    10.8 Capacity plann ing

    10.9 Planned independ ent requirements

    11 Project system (PS)

    11.1 Basic data

    11.2 Equipment

    12 Plant maintenance (PM)

    12.1 Human resour ces

    12.2 Sett ings

    12.3 Master data

    12.4 Info-types

    13 Other important tables

    14 MRP related

    1 Customising

    1.1 General set t ings

    1.1.1 Countries

    T005 Countries

    1.1.2 Currency

    TCURC Currency codes

    TCURR WisselkoersenTCURT CURRENCY NAME

    TCURX Decimal places for currencies.

    1.1.3 Unit of measure

    T006 Units of measure

    1.1.4 Calendar functions

    T247 Month namesTFACD Factory calendar definitionT015M Month namesTTZZ Time zones

    TTZD Summer time rulesTTZDF Summer time rules (fixed annual dates)TTZDV Summer time rules (variable dates)

    http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_workcenterhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_routinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_BOMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_prodordershttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_planedorderhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_Kanbanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_Kanbanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_reservationshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_reservationshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_capplanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_capplanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_planedindreqhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PShttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PShttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PShttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PS_basichttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PS_equipmhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_Humanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_settingshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_MDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_infotypeshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_infotypeshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#13%20Other%20important%20tablehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#13%20Other%20important%20tablehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#13%20Other%20important%20tablehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#14%20MRP%20Relatedhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#14%20MRP%20Relatedhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#14%20MRP%20Relatedhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#14%20MRP%20Relatedhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#13%20Other%20important%20tablehttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_infotypeshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_MDhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_settingshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_Humanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PM_Humanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PS_equipmhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PS_basichttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PS_basichttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PShttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_planedindreqhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_capplanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_reservationshttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_Kanbanhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_planedorderhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_prodordershttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_BOMhttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_routinghttp://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm#PP_workcenter
  • 8/10/2019 Overview of SAP Table

    5/23

    TTZDT Summer time rules textsTTZ5 Assign Time Tones to CountriesTTZ5S Assign time zones to regions

    1.2 Enterprise structure

    1.2.1 DefinitionFI T880 Company

    T001 Company codeCO TKA01 Controlling areaLO T001W Plant / sales organisation

    T499S LocationsTSPA Division

    SD TVKO Sales organisation / company codeTVTW Distribution channelTVBUR Sales office

    TVKBT SALES OFFICE TEXT

    TVKGR Sales group

    TVGRT Sales group textT171T Sales district textMM T001L Storage locations

    T024E Purchasing organizationT3001 Warehouse numberTVST Shipping pointTVLA Loading pointTTDS Transportation

    1.2.2 Assignment

    CO TKA02 Assign company code to controlling areaLO T001K Assign plant (valuation area) to company code

    SD TVKO Sales organisation / company codeTVKOV Distribution channel / sales organisationTVKOS Division to sales organizationTVTA Sales ariaTVKBZ Sales office to sales areaTVBVK Sales group to sales officeTVKWZ Plants to sales organization

    MM T024E Purchasing organization / company codeT024W Plant to Purchase organizationT001K Link plant ( = valuation area) / company codeTVSWZ Shipping point to plant

    T320 Assignment MM Storage Location to WM Warehouse

    1.3 Financia l accoun t ing

    1.3.1 Company code

    T004 Chart of accountsT077S Account group (g/l accounts)T009 Fiscal year variantsT880 Global company dataT014 Credit control area

    1.3.2 Fi document

    T010O Posting period variant

    T010P Posting Period Variant NamesT001B Permitted Posting PeriodsT003 Document types

  • 8/10/2019 Overview of SAP Table

    6/23

    T012 House banksGB01 Fields in Validations and Substitutions

    (add own field or remove X to add field as modifiable)

    1.4 Not categorized

    T007a Tax keys

    T134 Material typesT179 Materials: Product HierarchiesT179T Materials: Product hierarchies: TextsTJ02T Status textTINC Customer incotermsTVFK Billing doc typesT390 PM: Shop papers for print control

    2 Basic data / administration

    2.1 Workb ench related tables

    2.1.1 Data dictionary tablesDD02L TABLES IN SAP

    DD02T Tables descriptionDD03L Field names in SAPDD03T Field description in SAP

    2.1.2 Workbench

    TADIR Directory of R/3 Repository ObjectsTRDIR System table TRDIRTFDIR Function ModuleTLIBG Person responsible for function classTLIBT Function Group Short Texts

    TFTIT Function Module Short TextTSTC Transaction codes in SAPTSTCT TRANSACTION CODES TEXTS

    T100 Message text (vb e000)VARID Variant dataD020T Screen textsTDEVC Development classTDEVCT Texts for development classes

    2.2 Admin is t ra t ion

    2.2.1 User administration

    USR01 User masterUSR02 Logon dataUSR03 User address dataUSR04 User master authorizationsUSR11 User Master Texts for Profiles (USR10)UST12 User master: AuthorizationsUSR12 User master authorization valuesUSR13 Short Texts for AuthorizationsUSR40 Prohibited passwordsTOBJ ObjectsTOBC Authorization Object ClassesTPRPROF Profile Name for Activity Group

    DEVACCESS Table for development userUST04 User profiles (multiple rows per user)

  • 8/10/2019 Overview of SAP Table

    7/23

    USR10 Authorisation profiles (i.e. &_SAP_ALL)UST10C Composit profiles (i.e. profile has sub profile)USR11 Text for authorisation profilesUSR40 Tabl for illegal passwordsUSGRP User groupsUSGRPT Text table for USGRP

    USH02 Change history for logon dataUSER_ADDR Address Data for usersUSOBT Relation transaction to authorization object (SAP)USOBT_C Relation Transaction to Auth. Object (Customer)USOBX Check table for table USOBTUSOBXFLAGS Temporary table for storing USOBX/T* changUSOBX_C Check Table for Table USOBT_C

    AGR_1016 Name of the activity group profileAGR_1016B Name of the activity group profileAGR_1250 Authorization data for the activity groupAGR_1251 Authorization data for the activity groupAGR_1252 Organizational elements for authorizationsAGR_AGRS Roles in Composite Roles

    AGR_DEFINE Role definitionAGR_HIER2 Menu structure information - Customer versAGR_HIERT Role menu textsAGR_OBJ Assignment of Menu Nodes to RoleAGR_PROF Profile name for roleAGR_TCDTXT Assignment of roles to TcodesAGR_TEXTS File Structure for Hierarchical Menu - CusAGR_TIME Time Stamp for Role: Including profileAGR_USERS Assignment of roles to users

    2.2.2 Batch input queue

    APQD DATA DEFINITION QueueAPQI QUEUE INFO DEFINITION

    2.2.3 Job processing

    TBTCO Job status overview tableTBTCP Batch job step overview

    2.2.4 Spool

    TSP02 Spool: Print requests

    2.2.5 Runtime errors

    SNAP Runtime errors

    2.2.6 Message controlTNAPR PROCESSING PROGRAMS FOR OUTPUT

    NAST Message statusNACH Printer determination

    2.2.7 EDI

    EDIDC CONTROL RECORD

    EDIDD Data recordEDID2 Data record 3.0 VersionEDIDS EDI status recordEDPAR Convert External < > Internal Partner NumberEDPVW EDI partner types

    EDPI1 EDI partner profile inboundEDPO1/2/3 EDI partner profile outbound

  • 8/10/2019 Overview of SAP Table

    8/23

    2.2.8 Change documents

    CDHDR CHANGE DOCUMENT HEADER

    CDPOS Change document positionedJCDS Change Documents for System/User Statuses (Table JEST)

    2.2.9 Reporting tree table

    SERPTREE Reporting: tree structure

    2.2.10 LIS structure/control tables

    TMC4 Global Control Elements: LIS Info Structure

    3 MASTER DATA:

    3.1 Material master:

    MARA MATERIAL MASTERMAKT Material textMARC Material per plant / stock

    MVKE Material master, sales dataMARD Storage location / stockMSKA Sales order stockMSPR Project stockMARM Units of measureMEAN International article numberPGMI Planning materialPROP Forecast parametersMAPR Link MARC PROPMBEW Material valuationEBEW Material valuation project stockMVER Material consumptionMLGN Material / Warehouse number

    MLGT Material / Storage typeMPRP Forecast profilesMDTB MRP tableMDKP Header data for MRP documentMLAN Tax data material masterMTQSS Material master view: QM

    3.1.1 Basic data text (sap script)

    STXB SAP script: Texts in non-SAP script format

    STXH STXDSAPSCRIPT TEXT FILE HEADER

    STXL STXD SAP script text file lines

    3.1.2 Batches

    MCHA BATCHESMCH1 BatchesMCHB Stock: batches

    3.2 Custom er master data

    KNA1 Customer masterKNB1 Customer / companyKNVV Customer sales dataKNBK Bank detailsKNVH Customer hierarchyKNVP Customer partners

    KNVS Shipment data for customerKNVK Contact persons

  • 8/10/2019 Overview of SAP Table

    9/23

    KNVI Customer master tax indicator

    3.3 Vendor

    LFA1 Vendor masterLFB1 Vendor per company codeLFB5 Vendor dunning data

    LFM1 Purchasing organization dataLFM2 Purchasing data

    LFBK Bank details

    3.4 Customermateria l info record

    KNMT Customer material info record

    3.5 Bank d ata

    BNKA MASTER BANK DATA

    4 Characteristics

    4.1 Character ist ics

    CABN Characteristics ( o.a. batch/vendor)CABNT CHARACTERISTICS DESCRIPTION

    CAWN Characteristics ( o.a. material)CAWNT Characteristics description

    AUSP Characteristic Values

    4.2 Class types and ob jects

    TCLAO Several class types for object

    TCLA Class types ( vb. lfa1 => v10 en 010)TCLAT Class type text

    TCLT Classifiable objectsTCLC Classification status

    4.3 Links

    INOB Link between Internal Number and Object

    KLAH CLASS HEADER DATAKSSK Allocation Table: Object (vb.matnr) to ClassKSML Characteristics for a class (internal number)

    5 FI/CO

    5.1 FI

    5.1.1 Master data

    SKA1 AccountsSKAT Account descriptionsSKB1 Accounts company code partBNKA Bank master record

    5.1.2 Accounting documents // indices

    BKPF Accounting documentsBSEG item levelBSID Accounting: Secondary index for customers

    BSIK Accounting: Secondary index for vendorsBSIM Secondary Index, Documents for MaterialBSIP Index for vendor validation of double documents

  • 8/10/2019 Overview of SAP Table

    10/23

    BSIS Accounting: Secondary index for G/L accountsBSAD Accounting: Index for customers (cleared items)BSAK Accounting: Index for vendors (cleared items)BSAS Accounting: Index for G/L accounts (cleared items)VBKPF Document Header for Document ParkingVBSEGA Document Segment for Document Parking - Asset Database

    VBSEGD Document Segment for Customer Document ParkingVBSEGK Document Segment for Vendor Document ParkingVBSEGS Document Segment for Document Parking - G/L Account Database

    5.1.3 Payment run

    REGUH Settlement data from payment programREGUP Processed items from payment program

    5.1.4 Dunning run

    MHND Dunning DataMHNDO Dunning data version before the next changMHNK Dunning data (account entries)

    MHNKA Version administration of dunning changesMHNKO Dunning data (acct entries) version beforeMAHNS Accounts blocked by dunning selectionMAHNV Management Records for the Dunning Program

    5.2 CO

    5.2.1 Controlling general

    TKA01 Controlling areasTKA02 Controlling area assignmentCSKA Cost elementCSKU Cost element text

    CSKB Cost element controlling area dependent partKEKO Product-costing headerKEPH Cost components for cost of goods manuf.KALO Costing objectsKANZ Sales order items - costing objects

    5.2.2 Cost center accounting

    5.2.2.1 Cost center master data

    CSKS Cost Center Master DataCSKT Cost center textsCRCO Assignment of Work Center to Cost Center

    5.2.2.2 Cost center accounting documents

    COSP CO Object: Cost Totals for External PostingsCOEP CO Object: Line Items (by Period)

    . COBK CO Object: Document headerCOST CO Object: Price Totals

    5.2.3 COPA Profitability Analysis

    CE1xxxx Line itemsCE2xxxx Planning dataCE3xxxx Period totals

  • 8/10/2019 Overview of SAP Table

    11/23

    CE4xxxx Profitability segment (index/key for CE1)

    T250x Characteristic valuesT25Ax Characteristics description

    T251x Characteristic valuesT25Bx Characteristics descriptionK9RSPxx Derivation tables

    5.2.4 Profit center accounting

    5.2.4.1 Profit center master data

    CEPC Profit Center Master DataCEPCT Profit center texts

    5.2.4.2 Profit center accounting documents

    GLPCA Actual line itemGLPCT Totals by period

    . GLPCO Object table for Account assignment elements

    GLPCC Transaction attributes

    5.2.3.4 Others

    TJ01 Business transactionsTJ01T Business transactions textsCOBRA Settlement rulesCOBRB Distribution rules Settlement rules

    6 Sales and Distribution (SD)VBFA Document flow (alg.)VTFA Flow shipping documents

    6.1 Sales o rder

    VBAK Header data

    VBAP Item dataVBPA Partners in sales orderVBKD Sales district dataVBEP Schedule lines (related to line items, delivery lines)

    6.2 Bi l l ing doc ument

    VBRK Header data

    VBRP Item data

    6.3 Shipp ing

    VTTK Shipment headerVTTP Shipment itemVTTS Stage in transportVTSP Stage in transport per shipment itemVTPA Shipment partnersVEKP Handling Unit - Header Table

    VEPO Packing: Handling Unit Item (Contents)

  • 8/10/2019 Overview of SAP Table

    12/23

    6.4 Delivery

    LIKP Delivery headerLIPS Delivery item

    6.5 Pric ing

    KONH Conditions headerKONP Conditions itemsKONV Procedure ( billing doc or sales order)KOND

    6.6 cont racts

    VEDA Contract data

    7 Material Management (MM)

    7.1 Materia l do cum ent

    MKPF Material documentMSEG Material document (item level)

    7.2 Purchasing

    EKKO Purchase document

    EKPO Purchase document (item level)EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. ItemEKET Delivery scheduleVETVG Delivery Due Index for Stock TransferEKES Order Acceptance/Fulfillment ConfirmationsEKKN Account assignment in purchasingEKAN Vendor address purchasingEKPA Partner functions

    EIPO Item export / import dataEINA Purchase info record (main data)EINE Purchase info record (organisational data)EORD Source listEBAN Purchase requisitionEBKN Purchase Requisition Account AssignmentEKBE Purchasing historyRBKP Invoice receipt headerRSEG Invoice receipt itemsRBCO Document Item, Incoming Invoice, Account AssignmentRBMA Document Item: Incoming Invoice for MaterialRBSELBEST Invoice Receipt, Purchasing Documents Selection

    (give relation invoice - PO numbers)

    See also Finance for invoice parking tables

    8 Warehouse Management (WM)

    8.1 Transfer requirement

    LTBK Transfer requirement - headerLTBP Transfer requirement - item

    8.2 Transfer o rder

    LTAK Transfer order - headerLTAP Transfer order - item

  • 8/10/2019 Overview of SAP Table

    13/23

    8.3 Master data - stock p osit ion s

    LQUA QUANTS

    8.4 Inventory documents in WM

    LINK Inventory document header

    LINP Inventory document itemLINV Inventory data per quant

    9 Quality Management (QM)

    9.1 Insp ect ion lot / info record

    QALS Inspection lot recordQAMB LINK INSPECTION LOT -MATERIAL DOCUMENT

    QAVE Inspection usage decisionQDPS Inspection stagesQMAT Inspection type - material parameters

    QINF Inspection info record (vendor - material)QDQL Quality levelQDPS Inspection stages

    9.2 Quali ty not i f icat ion

    TQ80 Notification typesQMEL Quality notification

    QMFE Quality notificationitemsQMUR Quality notificationcausesQMSM Quality notificationtasksQMMA Quality notificationactivitiesQMIH Quality message - maintenance data excerpt

    9.3 Certif icate pro fi le

    QCVMT Certificate profile characteristic level: textsQCVM Certificate profile characteristic levelQCVK Certificate profile header

    10 Production Planning (PP)

    10.1 Work center

    CRHH Work center hierarchyCRHS Hierarchy structure

    CRHD Work center headerCRTX Text for the Work Center or Production Resource/Tool

    CRCO Assignment of Work Center to Cost CenterKAKO Capacity Header SegmentCRCA Work Center Capacity AllocationTC24 Person responsible for the workcenter

    10.2 Rout ings/operat ions

    MAPL Allocation of task lists to materialsPLAS Task list - selection of operations/activitiesPLFH Task list - production resources/toolsPLFL Task list - sequences

    PLKO Task list - headerPLKZ Task list: main headerPLPH Phases / suboperations

  • 8/10/2019 Overview of SAP Table

    14/23

    PLPO Task list operation / activityPLPR Log collector for tasklistsPLMZ Allocation of BOM - items to operations

    10.3 Bil l of materia l

    STKO BOM - header

    STPO BOM - itemSTAS BOM - Item SelectionSTPN BOM - follow-up controlSTPU BOM - sub-itemSTZU Permanent BOM dataPLMZ Allocation of BOM - items to operationsMAST Material to BOM linkKDST Sales order to BOM link

    10.4 Product ion orders

    AUFK Production order headers

    AFIH Maintenance order header

    AUFM Goods movement for prod. orderAFKO Order header data PP ordersAFPO Order itemRESB Order componenten

    AFVC Order operationsAFVV Quantities/dates/values in the operationAFVU User fields of the operationAFFL Work order sequenceAFFH PRT assignment data for the work order(routing)JSTO Status profileJEST Object status

    AFRU Order completion confirmations

    PRTs voor production ordersAFFH PRT assignment data for the work orderCRVD_A Link of PRT to DocumentDRAW Document Info RecordTDWA Document TypesTDWD Data Carrier/Network Nodes

    TDWE DATA CARRIER TYPE

    10.5 Planned ord ers

    PLAF PLANNED ORDERS

    10.6 KANBAN

    PKPS Kanban identification, control cyclePKHD Kanban control cycle (header data)PKER Error log for Kanban containers

    10.7 Reservat ions

    RESB MATERIAL RESERVATIONSRKPF Header

    10.8 Capacity planning

    KBKO Header record for capacity requirementsKBED Capacity requirements recordsKBEZ Add. data for table KBED (for indiv. capacities/splits)

  • 8/10/2019 Overview of SAP Table

    15/23

    10.9 Planned independ ent requirements

    PBIM Independent requirements for materialPBED Independent requirement dataPBHI Independent requirement historyPBIV Independent requirement index

    PBIC Independent requirement index for customer req.

    11 Project system (PS)

    11.1 Basic data

    PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)PROJ Project definitionPRPS WBS (Work Breakdown Structure) Element Master Data

    PRTE Scheduling dataAUFK Order and network headersAFKO Production orders / networksAFVC Network activities / operationsAFVU Structure of user fields of Network activities / operationsAFVV Structure of quantities/dates/values in Network activities / operationsRESB Network Components / ReservationsMLST Milestones

    RPSCO Project info database: Costs, revenues, financesRPSQT Project info database; QuantitiesCOSP Cost totals for external postingsCOSS Cost totals for internal postingsCOSB Total variances/ result analysisCOEP Actual line itemsCOOI Commitment line items

    BPGE Budget, overall costBPJA Budget, annual valuesQBEW Project stock valuationMSPR Project stock (including non-valuated)

    11.2 Equipment

    EQUI Equipment master dataEQKT Equipment short textEQUZ Equipment time segment

    12 Plant maintenance (PM)IHPA Plant Maintenance: PartnersOBJK Plant Maintenance Object List

    ILOA PM Object Location and Account AssignmentAFIH Maintenance order header

    12.1 Human resources

    12.2 Sett ings

    T582A Infotypes: Customer-Specific Settings

    12.3 Master data

    T527X Organizational UnitsT528T Position Texts

  • 8/10/2019 Overview of SAP Table

    16/23

    T554T Attendance and Absence TextsT501 Employee groupT503 Employee group, subgroupT503K Employee subgroupT510N Pay Scales for Annual Salaries (NA)T549A Payroll Accounting AreasT750X Vacancy

    12.4 Infotypes

    PA0001 Org. AssignmentPA0002 Personal DataPA0006 AddressesPA0007 Planned Working TimePA0016 Contract elementsPA0008 Basic payPA0105 CommunicationsPA1007 VacanciesPA1035 TrainingPA2001 Absences

    13 Other important tableJEST System Status with object numberTJ02 System status description.

    14 MRP RelatedMDKP Header Data for MRP DocumentMDTB MRP TableMDVL Planning file entry for long term planningMDVM Entry in MRP filePBVPV Material Index for consumption of planningREUL Material stock transfer reservation index

    SAFK Run schedule master dataSQ01 Abap queryEDMSG ALE message type table

    Details showing important Tables in SAP

    TABLE NAME Description Important Fields

    Financial

    Account ingFBAS

    Financial Accounting Basis

    BKPF Accounting Document Header MANDT / BUKRS / BELNR /

    GJAHR

    BSEG Accounting Document Segment MANDT / BUKRS / BELNR / GJAHR /

    BUZEI

    BSIP Index for Vendor Validation of

    Double Documents

    MANDT / BUKRS / LIFNR / WAERS /

    BLDAT / XBLNR / WRBTR / BELNR /

    GJAHR / BUZEI

  • 8/10/2019 Overview of SAP Table

    17/23

    BVOR Inter Company Posting Procedure MANDT / BVORG / BUKRS / GJAHR /

    BELNR

    EBKPF Accounting Document Header (docs

    from External Systems)

    MANDT / GLSBK / BELNR / GJHAR /

    GLEBK

    FRUN Run Date of a Program MANDT / PRGID

    KLPA Customer / Vendor Linking MANDT / NKULI / NBUKR / NKOAR /

    PNTYP / VKULI / VBUKR / VKOAR

    KNB4 Customer Payment History MANDT / KUNNR / BUKRS

    KNB5 Customer Master Dunning Data MANDT / KUNNR / BUKRS / MABER

    KNBK Customer Master Bank Details MANDT / KUNNR / BANKS / BANKL /

    BANKN

    KNC1 Customer Master Transaction

    Figures

    MANDT / KUNNR / BUKRS / GJHAR

    KNC3 Customer Master Special GL

    Transactions Figures

    MANDT / KUNNR / BUKRS / GJAHR /

    SHBKZ

    LFB5 Vendor Master Dunning Data MANDT / LIFNR / BUKRS / MABER

    LFBK Vendor Master Bank Details MANDT / LIFNR / BANKS / BANKL /

    BANKN

    LFC1 Vendor Master Transaction Figures MANDT / LIFNR / BUKRS / GJHAR

    LFC3 Vendor Master Special GL

    Transactions Figures

    MANDT / LIFNR / BUKRS / GJHAR /

    SHBKZ

    VBKPF Document Header for Document

    Parking

    MANDT / AUSBK / BUKRS / BELNR /

    GJHAR

    FBASCOREFinancial Accounting General

    Services Basis

    KNB1 Customer Master (Company Code) MANDT / KUNNR / BUKRS

    LFA1 Vendor Master (General Section) MANDT / LIFNR

    LFB1 Vendor Master (company Code

    Section)

    MANDT / LIFNR / BUKRS

    SKA1 G/L Account Master (Chart of

    Accounts)

    MANDT / KTOPL / SAKNR

    SKAT G/L Account Master (Chart of

    Accounts Description)

    MANDT / SPRAS / KTOPL / SAKNR

  • 8/10/2019 Overview of SAP Table

    18/23

    MAHNS Accounts Blocked by Dunning

    Selection

    MANDT / KOART / BUKRS / KONKO /

    MABER

    MHNK Dunning Data (Account Entries) MANDT / LAUFD / LAUFI / KOART /

    BUKRS / KUNNR / LIFNR / CPDKY /

    SKNRZE / SMABER / SMAHSK / BUSAB

    FI-GL-GL (FBS) General Ledger Accounting:

    Basic Functions- G/L Accounts

    SKAS G/L Account Master (Chart of

    Accounts Key Word list)

    MANDT / SPRAS / KTOPL / SAKNR /

    SCHLW

    SKB1 G/L Account Master (Company

    Code)

    MANDT / BUKRS / SAKNR

    FI-GL-GL (FBSC) General Ledger Accounting:

    Basic Functions - R/3

    Customizing for G/L Accounts

    FIGLREP Settings for G/L Posting Reports MANDT

    TSAKR Create G/L account with reference MANDT / BUKRS / SAKNR

    FI-GL-GL (FFE) General Ledger Accounting:

    Basic Functions - Fast Data

    Entry

    KOMU Account Assignment Templates forG/L Account items

    MANDT / KMNAM / KMZEI

    FI-AR-AR (FBD)Accounts Receivable: Basic

    Functions - Customers

    KNKA Customer Master Credit

    Management : Central Data

    MANDT / KUNNR

    KNKK Customer Master Credit

    Management : Control Area Data

    MANDT / KUNNR / KKBER

    KNKKF1 Credit Management : FI Status data MANDT / LOGSYS / KUNNR / KKBER /

    REGUL

    RFRR Accounting Data A/R and A/P

    Information System

    MANDT / RELID / SRTFD / SRTF2

    FI-BL-PT

    (BFIBL_CHECK_D) Bank Accounting: Payment

    TransactionsGeneral Sections

    PAYR Payment Medium File MANDT / ZBUKR / HBKID / HKTID /

    RZAWE / CHECT

    PCEC Pre-numbered Check MANDT / ZBUKR / HBKID / HKTID /

  • 8/10/2019 Overview of SAP Table

    19/23

    STAPL

    FI-BL-PT-

    AP(FMZA)

    Bank Accounting: Payment

    Transactions Automatic

    Payments

    F111G Global Settings for Payment

    Program for Payment Requests

    MANDT

    FDZA Cash Management Line Items in

    Payment Requests

    MANDT / KEYNO

    PAYRQ Payment Requests MANDT / KEYNO

    FI-AA-AA (AA )Asset Accounting: Basic

    FunctionsMaster Data

    ANKA Asset Classes: General Data MANDT / ANLKL

    ANKP Asset Classes: Fld Cont Dpndnt on

    Chart of Depreciation

    MANDT / ANLKL / AFAPL

    ANKT Asset Classes: Description MANDT / SPRAS / ANLKL

    ANKV Asset Classes: Insurance Types MANDT / ANLKL / VRSLFD

    ANLA Asset Master Record Segment MANDT / BUKRS / ANLN1 / ANLN2

    ANLB Depreciation Terms MANDT / BUKRS / ANLN1 / ANLN2 /

    AFABE / BDATU

    ANLT Asset Texts MANDT / SPRAS / BUKRS / ANLN1 /

    ANLN2

    ANLU Asset Master Record User Fields .INCLUDE / MANDT / BUKRS / ANLN1

    / ANLN2

    ANLW Insurable Values (Year Dependent) MANDT / BUKRS / ANLN1 / ANLN2 /

    VRSLFD / GJAHR

    ANLX Asset Master Record Segment MANDT / BUKRS / ANLN1 / ANLN2

    ANLZ Time Dependent Asset Allocations MANDT / BUKRS / ANLN1 / ANLN2 /

    BDATU

    FI-AA-AA (AA 2)Asset Accounting: Basic

    FunctionsMaster Data2.0

    ANAR Asset Types MANDT / ANLAR

    ANAT Asset Type Text MANDT / SPRAS / ANLAR

  • 8/10/2019 Overview of SAP Table

    20/23

    FI-AA-AA (AB )Asset Accounting: Basic

    FunctionsAsset Accounting

    ANEK Document Header Asset Posting MANDT / BUKRS / ANLN1 / ANLN2 /

    GJAHR / LNRAN

    ANEP Asset Line Items MANDT / BUKRS / ANLN1 / ANLN2 /

    GJAHR / LNRAN / AFABE

    ANEV Asset Downpymt Settlement MANDT / BUKRS / ANLN1 / ANLN2 /

    GJAHR / LNRANS

    ANKB Asset Class: Depreciation Area MANDT / ANLKL / AFAPL / AFABE /

    BDATU

    ANLC Asset value Fields MANDT / BUKRS / ANLN1 / ANLN2 /

    GJAHR / AFABE

    ANLH Main Asset Number MANDT / BUKRS / ANLN1

    ANLP Asset Periodic Values MANDT / BUKRS / GJAHR / PERAF /

    AFBNR / ANLN1 / ANLN2 / AFABER

    FI-SL-VSR (GVAL )Special Purpose Ledger:

    Validation, Substitution and

    Rules

    GB03 Validation / Substitution User VALUSER

    GB92 Substitutions MANDT / SUBSTID

    GB93 Validation MANDT / VALID

    Controlling

    AUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHL /

    MAFID / KLART / ADZHL

    CO-KBAS Overhead Cost Contro l l ing

    A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS /

    VERSN / RESRC / KOSTL / DATBI

    A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS /

    VERSN / RESRC / DATBI

    A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS /

    VERSN / RESRC / LAND1 / REGIO /

    DATBI

    COSC CO Objects: Assignment of Original

    Costing Sheets

    MANDT / OBJNR / SCTYP / VERSN /

    GJAHR

    CSSK Cost Center / Cost Element MANDT / VERSN / KOKRS / GJAHR /KOSTL / KSTAR

  • 8/10/2019 Overview of SAP Table

    21/23

    CSSL Cost Center / Activity Type MANDT / KOKRS / KOSTL / LSTAR /

    GJAHR

    KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN /

    VRGNG / PERBL

    CO-KBASCORE Overhead Cost Contro l l ing:

    General Services

    CSKA Cost Elements (Data Dependent on

    Chart of Accounts)

    MANDT / KTOPL / KSTAR

    CSKB Cost Elements (Data Dependent on

    Controlling Area)

    MANDT / KOKRS / KSTAR / DATBI

    CSKS Cost Center Master Data MANDT / KOKRS / KOSTL / DATBI

    CSLA Activity Master MANDT / KOKRS / LSTAR / DATBI

    CO-OM (KACC) Overhead Cost Contro l l ing

    COBK CO Object: Document Header MANDT / KOKRS / BELNR

    COEJ CO Object: Line Items (by Fiscal

    Year)

    MANDT / KOKRS / BELNR / BUZEI /

    PERBL

    COEJL CO Object: Line Items for Activity

    Types (by Fiscal Yr)

    MANDT / KOKRS / BELNR / BUZEI /

    PERBL

    COEJR CO Object: Line Items for SKF (by

    Fiscal Year)

    MANDT / KOKRS / BELNR / BUZEI /

    PERBL

    COEJT CO Object: Line Items for Prices (by

    Fiscal Year)

    MANDT / KOKRS / BELNR / BUZEI /

    PERBL

    COEP CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI

    COEPL CO Object: Line Items for Activity

    Types (by Period)

    MANDT / KOKRS / BELNR / BUZEI

    COEPR CO Object: Line Items for SKF (byPeriod)

    MANDT / KOKRS / BELNR / BUZEI

    COEPT CO Object: Line Items for Prices (by

    Period)

    MANDT / KOKRS / BELNR / BUZEI

    COKA CO Object: Control Data for Cost

    Elements

    MANDT / OBJNR / GJAHR / KSTAR /

    HRKFT

    COKL CO Object: Control Data for Activity

    Types

    MANDT / LEDNR / OBJNR / GJAHR /

    VERSN

    COKP CO Object: Control Data for Primary MANDT / LEDNR / OBJNR / GJAHR /

  • 8/10/2019 Overview of SAP Table

    22/23

    Planning WRTTP / VERSN / KSTAR / HRKFT /

    VRGNG / VBUND / PARGB / BEKNZ /

    TWAER

    COKR CO Object: Control Data for

    Statistical Key Figures

    MANDT / LEDNR / OBJNR / GJAHR /

    WRTTP / VERSN / STAGR / HRKFT /VRGNG

    COKS CO Object: Control Data for

    Secondary Planning

    MANDT / LEDNR / OBJNR / GJAHR /

    WRTTP / VERSN / KSTAR / HRKFT /

    VRGNG / PAROB / USPOB / BEKNZ /

    TWAER

    CO-OM-CEL

    (KKAL)

    Cost Element Accounting

    (Reconciliation Ledger)

    COFI01 Object Table for Reconciliation

    Ledger COFIT

    MANDT / OBJNR

    COFI02 Transaction Dependent Fields for

    Reconciliation Ledger

    MANDT / OBJNR

    COFIP Single Plan Items for Reconciliation

    Ledger

    RCLNT / GL_SIRID

    COFIS Actual Line Items for Reconciliation

    Ledger

    RCLNT / GL_SIRID

    CO-OM-CCA Cost Center Accounting (CostAccounting Planning RK-S)

    What is RK-S

    A138 Price per Company Code MANDT / KAPPL / KSCHL / KOKRS

    / VERSN / RESRC / BUKRS / GSBER /

    DATBI

    A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS

    / VERSN / RESRC / PRCTR / DATBI

    CO-OM-OPA(KABR)

    Overhead Orders: ApplicationDevelopment R/3 Cost

    Accounting Settlement

    AUAA Settlement Document: Receiver

    Segment

    MANDT / BELNR / LFDNR

    AUAB Settlement Document: Distribution

    Rules

    MANDT / BELNR / BUREG / LFDNR

    AUAI Settlement Rules per Depreciation

    Area

    MANDT / BELNR / LFDNR / AFABE

  • 8/10/2019 Overview of SAP Table

    23/23

    AUAK Document Header for Settlement MANDT / BELNR

    AUAO Document Segment: CO Objects to

    be Settled

    MANDT / BELNR / LFDNR

    AUAV Document Segment: Transactions MANDT / BELNR / LFDNR

    COBRA Settlement Rule for Order

    Settlement

    MANDT / OBJNR

    COBRB Distribution Rules Settlement Rule

    Order Settlement

    MANDT / OBJNR / BUREG / LFDNR

    CO-OM-

    OPA(KAUF)

    Overhead Orders: Cost

    Accounting Orders

    AUFK Order Master Data MANDT / AUFNR

    AUFLAY0 Enttity Table: Order Layouts MANDT / LAYOUT

    EC-PCA (KE1)Profit Center Accounting

    CEPC Profit Center Master Data Table MANDT / PRCTR / DATBI / KOKRS

    CEPCT Texts for Profit Center Master Data MANDT / SPRAS / PRCTR / DATBI /

    KOKRS

    CEPC_BUKRS Assignment of Profit Center to a

    Company Code

    MANDT / KOKRS / PRCTR / BUKRS

    GLPCA EC-PCA: Actual Line Items RCLNT / GL_SIRID

    GLPCC EC-PCA: Transaction Attributes MANDT / OBJNR

    GLPCO EC-PCA: Object Table for Account

    Assignment Element

    MANDT / OBJNR

    GLPCP EC-PCA: Plan Line Items RCLNT / GL_SIRID

    EC-PCA BS (KE1C) PCA Basic Settings:

    Customizing for Profit CenterAccounting

    A141 Dependent on Material and Receiver

    Profit Center

    MANDT / KAPPL / KSCHL / KOKRS /

    WERKS / MATNR / PPRCTR / DATBI

    A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS /

    MATNR / DATBI

    A143 Dependent on Material Group MANDT / KAPPL / KSCHL / WERKS /

    MATKL / DATBI