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

70 columns | Print definition?ERP 6.0  | STRUC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ICLUSCNTXTUser Context in Claim Applications5STRUCName of a structurenvarchar300
2T5APDAssignment of Global Data to AWPBP Split Functions3STRUCStructurenvarchar10
3T77EIRNL_BCKPRXNElectronic Illness Reporting NL: Association Backend & Proxy7STRUCTable name, 16 charactersnvarchar160
4T77PADRUDTFRMTCTDescription4STRUCName of a structurenvarchar300
5T77PADRUDTFRMTTText table for T7RUDATAFORMAT4STRUCName of a structurenvarchar300
6T7RUDATAFORMATData Output Format for Reports3STRUCName of a structurenvarchar300
7T7RUDATAFORMATCData Output Format for Reports3STRUCName of a structurenvarchar300
TOPAdvertising Management
8TJHCUSTENVIS-M: Cluster Builder Parameter for Business Partner Envrnmt4STRUCIS-M: Structure Selection for Business Partner Environmentnvarchar10
9TJHCUSTENVCLUBHIS-M: Cluster Builder Hierarchy for Business Partner Envrnmt1STRUCIS-M: Structure Selection for Business Partner Environmentnvarchar10
10TJHCUSTENVSTRUCIS-M: Cluster Builder Structure Business Partner Environment1STRUCIS-M: Structure Selection for Business Partner Environmentnvarchar10
11TJHCUSTENVSTRUCTIS-M: Cluster Builder Structure Business Partner Environment1STRUCIS-M: Structure Selection for Business Partner Environmentnvarchar10
TOPClinical System
12N2DEIS-H*MED: Table of documentation elements3STRUCDocumentation Element: Structurenvarchar10
13N2ETIS-H*MED: Table of docElement to DocCategory assignments20STRUCDocumentation Element: Structurenvarchar10
TOPCollectionsDisbursements
14INSCUSTENVINS Information Cluster Builder: Parameters4STRUCStructure Selectionnvarchar10
15INSCUSTENVCLUBHHierarchy of the IS-U CIC Cluster Builder1STRUCStructure Selectionnvarchar10
16TFSCD_COV_CLUBHFSCD: Hierarchy Cluster Builder Business Partner Environment1STRUCStructure Selectionnvarchar10
17TFSCD_COV_PARIns: Parameter Cluster Builder Business Partner Environment4STRUCStructure Selectionnvarchar10
18TINS_COV_PARIS-PS-CA: Parameter Cluster Builder Business Partner Environ4STRUCStructure Selectionnvarchar10
19TKKVVKKMModif. No. for Invoice Fields1STRUCIndicator for structures (header or item)nvarchar10
20TKKVVKKMTText Table for Modif. No. for Invoice Fields2STRUCIndicator for structures (header or item)nvarchar10
21VVKKFCSTRHelp Table for Posting Data Transfer1STRUCStructure indicator for posting data transfernvarchar10
TOPCross-Application Components
22TASUVSVDASU: Variants: transparent saved data5STRUCName of ABAP Dictionary Objectnvarchar300
TOPData Staging
23RSREQDONEMonitor: Saving of the QM entries18STRUCSingle-Character Indicatornvarchar10
TOPFinancial Accounting
24TTYPObject Types for Accounting2STRUCStructure Description of Organizational Fieldnvarchar100
TOPFront Office
25EWCUSTENVIS-U Information Cluster Builder: Parameter4STRUCStructure Selectionnvarchar10
26EWCUSTENVCLUBHHierarchy of the IS-U CIC Cluster Builder1STRUCStructure Selectionnvarchar10
TOPI18N Unicode
27UM4CONTAINContainer field definitions for Unicode conversions5STRUCnvarchar300
28UMGCONTAINERContainer field definitions for Unicode conversions5STRUCUnderlying structure for Container fields (direct)nvarchar300
TOPInformation Retention Manager
29IWP_AREA_FAudit Area Fields5STRUCStructurenvarchar400
30IWP_AREA_SAudit Area Tables5STRUCStructurenvarchar400
31IWP_REPOS_FRetention Warehouse: Repository Fields3STRUCStructurenvarchar400
32IWP_REPOS_FTRetention Warehouse: Repository Field Description4STRUCStructurenvarchar400
33IWP_REPOS_OT_SRetention Warehouse Repository: Structures ILM Objects4STRUCStructurenvarchar400
34IWP_REPOS_SRetention Warehouse: Repository Structures3STRUCStructurenvarchar400
35IWP_REPOS_STRetention Warehouse: Repository Structure Description4STRUCStructurenvarchar400
TOPLocalization
36GLOFAACNTRLCountry-Specific Master Records1STRUCTable Namenvarchar300
37GLOFAACNTRLCCountry-Specific Master Records3STRUCTable Namenvarchar300
38GLOFAACNTRLTCountry-Specific Table Name2STRUCTable Namenvarchar300
TOPNetherlands
39T77EIRNL_BCK_PRXElectronic Illness Reporting NL: Association Backend & Proxy6STRUCTable name, 16 charactersnvarchar160
40T77EIRNL_MSGFLDElectronic Illness Reporting NL: Fields per Message3STRUCTable name, 16 charactersnvarchar160
TOPPayroll
41T7UADATAFORMATData Output Format for Reports3STRUCName of a structurenvarchar300
42T7UADATAFORMATCData Output Format for Reports3STRUCName of a structurenvarchar300
TOPPayroll General Parts
43T515RTables in Payroll Results3STRUCTable Namenvarchar300
TOPPersonnel Administration
44T549DFeatures Directory5STRUCStructure name for decision fieldsnvarchar50
45T7PL05Configuration table for GUS forms9STRUCTable Namenvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
46TFMCA_COV_CLUBHIS-PS-CA: Hierarchy Cluster Builder Business Partner Environ1STRUCStructure Selectionnvarchar10
47TFMCA_COV_PARIS-PS-CA: Parameter Cluster Builder Business Partner Environ4STRUCStructure Selectionnvarchar10
TOPRetention Warehouse
48IWP_DB_REPOS_FRetention Warehouse: Repository Fields3STRUCStructurenvarchar400
49IWP_DB_REPOS_FTRetention Warehouse: Repository field description4STRUCStructurenvarchar400
50IWP_DB_REPOS_SRetention Warehouse: Repository structures3STRUCStructurenvarchar400
51IWP_DB_REPOS_STRetention Warehouse: Repository structure description4STRUCStructurenvarchar400
52IWP_DB_SET_FFields of the set3STRUCStructurenvarchar400
53IWP_DB_SET_SStructures of a set3STRUCStructurenvarchar400
54IWP_REPOS_BWAvailable Tables for BW6STRUCStructurenvarchar400
55IWP_REPOS_BW_CAvailable Tables for BW - Customer adoptions6STRUCStructurenvarchar400
56IWP_WPP_FFields of an Audit Package Template5STRUCStructurenvarchar400
57IWP_WPP_SStructures of an Audit Package Template5STRUCStructurenvarchar400
58IWP_WP_IOBJ_STDefinition structures of an Infoobject4STRUCStructurenvarchar400
59IWP_WP_IPRVInfoProviders of an Audit Package5STRUCStructurenvarchar400
60IWP_WP_PTH_STRCStructures of the Pathes of an Audit Package4STRUCStructurenvarchar400
61IWP_WP_STRUCTables of an Audit Package3STRUCStructurenvarchar400
62IWP_WP_STRUCTDescribtion: Tables of an Audit Package3STRUCStructurenvarchar400
TOPReuse Services for Country Development
63T599SFERequired infotypes for feature structure2STRUCStructure name for decision fieldsnvarchar50
TOPRouting
64CWB_SEL_VARIANTSEWB: User-Specific Initial Variants5STRUCTable Namenvarchar300
TOPSAP Query
65IQQCATDBInfoSet Query API: Query Catalog6STRUCTable Namenvarchar300
TOPSpain
66T5EL4Protected TemSe fields2STRUCTable Namenvarchar300
67T5EL6LOPD. High-level data fields and structures2STRUCTable Namenvarchar300
TOPStatements
68T50FGStatement Parameters3STRUCStructurenvarchar300
TOPWaste Management
69EWACUSTENVIS-U Waste, Information Cluster Builder: Parameters4STRUCStructure Selectionnvarchar10
70EWACUSTENVCLUBHHierarchy of Waste CIC Cluster Builder1STRUCStructure Selectionnvarchar10