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

52 columns | Print definition?ERP 6.0  | VARIANT_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/PERF_MSGSStarted messages for Performance Analysis2VARIANT_NAMEVariant for Time Trackingnvarchar200
2/AIF/PERF_VARSVariants for performance time tracking2VARIANT_NAMEVariant for Time Trackingnvarchar200
3/AIF/T_ACCHECKVCheck assignment3VARIANT_NAMEName of Interface Variantnvarchar200
4/AIF/T_ACTVAction3VARIANT_NAMEName of Interface Variantnvarchar200
5/AIF/T_FFIXVTable for variant fix values5VARIANT_NAMEName of Interface Variantnvarchar200
6/AIF/T_FINFVVariant Interface Selection3VARIANT_NAMEName of Interface Variantnvarchar200
7/AIF/T_FMAPCONDVField condition mapping variant3VARIANT_NAMEName of Interface Variantnvarchar200
8/AIF/T_FMAPVField mapping (obsolete)3VARIANT_NAMEName of Interface Variantnvarchar200
9/AIF/T_FUNCVFunction3VARIANT_NAMEName of Interface Variantnvarchar200
10/AIF/T_IFACTVAssign actions3VARIANT_NAMEName of Interface Variantnvarchar200
11/AIF/T_IFCHECKVCheck assignment3VARIANT_NAMEName of Interface Variantnvarchar200
12/AIF/T_INTFIXVFix value for interface3VARIANT_NAMEName of Interface Variantnvarchar200
13/AIF/T_MFIXVFix values for master data (no transport)5VARIANT_NAMEName of Interface Variantnvarchar200
14/AIF/T_MTFIXVFix value tables for master data (no transport)6VARIANT_NAMEName of Interface Variantnvarchar200
15/AIF/T_SM_FMAPVField mapping condition3VARIANT_NAMEName of Interface Variantnvarchar200
16/AIF/T_STRMAPVSelect & Add Structure Mapping3VARIANT_NAMEName of Interface Variantnvarchar200
17/AIF/T_TABCHKVSingle Check3VARIANT_NAMEName of Interface Variantnvarchar200
18/AIF/T_TABFLDVTable Check Fields3VARIANT_NAMEName of Interface Variantnvarchar200
19/AIF/T_TFIXVFix value table6VARIANT_NAMEName of Interface Variantnvarchar200
20/AIF/T_VARIANTTable for interface variants3VARIANT_NAMEName of Interface Variantnvarchar200
21/AIF/T_VARIANTTText Table for interface variants3VARIANT_NAMEName of Interface Variantnvarchar200
22/AIF/T_VMAPVValue mapping3VARIANT_NAMEName of Interface Variantnvarchar200
23/AIF/T_VMAPVAL5VValue mapping for master data (customizing)3VARIANT_NAMEName of Interface Variantnvarchar200
24/AIF/T_VMAPVALVValue mapping for master data (customizing)3VARIANT_NAMEName of Interface Variantnvarchar200
25/AIF/VAR_AS_TMPLTemplate for a variant assignment table6VARIANT_NAMEName of Interface Variantnvarchar200
26/SAPSRM/D_SAV_VADatabase table for saving user variants5VARIANT_NAMEPDO: Saved User Variant Namenvarchar300
27GRFNREPUSRVARReporting: Reports users variants5VARIANT_NAMEReport variant namenvarchar400
28MDG_GW_VARIANT_HDrill Down search save variant header data2VARIANT_NAMEDrill down search variant namenvarchar500
29UPS_OD_VARIANTUser Variants4VARIANT_NAMEVariant Namenvarchar500
TOPCapacity and Resource Planning
30/MRSS/D_VARIANTSVariants for RM Application2VARIANT_NAMEVariant Namenvarchar140
TOPEnvironment, Health and Safety
31/TDAG/EHFNDC_VARWFF: Customizing: Process variant of a TBO2VARIANT_NAMEWFF: Variant Name of Workflownvarchar300
32/TDAG/EHSRCD_MATable for persisting TBOs of type /TDAG/CL_TBO_MA11VARIANT_NAMEWFF: Variant Name of Workflownvarchar300
33/TDAG/EHSRCD_MILTable for persisting TBOs of type /TDAG/CL_TBO_MIL11VARIANT_NAMEWFF: Variant Name of Workflownvarchar300
34/TDAG/EHSRCD_RPTable for persisting TBOs of type /TDAG/CL_TBO_RP11VARIANT_NAMEWFF: Variant Name of Workflownvarchar300
35/TDAG/EHSRCD_SPTable for persisting TBOs of type /TDAG/CL_TBO_SP11VARIANT_NAMEWFF: Variant Name of Workflownvarchar300
TOPFSCM In-House Cash
36IHC_TAB_ARCH_IDXIHC: Archive Index Table6VARIANT_NAMEIHC: Archive Index, Variant Namenvarchar140
37IHC_TAB_SELECTIHC: Selections in Selection Variants4VARIANT_NAMESelection Variantnvarchar140
38IHC_TAB_VARIANTIHC: Selection Variant4VARIANT_NAMESelection Variantnvarchar140
39IHC_TAB_WORKLISTIHC: Saved Worklists4VARIANT_NAMESelection Variantnvarchar140
TOPMaintenance Processing
40/MRSS/D_VARIANTVariant details4VARIANT_NAMEVariant Namenvarchar140
TOPNetWeaver Demonstration
41SNWD_DG_PARAMSEXM: Data Generator Parameters3VARIANT_NAMEnvarchar200
TOPObject Navigator
42/PLMB/NAV_SETVALNAV - User Specific Navigator Setting data2VARIANT_NAMEVariant Namenvarchar300
43/PLMB/NAV_SETVARNAV - User Specific Navigator Setting Variants2VARIANT_NAMEVariant Namenvarchar300
TOPProduct and Process Modeling
44RLMFWOLCMPRelease Order - Items - Component Variants15VARIANT_NAMEVariantnvarchar80
TOPProduct Structure and Assembly Management
45/PLMI/PPE_C_ODVTPLM WebUI Customizing Object Description: Variants Texts4VARIANT_NAMEDescription of iPPE Object Typenvarchar400
TOPProduction Orders
46COCF_CU_VARIANTCustomizing for F4 Help for Variant Selection4VARIANT_NAMEName of a Variant for Order Information Systemnvarchar140
TOPSAP NetWeaver Mobile - Use subcomponents
47MEREP_209Variant for SyncBO Emulator3VARIANT_NAMEVariantnvarchar140
48MEREP_210Variant for SyncBO Emulator3VARIANT_NAMEVariantnvarchar140
TOPShift Planning for Public Sector
49PSPP_INFO_COLTable for Info Columns Associated with a Variant3VARIANT_NAMEVariant Name for Grouping of Information Columnsnvarchar120
50PSPP_INFO_VARTable for Variant Information for Info Column Grouping3VARIANT_NAMEVariant Name for Grouping of Information Columnsnvarchar120
51PSPP_INFO_VARTTable for Variant Text for Info Column Grouping4VARIANT_NAMEVariant Name for Grouping of Information Columnsnvarchar120
TOPUser Interface
52/PLMPCV/D_VARTTQuery Variant Texts5VARIANT_NAMEName of Query Viewnvarchar400