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

44 columns | Print definition?ERP 6.0  | MATERIAL_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHFNDD_CHM_MATChemical - Material9MATERIAL_IDMaterialnvarchar180
2EHFNDD_PCHA_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
3EHFNDD_PTN_ROOT34MATERIAL_IDMaterialnvarchar180
4EHFNDD_REQC_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
5EHFNDD_SDSE_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
6EHHSSD_CHAI_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
7EHHSSD_PCI_ROOTControl Inspection PCBO34MATERIAL_IDMaterialnvarchar180
8EHHSSD_PRQ_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
9EHHSSD_PRSPS_RTProcess Control - Sample Shipment - Root34MATERIAL_IDMaterialnvarchar180
10EHHSSD_RPL_ROOTProcess Control - Mass Replace Controls - Root34MATERIAL_IDMaterialnvarchar180
11EHPRCD_BBT_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
12EHPRCD_CMP_POSCampaign Position8MATERIAL_IDMaterial Numbernvarchar180
13EHPRCD_OBL_ITEMObject List Item8MATERIAL_IDMaterial Numbernvarchar180
14EHPRCD_PBB_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
15EHPRCD_PCA_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
16EHPRCD_PCR_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
17EHPRCD_PSA_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
18EHPRCD_PSI_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
19SESI_DEMO_ST_BOOrder status of the SESI Demo Backoffice Application16MATERIAL_IDSRT FT Tests: Single Material Itemnvarchar200
20SESI_DEMO_ST_PLProduction status of the SESI Demo Plant Application7MATERIAL_IDSRT FT Tests: Single Material Itemnvarchar200
21SESI_DEMO_ST_SOOrder status of the SESI Demo Salesoffice Application13MATERIAL_IDnvarchar200
22SESI_DEMO_ST_WHOrder status of the SESI Demo Warehouse Application13MATERIAL_IDnvarchar200
23VMP_EXPLODED_MATVMP Planning scope expanded materials5MATERIAL_IDMaterial Numbernvarchar180
TOPBusiness Objects, Common Components
24EHFNDD_PAM_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
TOPCampaign Weighing and Dispensing
25CWD_MATERIALCampaign Weighing Component Materials3MATERIAL_IDMaterial Numbernvarchar180
TOPIncident Workflow and Tasks
26EHHSSD_IIL_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
27EHHSSD_IIS_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
28EHHSSD_PGI_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
29EHHSSD_PIA_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
30EHHSSD_PIC_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
31EHHSSD_PIH_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
32EHHSSD_PII_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
33EHHSSD_PIL_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
34EHHSSD_PIN_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
35EHHSSD_PIR_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
TOPProduction Planning and Control
36LPO_INTMODEL_MATIntegration model LPO: Integrated Materials2MATERIAL_IDMaterial Numbernvarchar180
TOPRisk Assessment
37EHHSSD_PRA_ROOTAction PCBO for Risk Assesment34MATERIAL_IDMaterialnvarchar180
TOPWorkflows and Tasks for Risk Assessment
38EHHSSD_EVL_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
39EHHSSD_PRF_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
40EHHSSD_PRL_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
41EHHSSD_PRN_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
42EHHSSD_PRR_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180
43EHHSSD_PRS_ROOTProcess Control - Root34MATERIAL_IDMaterialnvarchar180
44EHHSSD_PRT_ROOTProcess Control - Root35MATERIAL_IDMaterialnvarchar180