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

30 columns | Print definition?ERP 6.0  | COMPLETED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/FC_STATUSStatus Info Table3COMPLETEDCompleted Statusnvarchar10
2/LOCSRM/T_LAW_BRLAW 123 Bidders and corresponding Item line for an auction5COMPLETEDSingle-Character Indicatornvarchar10
3CNVCMIS_A_10_RUNcmis table for tracking execution of the analysis prg16COMPLETEDAnalysis Completenvarchar10
4CNVCMIS_A_30_RUNCmis table for tracking execution of the analysis prg13COMPLETEDAnalysis Completenvarchar10
5CNV_10020_ADTFLDAnalysis results for filling percentage of determin. field15COMPLETEDIndicator for 'completed'nvarchar10
6CNV_10020_AOBJNRAnalysis results for object numbers8COMPLETEDIndicator for 'completed'nvarchar10
7CNV_10020_TRACKStatistics for executed determinations14COMPLETEDIndicator for 'completed'nvarchar10
8LTR_TASKSLTR Preselection Tasks10COMPLETEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
9SWLT_STATIC_HSWLT: Static data - header12COMPLETEDBoolean Variable (X=True, Space=False)nvarchar10
10VIXCITCADLOGLogging table for Splitting/Merging of Cadaster Data6COMPLETEDSplitting/Merging Process already completednvarchar10
11ZXMII_M_PROCIProcess instances7COMPLETEDLogical data elementnvarchar10
12PIQDBATEVENTSSTClass Attendance Maintenance Status4COMPLETEDAttendance Maintenance Status of an Eventnvarchar10
13PIQDBATEVENTSTCM: Attendance Maintenance Status6COMPLETEDAttendance Maintenance Status of an Eventnvarchar10
TOPExcise Duty
14/BEV2/CS_HDEMCS Process: Header Data34COMPLETEDEMCS Process Is Completednvarchar10
15/BEV2/CS_HD_HEMCS Process: Header Data - History35COMPLETEDEMCS Process Is Completednvarchar10
TOPFunds Management
16FMCCFLOTHDLot for Commitment Carryforward (Approval Procedure)6COMPLETEDLevel in Approval Procedure for Commitment Carryforwardnvarchar10
TOPLogistics Basic Data
17DMF_D_ARTTransfer Status of Articles4COMPLETEDCompletion Indicator for Data Transfernvarchar10
18DMF_D_ART_SITETransfer Status of Article/Site Combinations5COMPLETEDCompletion Indicator for Data Transfernvarchar10
19DMF_D_SITETransfer Status of Sites4COMPLETEDCompletion Indicator for Data Transfernvarchar10
20DMF_D_VENDORTransfer Status of Vendors4COMPLETEDCompletion Indicator for Data Transfernvarchar10
TOPMedical Patient Data Organization Patient Organizer
21N1STRUCMEDRECIS-H*MED: Health Problems (Struct. Med. Patient Record)13COMPLETEDMedical Problem Inactivenvarchar10
TOPPosition Management
22WBASSOCGlobal Trade: Association Table30COMPLETEDAssoc. Mngt: Indicates Whether Asc.Qty is Transferred inFullnvarchar10
TOPRetail Demand Management
23DMF_D_ARTHIERTransfer Status of Material Hierarchy5COMPLETEDCompletion Indicator for Data Transfernvarchar10
TOPSAP Business Workflow
24SWF_WFPRECWF: Recovery information for Workflow Wizards12COMPLETEDInternal Data Elementnvarchar10
25SWPNODEWFM: Node Properties and Node Hierarchy at Runtime11COMPLETEDWFM: Indicator that WFM component is completenvarchar10
26SWP_NODEWIWF: Work items for nodes in a workflow definition8COMPLETEDWorkflow: Error When Completing a Work Itemnvarchar10
TOPSoftware Agent Framework
27CRMD_EI_LOG_GENSAF: Log for knowledge base generation9COMPLETEDFlag in Software Agent Frameworknvarchar10
TOPWork Clearance Management
28WCAMEWCM: (Temporary) Log of Operational Lists (Items)48COMPLETEDProcessing Statusnvarchar10
29WCAQWCM: Verification List (Items)19COMPLETEDProcessing Statusnvarchar10
TOPWorkforce Management Core
30/SAPAPO/LRPGWGOPProxy for Groupware Object23COMPLETEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150