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

35 columns | Print definition?ERP 6.0  | SGRANT_NBR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_C1HCM Declustering B2 - Cost Distribution Table C146SGRANT_NBRSender Grantnvarchar200
2P2PL_RETROADJPayroll Result PL: Retro, originals and changes56SGRANT_NBRSender Grantnvarchar200
3P2PL_RETRODIFPayroll Result PL: Retro, originals and changes56SGRANT_NBRSender Grantnvarchar200
4P2PL_RETROMEMPayroll Result PL: Retro, originals and changes56SGRANT_NBRSender Grantnvarchar200
5P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)63SGRANT_NBRSender Grantnvarchar200
6P2RT_CZDAVP18_0347SGRANT_NBRSender Grantnvarchar200
7P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)63SGRANT_NBRSender Grantnvarchar200
8P2RX_C1Cost Distribution Table C144SGRANT_NBRSender Grantnvarchar200
TOPConstruction Industry
9T5DBVConstruction Pay: Cost Assignment: Hostels43SGRANT_NBRSender Grantnvarchar200
10T5DBXConstruction Pay: Incentive Wage Connection43SGRANT_NBRSender Grantnvarchar200
TOPControlling
11COPPP_ITMCO Postprocessing List - Items23SGRANT_NBRSender Grantnvarchar200
TOPCost Element Accounting
12COFIPSingle plan items for reconciliation ledger32SGRANT_NBRSender Grantnvarchar200
13COFISActual line items for reconciliation ledger32SGRANT_NBRSender Grantnvarchar200
14COFITTotals Records for Reconciliation Ledger31SGRANT_NBRPartner Grantnvarchar200
TOPFund Accounting
15FMGLFLEX06General ledger: Sender SAP additional account assignment6SGRANT_NBRPartner Grantnvarchar200
16FMGLFLEXAGeneral Ledger: Actual Line Items24SGRANT_NBRPartner Grantnvarchar200
17FMGLFLEXPGeneral Ledger: Plan Line Items26SGRANT_NBRPartner Grantnvarchar200
18FMGLFLEXTGeneral Ledger Public Sector: Total33SGRANT_NBRPartner Grantnvarchar200
19PSGLFLEX06General ledger: Sender SAP additional account assignment6SGRANT_NBRPartner Grantnvarchar200
20PSGLFLEXAGeneral Ledger: Actual Line Items26SGRANT_NBRPartner Grantnvarchar200
21PSGLFLEXPGeneral Ledger: Plan Line Items28SGRANT_NBRPartner Grantnvarchar200
22PSGLFLEXTGeneral Ledger Public Sector: Total35SGRANT_NBRPartner Grantnvarchar200
TOPFunds Management
23FMCHA1Work List for Reassignment Tool22SGRANT_NBRGrantnvarchar200
24FMSPLITAActual line item table31SGRANT_NBRPartner Grantnvarchar200
25FMSPLITPPlan line items table31SGRANT_NBRPartner Grantnvarchar200
26FMSPLITTSummary table32SGRANT_NBRPartner Grantnvarchar200
TOPMaster Data
27GMOMDGrants Management Object Mapper Table7SGRANT_NBRIncoming Grantnvarchar200
TOPPayroll
28T5TPSC1SPLITRozdelení nákladu54SGRANT_NBRGrant-odesilatelnvarchar200
TOPPersonnel Time Management
29ASSOBAssignment Objects42SGRANT_NBRSender Grantnvarchar200
30COIFTInterface to Activity Allocation74SGRANT_NBRSender Grantnvarchar200
31PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)76SGRANT_NBRSender Grantnvarchar200
32PTEX2003GENInterface Table for IT 2003: General Information75SGRANT_NBRSender Grantnvarchar200
33PTEX2003SPECInterface Table for IT 2003: Interval Information51SGRANT_NBRSender Grantnvarchar200
34PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)75SGRANT_NBRSender Grantnvarchar200
TOPTravel Planning
35FTPT_REQ_ACCOUNTTravel Request Cost Assignment46SGRANT_NBRSender Grantnvarchar200