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

120 columns | Print definition?ERP 6.0  | GROUPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/BDC_IF_CONFAssign Batch Input Session and Creator (Config.)5GROUPIDGroup name: Batch input session namenvarchar120
2/AIF/BDC_IF_GENAssign Batch Input Session and Creator (Gen.)4GROUPIDGroup name: Batch input session namenvarchar120
3/AIF/BDC_ST_CONFDefine Pre-Interface Determination for Batch Input (Config.)2GROUPIDGroup name: Batch input session namenvarchar120
4/AIF/BDC_ST_GENDefine Pre-Interface Determination for Batch Input (Gen.)1GROUPIDGroup name: Batch input session namenvarchar120
5/AIF/T_SEL_BDCSelection Set for BDC Interfaces5GROUPIDGroup name: Batch input session namenvarchar120
6/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program6GROUPIDID of match group identified by batch matchnvarchar100
7/FLDQ/HNA_BM_OUTHANA task Batch Match Result Records8GROUPIDnvarchar100
8/PERSOS/FLAVGRPTable to store Flavor Shared to a Group4GROUPIDGroup IDnvarchar320
9/PERSOS/GRPPFLAVTable to store Group profile Id and flavor id3GROUPIDGroup Profile IDnvarchar320
10/PERSOS/USRGRPUsers and Groups4GROUPIDGroup IDnvarchar320
11/TDAG/GFWWIM_CGPGenifix: Komponentengruppen2GROUPIDGenifix: ID of component groupint100
12/TDAG/GFWWIM_CMPGenifix: Meta information of a component3GROUPIDGenifix: ID for a group of a componentint100
13DVK00unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx15GROUPIDGroup name: Batch input session namenvarchar120
14EDIPRIOIDbgRFC Inbound Priorities2GROUPIDID of Priority Groupnvarchar60
15EDIQIDESTAssignment of bgRFC Queue Names and Destination4GROUPIDID of Priority Groupnvarchar60
16GRFNJOBCASECase Data for Job3GROUPIDNumberint100
17GRFNJOBDETAILJob Step4GROUPIDNumberint100
18N1CORDFCORD: Order Filler3GROUPIDCORD: Identification of Order Filler Groupnvarchar200
19N1CORDFGCORD: Order Filler Group3GROUPIDCORD: Identification of Order Filler Groupnvarchar200
20N1CORDFGTCORD: Order Filler Group Texts4GROUPIDCORD: Identification of Order Filler Groupnvarchar200
21N1CORDFTCORD: Order Fller Texts4GROUPIDCORD: Identification of Order Filler Groupnvarchar200
22N1CORDFVCORD: Initiator3GROUPIDCORD: Identification of Order Filler Groupnvarchar200
TOPBack Office
23TRST_RECON_RCETreasury: External Securities Account Statement12GROUPIDGrouping of External Securities Account Statementsnvarchar180
TOPBases
24T77OMAHQ_FUNCAROM-Search Function "Free Search": Obj. Type InfoSet (Cust.)5GROUPIDGrouping ID for General Selectionnvarchar200
25T77OMAHQ_FUNCARSOM-Search Function "Free Search": Obj. Type InfoSet (Std.)5GROUPIDGrouping ID for General Selectionnvarchar200
TOPBasic Data
26TNCI1IS-HCM Receipt Parameters for Partner Systems10GROUPIDIS-H: Name of Batch Input Sessionnvarchar120
TOPBasic Functions
27T323VError handling (Host)- Decentralized SD (Definition of mail)7GROUPIDDummy, undefined field consisting of 12 digitsnvarchar120
28TFBWDPersonal Customizing for Transaction FBWD13GROUPIDBatch input session namenvarchar120
29TFBWEPersonal Customizing for Transaction FBWE19GROUPIDBatch input session namenvarchar120
TOPClinical System
30N1CYGROUPi.s.h.med: Group Determination for Cycles2GROUPIDID of Groupnvarchar320
31N1CYGROUPTi.s.h.med: Texts for Group Determination for Cycles3GROUPIDID of Groupnvarchar320
32N1STZYi.s.h.med: Cycles12GROUPIDID of Groupnvarchar320
33TN2KUM01IS-H*MED: Group headers for cumulative findings5GROUPIDID for Groups of Servicesnvarchar40
34TN2KUM02IS-H*MED: Asgmt Services->Groups for cumulative findings4GROUPIDID for Groups of Servicesnvarchar40
35TN2KUM07IS-H*MED: Assignm. of service groups for cumulative findings5GROUPIDID for Groups of Servicesnvarchar40
TOPData Staging
36RSTRANGROUPTTransformation Texts4GROUPIDNumber of Transformation Groupnvarchar20
37RSTRANRULETransformation Rule5GROUPIDNumber of Transformation Groupnvarchar20
TOPFunds Management
38FMFGRCNGROUPReconciliation Group for Reconciliation Tool1GROUPIDReconciliation Group IDnvarchar40
39FMFGRCNGROUPTReconciliation Group Text1GROUPIDReconciliation Group IDnvarchar40
40FMFGRCNPROVIDERReconciliation Tool Data Provider2GROUPIDReconciliation Group IDnvarchar40
41FMFGRCNRULEReconciliation: Reconcilation Rule definition3GROUPIDReconciliation Group IDnvarchar40
42FMFGRCNSLICEData slice for Reconciliation Tool4GROUPIDReconciliation Group IDnvarchar40
TOPGeneral Application Functions
43TABADRSCharacteristic Derivation: Steps12GROUPIDID for step groupnvarchar80
TOPGeneral Object Relations
44SROBJGROUPObject Relationship Service object group2GROUPIDGUID of a group of objectsnvarchar220
45SROBJINGRPObject Relationship Service table objects in group5GROUPIDGUID of a group of objectsnvarchar220
TOPHandling of Inflation
46J_1APROLOGLog table for Inflation Adjustment Programs3GROUPIDGroup name: Batch input session namenvarchar120
TOPHR Information Systems
47HRSEL_GROUPIDSPossible Groupings2GROUPIDGrouping ID for General Selectionnvarchar200
48HRSEL_GROUPINGSelection Grouping2GROUPIDGrouping ID for General Selectionnvarchar200
TOPInformation System
49COCF_MD_ADM_MULDTable for Multidimensional analysis for manufacturing dash b7GROUPIDGroup ID for Multidimensional Analysisnvarchar320
TOPLease Accounting
50TFILA_FA_001Process+Accounting Principle -> Transaction Type4GROUPIDCompany Code Groupnvarchar40
51TFILA_FA_003Control of Useful Life Adjustment for Upgrades3GROUPIDCompany Code Groupnvarchar40
52TFILA_GF_003CFAssignment of Value ID -> Payment Schedule for Calculation4GROUPIDCompany Code Groupnvarchar40
53TFILA_GF_003MFor Later Use of Value IDs for Retrieval4GROUPIDCompany Code Groupnvarchar40
54TFILA_GF_003MVAssignment Value ID <-> Processing Method5GROUPIDCompany Code Groupnvarchar40
55TFILA_GF_003RValue IDs Referenced from Method6GROUPIDCompany Code Groupnvarchar40
56TFILA_GF_004Assignment Value ID -> Accrual Method4GROUPIDCompany Code Groupnvarchar40
57TFILA_GF_004BTAssignment of Value ID -> Accrual Method for Determ. Balance4GROUPIDCompany Code Groupnvarchar40
58TFILA_GF_004CFAssignment of Payment Schedule for Accrual Postings4GROUPIDCompany Code Groupnvarchar40
59TFILA_GF_005Specifications for One-Time Postings per Value ID4GROUPIDCompany Code Groupnvarchar40
60TFILA_GF_008Assignment of Company Code to Grouping Key4GROUPIDCompany Code Groupnvarchar40
61TFILA_GF_008GGrouping Key3GROUPIDCompany Code Groupnvarchar40
62TFILA_GF_008GTName of Grouping Key4GROUPIDCompany Code Groupnvarchar40
63TFILA_GF_009Assignment of Value IDs to Structure Field5GROUPIDCompany Code Groupnvarchar40
64TFILA_GF_009FAssignment of Field Transfer of Two Structures5GROUPIDCompany Code Groupnvarchar40
65TFILA_GF_009VMapping Table for Structure Fields in Value IDs5GROUPIDCompany Code Groupnvarchar40
66TFILA_GF_020SAssign Value IDs for Determining Residual Value2GROUPIDCompany Code Groupnvarchar40
67TFILA_GF_020TFill New Residual Values in Conditions2GROUPIDCompany Code Groupnvarchar40
68TFILA_LC_002TOSpecification Asset Values Copied for Following Business3GROUPIDCompany Code Groupnvarchar40
TOPMedia Product Sales and Distribution
69TJVSDSHPGFILTERFilter Groups in Shipping Plan2GROUPIDFilter Group for Shipping Plannvarchar20
70TJVSDSHPGFILTERTFilter Groups in Shipping Plan - Texts2GROUPIDFilter Group for Shipping Plannvarchar20
71TJVSDSHPVFILTERFilter Variants in Shipping Plan3GROUPIDFilter Group for Shipping Plannvarchar20
72TJVSDSHPZFILTERAssignment of Filters to Filter Groups in Shipping Plan2GROUPIDFilter Group for Shipping Plannvarchar20
TOPMonitoring
73ALPFREP_CATPerfDB Reporting Catalog2GROUPIDID Number of a Group in a PerfDB Report Definitionint100
TOPPeriodical Sales and Distribution
74TJY09IS-M: Restart Data Transfer5GROUPIDIS-M: Session Namenvarchar120
TOPPersonnel Administration
75T599CReport Categories13GROUPIDGrouping ID for General Selectionnvarchar200
TOPPersonnel Management
76/BKC/S21_T599CShadow table of T599C13GROUPIDGrouping ID for General Selectionnvarchar200
TOPProduction and Revenue Accounting
77OIUPR_API_RFCRFC transmission status16GROUPIDGroup name: Batch input session namenvarchar120
TOPProduction Orders
78COCF_IS_PT_BTNButtons for types of Information System Feeder5GROUPIDButton Group IDnvarchar30
TOPProfitability Analysis
79TKEDRSCharacteristic Derivation: Steps12GROUPIDID for step groupnvarchar80
TOPRisk Analysis
80AFWCH_DRS_SAMPSample Customizing for Derivation (Steps)11GROUPIDID for step groupnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
81N2BIGROUPABase Items: Base Item Groups Assignment3GROUPIDBase Items: Internal Identification of Groupnvarchar320
82TN2BIGROUPBase Items: Base Item - Groups2GROUPIDBase Items: Internal Identification of Groupnvarchar320
83TN2BIGROUPTBase Items: Base Item Groups - Texts2GROUPIDBase Items: Internal Identification of Groupnvarchar320
TOPSAP Records Management
84SRMWFGRPMaintenance of Grouping Options for Process Route Model3GROUPIDGrouping Key for Program Run Modelnvarchar20
85SRMWFGRPTText Table for Grouping Process Route Models3GROUPIDGrouping Key for Program Run Modelnvarchar20
86SRMWFPATHGROUPAssignment Table of Process Route Models for Groups4GROUPIDGrouping Key for Program Run Modelnvarchar20
TOPSCM Basis
87CIFOBJINFOControl Table for APO-CIF Filter Objects, Client-Independent24GROUPIDThematic Group of Publishing Typesnvarchar10
88CIFSELOPTDefinition of the Selection Options for Publishing Types3GROUPIDGrouping ID for Objects for a Selection Optionnvarchar20
TOPService Data Download
89/BDL/BDLFUGRPSService Definition, Link between GROUPID and Logfunc2GROUPIDGroup IDnvarchar40
90/BDL/BDLGROUPSService Definition, Table of group descriptions2GROUPIDGroup IDnvarchar40
91/BDL/BDLSERGRPSService Definition, Link between contract type and GROUPID4GROUPIDGroup IDnvarchar40
92BDLFUGRPSLink between GROUPID and the logical function name1GROUPIDGroup IDnvarchar40
93BDLGROUPSTable of group descriptions (reference table)1GROUPIDGroup IDnvarchar40
94BDLSERGRPSLink between contract type and GROUPID3GROUPIDGroup IDnvarchar40
TOPShared Service Center Framework
95SSCELEMENTShared Service Center: Activity4GROUPIDShared Services Center: Application Areanvarchar100
96SSCGROUPShared Service Center: Application Area3GROUPIDShared Services Center: Application Areanvarchar100
97SSCGROUPTShared Service Center: Application Area name4GROUPIDShared Services Center: Application Areanvarchar100
98SSCMESSAGEFSSC: Automatic Service Request Aggregation Rule3GROUPIDShared Services Center: Application Areanvarchar100
99SSCPARADETERMShared Service Center: Target field value determination3GROUPIDShared Services Center: Application Areanvarchar100
100SSCSOURCEFLDShared Service Center: Source Field3GROUPIDShared Services Center: Application Areanvarchar100
101SSCSRservice request in backend6GROUPIDShared Services Center: Application Areanvarchar100
TOPShift Planning
102T77ESSelection ID for Shift Planning Profile3GROUPIDGrouping ID for General Selectionnvarchar200
TOPSocial Services and Social Security
103PSSCC_SWITCHSocial Services Switches1GROUPIDSwitch Group IDnvarchar100
104PSSCC_SWITCHVALSocial Services Switches2GROUPIDSwitch Group IDnvarchar100
105PSSCC_SWITCH_TSocial Services Switches2GROUPIDSwitch Group IDnvarchar100
TOPTable Maintenance Tool
106SDMEDPFFDME: Dialog Pool Component 'Form' (Fields)10GROUPIDDME: Group ID for Field Groups in Detail Screennvarchar80
107SDMEDPFGTDME: Dialog Pool Component 'Form' (Group Texts)4GROUPIDDME: Group ID for Field Groups in Detail Screennvarchar80
TOPUI Services, Screen, Batch Input
108APQIQueue info definition5GROUPIDGroup name: Batch input session namenvarchar120
109APQLBatch Input Log Directory5GROUPIDGroup name: Batch input session namenvarchar120
110BDCUSEOPUser-Specific Options for Transaction SM354GROUPIDGroup name: Batch input session namenvarchar120
TOPUpgrade Tools
111CRRPARATESTTest table for CRR parallelisation test5GROUPIDtinyint30
112CRRTASKINFOCRR task information5GROUPIDtinyint30
TOPWorkplace Server
113TCBRCUSTOMCustomer Branding Parameter Table1GROUPIDGroup ID for Parameter Setnvarchar200
114TCBRGROUPCustomer Branding Parameter Groups1GROUPIDGroup ID for Parameter Setnvarchar200
115TCBRGROUPTCustomer Branding Parameter Groups2GROUPIDGroup ID for Parameter Setnvarchar200
116TWPCUSTMCTText Table for Customer System Settings for Workplace3GROUPIDGroup Name for System Settingsnvarchar100
117TWPCUSTOMSystem Setting for the Workplace1GROUPIDGroup Name for System Settingsnvarchar100
118TWPCUSTOMCCustomer-Defined System Setting for the Workplace2GROUPIDGroup Name for System Settingsnvarchar100
119TWPCUSTOMTText Table for System Settings for the Workplace2GROUPIDGroup Name for System Settingsnvarchar100
120USRGENPRSTable for General Workplace Personalization Data3GROUPIDGroup Name for System Settingsnvarchar100