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

60 columns | Print definition?ERP 6.0  | GRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/DOBJGRPCustomizingtabelle dyn. Objekte - Gruppen2GRPCAFM Foundation dynamische Objekte - Gruppenvarchar300
2/CFMFND/DOBJG_TCustomizingtabelle dyn. Objekte - Gruppenbeschreibung2GRPCAFM Foundation dynamische Objekte - Gruppenvarchar300
3/CFMFND/DOBJTYPCustomizingtabelle dyn. Objekte - Typen6GRPCAFM Foundation dynamische Objekte - Gruppenvarchar300
4/CFMFND/GI_CTMNOKontextmenü: Einträge zulässig je Objekttyp3GRPCAFM Foundation dynamische Objekte - Gruppenvarchar300
5/OPT/VIM_GRPTable Mappings for upgrade2GRPGroup ID for Grouping tables in upgradenvarchar100
6/OPT/VIM_UPGTable Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
7/OPT/VIM_UPG_GRPTable Mappings for upgrade2GRPGroup ID for Grouping tables in upgradenvarchar100
8/OPT/VIM_UPG_GRTGroup Texts2GRPGroup ID for Grouping tables in upgradenvarchar100
9/OPT/VIM_UPG_STable Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
10/OPT/X119Table Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
11/OPT/X120Table Mappings for upgrade2GRPGroup ID for Grouping tables in upgradenvarchar100
12/OPT/X121Group Texts2GRPGroup ID for Grouping tables in upgradenvarchar100
13/OPT/X122Table Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
14/OPT/Y119Table Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
15/OPT/Y120Table Mappings for upgrade2GRPGroup ID for Grouping tables in upgradenvarchar100
16/OPT/Y121Group Texts2GRPGroup ID for Grouping tables in upgradenvarchar100
17/OPT/Y122Table Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
18/OPT/Z119Table Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
19/OPT/Z120Table Mappings for upgrade2GRPGroup ID for Grouping tables in upgradenvarchar100
20/OPT/Z121Group Texts2GRPGroup ID for Grouping tables in upgradenvarchar100
21/OPT/Z122Table Mappings for upgrade4GRPGroup ID for Grouping tables in upgradenvarchar100
22/PLMB/PR_GRP_ITMProcess Route Grouping item table5GRPGroup in Process Route Table Groupingnvarchar200
23BOE_CUST_ACTEnable customer enhance status1GRPBoE status groupnvarchar30
24BOE_CUST_TESTtest2GRPBoE status groupnvarchar30
25BOE_STACUSTCustomized status1GRPBoE status groupnvarchar30
26BOE_STATUS_CUSTBoE status for cusotmer inserted1GRPBoE status groupnvarchar30
27BOE_STATUS_GRPBoE status grouping1GRPBoE status groupnvarchar30
28PIQPROC_ED_EXT_WED Activity Document: External Work of Equivalency4GRPAcademic Work Groupingnvarchar20
29PIQPROC_ED_GRPED Activity Document: Transferred Work Grouping3GRPAcademic Work Groupingnvarchar20
30PIQPROC_ED_INT_WED Activity Document: Transferred Internal Academic Work4GRPAcademic Work Groupingnvarchar20
TOPBasic Functions
31T862SStandard reports: Column layout9GRPValue of the group indicatornvarchar60
TOPBusiness Partner
32BP3010Additional Data4GRPGroup Keynvarchar30
33TP019Business Partner: Key for Blank Fields3GRPGroup Keynvarchar30
34TP019TBusiness Partner: Key for Blank Fields4GRPGroup Keynvarchar30
TOPCollectionsDisbursements
35TKKV_T1Test: Quantity of Customizing Tables1GRPVersion Number Componentnvarchar20
TOPGeneral Ledger Reorganization
36FAGL_R_APARReorganization: Object List for Receivables and Payables39GRPGrouping for Entries Belonging Together (All Levels)nvarchar400
37FAGL_R_PL_OBJECTReorganization: Objects27GRPGrouping for Entries Belonging Together (All Levels)nvarchar400
TOPGlobal Performance Analysis Transaction ST3
38SMEC_PROFMEC profile param metadata6GRPMEC Profile Parameter Groupnvarchar100
TOPManagement of Internal Controls
39FOPCTASKMIC Task3GRPTask Groupnvarchar30
TOPMaterials Management
40/ISDFPS/CUSTACCCustomer Jump5GRPGrouping Termnvarchar400
TOPProduction and Revenue Accounting
41OIU_PR_HPPNDVolumetric Historical PPN Detail4GRPGroup (Production)nvarchar40
42OIU_PR_PPNDProduction Prior Period Notification Delivery Ntwk Det. T4GRPGroup (Production)nvarchar40
TOPProfile Maintenance
43TPFYPROPTYParameter attributes3GRPData element describing profile parameternvarchar100
TOPSAP Records Management
44RCMDOCTRANSGRRCM: Possible Transitions for SP Document in Web Dynpro4GRPsmallint50
TOPService Data Download
45/BDL/BDLSERTRANService Definition, Important information to functions6GRPnvarchar200
46BDLSERTRANImportant information to functional modules (download)5GRPnvarchar200
TOPTransformation
47RMXMC_T11ROM: Transformation Groups2GRPTransformation Groupnvarchar30
48RMXMC_T11TROM: Transformation Group Texts3GRPTransformation Groupnvarchar30
49RMXMC_T12ROM: Assignment (Transf. Group, Obj. Cat.) to ABAP Class2GRPTransformation Groupnvarchar30
50RMXMC_T16Default Values for Plants and Transformation Groups3GRPTransformation Groupnvarchar30
TOPTranslation Tools
51LXE_CO_2Collection Groups1GRPCharacter field of length 15nvarchar150
52LXE_CO_2HHeader Data for Collection Groups1GRPCharacter field of length 15nvarchar150
53LXE_TAB_TESTTest Table3GRPnvarchar200
54TRNL_DC_2Package Lists1GRPCharacter field of length 15nvarchar150
55TRNL_DC_2HHeader Data for Groups of Development Classes1GRPCharacter field of length 15nvarchar150
56TRNL_TRTransport groups1GRPCharacter field, length 5nvarchar50
TOPVisit Control
57/DSD/VC_GRPDSD Grouping2GRPDSD Groupingnvarchar60
58/DSD/VC_GRPTDSD: Grouping - Texts2GRPDSD Groupingnvarchar60
TOPWork Clearance Management
59WCCQWCM: Group2GRPGroupnvarchar50
60WCCQTWCM: Group (Texts)2GRPGroupnvarchar50