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

56 columns | Print definition?ERP 6.0  | PSTAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table200PSTATMaintenance statusnvarchar150
2/SMERP/STG_MM002Data staging - Material storage location view complex table201PSTATMaintenance statusnvarchar150
3DFKKPDCFI-CA: Postdated Checks4PSTATStatus of Postdated Checknvarchar10
4DFKKPDCSFI-CA: Status Changes for Postdated Checks4PSTATStatus of Postdated Checknvarchar10
5FIAPSAD_ORDR_HDOrder Number Header KSA15PSTATProcessing Status for Payment Ordernvarchar10
6P2RN_NARGPayroll Results: Add. Terms of Employment12PSTATPayment Statusnvarchar10
7PA0624HR Master Record: Infotype 062425PSTATMembership Statusnvarchar30
8T130CDefinition of required tables5PSTATMaintenance statusnvarchar150
9T130DScreen data3PSTATMaintenance statusnvarchar150
10T130MTransaction control parameters: material master maintenance4PSTATMaintenance statusnvarchar150
11T130OSAP components for material master record maintenance6PSTATMaintenance statusnvarchar150
12T131VChange code plus maintenance status3PSTATMaintenance statusnvarchar150
13T138VVersions for Mass Change: Material Master Records2PSTATMaintenance statusnvarchar150
14T589AStatus and Input Mode in Screen Painter Screens3PSTATGUI status assigned to operationnvarchar200
15T5GPBSQ_STAMembership Status3PSTATMembership Statusnvarchar30
16ZEIMMARAUSING FOR STORING EIM MARA DATAS8PSTATMaintenance statusnvarchar150
TOPBasic Data
17NC301RIS-H: EDI Other Inbound Data for Misc. Evaluation/Display30PSTATIS-H: Processing statusnvarchar20
TOPBudget Management
18HRPMPROTHR-FPM Log Table18PSTATProcessing statusnvarchar10
TOPChina
19PA0528HR Master Record: Infotype 0528 (Family information)38PSTATPolitical statusnvarchar20
20PA0534HR Master Record: Infotype 0534 (Party Infomation)30PSTATParty statusnvarchar10
TOPCross-Application Components
21MMARAGeneral material data8PSTATMaintenance statusnvarchar150
22MMARCPlant Data for Material4PSTATMaintenance statusnvarchar150
TOPData Collection
23CF003Projects20PSTATStatus of projectnvarchar20
TOPEnterprise Compensation Management
24T71ADM_PROCESSCompensation Tracking for Process10PSTATInternal status of the planning for an organizational unitnvarchar10
TOPFinancial Accounting
25FBICRC001AICRC: Open Items GL Accounts: Documents39PSTATProcessing Statusnvarchar30
26FBICRC002AICRC: GL Accounts: Documents39PSTATProcessing Statusnvarchar30
27FBICRC003AICRC: Open Items Customers/Vendors: Documents40PSTATProcessing Statusnvarchar30
TOPMaster Data
28MDMAMRP Area for Material40PSTATMaintenance statusnvarchar150
TOPMaterial Master
29MARAGeneral Material Data8PSTATMaintenance statusnvarchar150
30MARA_TMPFile for Incorrect Data in Direct Input15PSTATMaintenance statusnvarchar150
31MARCPlant Data for Material4PSTATMaintenance statusnvarchar150
32MARC_TMPFile for Incorrect Data in Direct Input7PSTATMaintenance statusnvarchar150
33MARDStorage Location Data for Material5PSTATMaintenance statusnvarchar150
34MARD_TMPFile for Incorrect Data in Direct Input8PSTATMaintenance statusnvarchar150
35MBEWMaterial Valuation65PSTATMaintenance statusnvarchar150
36MBEW_TMPFile for Incorrect Data in Direct Input68PSTATMaintenance statusnvarchar150
37MVEWMaterial Valuation65PSTATMaintenance statusnvarchar150
38MVRACross-version fields for MARA8PSTATMaintenance statusnvarchar150
39MVRCCross-version fields for MARC4PSTATMaintenance statusnvarchar150
40MVRDStorage Location Data for Material5PSTATMaintenance statusnvarchar150
41T130FField attributes5PSTATMaintenance statusnvarchar150
42T130WPlant parameters for master data maintenance3PSTATMaintenance statusnvarchar150
43T133ALogical Screens: Attributes7PSTATMaintenance statusnvarchar150
44T134Material Types11PSTATMaintenance statusnvarchar150
TOPMaterial Requirements Planning
45CIFMDMAVRVersions of Table MDMA41PSTATMaintenance statusnvarchar150
TOPNetherlands
46PA3210HR Master Record: Infotype 321027PSTATPayment Statusnvarchar10
TOPOrganizational Management
47T77FCPD Function Codes3PSTATGUI Statusnvarchar200
TOPPatient Management
48NKSPIS-H: Insurance verification/certificate - item data10PSTATProcessing Status of Insurance Verification Itemnvarchar10
TOPPersonnel Administration
49T7SI1PSlovenia items for personal areas7PSTATRegistry number (statistics...)nvarchar110
TOPPersonnel Management
50PA0563HR Master Record: Infotype 056346PSTATRegion (State, Province, County)nvarchar30
TOPPublic Sector
51T5PBSR6EAnnual Wage Adjustment for Basic Component3PSTATStatusnvarchar10
52T5PBSR6FMonthly Salary Scale3PSTATStatusnvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
53NLVERPRechnungregister-position15PSTATBewerking statusnvarchar10
TOPUSA
54T51G2Off-Cycle Batch Table9PSTATProgram status for off-cycle batch processnvarchar10
55T5UGJPrint Request of Notification Letters6PSTATPrint statusnvarchar10
56T5UGKPrint Request of Answer Letters5PSTATPrint statusnvarchar10