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

148 columns | Print definition?ERP 6.0  | VARIANTE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/T_VARIANTSGraphical Planning Table: Settings for Fields3VARIANTEnvarchar200
2/GEP/T_VARIANTSTGraphischer Leitstand: EinstellungenTexttabelle3VARIANTEGraphische Einsatzplanung: Darstellungsvariantenvarchar200
3/SAPSRM/TT_DATATest Data for SRM Test Tool3VARIANTEVariant for SRM Test Toolnvarchar150
4RSPCCHAIN_SKIPSkipped processes4VARIANTEProcess Variant (Name)nvarchar300
5RSPCTRACETrace: Process chain17VARIANTEProcess Variant (Name)nvarchar300
6T086ACall up of AM reports per transaction function6VARIANTEName of selection version of a reportnvarchar140
7T160VDefault Values for Purchasing34VARIANTELayoutnvarchar100
8TKE_TIMERCO-PA Runtime Measurements5VARIANTEText field length 14nvarchar140
9TQ32Assignment of inspection type to origin3VARIANTEVariant of The Inspection Lot Originnvarchar20
TOPAccounting - General
10TFC_INST_ITEMAdministration of a Job (Report/Transaction or Workflow)11VARIANTEVariant Namenvarchar140
11TFC_TEMPL_ITEMAdministration of a Job (Report/Transaction or Workflow)11VARIANTEVariant Namenvarchar140
TOPActivity-Based Costing
12COSRVVariants (characteristics) for LIS performance measures2VARIANTECharacteristics for statistical base from LISnvarchar100
13COSRVAPPLApplication Component to Which LIS Variants Belong2VARIANTECharacteristics for statistical base from LISnvarchar100
TOPAnalyzer
14AFWCH_FLD_BKBackup Filter Definition3VARIANTEFilter: Variantnvarchar80
15AFWCH_FL_BKAFWCH: Header Data for Filter History3VARIANTEFilter: Variantnvarchar80
16AFWCH_PHDEFALTAlternative Portfolio Hierarchy Definition6VARIANTECharacteristics Hierarchynvarchar30
TOPBasic Functions
17TABVAVariants for determining asset value date2VARIANTEVariant for determining asset value datenvarchar140
18TABVATNames of variants for determining asset value date3VARIANTEVariant for determining asset value datenvarchar140
19TABVODetermine asset value date in Asset Accounting transactions2VARIANTEVariant for determining asset value datenvarchar140
TOPBW Service API
20ROPC_WFBORWorkflow Processes Started5VARIANTEProcess Chains: Variant (for Workflow)nvarchar300
TOPClient-System Adapter
21MDMEXVARIHEADMDM Extraction Process: Header Table1VARIANTEVariant for Extractionnvarchar300
22MDMEXVARISELMDM Extractor: Selection Criteria1VARIANTEVariant for Extractionnvarchar300
23MDMEXVARITRANMDM Extractor: Transfers1VARIANTEVariant for Extractionnvarchar300
24MDMEXVARITXTMDM Extraction Process: Text Table2VARIANTEVariant for Extractionnvarchar300
TOPConstruction Equipment Management
25J_3GTCHLPAuxiliary Table for Joint Venture Trans. Calls (SAPMJ3GO)5VARIANTETransaction variantnvarchar300
TOPCross-Application Components
26J_8A3T0009clipboard for test environment2VARIANTEtestenvironment: parameter variantnvarchar200
27J_8A3TUMclipboard for test environment - Old Version, don't use2VARIANTEtestenvironment: parameter variant - Old Version, don't usenvarchar200
TOPCustomer Bill of Services
28/SAPBOQ/T162V/SAPBOQ/: Display Variant for Service Overview1VARIANTELayoutnvarchar100
TOPData Collection
29TKEBXAdministration of exceptions11VARIANTEVariant Namenvarchar140
30TKEV1Background variants for drill-down reporting4VARIANTEVariable group for planning a job in the backgroundnvarchar140
31TKEV2Background variants for drill-down reporting (text)5VARIANTEVariable group for planning a job in the backgroundnvarchar140
TOPData Staging
32RSICPROTLogs for Processed Jobs22VARIANTEProcess Variant (Name)nvarchar300
33RSLDPUSEDHISTChange History Use of InfoPackage10VARIANTEProcess Variant (Name)nvarchar300
34RSMONENQEnqueue table for scheduler1VARIANTEVariantnvarchar120
35RSMONPCLoad-Monitor Connection of Process Runs4VARIANTEProcess Variant (Name)nvarchar300
36RSMONPROCESSProcesses that have worked with requests3VARIANTEProcess Variant (Name)nvarchar300
37RSPCABAPASYNCLogging for ABAP Processes(Synchronously and Asynchronously)1VARIANTEProcess Variant (Name)nvarchar300
38RSPCACTIVECHECKResults of Active Check with PC_ACTIVE Process Type1VARIANTEProcess Variant (Name)nvarchar300
39RSPCCHAINProcess chain4VARIANTEProcess Variant (Name)nvarchar300
40RSPCCHAINEVENTSMultiple Events with Process Chains4VARIANTEProcess Variant (Name)nvarchar300
41RSPCCOMMANDLOGSystem Command Execution Logs (Process Chains)1VARIANTEProcess Variant (Name)nvarchar300
42RSPCENQUEUEDummy Table for Runtime Locks of a Process2VARIANTEProcess Variant (Name)nvarchar300
43RSPCEXORExcluding Or: Log Table1VARIANTEProcess Variant (Name)nvarchar300
44RSPCINSTANCEGeneric Instance Storage2VARIANTEProcess Variant (Name)nvarchar300
45RSPCINSTANCETTexts for Generic Instance-Storage3VARIANTEProcess Variant (Name)nvarchar300
46RSPCINTERRUPTVariants for the Trigger Processes1VARIANTEProcess Variant (Name)nvarchar300
47RSPCINTERRUPTLOGTable for Interrupt Processes1VARIANTEProcess Variant (Name)nvarchar300
48RSPCINTERRUPTTTexts for Interrupt Variants2VARIANTEProcess Variant (Name)nvarchar300
49RSPCLOGCROSSCross-Table Log ID Old / Log ID New3VARIANTEProcess Variant (Name)nvarchar300
50RSPCLOGSApplication Logs for the Process Chains (Generic Service)2VARIANTEProcess Variant (Name)nvarchar300
51RSPCPROCESSLOGLogs for the Chain Runs9VARIANTEProcess Variant (Name)nvarchar300
52RSPCTRIGGERVariants for the Trigger Processes1VARIANTEProcess Variant (Name)nvarchar300
53RSPCTRIGGERTTexts for the Trigger Variants2VARIANTEProcess Variant (Name)nvarchar300
54RSPCVARIANTGeneric Variant Storage2VARIANTEProcess Variant (Name)nvarchar300
55RSPCVARIANTATTRAttributes of a Process Variant2VARIANTEProcess Variant (Name)nvarchar300
56RSPCVARIANTTTexts for Generic Variant Storage3VARIANTEProcess Variant (Name)nvarchar300
57RSPC_BUFFERShared Buffer for Processes (Esp. Customer Programs)2VARIANTEProcess Variant (Name)nvarchar300
TOPEnd User Technology
58RSRA_BC_LOGLog Table for the Batch Runs for Precalculating Template9VARIANTEABAP: Name of variant (without program name)nvarchar140
59RSRA_ER_LOGNLog Table for Batch Runs of Exception Reporting9VARIANTEABAP: Name of variant (without program name)nvarchar140
60RSRA_SETTING_BBRA Settings for Calculating Buckets6VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPExternal Services
61T162VDisplay Variant for Service Overview1VARIANTELayoutnvarchar100
TOPFinancial Accounting
62TAX_SERVICESTax Services3VARIANTEVariant for the Execution of Tax Servicesnvarchar10
TOPIncentive and Commission Management ICM
63CACS_USAGETREEICM Application Measurement: Tree5VARIANTELayoutnvarchar120
64CACS_USAGETREECCACS_USAGE Tree - Customer Entries5VARIANTELayoutnvarchar120
TOPInformation System
65TCNDBProfile: Database parameters in Project Info System29VARIANTEVariant Namenvarchar140
66TCNDB_PSJTProfile: as TCNDB, only for verification of LDB PSJ!!29VARIANTEVariant Namenvarchar140
TOPInteractive Drilldown Reporting
67TKEV7Language-Dependent Variant Information for Drilldown Reportg7VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPInvoice Verification
68T169TCLogistics Invoice Verification: Item List Variants1VARIANTELayoutnvarchar100
69T169TCDATALogistics Invoice Verification: Item List Variants1VARIANTELayoutnvarchar100
70T169TCTEXTTo be deleted!2VARIANTELayoutnvarchar100
TOPliveCache
71LCINITControl Table for liveCache Initialization (Application)3VARIANTEVariant Namenvarchar140
TOPliveCache Applications
72/SAPAPO/OM02_BTCVariants for Background Processing /SAPAPO/OM023VARIANTEABAP: Name of variant (without program name)nvarchar140
73LCA02_BTCVariants for Background Processing of LCA023VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPLocal Currency Changeover
74EWUPGCTEMU: Program check for conversion8VARIANTEBatch job variantnvarchar140
TOPLogical DB, Selection Screens, Selection Variants
75TVARTABAP/4: Texts of variables in selection conditions3VARIANTECHAR14 for SYSTnvarchar140
TOPMaterial Sorting
76/BEV1/EMASVMaterial Sorting Variant2VARIANTEMaterial Sorting Variantnvarchar20
77/BEV1/EMASVTMaterial Sorting Variant - Texts2VARIANTEMaterial Sorting Variantnvarchar20
78/BEV1/EMFASForm for Material Sorting Variant3VARIANTEMaterial Sorting Variantnvarchar20
79/BEV1/EMFAS1Material Sorting: Sales Documents4VARIANTEMaterial Sorting Variantnvarchar20
80/BEV1/EMFAS2Material Sorting: Shipping Documents5VARIANTEMaterial Sorting Variantnvarchar20
81/BEV1/EMFAS3Material Sorting: Groups5VARIANTEMaterial Sorting Variantnvarchar20
82/BEV1/EMFAS4Material Sorting: Billing Documents6VARIANTEMaterial Sorting Variantnvarchar20
TOPMaterials Management
83USER_VARUser-Dependent Start Variants4VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPOverhead Cost Controlling
84COKRCO Object: Control Data for Statistical Key Figures19VARIANTECharacteristics for statistical base from LISnvarchar100
TOPPayment Item
85TBKKI_06Field Modifications for Payment Order2VARIANTEVariants for Field Statusnvarchar10
86TBKKI_RCVControl of the Recipient Bank Detail Identification4VARIANTEBank Identification Variantnvarchar10
TOPPeriodical Sales and Distribution
87TJY19IS-M/SD: Dynamic Maintenance of Variables in Table TVARV3VARIANTEUsed Selection Screen Variantnvarchar140
TOPPool Asset Management
88PAMS_VARIGraphical Planning Board: Field Settings3VARIANTEGraphical Operational Planning: Display Variantnvarchar200
89PAMS_VARITGraphical Planning Board: Field Settings - Text Tab.3VARIANTEGraphical Operational Planning: Display Variantnvarchar200
TOPProcess Order
90TOPDEVVProcess Order - Selection Variants4VARIANTEName of the report variant of the filternvarchar140
TOPProduct Cost Controlling
91CATDHCATT Test Data Memory, History6VARIANTELayoutnvarchar100
92CATDOCATT Test Data Memory, Test Objects7VARIANTELayoutnvarchar100
TOPProduct Cost Planning
93MAKABuffer Table for MiniApps of the Costing3VARIANTEVariant Namenvarchar140
94TCWB_OBJECTSTestobjekte5VARIANTEVariante eines Prozessesnvarchar100
95TCWB_OBJECTS_HISHistorie zum Testobjekt6VARIANTEVariante eines Prozessesnvarchar100
96TCWB_PROCESSProzess: Prozeßablauf3VARIANTEVariante eines Prozessesnvarchar100
97TPROCESSESProzesse und Varianten3VARIANTEAnzeigevariantenvarchar100
98TSETTINGSEinstellungen für COPCDATEN und COPCOBJ7VARIANTEAnzeigevariantenvarchar100
TOPProduction Orders
99TCOAOverall profile for order information system5VARIANTEVariant for order information systemnvarchar140
TOPPurchasing
100T161Purchasing Document Types19VARIANTELayoutnvarchar100
TOPRecycling Administration Core Functions
101J_7LM01REA Article Master: General Data3VARIANTEVariant of Articlenvarchar180
102J_7LM02REA Article Master: Company Code4VARIANTEVariant of Articlenvarchar180
103J_7LM03REA Article Master: Sales Units6VARIANTEVariant of Articlenvarchar180
104J_7LM04REA Article Master: Packaging Assignments6VARIANTEVariant of Articlenvarchar180
105J_7LM05REA Article Master: Recycling Partner Assignment6VARIANTEVariant of Articlenvarchar180
106J_7LM06REA Article Master: Bills of Material6VARIANTEVariant of Articlenvarchar180
107J_7LM07REA Article Master: General Referencing3VARIANTEVariant of Reference Articlenvarchar180
108J_7LM08REA Article Master: Referencing Company Codes/Countries5VARIANTEVariant of Reference Articlenvarchar180
109J_7LM09REA Article Master: R.Partner-Depend.Data Assign.Packaging6VARIANTEVariant of Articlenvarchar180
110J_7LM10REA Article Master: Filters for Regional Processing6VARIANTEVariant of Articlenvarchar180
111J_7LM11REA Article Master: Declaration Key5VARIANTEVariantnvarchar180
112J_7LV01REA Packaging Master Data: General Data3VARIANTEVariant of Packagingnvarchar180
113J_7LV01TREA Packaging Master: Short Texts3VARIANTEVariantnvarchar180
114J_7LV02REA Packaging Master Data: Fraction Assignment (Weight)3VARIANTEVariant of Packagingnvarchar180
115J_7LV03REA Packaging Master Data: Recycling Partner Assignment3VARIANTEVariant of Packagingnvarchar180
116J_7LV06REA Packaging Master Data: Bills of Material3VARIANTEVariantnvarchar180
117J_7LV08REA Packag. Mast. Data: Re.Partner-Dep. Data Asgmt Fraction3VARIANTEVariant of Packagingnvarchar180
118J_7LV1MREA Document: Quantity Flow on Article Level17VARIANTEVariantnvarchar180
119J_7LV1PREA Document: Item Data80VARIANTEVariantnvarchar180
120J_7LV2KREA Assortment Declaration Declar. Objects: Header8VARIANTEVariant of Articlenvarchar180
121J_7LV2PREA Assortment Declaration Declar. Objects: Line Items10VARIANTEVariant of Packagingnvarchar180
TOPRemaining Beverage - Obsolete Objects
122/BEV3/CHCVRSTRTSelection of Report Variants Before Start3VARIANTEABAP: Name of variant (without program name)nvarchar140
123/BEV3/CHCVRSTRTTSelection of Report Variants Before Start - Text4VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPRisk Analysis
124JBRPHDEFDefinitions Used to Derive Portfolio Hierarchy5VARIANTECharacteristics Hierarchynvarchar30
125JBRPHDEFBKRM: Backup for Table JBRPHDEF5VARIANTECharacteristics Hierarchynvarchar30
126JBRPHGERM: Portfolio Hierarchy: Generation Data17VARIANTEFilter: Indexnvarchar80
127JBRTKCHABKRM: Backup Table for Characteristic Hierarchies5VARIANTEHierarchy variantnvarchar30
TOPRouting
128CWB_SEL_VARIANTSEWB: User-Specific Initial Variants4VARIANTEVariant Namenvarchar140
129CWB_SEL_VAR_DEFEWB: User-defined settings for selection variants4VARIANTEDefault selection variantnvarchar140
130CWB_SEL_VAR_ROOTEWB: All selection variants4VARIANTESelection variantnvarchar140
131CWB_SEL_VAR_TXTEWB: Descriptions (meanings) of selection variants in EWB4VARIANTESelection variantnvarchar140
TOPSAP Media
132J_1SVARIEVIS-M/SD CH: Variants for Global Changes in Retail2VARIANTEVariant Namenvarchar140
TOPSAP Records Management
133SRM_INDX4Table for Search Variants6VARIANTEProfile Namenvarchar640
TOPSchedule Manager
134SCMAVARIANTSVariants for Flow Definitions3VARIANTEVariant Namenvarchar140
135SMMAINMain Information for an Entry in the Monitor17VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPService Data Download
136/SOMO/JOSCHEDLJob scheduling table for business process monitoring79VARIANTEnvarchar300
137/SOMO/JOSCHEDLTJob Schedule Local Template61VARIANTEnvarchar300
TOPSyntax, Compiler, Runtime
138SABAP_ALV_CHECKSTable for Collecting Dynamic ALV Check Data10VARIANTEABAP: Name of variant (without program name)nvarchar140
TOPTime Sheet
139CATS_TEMPCATS: Database Table for Templates3VARIANTEData Entry Profilenvarchar80
TOPTravel Planning
140FTPT_FARE_NOTERate Rules5VARIANTEPlan variant number (sequential number)nvarchar20
141FTPT_FLIGHT_FCMPAssignment table: flights <-> rate components5VARIANTEPlan variant number (sequential number)nvarchar20
142FTPT_FLIGHT_TSTKTicket Information5VARIANTEPlan variant number (sequential number)nvarchar20
143FTPT_OTHERTravel Reservation Request Item - Other Service5VARIANTEPlan variant number (sequential number)nvarchar20
144FTPT_REQUESTTravel Plan Requests5VARIANTEPlan variant number (sequential number)nvarchar20
145FTPT_SERVICEGeneral Services5VARIANTEPlan variant number (sequential number)nvarchar20
146FTPT_SYNC_DATAData Synchronization: SAP - External System5VARIANTEPlan variant number (sequential number)nvarchar20
TOPUpgrade Tools
147DDCNVTIMESDD: Exclusion times for conversion2VARIANTEDD: For different variants of exclusion timesnvarchar50
TOPWork Management Mobile Business
148EWM_MREAD_CUSTMAU: Meter Reading Customizing for User4VARIANTEABAP: Name of variant (without program name)nvarchar140