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

60 columns | Print definition?ERP 6.0  | PROC_STATUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EDOCUMENTeDocument9PROC_STATUSeDocument Statusnvarchar40
2EDOCUMENTHISTORYeDocument: History9PROC_STATUSeDocument Statusnvarchar40
3EHFNDD_PCHA_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
4EHFNDD_PTN_ROOT30PROC_STATUSWork item IDnvarchar120
5EHFNDD_REQC_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
6EHFNDD_SDSE_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
7EHHSSD_CHAI_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
8EHHSSD_PCI_ROOTControl Inspection PCBO30PROC_STATUSWork item IDnvarchar120
9EHHSSD_PRQ_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
10EHHSSD_PRSPS_RTProcess Control - Sample Shipment - Root30PROC_STATUSWork item IDnvarchar120
11EHHSSD_RPL_ROOTProcess Control - Mass Replace Controls - Root30PROC_STATUSWork item IDnvarchar120
12EHPRCD_BBT_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
13EHPRCD_PBB_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
14EHPRCD_PCA_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
15EHPRCD_PCR_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
16EHPRCD_PSA_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
17EHPRCD_PSI_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
18GRFNACTIONISSUEAudit Management Action and Ad hoc Issue Mapping5PROC_STATUSProcessing Status of the Audit Componentnvarchar10
19PYD_D_DAE_EREGPYDS: Scheduling Event Registry7PROC_STATUSPayroll Data Source Framework: Scheduling event statusnvarchar10
20PYD_D_DAE_REGPYDS: Scheduling Use Case Registry7PROC_STATUSPayroll Data Source Frwk: Scheduling use case statusnvarchar10
21PYD_D_SHPayroll Data Source Shadow5PROC_STATUSPayroll Data Source Shadow Processing Statusnvarchar20
22PYD_D_SHIPayroll Data Source Shadow Item10PROC_STATUSPayroll Data Source Shadow Processing Statusnvarchar20
23TLRT_TARO_ADMTrade Repository Object Administrative Data11PROC_STATUSStatus of Trade Repository Objectnvarchar20
TOPAudit Management
24PLMM_AUDITAudit25PROC_STATUSProcessing Status of the Audit Componentnvarchar10
25PLMM_AUDITPLANAudit Plan11PROC_STATUSProcessing Status of the Audit Componentnvarchar10
26PLMM_AUDIT_ACTAudit - Corrective Action6PROC_STATUSProcessing Status of the Audit Componentnvarchar10
27PLMM_QUEST_HQuestion List8PROC_STATUSProcessing Status of the Audit Componentnvarchar10
28PLMM_QUEST_IQuestion List Item20PROC_STATUSProcessing Status of the Audit Componentnvarchar10
TOPBasic Functions
29UDM_T_PROC_STATProcessing Status for Dispute Cases4PROC_STATUSProcessing Status for Dispute Casesnvarchar10
TOPBusiness Objects, Common Components
30EHFNDD_PAM_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
TOPDistributor-Reseller-Management
31/SAPHT/DRMBUDLBill Up Due List65PROC_STATUSBill-up due list item processing statusnvarchar10
32/SAPHT/DRMR3XNDRM relevant ERP Transactions57PROC_STATUSStatus of transactionsnvarchar10
33/SAPHT/DRMSLSRPTDRM 867 Outbound processing table15PROC_STATUSTransaction status for sales reportnvarchar10
34/SAPHT/DRMSTAGDRM Staging Area53PROC_STATUSProcessing status of staging recordnvarchar10
TOPDSD Connector
35/DSD/ME_TRANSDSD Connector: Transaction Management with Mobile Devices5PROC_STATUSDSD Connector: Process Statusnvarchar10
TOPElectronic Data Interchange
36PRICAT_K003PRICAT: Catalog item basic data72PROC_STATUSProcessing Statusnvarchar20
TOPFinancials Basis
37FOBJ_OBJ_W_POSTFIN Objects with Postings That Have Not Yet Been Processed4PROC_STATUSProcessing Status of Postings for an Objectnvarchar10
TOPFunds Management
38FMFG_REPOST_CNTLDocument batching/control for SL Repost for ECC 600 migratio12PROC_STATUSStatus for SL repost: X=submitted;E=Error;C=Completednvarchar10
TOPHR Administrative Services
39T5ASRSTEPSHR Administrative Services: Process Steps (Work Items)28PROC_STATUSStep Status After User Actionnvarchar220
TOPIncident Workflow and Tasks
40EHHSSD_IIL_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
41EHHSSD_IIS_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
42EHHSSD_PGI_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
43EHHSSD_PIA_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
44EHHSSD_PIC_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
45EHHSSD_PIH_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
46EHHSSD_PII_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
47EHHSSD_PIL_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
48EHHSSD_PIN_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
49EHHSSD_PIR_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
TOPMaterials Management
50/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions148PROC_STATUSProcessing Statenvarchar10
TOPPurchasing
51EBAN_TECHPurchase Requisition for External Sourcing4PROC_STATUSProcessing Statenvarchar10
TOPRisk Assessment
52EHHSSD_PRA_ROOTAction PCBO for Risk Assesment30PROC_STATUSWork item IDnvarchar120
TOPValuation
53OIURV_DOC_HDRValuation Document Header15PROC_STATUSValuation Document Processing Statusnvarchar10
TOPWorkflows and Tasks for Risk Assessment
54EHHSSD_EVL_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
55EHHSSD_PRF_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
56EHHSSD_PRL_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
57EHHSSD_PRN_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
58EHHSSD_PRR_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120
59EHHSSD_PRS_ROOTProcess Control - Root30PROC_STATUSWork item IDnvarchar120
60EHHSSD_PRT_ROOTProcess Control - Root31PROC_STATUSWork item IDnvarchar120