SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

61 columns | Print definition?ERP 6.0  | CATEG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPT_IMS_LOGIMS Log Data Table22CATEGCategory Attachmentnvarchar10
2BBP_PDATTDocument Attachment16CATEGCategory Attachmentnvarchar10
3BBP_TRANS_ARCATBBP: Transient Storage of Archived Attachments18CATEGCategory Attachmentnvarchar10
4P2RB_I0125Garnishment payroll Belgium47CATEGIntegration Income Categorynvarchar10
5T5FDSNOPSTYDefinition of types of OPS (Social Protection Agencies)7CATEGCategory of a type of OPS (Social Protection Agency)nvarchar20
6T5FPBS4DCatégorie2CATEGCatégorienvarchar10
7T5FPBS4DTTextes Catégorie3CATEGCatégorienvarchar10
8T5FPBS4GGrade6CATEGCatégorienvarchar10
9T5FPBSD8Codes officiels de la décision5CATEGCatégorie Code officiel de la décisionnvarchar40
10T7BREFD_EELINFEmployee legal information6CATEGWorker categorynvarchar30
11T7BREFD_EEWERTInfo termination employee with no employment relationship7CATEGWorker categorynvarchar30
12T7BREFD_PYREMEmployee remuneration information16CATEGWorker categorynvarchar30
13T7BREFD_PYTOTTotaling of worker's remuneration6CATEGWorker categorynvarchar30
14T7NZCATEmployee Categories2CATEGEmployee Categorynvarchar10
15T7NZCATTEmployee Categories Description3CATEGEmployee Categorynvarchar10
16T7NZCTEmployee Categories - NZ4CATEGEmployee Categorynvarchar10
TOPActual CostingMaterial Ledger
17CKMLKEKOMaterial Ledger: Cost Component Split (Header)6CATEGCategory in Material Ledger Data Displaynvarchar20
18CKMLKEPHMaterial Ledger: Cost Component Split (Elements)6CATEGCategory in Material Ledger Data Displaynvarchar20
19CKMLSCHEMADefinition of Key Figure Scheme in Material-Ledger3CATEGCategory in Material Ledger Balance Sheet Valuationnvarchar20
20FCML_CCS_REPHDB Reporting Structure for ML7CATEGCategory in Material Ledger Data Displaynvarchar20
21FCML_REPML Reporting Structure7CATEGCategory in Material Ledger Data Displaynvarchar20
22MLCDMaterial Ledger: Summarization Record (from Documents)6CATEGCategory in Material Ledger Data Displaynvarchar20
TOPAlternative Valuation Run
23CKMLRUNSCALERe-scaling Amounts in the AVR7CATEGCategory in Material Ledger Data Displaynvarchar20
24MLAVRSCALERe-scaling Amounts AVR11CATEGCategory in Material Ledger Data Displaynvarchar20
25MLAVRSCALEKEPHCost Component Split of Re-scaling Amounts AVR11CATEGCategory in Material Ledger Data Displaynvarchar20
TOPAssortment
26WRF_APC_MPAMarkdown Profile Assignment9CATEGCategorynvarchar180
TOPBelgium
27PA0125HR Master Record: Infotype 0125 (Garnishment B)54CATEGIntegration Income Categorynvarchar10
28T5BSB1HR-Belgium: Social Balance SAP Code Attributes7CATEGDeclaration Data Categorynvarchar40
TOPCompensation Management
29T71C0Compensation Component3CATEGCompensation categorynvarchar10
30T71CCTo be deleted - no longer used!6CATEGProcess for Activating Variable Compensation Adjustmentsnvarchar10
31T71TCS1TCS category2CATEGTotal Compensation Statement Categorynvarchar30
32T71TCS1ATCS category attribute2CATEGTotal Compensation Statement Categorynvarchar30
33T71TCS1TTCS category text3CATEGTotal Compensation Statement Categorynvarchar30
34T71TCS2TCS subcategories2CATEGTotal Compensation Statement Categorynvarchar30
35T71TCS2ATCS subcategory attributes2CATEGTotal Compensation Statement Categorynvarchar30
36T71TCS2TTCS subcategory text3CATEGTotal Compensation Statement Categorynvarchar30
TOPFinland
37T7FIA5ATS Categories2CATEGCategory (ATS)nvarchar50
38T7FIA5TCategory Texts (ATS)3CATEGCategory (ATS)nvarchar50
TOPFrance
39T5F1ASI organizations (France)5CATEGInsur. org. categorynvarchar30
40T5F4NAgency indicator check table3CATEGnvarchar30
TOPFree Goods
41KONBBYHBonus Buys: Header7CATEGBonus buy categorynvarchar10
TOPIncentive and Commission Management ICM
42TCACS_TGCTarget Agreement: Target Category3CATEGTarget Agreement: Target Categorynvarchar40
43TCACS_TGCLCTarget Agreement: Classification Category3CATEGTarget Agreements: Target Classification Categorynvarchar40
44TCACS_TGCLCTTarget Agreement: Classification Category Texts4CATEGTarget Agreements: Target Classification Categorynvarchar40
45TCACS_TGCLTTarget Agreement: Classification Type5CATEGTarget Agreements: Target Classification Categorynvarchar40
46TCACS_TGCTTarget Agreement: Target Category Texts4CATEGTarget Agreement: Target Categorynvarchar40
47TCACS_TGTTarget Agreements: Complex Target Type5CATEGTarget Agreement: Target Categorynvarchar40
TOPLocalization
48CIS_VF_EXTExtension Table for CIS Sub contractors4CATEGSubcontractor's Business Typenvarchar120
TOPPension fund General Parts
49T72A9HR-PF: Total Compensation Statement Integration5CATEGTotal Compensation Statement Categorynvarchar30
TOPProject Risk Management for Contractors
50/SAPPCE/HRP1961DB table for info type 196121CATEGCategory 1nvarchar20
51/SAPPCE/TORG01Category 12CATEGCategory 1nvarchar20
52/SAPPCE/TORG01TText for Category 13CATEGCategory 1nvarchar20
TOPPublic Sector
53T5VPPS_CATEligibilty Category for Norway Public Sector3CATEGEligibility Category for Norway Public Sectornvarchar40
54T5VPPS_CATTEligibilty Category for Norway Public Sector- Text4CATEGEligibility Category for Norway Public Sectornvarchar40
55T5VPPS_ELG_CATEligibility Category with Values for Norway Public Sector3CATEGEligibility Category for Norway Public Sectornvarchar40
TOPReuse Services for Country Development
56T799L30HCM Log category structure enhancements2CATEGHR Application Log: Category IDnvarchar60
TOPSouth Africa
57T5W9CCategories of Labour Relations interventions3CATEGLabour Relations Categorynvarchar20
58T5W9CTText - Categories for Labour Relations types4CATEGLabour Relations Categorynvarchar20
59T5W9RReasons for Labour Relations interventions4CATEGLabour Relations Categorynvarchar20
TOPSpain
60T5E48Groups of professional categories4CATEGProfessional categorynvarchar30
61T5E8SAssignation of professional categories to modifiers4CATEGProfessional categorynvarchar30