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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

70 columns | Print definition?ERP 6.0  | ACC_DATABASIS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounting Engine
1/EACC/CHARNAMESCharacteristic Names for Fixed Fields2ACC_DATABASISData Basisnvarchar50
TOPBusiness Analytics
2TCOCOMAPMapping Fields: Remote <--> SEM2ACC_DATABASISData Basisnvarchar50
3TCOCOMAP2Mapping Fields: Remote <--> SEM2ACC_DATABASISData Basisnvarchar50
4TCOCOMAPTYPESMapping: Type Remote System <--> Object Type SEM2ACC_DATABASISData Basisnvarchar50
5TIPPE_EDGEFIELDSImport iPPE: Assignment Link Fields2ACC_DATABASISData Basisnvarchar50
6TIPPE_EDGESImport iPPE: Assignment Links2ACC_DATABASISData Basisnvarchar50
7TIPPE_EDGES2Import iPPE: Assignment Links2ACC_DATABASISData Basisnvarchar50
8TIPPE_TYPEFIELD2Import iPPE: Assignment Type Fields2ACC_DATABASISData Basisnvarchar50
9TIPPE_TYPEFIELDSImport iPPE: Assignment Type Fields2ACC_DATABASISData Basisnvarchar50
10TIPPE_TYPESImport iPPE: Assignment Types2ACC_DATABASISData Basisnvarchar50
11TIPPE_TYPES2Import iPPE: Assignment Types2ACC_DATABASISData Basisnvarchar50
12UABWEDGCALCFLATBW Extraction: Extracted Replacement Links for Costing6ACC_DATABASISData Basisnvarchar50
13UABWMDEXTBW Objects for Master Data Extraction2ACC_DATABASISData Basisnvarchar50
14UABWTDEXTBW Objects for Transaction Data Extraction2ACC_DATABASISData Basisnvarchar50
15UAB_ARCH_LOCKPersistent Locking for Archived Objects2ACC_DATABASISData Basisnvarchar50
16UACOSTCOMPGROUPCost Component Split2ACC_DATABASISData Basisnvarchar50
17UACOSTCOMPGROUPTCost Component Split Element Groups: Texts3ACC_DATABASISData Basisnvarchar50
18UACOSTCOMPONENTCost Component Split Elements2ACC_DATABASISData Basisnvarchar50
19UACOSTCOMPONENTTCost Component Split Element Texts3ACC_DATABASISData Basisnvarchar50
20UACOSTCOMPSPLITCost Component Split2ACC_DATABASISData Basisnvarchar50
21UACOSTCOMPSPLITTCost Component Split Texts3ACC_DATABASISData Basisnvarchar50
22UAGRPCOMPASSIGNCost Comp. Split Element Groups: Assignment Group-Element2ACC_DATABASISData Basisnvarchar50
23UAGRPCOMPASSIGNTCComp. Split Element Groups: Texts Assignmnt Groups-Elements3ACC_DATABASISData Basisnvarchar50
24UANRGRNumber Range Groups Costing Platform2ACC_DATABASISData Basisnvarchar50
25UAPRICETABLEPrice Tables Assignment2ACC_DATABASISData Basisnvarchar50
26UATPLMAPField Assignment during Template Call2ACC_DATABASISData Basisnvarchar50
27UATPLTPLTemplate Selection for Template Call2ACC_DATABASISData Basisnvarchar50
28UATUBD_LIGHTBDLib Light: Generated Methods (Data Basis-Dependent)2ACC_DATABASISData Basisnvarchar50
29UAUPLCMDActions During Upload2ACC_DATABASISData Basisnvarchar50
30UAUPLCMD_MISSKEYAssignment of Object Type2ACC_DATABASISData Basisnvarchar50
31UAUPLMAPField Assignment During Upload2ACC_DATABASISData Basisnvarchar50
32UAUPLMAP_PRELIMField Name Assignment with Switch of Object Type2ACC_DATABASISData Basisnvarchar50
33UAUPL_MISSINGKEYMissing Key Field2ACC_DATABASISData Basisnvarchar50
TOPFinancials
34ACCSYSTEM0CAccounting Systems7ACC_DATABASISData Basisnvarchar50
35FINPRCTABDERIVAssignment Table for Table Type of Prices3ACC_DATABASISData Basisnvarchar50
36FINPRICELABEL01Price Type Controls2ACC_DATABASISData Basisnvarchar50
37FINPRICELABEL0CMaster Data for Price Types2ACC_DATABASISData Basisnvarchar50
38FINPRICELABEL0TText Table for Price Types2ACC_DATABASISData Basisnvarchar50
39FINVALFUNC0CMaster Data for Strategy Functions2ACC_DATABASISData Basisnvarchar50
40FINVALFUNC0TTexts for Strategy Functions2ACC_DATABASISData Basisnvarchar50
41FINVALMETHOD0CValuation Functions for Strategy Formulas2ACC_DATABASISData Basisnvarchar50
42FINVALMETHOD0TTexts for Valuation Functions for Strategy Formulas2ACC_DATABASISData Basisnvarchar50
43FINVALSTRAT0CMaster Data for Valuation Strategy2ACC_DATABASISData Basisnvarchar50
44FINVALSTRAT0TTexts for Valuation Strategies2ACC_DATABASISData Basisnvarchar50
45FINVALSTRATDERIVDerivation Table: Valuation Strategy for Business Transactio2ACC_DATABASISData Basisnvarchar50
TOPFinancials Basis
46ACCACCTGROUP00Account Group4ACC_DATABASISData Basisnvarchar50
47ACCAREAIDCOMPArea ID of a Technical Component3ACC_DATABASISData Basisnvarchar50
48ACCASSTYPE00Account Assignment Category2ACC_DATABASISData Basisnvarchar50
49ACCASSTYPE0CAccount Assignment Category2ACC_DATABASISData Basisnvarchar50
50ACCASSTYPE0TAccount Assignment Category3ACC_DATABASISData Basisnvarchar50
51ACCDBS01Data Basis <-> Business Domain Assignment2ACC_DATABASISData Basisnvarchar50
52ACCDBS02Assignment Data Basis - Generated ALV Reference Structure2ACC_DATABASISData Basisnvarchar50
53ACCDBS0CData Basis2ACC_DATABASISData Basisnvarchar50
54ACCDBS0TData Basis Name3ACC_DATABASISData Basisnvarchar50
55ACCENTCONF01Entities: Local Storage of Configuration2ACC_DATABASISData Basisnvarchar50
56ACCQNTTYPE0CData Elements of Quantity Type2ACC_DATABASISData Basisnvarchar50
57ACCROLE11Application Role Registration: Classes2ACC_DATABASISData Basisnvarchar50
58ACCROLE21Application Role Registration: FieldNames and FinObjectTypes2ACC_DATABASISData Basisnvarchar50
59ACCSTRU0CStructure IDs3ACC_DATABASISData Basisnvarchar50
60ACCSYS06Settings for Reference Valuation2ACC_DATABASISData Basisnvarchar50
61ACCSYS07Reference Accounting Systems2ACC_DATABASISData Basisnvarchar50
62ACCSYS0CAccounting System3ACC_DATABASISData Basisnvarchar50
63FINB_ATTRIBUTESAttributes of Field on Data Basis2ACC_DATABASISData Basisnvarchar50
64FINB_FIELDSFields on the Data Basis2ACC_DATABASISData Basisnvarchar50
TOPGeneral Ledger
65/EACA/GLCONFIG1GL Configuration: Active Subcomponents2ACC_DATABASISData Basisnvarchar50
66/EACA/TGLMPCONDBConfiguration of Manual Posting Transaction for Data Basis2ACC_DATABASISData Basisnvarchar50
TOPServices
67FINBSCMIDRFC0CRFC Data for Object Navigation2ACC_DATABASISData Basisnvarchar50
68FINB_FUNCTIONSFunction Builder2ACC_DATABASISData Basisnvarchar50
69FINB_FUNCTIONS_TFunction Builder3ACC_DATABASISData Basisnvarchar50
70FINB_SIGNATUREFunction Builder2ACC_DATABASISData Basisnvarchar50