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

77 tablesERP 6.0 

Industry Specific :: Aerospace Defence Industry Solution :: Specification 2
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ADS2KIPUPL_CLS81Spec2000 Upload: Parallel Processing ResumptionSpecification 2
2ERP EHP76.0ADS2KIPUPL_DTEL41SPEC2000 IP Upload: Data ElementsSpecification 2
3ERP EHP76.0ADS2KIPUPL_GSET181Spec2000 Upload: Upload Customizing SettingsSpecification 2
4ERP EHP76.0ADS2KIPUPL_GSETT41Spec2000 Upload: Upload Customizing SettingsSpecification 2
5ERP EHP76.0ADS2KUPL_CURMAP21SPEC2000 IP Upload: Currency Code MappingSpecification 2
6ERP EHP76.0ADSPCM_MM_SAC91SAC for MMSpecification 2
7ERP EHP76.0ADSPCM_SD_SAC71SAC for SDSpecification 2
8ERP EHP76.0ADSPC_CUSTRNMGR101Transactions for Customizing for SPEC 2000Specification 2
9ERP EHP76.0CSPCICC31ICC for 'Fully Interchangeable' in ATA/AECMA SPEC2000Specification 2
10ERP EHP76.0CSPCMOI21Type IdentificationSpecification 2
11ERP EHP76.0CSPCMOIT41Model ID Code TextSpecification 2
12ERP EHP76.0CSPCPRI31Conversion: SPEC Priority -> Delivery PrioritySpecification 2
13ERP EHP76.0CSPCPRIT41Order Priority TextSpecification 2
14ERP EHP76.0CSPCS1S51RFQ/Quotation Type for Part Availability InformationSpecification 2
15ERP EHP76.0CSPCTAX31Condition Types for SPC2K Tax Types: TXS, TXC, TXLSpecification 2
16ERP EHP76.0SPCCNVDOCNUM81Conversion between S2K doc. no. and Appl. Doc. No.Specification 2
17ERP EHP76.0SPCCOCODE21Position code for SPEC 2000 Command CodeSpecification 2
18ERP EHP76.0SPCDISPMESSAGES31List of TEIs the values of which are to be shownSpecification 2
19ERP EHP76.0SPCDTEL81SPEC 2000 Data ElementsSpecification 2
20ERP EHP76.0SPCERROR21Error type table for SPEC 2000 messagesSpecification 2
21ERP EHP76.0SPCFILE181SPEC 2000 messages & fieldsSpecification 2
22ERP EHP76.0SPCGLOBAL161Global constants for SPEC 2000Specification 2
23ERP EHP76.0SPCINMAP141Rules for linking src field and trg fieldSpecification 2
24ERP EHP76.0SPCINMAPCTRL61Mapping required for the control recordSpecification 2
25ERP EHP76.0SPCIPMAP171SPEC2000: MetaData Information on IP FilesSpecification 2
26ERP EHP76.0SPCIPTEI61SPEC2000: TEI to Explanation CodeSpecification 2
27ERP EHP76.0SPCMAP1N101Mapping a structure to IDoc data tablSpecification 2
28ERP EHP76.0SPCMCNVDOCNUM81Conversion between S2KM doc. no. and Appl. Doc. No.Specification 2
29ERP EHP76.0SPCMCOMP101SPEC 2000 AEC Data setsSpecification 2
30ERP EHP76.0SPCMDTEL91SPEC 2000M Data ElementsSpecification 2
31ERP EHP76.0SPCMFILE191SPEC 2000 AEC messages & fieldsSpecification 2
32ERP EHP76.0SPCMGLOACA41SPEC2000M Translation COND-ACASpecification 2
33ERP EHP76.0SPCMGLOBAL111Global constants for SPEC 2000MSpecification 2
34ERP EHP76.0SPCMGLOH451H4-Codes SPEC2000MSpecification 2
35ERP EHP76.0SPCMGLOSAC41Status/Advice Codes SPEC2000MSpecification 2
36ERP EHP76.0SPCMINMAP141Rules for linking src field and trg field (AECMA)Specification 2
37ERP EHP76.0SPCMPORTFUN71SPEC 2000 message with FMs for further processingSpecification 2
38ERP EHP76.0SPCMPRTNRINF131Partner Information for SPEC 2000 messageSpecification 2
39ERP EHP76.0SPCMVERSION31Versions for SPEC messagesSpecification 2
40ERP EHP76.0SPCM_DISP_MENU111Action table for A&D Displaytool (menu)Specification 2
41ERP EHP76.0SPCPORTFUN71SPEC 2000 message with FMs for further processingSpecification 2
42ERP EHP76.0SPCPORTFUNII101Rules table linking src field and trg fieldsSpecification 2
43ERP EHP76.0SPCPRTNRINF141Partner Information for SPEC 2000 messageSpecification 2
Industry Specific :: Aerospace Defence Industry Solution :: Specification 2 :: Provisioning
ProductVersionTableColumnsIndexesDescriptionModule
44ERP EHP76.0ADS2KIPBRO_CMD111SPEC 2000 IP: Key fields for master data creationProvisioning
45ERP EHP76.0SPCIPCLS41Class for aircraft partsProvisioning
46ERP EHP76.0SPCIPCLSIF71Interface IP Data - Master DataProvisioning
47ERP EHP76.0SPCIPCSN192LocationsProvisioning
48ERP EHP76.0SPCIPCSNT31Texts for CSNProvisioning
49ERP EHP76.0SPCIPEFF91Effectivity RangeProvisioning
50ERP EHP76.0SPCIPFIELDLIST51Display-fields for creating material master from IPProvisioning
51ERP EHP76.0SPCIPGLOBAL11Technical Settings for IPProvisioning
52ERP EHP76.0SPCIPHDR131Stores header information for IP dataProvisioning
53ERP EHP76.0SPCIPHDRT31Texts for SPCIPHDR - for every SQNBRProvisioning
54ERP EHP76.0SPCIPINTERFACE61Interface IP Data - Master DataProvisioning
55ERP EHP76.0SPCIPMFR31Classification table of manufacturersProvisioning
56ERP EHP76.0SPCIPOCH101Other Charges - Code & AmountProvisioning
57ERP EHP76.0SPCIPOSC81SPEC2000: Stores optional suppliers for the subject SPLProvisioning
58ERP EHP76.0SPCIPOSC_D91SPEC2000: Stores deleted entries for SPCIPOSCProvisioning
59ERP EHP76.0SPCIPOSDS101Optional Suppliers and DistributorsProvisioning
60ERP EHP76.0SPCIPPARTS121Other parts that can be usedProvisioning
61ERP EHP76.0SPCIPPDR282Spare parts / End itemsProvisioning
62ERP EHP76.0SPCIPPDS311SPEC2000: Procurement Data SegmentProvisioning
63ERP EHP76.0SPCIPPQA101Price Break - Quantity & AmountProvisioning
64ERP EHP76.0SPCIPPROFILEKEYS21Profile Keys for IPProvisioning
65ERP EHP76.0SPCIPPROFILES41Profiles for creating master data from IPProvisioning
66ERP EHP76.0SPCIPPROFILEST41Descriptions of profiles for creating master data from IPProvisioning
67ERP EHP76.0SPCIPPROFKEYS301Key fields and values of IP profilesProvisioning
68ERP EHP76.0SPCIPPROFVALUES61Profile values of fields in master dataProvisioning
69ERP EHP76.0SPCIPRPDE161Replacing Parts / Replaced PartsProvisioning
70ERP EHP76.0SPCIPSPLMNT261SPEC2000: Stores Additional/Long/MultipleOccurance fieldsProvisioning
71ERP EHP76.0SPCIPSTAT51SPEC2000 : User Status Profiles for an Object TypeProvisioning
72ERP EHP76.0SPCIPSTAT_END31SPEC 2000: End ItemProvisioning
73ERP EHP76.0SPCIPSTAT_LOC31SPEC2000: User Status Profiles for the Object - LocationsProvisioning
74ERP EHP76.0SPCIPSTAT_PART31SPEC2000: PartsProvisioning
75ERP EHP76.0SPCIPSTAT_SUPP31SPEC 2000: User Status Profiles for the Object - SuppliersProvisioning
76ERP EHP76.0SPCIPSWITCH31IP Browser SwitchProvisioning
77ERP EHP76.0SPCIPUOA121Used On AssembliesProvisioning