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

40 columns | Print definition?ERP 6.0  | XACTIVE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVC_CCE_SYSTEMSMaintenance: Systems5XACTIVEactive?nvarchar10
2CNVC_SCNG_HEADComparison run header8XACTIVEFlag: active runnvarchar10
3CNVC_SCWB_ORObject overview4XACTIVECheckboxnvarchar10
4CNVC_SCWB_TRIGTrigger4XACTIVEFlag: Activatednvarchar10
5CNVC_SCWB_UEControl table4XACTIVECheckboxnvarchar10
6CNVC_SCWB_XTTrigger header table5XACTIVEFlag: Activatednvarchar10
7FAGL_SLL_CLOCO_IClosing Cockpit Instances for Switching Leading Ledger5XACTIVEActivation Indicator for a Task Listnvarchar10
8TFAAD_BSN_FUNCValidation of Business Function Switches for FI-AA3XACTIVEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPAccounts Receivable Accounting Process Integration
9FDM_INVOICE_METHProcedure for Providing Invoice Information3XACTIVECheckboxnvarchar10
10FDM_STAT_MIRRORActivation status2XACTIVEInd: Function has been activatednvarchar10
TOPActual CostingMaterial Ledger
11CKMLWIPCUSTCustomizing: WIP To Actual3XACTIVEWIP Revaluation Activenvarchar10
TOPAdvertising Management
12TJJPRDH_TVKCUSIS-M/AM: Product Hierarchy (S&P) Global Settings2XACTIVEIS-M/AM: Product Hierarchy (S&P) - Active Indicatornvarchar10
TOPAsset Accounting
13AAACC_OBJAccount Assignment Settings in Asset Accounting7XACTIVEAccount Assignment: Yes/Nonvarchar10
14T093_ACCOBJAccount Assignment Objects in Asset Accounting3XACTIVEActivation of Account Assignment Objectnvarchar10
TOPCollectionsDisbursements
15ITAGCYBASICGeneral Settings for Agency Collections2XACTIVEFlag: Agenc< Collections Activenvarchar10
TOPContract Accounts Receivable and Payable
16TFKINFCOTSSettings for Information Container Categories3XACTIVEInformation Container Activenvarchar10
TOPFinancial Accounting
17T8HSPLITACTOnline Split for FI Postprocessing Costs2XACTIVEOnline Split Active for FInvarchar10
TOPFunds Management
18FMRESACCMVRULESRules for Account Assignment Transfer5XACTIVEIndicator: Field transferred to follow-on documentnvarchar10
TOPGeneral Ledger Accounting
19FAGLCOFIVARCVariants for Real-Time Integration CO->FI3XACTIVEReal-Time Integration with CO Activenvarchar10
TOPGeneral Ledger Reorganization
20FAGL_R_COMP_AAActivation of Asset Accounting by Plan Type3XACTIVEReorganization of Assets: Activenvarchar10
21FAGL_R_DERH_VERReorganization: Version of a Derivation Hierarchy4XACTIVEVersion of Derivation Hierarchy Is Activenvarchar10
22FAGL_R_DERH_VER0Reorganization: Version of a Derivation Hierarchy4XACTIVEVersion of Derivation Hierarchy Is Activenvarchar10
23FAGL_R_PLTYReorganization: Plan Type3XACTIVEPlan Type Is Activenvarchar10
TOPLoans Management
24TDPR_PRODVVersion of a Prodcut, Master Data4XACTIVEIndicator: Version Is Active (Can Have Characteristic Vals)nvarchar10
25TDPR_VAVersion Attribute4XACTIVEIndicator: Version Is Active (Can Have Characteristic Vals)nvarchar10
26TDPR_VA_FLDVersion Attribute Category Field4XACTIVEIndicator: Version Is Active (Can Have Characteristic Vals)nvarchar10
27TDPR_VA_FLDMVersion Attribute Category Field: Multiple Value Fields4XACTIVEIndicator: Version Is Active (Can Have Characteristic Vals)nvarchar10
TOPMedia Product Sales and Distribution
28JKSDFCVARIANTIS-M: Reference Issue Header Data10XACTIVEIS-M: Selection Activenvarchar10
29JKSDFCVARIANTPOIS-M: Header Data for Ref. Issues with Planning Organization11XACTIVEIS-M: Selection Activenvarchar10
30TJKSDVIEWQuantity Planning View4XACTIVEPlanning View for Changing Distribution Listnvarchar10
TOPPeriodical Sales and Distribution
31JKDELIVOPTIS-M/SD: Delivery Viability Optimization15XACTIVEIS-M/SD: Delivery Viability Optimization Activenvarchar10
32TJMSD2SDIS-M/SD: Customizing Settings for LES Interface2XACTIVEIS-M/SD: LES Interface Activenvarchar10
TOPProduct definition
33FIPR_PARTPRODAssignment Version Partial Product4XACTIVEID Version is Active (Can Have Instances)nvarchar10
34FIPR_PRODVVersion of a Prodcut, Master Data4XACTIVEID Version is Active (Can Have Instances)nvarchar10
35FIPR_VAVersion Attribute4XACTIVEID Version is Active (Can Have Instances)nvarchar10
36FIPR_VA_FLDVersion Attribute Category Field4XACTIVEID Version is Active (Can Have Instances)nvarchar10
37FIPR_VA_FLDMVersion Attribute Category Field: Multiple Value Fields4XACTIVEID Version is Active (Can Have Instances)nvarchar10
38FIPR_VA_FLDVALVersion Attribute Category Field: Value Restriction4XACTIVEID Version is Active (Can Have Instances)nvarchar10
39FIPR_VA_VALUEVersion Attribute Category List4XACTIVEID Version is Active (Can Have Instances)nvarchar10
40FIPR_VA_VALUE2Version Attribute Category Matrix4XACTIVEID Version is Active (Can Have Instances)nvarchar10