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

139 tablesERP 6.0 

Industry Specific :: Industry Solution High Tech
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KOTG40171GG: Listing - Material entered / MaterialIndustry Solution High Tech
Industry Specific :: Industry Solution High Tech :: Distributor-Reseller-Management
ProductVersionTableColumnsIndexesDescriptionModule
2ERP EHP76.0/SAPHT/DRMACLVAL41Staging Validations: Assign Validations to the ClassDistributor-Reseller-Management
3ERP EHP76.0/SAPHT/DRMAGRDEF131Agreement : Default dataDistributor-Reseller-Management
4ERP EHP76.0/SAPHT/DRMAGRST51agreement StateDistributor-Reseller-Management
5ERP EHP76.0/SAPHT/DRMAGRWL371DRM - worklist table for agreement negotiationDistributor-Reseller-Management
6ERP EHP76.0/SAPHT/DRMANAL0061DRM Inventory analysisDistributor-Reseller-Management
7ERP EHP76.0/SAPHT/DRMBUDL734Bill Up Due ListDistributor-Reseller-Management
8ERP EHP76.0/SAPHT/DRMCDSDC21Drop-Ship SettingsDistributor-Reseller-Management
9ERP EHP76.0/SAPHT/DRMCECTYP31DRM end customer typeDistributor-Reseller-Management
10ERP EHP76.0/SAPHT/DRMCGVAL51General validation in Inbound 867/844 and stagingDistributor-Reseller-Management
11ERP EHP76.0/SAPHT/DRMCGVALT31Text table: Active validations for inb 867/844 and stagingDistributor-Reseller-Management
12ERP EHP76.0/SAPHT/DRMCGVL51Validations: detailsDistributor-Reseller-Management
13ERP EHP76.0/SAPHT/DRMCMMXN61Determination of DRM Transaction Code for MM applicationDistributor-Reseller-Management
14ERP EHP76.0/SAPHT/DRMCONEXT532DRM Ship and debit agreement extractsDistributor-Reseller-Management
15ERP EHP76.0/SAPHT/DRMCORJN31Mapping of ERP Rejection Reason to DRM SD rejection reasonDistributor-Reseller-Management
16ERP EHP76.0/SAPHT/DRMCPACNV171DRM Partner ConversionDistributor-Reseller-Management
17ERP EHP76.0/SAPHT/DRMCPRCCD31Control table: processing code propertiesDistributor-Reseller-Management
18ERP EHP76.0/SAPHT/DRMCPRXR31Mapping from Processing Code to Reversal Processing CodesDistributor-Reseller-Management
19ERP EHP76.0/SAPHT/DRMCRFCST61Reference customers for EC creation during EC aliasingDistributor-Reseller-Management
20ERP EHP76.0/SAPHT/DRMCRJRN21Claim Rejection TableDistributor-Reseller-Management
21ERP EHP76.0/SAPHT/DRMCRJRNT41Text Table : Claim Rejection ReasonDistributor-Reseller-Management
22ERP EHP76.0/SAPHT/DRMCRULE51Validation Rules: Group of Individual validation ruleDistributor-Reseller-Management
23ERP EHP76.0/SAPHT/DRMCSADRV61DRM: Sales Area derivationDistributor-Reseller-Management
24ERP EHP76.0/SAPHT/DRMCSDXN61Determination of DRM Transaction Code for SD applicationDistributor-Reseller-Management
25ERP EHP76.0/SAPHT/DRMCSTGR31Staging Validation rules: Basic DefinitionDistributor-Reseller-Management
26ERP EHP76.0/SAPHT/DRMCSTGRT51Staging Validations: Text for the rulesDistributor-Reseller-Management
27ERP EHP76.0/SAPHT/DRMCT16141DRM relevant settings for Purchase order typeDistributor-Reseller-Management
28ERP EHP76.0/SAPHT/DRMCT685A51DRM relevant setting for condition typesDistributor-Reseller-Management
29ERP EHP76.0/SAPHT/DRMCTVAK51DRM relevant settings for Sales order typesDistributor-Reseller-Management
30ERP EHP76.0/SAPHT/DRMCTVFK31DRM relevant setting for Billing document typesDistributor-Reseller-Management
31ERP EHP76.0/SAPHT/DRMCUSINF52End Customer list for SD agreementsDistributor-Reseller-Management
32ERP EHP76.0/SAPHT/DRMCVFLD31The fields associated with an error codeDistributor-Reseller-Management
33ERP EHP76.0/SAPHT/DRMCVLIND21Validations: for manufacturer or distributorDistributor-Reseller-Management
34ERP EHP76.0/SAPHT/DRMCWLCND81Customizing table for Agreement Conditiion type determinatDistributor-Reseller-Management
35ERP EHP76.0/SAPHT/DRMCXNCD41DRM Transaction CodesDistributor-Reseller-Management
36ERP EHP76.0/SAPHT/DRMCXNCDT41DRM Transaction Code TextsDistributor-Reseller-Management
37ERP EHP76.0/SAPHT/DRMCXNVL41Assign Validation rules to transaction codesDistributor-Reseller-Management
38ERP EHP76.0/SAPHT/DRMCXNXR51Mapping Transaction Codes to Reversal Transaction CodesDistributor-Reseller-Management
39ERP EHP76.0/SAPHT/DRMDETL1635DRM Audit TrailDistributor-Reseller-Management
40ERP EHP76.0/SAPHT/DRMFIFINV272DRM Inventory Reconciliation FIFO InventoryDistributor-Reseller-Management
41ERP EHP76.0/SAPHT/DRMGLOBAL11DRM global settings (MS/DR installation indicator setting)Distributor-Reseller-Management
42ERP EHP76.0/SAPHT/DRMHEAD494DRM FIFO HeaderDistributor-Reseller-Management
43ERP EHP76.0/SAPHT/DRMINVSUM333DRM Inventory SummaryDistributor-Reseller-Management
44ERP EHP76.0/SAPHT/DRMIUSR71DRM Internet User Management TableDistributor-Reseller-Management
45ERP EHP76.0/SAPHT/DRMPARTAD31DRM Resale link additional address data table.Distributor-Reseller-Management
46ERP EHP76.0/SAPHT/DRMPPDL834Price Protection Due ListDistributor-Reseller-Management
47ERP EHP76.0/SAPHT/DRMPPXN41Determination of DRM Transaction Code for PP applicationDistributor-Reseller-Management
48ERP EHP76.0/SAPHT/DRMPRFRUL51DRM Profile to Validation Rules MappingDistributor-Reseller-Management
49ERP EHP76.0/SAPHT/DRMPRINF51DRM personalization information tableDistributor-Reseller-Management
50ERP EHP76.0/SAPHT/DRMPR_DEF61Default Profile for the Tracking PartnerDistributor-Reseller-Management
51ERP EHP76.0/SAPHT/DRMR3XN645DRM relevant ERP TransactionsDistributor-Reseller-Management
52ERP EHP76.0/SAPHT/DRMREPINV121DRM Inventory Reconciliation Reported InventoryDistributor-Reseller-Management
53ERP EHP76.0/SAPHT/DRMRFCDST21Agreement Negotitiaon Logical sys maintainence tableDistributor-Reseller-Management
54ERP EHP76.0/SAPHT/DRMRLAP31DRM Rule Application TableDistributor-Reseller-Management
55ERP EHP76.0/SAPHT/DRMRLAP_T41DRM Rule Application TableDistributor-Reseller-Management
56ERP EHP76.0/SAPHT/DRMRLCR81DRM Rule : Complex RuleDistributor-Reseller-Management
57ERP EHP76.0/SAPHT/DRMRLCR_T52DRM Rule : Complex RuleDistributor-Reseller-Management
58ERP EHP76.0/SAPHT/DRMRLCSR51DRM Rule : Assigning Complex Rule To SchemaDistributor-Reseller-Management
59ERP EHP76.0/SAPHT/DRMRLSC41DRM Rule : Schema tableDistributor-Reseller-Management
60ERP EHP76.0/SAPHT/DRMRLSCR51DRM Rule : Assigning Simple Rule to Complex RuleDistributor-Reseller-Management
61ERP EHP76.0/SAPHT/DRMRLSC_T52DRM Rule : Schema tableDistributor-Reseller-Management
62ERP EHP76.0/SAPHT/DRMRLSR221DRM Rule : Simple RuleDistributor-Reseller-Management
63ERP EHP76.0/SAPHT/DRMRLSR_T52DRM Rule : Text Table for Simple RuleDistributor-Reseller-Management
64ERP EHP76.0/SAPHT/DRMSDDL925Ship and Debit Due ListDistributor-Reseller-Management
65ERP EHP76.0/SAPHT/DRMSDRJN41Rejections reasons for a staging recordDistributor-Reseller-Management
66ERP EHP76.0/SAPHT/DRMSLSRPT153DRM 867 Outbound processing tableDistributor-Reseller-Management
67ERP EHP76.0/SAPHT/DRMSTAG1074DRM Staging AreaDistributor-Reseller-Management
68ERP EHP76.0/SAPHT/DRMTRCK51Mapping table for Tracking PartnerDistributor-Reseller-Management
69ERP EHP76.0/SAPHT/DRMVALCL31Validation Class TableDistributor-Reseller-Management
70ERP EHP76.0/SAPHT/DRMVALCLT51Staging Validations: Text for the ClassDistributor-Reseller-Management
71ERP EHP76.0/SAPHT/DRMWLCOMP91DRM Agreement Negotiation Competitor Info Table.Distributor-Reseller-Management
72ERP EHP76.0/SAPHT/DRMWLDATE51DRM- Agreement Negotiation dates infoDistributor-Reseller-Management
73ERP EHP76.0/SAPHT/DRMWLPRIC91DRM-Agreement negotiation prices info table.Distributor-Reseller-Management
74ERP EHP76.0/SAPHT/DRMWLQTY51DRM - Agreement negotiation Quantity TableDistributor-Reseller-Management
75ERP EHP76.0/SAPHT/DRMXMCL91Transmission Report Data - Class levelDistributor-Reseller-Management
76ERP EHP76.0/SAPHT/DRM_CLOSE131DRM CLOSING TABLEDistributor-Reseller-Management
77ERP EHP76.0/SAPHT/DRM_PHONE211DRM Phone TableDistributor-Reseller-Management
78ERP EHP76.0/SAPHT/DRM_PRF581DRM Tracking Partner ProfileDistributor-Reseller-Management
79ERP EHP76.0/SAPHT/DRM_PRF_T41DRM Tracking Partner Profile DescriptionDistributor-Reseller-Management
80ERP EHP76.0/SAPHT/DRM_RSDTT51Text table for the Sell In Date of the return LotDistributor-Reseller-Management
81ERP EHP76.0/SAPHT/DRM_RSLDT31Value table for the Sell In Date of the return LotDistributor-Reseller-Management
82ERP EHP76.0A273121Sales org./Distr. chl/Division/Material/Customer/ItemDistributor-Reseller-Management
83ERP EHP76.0A274111Sales org./Distr. chl/Division/Material/ItemDistributor-Reseller-Management
84ERP EHP76.0A275181Material/Agreement Data for ATO/MTS ComponentsDistributor-Reseller-Management
85ERP EHP76.0A276191Agreement Data and status with agreement searchDistributor-Reseller-Management
86ERP EHP76.0A30291SD doc./Item/CustomerDistributor-Reseller-Management
87ERP EHP76.0A303121SD doc./Item/Material/CompMat/CompSup/CompTypeDistributor-Reseller-Management
88ERP EHP76.0A308101SD doc./Item/Customer/PersonnelDistributor-Reseller-Management
89ERP EHP76.0A30991SD Doc./Customer/PersonnelDistributor-Reseller-Management
90ERP EHP76.0A313121SD Doc./Item/Personnel/Sold-to pt/No.ser.no./CustomerDistributor-Reseller-Management
91ERP EHP76.0A435131Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM ItmDistributor-Reseller-Management
92ERP EHP76.0A436181Agreement data in combination with Agreement searchDistributor-Reseller-Management
93ERP EHP76.0A437211Material/Customer/Agreement dataDistributor-Reseller-Management
94ERP EHP76.0A439201Material/Agreement dataDistributor-Reseller-Management
95ERP EHP76.0B49951Movmt typeDistributor-Reseller-Management
96ERP EHP76.0KONDW31Conditions: Data part for DRM RulesDistributor-Reseller-Management
97ERP EHP76.0KOTW00191Matl grp 2/Matl grp 3/Price listDistributor-Reseller-Management
98ERP EHP76.0KOTW002101Sales org./Distr. chl/Division/MaterialDistributor-Reseller-Management
99ERP EHP76.0KOTW50171MaterialDistributor-Reseller-Management
100ERP EHP76.0MC09DR0DRMSETUP61Storage data BW reconstruction for MC09DR0DRMDistributor-Reseller-Management
101ERP EHP76.0MC09MS0DRMSETUP61Storage data BW reconstruction for MC09MS0DRMDistributor-Reseller-Management
102ERP EHP76.0MCHTDR0DRMSETUP61Storage data BW reconstruction for MC09DR0DRMDistributor-Reseller-Management
103ERP EHP76.0S490191CEM SettlementDistributor-Reseller-Management
104ERP EHP76.0S490E132S490 - Structure InformationDistributor-Reseller-Management
105ERP EHP76.0S491181CEM Construction Site Stock ValueDistributor-Reseller-Management
106ERP EHP76.0S491E142S491 - Structure InformationDistributor-Reseller-Management
107ERP EHP76.0S492271CEM Total Costs for EquipmentDistributor-Reseller-Management
108ERP EHP76.0S492E142S492 - Structure InformationDistributor-Reseller-Management
109ERP EHP76.0S495291Transmission ReportDistributor-Reseller-Management
110ERP EHP76.0S495E162S495 - Structural informationDistributor-Reseller-Management
111ERP EHP76.0S496592DRM: MS Side Business MetricsDistributor-Reseller-Management
112ERP EHP76.0S496E173S496 - Structural informationDistributor-Reseller-Management
113ERP EHP76.0S497472DRM: DR Side Business MetricsDistributor-Reseller-Management
114ERP EHP76.0S497E173S497 - Structural informationDistributor-Reseller-Management
115ERP EHP76.0S498252DRM: Sellin Business MetricsDistributor-Reseller-Management
116ERP EHP76.0S498E153S498 - Structural informationDistributor-Reseller-Management
117ERP EHP76.0T685W41DRM Relevancy for Rules Condition TypesDistributor-Reseller-Management
118ERP EHP76.0W00081Condition Table for Rule Determination $Distributor-Reseller-Management
Industry Specific :: Industry Solution High Tech :: Manufacturing Execution System
ProductVersionTableColumnsIndexesDescriptionModule
119ERP EHP76.0/SAPHT/MESEXIT41MES SPC IBU exit flag setupManufacturing Execution System
120ERP EHP76.0/SAPHT/MEST9LG21Lot genealogy: mvmt. types with special handlingManufacturing Execution System
121ERP EHP76.0/SAPHT/MESZFLWUP11User names for follow up actionsManufacturing Execution System
122ERP EHP76.0/SAPHT/MESZFORMP51Table for custom formula parametersManufacturing Execution System
123ERP EHP76.0/SAPHT/MESZPARM121Table for custom formula parameters across operationsManufacturing Execution System
124ERP EHP76.0/SAPHT/MESZPCHAR101Custom formula parameters for characteristcs.Manufacturing Execution System
125ERP EHP76.0/SAPHT/MESZSPLPO82Process Order Split link tableManufacturing Execution System
Industry Specific :: Industry Solution High Tech :: Software Management
ProductVersionTableColumnsIndexesDescriptionModule
126ERP EHP76.0KOTG40261IS-SW Product List ExclusionSoftware Management
127ERP EHP76.0S426151Variant Config.1---IBASESoftware Management
128ERP EHP76.0S426E82S426 - Structural informationSoftware Management
129ERP EHP76.0S427191Variant Config.2---IBASESoftware Management
130ERP EHP76.0S427E122S427 - Structural informationSoftware Management
131ERP EHP76.0TOGCF71GG: Configuration ViewsSoftware Management
132ERP EHP76.0TOGM1114Software Maintenance Process: Collective ProcessingSoftware Management
133ERP EHP76.0TOGM241Maintenance sets for profilesSoftware Management
134ERP EHP76.0TOGM331SMP 'push' material listSoftware Management
135ERP EHP76.0TOGM4121Maintenance ProfileSoftware Management
136ERP EHP76.0TOGM561Software Maintenance Process: Rejection CodesSoftware Management
137ERP EHP76.0TOGMT51PLM profile descriptionSoftware Management
138ERP EHP76.0TPGAC21GG enhancement: Material types representing Product GroupsSoftware Management
Industry Specific :: Industry Solution High Tech :: Distributor-Reseller-Management :: Information System
ProductVersionTableColumnsIndexesDescriptionModule
139ERP EHP76.0HTDRM_BW_TMSTMP31DRM Timestamp for BW extractorInformation System