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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

59 columns | Print definition?ERP 6.0  | COSTCENTER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_MDOC_ITMMaterial Document Item for Tracking24COSTCENTERCost Centernvarchar100
2BBP_COSTCENT_FAVUser-Specific Favorites for Permitted Cost Centers4COSTCENTERCost Centernvarchar100
3BBP_PCACCProcurement Card: Accounting Data16COSTCENTERCost Centernvarchar100
4BBP_PCMODProcurement Card: Modified Statement Data18COSTCENTERCost Centernvarchar100
5BBP_USR01Internet user data39COSTCENTERCost Centernvarchar100
6GRACREQUSERADRUser Communication Fields8COSTCENTERCost Centernvarchar400
7ODFIN_MAP_KOSTLKey Mapping Cost Center - Cost Center4COSTCENTERCost Center for key mappingnvarchar200
8ZPPMC_DPR_COSTPLBewegungsdaten für die Sachkostenplanung in cProjects5COSTCENTERCost Centernvarchar100
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
9CRMAHRData on Persons6COSTCENTERAddresses: Cost centernvarchar100
10CRMCHKRESLFindings (Display LoaD)33COSTCENTERAddresses: Cost centernvarchar100
TOPAccrual Engine
11ACEDSASSGMTStandard Account Assignments for Accrual Objects10COSTCENTERCost Centernvarchar100
TOPAP-LIM Logistics Inventory Management Engine
12/LIME/COLL_APSCollection for Planning System90COSTCENTERCost Centernvarchar100
13/LIME/COLL_BWCollection for Business Warehouse90COSTCENTERCost Centernvarchar100
14/LIME/COLL_FINCollection for Financial System90COSTCENTERCost Centernvarchar100
15/LIME/COLL_INVCollection for Inventory System90COSTCENTERCost Centernvarchar100
16/LIME/COLL_LEGCollection for External System90COSTCENTERCost Centernvarchar100
17/LIME/COLL_MMIMCollection for R/3 Inventory Management90COSTCENTERCost Centernvarchar100
18/LIME/COLL_W2IMCollection for WME after ERP-MMIM90COSTCENTERCost Centernvarchar100
TOPBasis Components
19/XFT/INV_Q_11Account assignment data17COSTCENTERCost Centernvarchar100
20/XFT/INV_Q_11_SAccount assignment data17COSTCENTERCost Centernvarchar100
TOPCross-Application Components
21ETP_PARTNERTask Partner9COSTCENTERCost Centernvarchar100
TOPDefense Forces and Public Security
22PA0800Personal Master Record Infotype 080069COSTCENTERCost Centernvarchar100
TOPDepreciation Simulation
23IMCCIM Summarization: Characteristics that are master data15COSTCENTERIM Summarization: Requesting cost centernvarchar100
24IMCECCIM Summarization: Cost centers3COSTCENTERIM Summarization: Requesting cost centernvarchar100
25IMCECCTIM Summarization: Texts for cost centers4COSTCENTERIM Summarization: Requesting cost centernvarchar100
TOPE-Recruiting
26HRP5125DB Table for Infotype 512523COSTCENTERCost Centernvarchar100
TOPGrantee Management
27GMIAActual Line Item Table46COSTCENTERCost Centernvarchar100
TOPIncentive and Commission Management ICM
28CACS00_DOCFI_PData Transfer: FI Documents (Items)11COSTCENTERCost Centernvarchar100
29CACSHR_DOCHR_TXSettlement to PY: Reference Document Tax9COSTCENTERCost Centernvarchar100
30YCRM01_ACCASAccount Assignment Type/Cost Information for Remuneration11COSTCENTERCost Centernvarchar100
31YCRM01_ACCSTAccount Assignment Type/Cost Info for Settlement Types7COSTCENTERCost Centernvarchar100
32YCRM01_DOCFI_PData Transfer: FI Documents Item13COSTCENTERCost Centernvarchar100
33YHITEC_DOCFI_PData Transfer: FI Documents Item11COSTCENTERCost Centernvarchar100
34YSVMA_ACCASAccount Assignment Type/Cost Information for Remuneration12COSTCENTERCost Centernvarchar100
35YSVMA_ACCSTAccount Assignment Type/Cost Info for Settlement Types15COSTCENTERCost Centernvarchar100
36YSVMA_DOCFI_PData Transfer: FI Documents (Items)11COSTCENTERCost Centernvarchar100
37YTEL01_ACCASAccount Assignment Type/Cost Information for Remuneration12COSTCENTERCost Centernvarchar100
38YTEL01_ACCSTAccount Assignment Type/Cost Info for Settlement Types5COSTCENTERCost Centernvarchar100
39YTEL01_DOCFI_PData Transfer: FI Documents Item11COSTCENTERCost Centernvarchar100
40YTEL05_ACCASAccount Assignment Type/Cost Information for Remuneration12COSTCENTERCost Centernvarchar100
41YTEL05_ACCSTAccount Assignment Type/Cost Info for Settlement Types13COSTCENTERCost Centernvarchar100
42YTEL05_DOCFI_PData Transfer: FI Documents (Items)11COSTCENTERCost Centernvarchar100
43ZICMAG_ACCASAccount Assignment Type/Cost Information for Remuneration6COSTCENTERCost Centernvarchar100
44ZICMAG_ACCSTAccount Assignment Type/Cost Info for Settlement Types7COSTCENTERCost Centernvarchar100
45ZICMAG_DOCFI_PData Transfer: FI Documents (Items)11COSTCENTERCost Centernvarchar100
TOPLegal Case Management for ILM
46LHM_CASE_ATTRTable with Additional Attributes for Legal Hold Cases5COSTCENTERCost Centernvarchar100
47SLHM_CASE_HEADLegal Hold Management - Cases (Header Data)9COSTCENTERCost Centernvarchar100
TOPPersonnel Time Management
48PTARQ_EXTRA_INFOLeave Request: Additional Fields for Attendances/Absences6COSTCENTERCost Centernvarchar100
TOPRental Accounting
49VIEXCFCNDNSCash Flow Summarization38COSTCENTERCost Centernvarchar100
TOPSAP Business Workflow
50SWH_ABSENCEWorkflow: Demo for Workflow Infos7COSTCENTERCost centernvarchar100
51SWXFORMABSForm: Notification of Absence10COSTCENTERCost centernvarchar100
TOPSAP Retail Store
52WOSCR_EXI_ST_02Vendor Invoice - Store Settings (FI/CO)4COSTCENTERCost Centernvarchar100
53WOSCR_SITE_GRPCash Balancing: Settings for Each Group of Accounts5COSTCENTERCost Centernvarchar100
54WSGM_ITEM_DB_TMPSRS GM: Temporary Persistence for Item Data16COSTCENTERCost Centernvarchar100
55WSGR_ITEM_DB_TMPSRS GR: Temporary Persistence for Item Data15COSTCENTERCost Centernvarchar100
56WSMAN_PT_BUFFERStore Manager Portal: Buffer for Availability Display6COSTCENTERCost Centernvarchar100
57WSRS_DB_PLNT_CCSAP Retail Store: Assignment of Cost Centers to Plants4COSTCENTERCost Centernvarchar100
TOPTravel Expenses
58PTRV_COMM_ITMHeader Data: Transfer to FM When Trip Saved18COSTCENTERCost Centernvarchar100
59PTRV_SCOSTrip Statistics - Cost Assignment9COSTCENTERCost Centernvarchar100