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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

48 columns | Print definition?ERP 6.0  | SUBTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPASAP AcceleratedSAP
1SATTUSEAttribute Types Included in Object Types2SUBTYPSubgroup of object types in the attribute repositorynvarchar40
2SBRANCHEEXAttribute Repository for Ref. Objects: Invalid Ind. Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
3SBRANCHEINAttribute Store for Reference Objects: Valid Industry Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
4SCOUNTRYEXAttribute Rep. for Reference Objects: Invalid Country Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
5SCOUNTRYINAttribute Store for Reference Objects: Valid Country Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
6SFLAVOREXAttribute Repository: Invalid Flavor Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
7SFLAVORINAttribute Repository: Valid Flavor Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
8SIAROLEEXAttribute Repository for Ref. Objects: Invalid Role Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
9SIAROLEINAttribute Rep. for Reference Objects: Valid Role Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
10SRELEASEEXAttrib. Repository for Ref. Objects: Invalid Release Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
11SRELEASEINAttribute Repository for Ref. Objects: Valid Release Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
12SROADMAPEXAttribute Rep. for Reference Objects: Valid Role Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
13SROADMAPINAttribute Rep. for Reference Objects: Valid Role Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
14SSUBJECTEXAttribute Rep. for Ref. Objects: Invalid Subj. Areas Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
15SSUBJECTINAttribute Rep. for Ref. Objects: Valid Subject Area Values4SUBTYPSubgroup of object types in the attribute repositorynvarchar40
16TTREEBRAEXAttribute Repository for Structure Nodes: Invalid Industry7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
17TTREEBRAINAttribute Repository for Sturcture Nodes: Valid Industry7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
18TTREECOUEXAttribute Repository for Structure Nodes: Invalid Countries7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
19TTREECOUINAttribute Repository for Structure Nodes: Valid Countries7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
20TTREEFLAEXAttribute Repository for Hierarchy Nodes: Invalid Flavors7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
21TTREEFLAINAttribute Repository for Hierarchy Nodes: Valid Flavors7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
22TTREERELEXAttribute Repository for Hierarchy Nodes: Invalid Release7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
23TTREERELINAttribute Repository for Hierarchy Nodes: Valid Release7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
24TTREEROAEXAttribute Repository for Structure Nodes: Invalid Roadmap7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
25TTREEROAINAttribute Repository for Structure Nodes: Valid Roadmap7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
26TTREEROLEXAttribute Repository for Structure Nodes: Invalid Role7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
27TTREEROLINAttribute Repository for Structure Nodes: Valid Role7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
28TTREESUBEXAttribute Rep. for Structure Nodes: Invalid Subject Area7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
29TTREESUBINAttribute Repository for Structure Nodes: Valid Subject Area7SUBTYPSubgroup of object types in the attribute repositorynvarchar40
TOPDefense Forces and Public Security
30HRP1988DB Table for Infotype 198820SUBTYPSubtypenvarchar40
TOPDocument Management Framework
31SKWS_ACTNStatus Management: Actions6SUBTYPStatus Management: Action Subtypenvarchar20
TOPFunds Management
32FMRESINI1Earmarked Funds: Initialization Information7SUBTYPEarmarked funds: Document category subtypenvarchar10
33FMRESINI2Earmarked Funds: Initialization Data2SUBTYPEarmarked funds: Document category subtypenvarchar10
TOPHierarchy Storage
34TTREVBRAEXVersions: Copy of TTREEBRAEX8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
35TTREVBRAINVersions: Copy of TTREEBRAIN8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
36TTREVCOUEXVersions: Copy of TTREECOUEX8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
37TTREVCOUINVersions: Copy of TTREECOUIN8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
38TTREVROAEXVersions: Copy of TTREEROAEX8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
39TTREVROAINVersions: Copy of TTREEROAIN8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
40TTREVROLEXVersions: Copy of TTREEROLEX8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
41TTREVROLINVersions: Copy of TTREEROLIN8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
42TTREVSUBEXVersions: Copy of TTREESUBEX8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
43TTREVSUBINVersions: Copy of TTREESUBIN8SUBTYPSubgroup of object types in the attribute repositorynvarchar40
TOPInstalled Base
44T371UIB: Permitted Object Types per IBase Type3SUBTYPIB: Object Type of Component Master Recordnvarchar40
TOPPersonnel Categories
45/ISDFPS/OPRRELPermitted Relationships for Operational Readiness (IT 1988)3SUBTYPSubtypenvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
46NWAT_EDI_KOMIS-H AT: EDI Kommentar (K12)7SUBTYPIS-H AT: EDI Subtyp zur Nachrichtnvarchar10
TOPTalent Management
47T5TMCSRDEFFLDField Names for Search Configuration16SUBTYPSubtypenvarchar40
TOPWorkload Balancing and Group Management
48TALIMAlert Thresholds and Parameters3SUBTYPEntry type of alert boundary value table TALIMnvarchar50