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

45 columns | Print definition?ERP 6.0  | VARID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTTRACKVARStable for tracking variants4VARIDName for Set of Activity Parametersnvarchar140
2CNVMBTTRTRACKTo store tables configured for tracking5VARIDName for Set of Activity Parametersnvarchar140
3T5HACDefine program variants2VARIDnvarchar40
4HRP1730DB Table for Infotype 173018VARIDSession Variantnvarchar20
5HRPAD506Additional Data for PAD50616VARIDSession Variantnvarchar20
6HRT1773Table Section for Infotype 177331VARIDSession Variantnvarchar20
7T7PIQVARYSession Variants2VARIDSession Variantnvarchar20
8T7PIQVARYTText Table for Academic Session Variants3VARIDSession Variantnvarchar20
TOPCAD Integration
9CDESK_BBOXCDESK: Table for Saving Bounding Boxes13VARIDCDESK: Name of Variantnvarchar100
TOPCATT Computer Aided Test Tool
10CATPCATT - Parameters and variants2VARIDCATT - Variant IDnvarchar80
TOPData Mining
11RSDMTP_DS_PARAMRuntime parameters for Data Source4VARIDSource Parameter GUIDnvarchar300
TOPeCATT Extended Computer Aided Test Tool
12ECLOG_SELSelection of STORE Data for RETRIEVE3VARIDVariant namenvarchar300
13ECSCR_DATAValues for eCATT Script Parameters5VARIDVariant namenvarchar300
14ECSCR_XMLDefinition/Data of Structured eCATT Parameter (XML)5VARIDVariant namenvarchar300
15ECSCR_XML_STRDefinition/Data of Structured Param. of eCATT (XML) STRING5VARIDVariant namenvarchar300
16ECSP_PAR_DATAValues for eCATT Test Run Data Parameters5VARIDVariant namenvarchar300
17ECSP_PAR_VARVvariant defination Test Run Data3VARIDVariant namenvarchar300
18ECSP_PAR_XMLDefinition/Data for Structured Param. - Test Run Data5VARIDVariant namenvarchar300
19ECSP_PAR_XML_STRDefinition/Data of Structured Param. of TRD (XML) STRING5VARIDVariant namenvarchar300
20ECTC_DATAAssignment of TD Parameters to eCATT Interface5VARIDVariant namenvarchar300
21ECTC_VAReCATT Variant Definition Test Configuration3VARIDVariant namenvarchar300
22ECTC_XMLDefinition/Data of Struct. Parms of a Test Config. (XML)5VARIDVariant namenvarchar300
23ECTC_XML_STRDefinition/Data of Struct. Param. of Test Conf. (XML) STRING5VARIDVariant namenvarchar300
24ECTD_DATAValues for Test Data Container Parameters5VARIDVariant namenvarchar300
25ECTD_DATAXValues for Parameters of Test Data Containers (AUNIT)5VARIDVariant namenvarchar300
26ECTD_SYNCXSynchronization for ECTD_DATAX3VARIDVariant namenvarchar300
27ECTD_VAReCATT Variant Definition Test Data Container3VARIDVariant namenvarchar300
28ECTD_XMLDefinition/Data for Structured Param. - Test Data Container5VARIDVariant namenvarchar300
29ECTD_XML_STRDef./Data of Struct. Param. of Test Data Cont. (XML) STRING5VARIDVariant namenvarchar300
TOPItaly
30T5ITVRdefinizione di variabili di UR per condizioni2VARIDIdentificatore di variabilenvarchar100
TOPLocalization
31IDWT_ADD_VARIANTAdditional variant contents for WT generic tool3VARIDABAP: Name of variant (without program name)nvarchar140
TOPMedia Product Sales and Distribution
32JSDVARIANTIS-M Selection Variants4VARIDVariant Namenvarchar140
33JSDVARIANTPARAMSIS-M Selection Variants - Parameters4VARIDVariant Namenvarchar140
34JVSDVARIANTORDIS-M: Assignment of Variant to Sort Criterion3VARIDVariant Namenvarchar140
35TJUSERIS-M: User Settings4VARIDVariant Namenvarchar140
TOPOff-Cycle
36T52OCVVariants for Off-Cycle Payroll Runs5VARIDVariantnvarchar140
TOPPersonalization Framework
37FPB_PERSVARPersonalization: Variables1VARIDPersonalization Variablenvarchar100
38FPB_PERSVARTPersonalization: Texts for Variables1VARIDPersonalization Variablenvarchar100
TOPRemaining Beverage - Obsolete Objects
39/BEV3/CHBCALCVAgreement Calculation - Formula Variable7VARIDIdentifiernvarchar40
40/BEV3/CHCFMVARSFormula variable2VARIDIdentifiernvarchar40
41/BEV3/CHCFMVARSTFormula Variable Text3VARIDIdentifiernvarchar40
TOPSouth Africa
42T5W7GSalary packaging: package variant data4VARIDPackage variant IDnvarchar20
43T5W7ISalary packaging: package variants4VARIDPackage variant IDnvarchar20
TOPWorkbench Utilities
44SPAR_DATAParameter Storage: Persistent Data Container2VARIDABAP: Name of variant (without program name)nvarchar140
45SPAR_SDATParameter Storage: Short data2VARIDABAP: Name of variant (without program name)nvarchar140