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

48 columns | Print definition?ERP 6.0  | GENERATED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/TRANSSAP LT AP: transport admin tables10GENERATEDSAP LT: Objects are generatednvarchar10
2CNVCDOPCA_ACTIVECDOP - ? ? ?6GENERATEDRecord was automatically insertednvarchar10
3CNVCMIS_FIELDSExplicit conversion rules for fields during migration11GENERATEDis generated with the dom-/fieldrules assignmentnvarchar10
4CNVCMIS_FIPARSparameters for rules mentioned in cnvmbtfields10GENERATEDis generated with the dom-/fieldrules assignmentnvarchar10
5CNVMBTFIELDSexplicite conversion rules for fields during migration11GENERATEDis generated with the dom-/fieldrules assignmentnvarchar10
6CNVMBTFIPARSparameters for rules mentioned in cnvmbtfields10GENERATEDis generated with the dom-/fieldrules assignmentnvarchar10
7CNVMBTINCLMBT PCL: Includes to be integrated in Conversion Objects14GENERATEDis generated with the dom-/fieldrules assignmentnvarchar10
8CNVMBTSTEPSsteps / rules7GENERATEDis generated with the dom-/fieldrules assignmentnvarchar10
9CNV_NCE_DOC_MAPNCE: Mapping data for individual doc numbers19GENERATEDAutomatically generated mapping (flag)nvarchar10
10CNV_NCE_DOC_SIMNCE: Mapping data for individual doc numbers19GENERATEDAutomatically generated mapping (flag)nvarchar10
11DMC_MT_TABLESDMC: Tables for a Mass Data Transfer6GENERATEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
12OIUY6_WY_RPDTLRoyalty 2.0 - WY - Report Details Lease7GENERATEDGeneral Flagnvarchar10
13OIUY6_WY_RPDTURoyalty 2.0 - WY - Report Details Unit7GENERATEDGeneral Flagnvarchar10
14SWD_USRATTWorkflow Definition: User Attributes15GENERATEDNew Input Valuesnvarchar10
TOPABAP Authorization and Role Management
15AGR_1016Name of the activity group profile6GENERATEDIndicator: Entry generatednvarchar10
16AGR_1016BName of the activity group profile6GENERATEDIndicator: Entry Generatednvarchar10
TOPALE Integration Technology
17EDBASBasic types8GENERATEDFlag: IDoc type was generatednvarchar10
18EDISEGMENTIDoc Development : IDoc Segment3GENERATEDIDoc development: Segment generatednvarchar10
TOPApplication Framework
19USMD0020Data Model: Entity Types28GENERATEDGenerated Elementnvarchar10
20USMD0022Data Model: Attributes of Ent.Types w/Generated Persistence15GENERATEDGenerated Elementnvarchar10
21USMD0023Data Model: Relationships of Entity Types13GENERATEDGenerated Elementnvarchar10
TOPArchive Information System
22ASPART_ACTArchiveInfoSys: Actual Partitioning6GENERATEDArchive Information System, Partitioning: "Table Generated"nvarchar10
TOPArchiving Engine
23TARCHENGINE01Archiving Engine: Scenarios28GENERATEDGeneratednvarchar10
TOPBudget Management
24HRP1500DB Table for Infotype 150028GENERATED'Generated object' indicatornvarchar10
TOPCustom Development Management Cockpit
25CNVCDMCCA_ACTIVECDOP - ? ? ? - Not Valid6GENERATEDRecord was automatically insertednvarchar10
TOPCustomer Enhancements
26ENHHEADEREnhancement Header Table11GENERATEDEnhancement Booleannvarchar10
27ENHSPOTHEADEREnhancement Spot Header Data13GENERATEDEnhancement Booleannvarchar10
TOPData Basis
28RSBOHDESTDirectory of Open Hub Destinations25GENERATEDBooleannvarchar10
TOPData Staging
29RSLDPIOLog.data packet: No.18GENERATEDSingle-Character Indicatornvarchar10
30RSLDPIOSHLog.data packet: No.15GENERATEDSingle-Character Indicatornvarchar10
31RSSELDONEMonitor: Selections for executed request86GENERATEDBooleannvarchar10
TOPEnd User Technology
32RSRVTABLEDIRDirectory of all Tables for Variable Type Table8GENERATEDBooleannvarchar10
TOPFunction Builder
33ENLFDIRAdditional Attributes for Function Modules4GENERATEDGenerated function modulenvarchar10
TOPOrganizational Flexibility
34/ISDFPS/SV_RUNGenerated Checklists4GENERATEDForm Generatednvarchar10
TOPOrganizational Management
35HRP1201Infotype 1201 DB Table27GENERATEDIndicator: Entry Generatednvarchar10
36HRP1216Infotype 1216 DB Table21GENERATEDStandard object was generated for a special purposenvarchar10
37HRS1201Standard Infotype 1201 (SAP) Object Method14GENERATEDIndicator: Entry Generatednvarchar10
38HRS1216Standard Infotype 1216 (SAP) Assigned Reference Function8GENERATEDStandard object was generated for a special purposenvarchar10
39HRT1016Table Part Infotype 10166GENERATEDIndicator: Entry Generatednvarchar10
40HRT1220Table Part Infotype 1220 Activity Profile6GENERATEDIndicator: Entry Generatednvarchar10
41HRT1221Table Part Infotype 1221 Excluded Activities8GENERATEDIndicator: Entry Generatednvarchar10
TOPPatient Management
42NKSDIS-H: Treatment Certificate Details52GENERATEDIndicator for Manual Changes to Treatment Certificatenvarchar10
TOPPerformance Monitors TCC
43ORA_DBA_OBJECTSCopy of DBA_OBJECTS (currently not provided with snapshots)15GENERATEDOracle monitoring: Was name of this object system generatednvarchar10
TOPSAP Business Workflow
44SWDSBINDEFWF Definition: Bindings36GENERATEDCheckboxnvarchar10
45SWD_BINDEFWF Definition/Runtime: Bindings37GENERATEDCheckboxnvarchar10
TOPTest Organizer
46TWB_PRODUCTProduct and Product Release9GENERATEDGenerated automaticallynvarchar10
47TWB_RMPWork Breakdown Structure Elements (WBS Elements)10GENERATEDGenerated automaticallynvarchar10
48TWB_TPRProduct6GENERATEDGenerated automaticallynvarchar10