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

98 columns | Print definition?ERP 6.0  | ENTITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/ENTITYBUKRSLegal Entity companies3ENTITYLegal Entitynvarchar40
2/ATL/ENTTYTEXTForeclosure Legal Entity Texts3ENTITYLegal Entitynvarchar40
3/ATL/FORECLOSUREForeclosures5ENTITYLegal Entitynvarchar40
4/ATL/FORECPYMNTForeclosure payments5ENTITYLegal Entitynvarchar40
5/ATL/LEGALENTITYForeclosure Legal Entity Codes3ENTITYLegal Entitynvarchar40
6/UI2/CACHECache for storing query results (collections and entities)8ENTITYUI2 Entity namenvarchar400
7ACMACAVIEWDETAILACM: Access-Condition Authorization-View Details5ENTITYACM: ID of an Entitynvarchar300
8ACMTSTACAVIEWDETACMTST: AC-AuthView-Detail (Expected test-results)5ENTITYACM: ID of an Entitynvarchar300
9BBPD_MDG_FLDMAPMDG: Assignment Entity/Database Field Name2ENTITYEntity Typenvarchar90
10GRFNAMAHQRYCFGAM ad-hoc query configuration2ENTITYEntity IDnvarchar200
11GRFNASENTITYAgent Slot - Entity Usage2ENTITYEntity IDnvarchar200
12GRFNAUSTEPAudit Proposal Steps2ENTITYEntity IDnvarchar200
13GRFNAUSTEPLOGAudit Proposal Steps Transfer Log2ENTITYEntity IDnvarchar200
14GRFNBRABusiness Rule Assignment - Data common8ENTITYEntity IDnvarchar200
15GRFNEEFES(Obsoleted!)Entity Enabled for Enterprise Search1ENTITYEntity IDnvarchar200
16GRFNESE(Obsoleted!)Enteprise search extractors1ENTITYEntity IDnvarchar200
17GRFNISSUEENTITYThe GRC Ad hoc issue settings per entity2ENTITYEntity IDnvarchar200
18GRFNISSUERMDConfiguration Table for issue remediation type per entity2ENTITYEntity IDnvarchar200
19GRFNISSUETYPETYRelationship between Issue Type and Entity2ENTITYEntity IDnvarchar200
20GRFNPARENTAll allowed parent entity of GRC entities1ENTITYEntity IDnvarchar200
21GRFNROLEASSNMTnew DB Table for non-HR object role assignment9ENTITYEntity IDnvarchar200
22GRFNSTCFGSearch term configuration2ENTITYEntity IDnvarchar200
23GRFNSTEESearch term enabled entity1ENTITYEntity IDnvarchar200
24GRRMOBAGHIERCHLDAggregation hierarchy (Parent - Child)3ENTITYEntity IDnvarchar200
25GRRMOBAGHIERRULEAggregation hierarchy3ENTITYEntity IDnvarchar200
26GRRMOBRCSAPLANRCSA Plan header4ENTITYEntity IDnvarchar200
27J_3RFREP_ADPXML Report Data Provider3ENTITYObject Namenvarchar400
28MDGHDB_LEAD_ENTYLeading Entity Information for MDG Model Entities3ENTITYEntity Typenvarchar90
29MDGHDB_PP_FMAPMDG reuse fieldmapping2ENTITYEntity Typenvarchar90
30MDG_BS_MAT_LENTYTable for leading entity of nodes2ENTITYEntity Typenvarchar90
31SMI_ETYPES_E_ENTList of Entitys to be excluded by Sententiment Assignment3ENTITYEntitynvarchar2000
32SMI_VOICE_CUSTAssignment of Sentiment to an Entity on Post Level5ENTITYEntitynvarchar2000
33TLRC_THM_ENTITYThreshold Entities2ENTITYOrganizational Entity for CTRnvarchar40
34TLRC_THM_ENT_CCThreshold Entities assigned Comp.Codes2ENTITYOrganizational Entity for CTRnvarchar40
35TLRT_THM_RES_HThreshold Result Header Data4ENTITYOrganizational Entity for CTRnvarchar40
TOPApplication Framework
36MDG_MDF2100Master Data Generation: Object -> Logical Name2ENTITYSingle-Character Indicatornvarchar10
37USMD101CUI Model: Layout of Web Interface3ENTITYEntity Typenvarchar90
38USMD101TUI Model: Layout of Web Interface4ENTITYEntity Typenvarchar90
39USMD1020UI Model: Customer-Defined Web Dynpro Component3ENTITYEntity Typenvarchar90
40USMD1021UI Model: Hierarchy Relationships3ENTITYEntity Typenvarchar90
41USMD1022UI Model: Sets3ENTITYEntity Typenvarchar90
42USMD2004Personalization: User-depend. Personalization per Data Model5ENTITYEntity Typenvarchar90
43USMD2005Personalization: Role-depend. Personalization per Data Model5ENTITYEntity Typenvarchar90
44USMD203CStored Search Criteria (by User and Entity Type)4ENTITYEntity Typenvarchar90
45USMD6011Data Transfer: Internal Structure6ENTITYEntity Typenvarchar90
46USMD_PP_CDChange Document for Active Area3ENTITYEntity Typenvarchar90
TOPApplications
47MDG_ECC_CUST_FGAttribution Entity/DB/Modification group (Customer)2ENTITYEntity Typenvarchar90
TOPData Quality
48MDG_DQ_CONF_DCConfiguration table for duplicate check - Data Quality4ENTITYEntity Typenvarchar90
49MDG_DQ_MAP_GENMapping table for MTC generated table and data model3ENTITYEntity Typenvarchar90
TOPDocument Management Services
50SDOKMESDOK/Model: Model Entities2ENTITYModel: Entity Namenvarchar300
51SDOKMEPSDOK/Model: Model Entity Properties2ENTITYModel: Entity Namenvarchar300
52SDOKMEPCSDOK/Model/Customizing: Model Entity Properties2ENTITYModel: Entity Namenvarchar300
53SDOKMETSDOK/Model: Model Entity Descriptions3ENTITYModel: Entity Namenvarchar300
TOPFinancials Basis
54UGMD2100FIN Master Data: Generation: Object -> Logical Name3ENTITYSingle-Character Indicatornvarchar10
TOPGeneric Project Planning
55CGPL_CM_SETTINGSGeneral Project Planning: Settings for Document Management5ENTITYModel: Entity Namenvarchar300
TOPGovernance, Risk and Compliance
56GRFNAGENTSLOTDefinition of Rules for Business Event2ENTITYEntity IDnvarchar200
57GRFNAGENTSLOTCCustomized Rules for Business Event5ENTITYEntity IDnvarchar200
58GRFNDATAPARTData Part1ENTITYEntity IDnvarchar200
59GRFNDATAPARTTText table for dataparts1ENTITYEntity IDnvarchar200
60GRFNOBJSCRMap between object type and WD screen1ENTITYEntity IDnvarchar200
61GRFNPERSRESPUser Responsible for Entity2ENTITYEntity IDnvarchar200
62GRFNPLANUSAGEConfiguration table for planner usage9ENTITYEntity IDnvarchar200
63GRFNRELLINKRelated links2ENTITYEntity IDnvarchar200
64GRFNRELROLESRelevant Roles for GRC Authorization2ENTITYEntity IDnvarchar200
65GRFNRELROLESREGRelevant Roles for GRC Authorization2ENTITYEntity IDnvarchar200
66GRFNYCATable for entries of 'You can also'1ENTITYEntity IDnvarchar200
TOPInternal Self-Services
67UISSPPACCESSStandard settings for access class and UI class for entity2ENTITYEntity Typenvarchar90
68UISSPPACCESS_CCustomizing for access class and UI class for entity2ENTITYEntity Typenvarchar90
69UISSPPACCESS_SCustomizing for access class and UI class for entity2ENTITYEntity Typenvarchar90
TOPManagement of Internal Controls
70FOPCROLEMIC Role4ENTITYObject Type IDnvarchar100
71FOPCTASKMIC Task6ENTITYObject Type IDnvarchar100
TOPMDG Business Partner Central Part
72MDG_BS_BP_FLDGRPAttribution Entity/DB/Fieldgroups2ENTITYEntity Typenvarchar90
TOPMDG for Financials
73USMDZ5200Determination Entity Type Depending on DataSource3ENTITYEntity Typenvarchar90
74USMDZ5201Determination Entity Type Depending on Refer. Characteristic3ENTITYEntity Typenvarchar90
75USMDZ5202Determination Entity Type/InfoObject Depending on Ref. Char.3ENTITYEntity Typenvarchar90
TOPMDG Supplier Central Parts
76MDG_BS_SUPPL_FGAttribution Entity/DB/Modification group (Supplier)2ENTITYEntity Typenvarchar90
TOPNetWeaver Enterprise Search
77ESH_OM_TRANSObjects for Cross-System Transport5ENTITYES Model Entitynvarchar30
TOPPortugal
78T5P2UHR-PT: Social Security Contributor12ENTITYEntity codenvarchar90
TOPProcess Controls
79GRPCAGENTSLOTMAPAgentslot Mapping Table5ENTITYEntity IDnvarchar200
80GRPCENABLELOGEnable/disable API logging4ENTITYGRPC ID of the entitynvarchar200
81GRPCROLEObsolete: PC Role4ENTITYObject Type IDnvarchar100
82GRPCTASKObsolete: GRPC authorization tasks4ENTITYObject Type IDnvarchar100
83GRPC_TASK25ROLEPC2.5 task PFCG role mapping3ENTITYEntity IDnvarchar200
TOPRecords and Case Management
84RMPSC_TRF_ENTITYDoD: Transfer - export/import configuration - entities3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
85RMPSC_TRF_PPATHDoD: Transfer -exp./imp. config - template XML parent paths3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
86RMPSC_TRF_PROPDoD: Transfer - export/import configuration - properties3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
87RMPSC_TRF_STDoD: Transfer - export/import configuration - ST templates3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
88RMPSC_TRF_XSDDoD: Transfer - export/import configuration - XML schemas3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
89RMPSC_TRF_XSLDoD: Transfer - export/import config. - style sheets3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
90RMPSI_TRF_TPL_ECDoD: Transfer - exp./imp. config - templ. entity components3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
91RMPSI_TRF_TPL_ENDoD: Transfer - exp./imp. config - template entities3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
92RMPSI_TRF_TPL_PPDoD: Transfer -exp./imp. config - template XML parent paths3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
93RMPSI_TRF_TPL_PRDoD: Transfer - export/import config. - template properties3ENTITYDoD: Transfer - Entity: FOLDER, DOCUMENT, ...nvarchar320
TOPResourcen Management
94FRMLC21RMS-FRM: API Entity Types - Structural Part1ENTITYEntity Types for Formulanvarchar30
95FRMLC27RMS-FRM: API Entity Types - Attribute Part1ENTITYEntity Types for Formulanvarchar30
96FRMLC_CPT_KINDRMS-FRM: API - Assigning View to Vector Type (Internal)2ENTITYEntity Types for Formulanvarchar30
TOPWeb Service and SOAP - ABAP
97SRT_ENTITYSOAP Runtime: SOAP Applications3ENTITYAny URInvarchar2550
98SRT_TEST_OVERRIDuser specific test data3ENTITYTest enviroment override entitynvarchar100