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 columns | Print definition?ERP 6.0  | STLAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMI/GSS_R2M_SUGSS Recipe -> Master Recipe: Sync Units Table9STLANBOM Usagenvarchar10
2/SMD/MD_____00X8SID-Tabelle fuer BOM Usage3STLANBOM Usagenvarchar10
3/SMERP/STG_MM001Data staging - Material master plant view complex table302STLANBOM Usagenvarchar10
4T399JMaintenance parameters (client)10STLANBOM Usagenvarchar10
TOPActual CostingMaterial Ledger
5CKMLMV013Assignment table: Process for production order17STLANBOM Usagenvarchar10
6FCML_ALTAlternatives8STLANBOM Usagenvarchar10
7FCML_PROCBusiness Processes10STLANBOM Usagenvarchar10
TOPBasic Data
8MKALProduction Versions of Material8STLANBOM Usagenvarchar10
TOPBasic Functions
9MMPREF_PRO_02Log table - Main component - Information9STLANBOM Usagenvarchar10
10MMPREK_PRO_02Log table - Main component - Information12STLANBOM Usagenvarchar10
11MMPREW_PRO_02Preference CPG: Log main component - Information11STLANBOM Usagenvarchar10
12T604_PREF_PARAMPreference: Preference determination parameters6STLANBOM Usagenvarchar10
TOPBills of Material
13CLSTLink class - BOM3STLANBOM Usagenvarchar10
14EQSTEquipment to BOM Link4STLANBOM Usagenvarchar10
15KDSTSales Order to BOM Link6STLANBOM Usagenvarchar10
16MASTMaterial to BOM Link4STLANBOM Usagenvarchar10
17PRSTProject - BOM link5STLANBOM Usagenvarchar10
18STSTStandard BOM Link4STLANBOM Usagenvarchar10
19STZUPermanent BOM data4STLANBOM Usagenvarchar10
20T415AAlternative BOM Determination4STLANBOM Usagenvarchar10
21T415BAlternative Determination by Unit of Measure3STLANBOM Usagenvarchar10
22T415MMaterial Types Allowed in BOM2STLANBOM Usagenvarchar10
23T416BOM Usage - Item Statuses2STLANBOM Usagenvarchar10
24T416TBOM Usage Texts3STLANBOM Usagenvarchar10
25T416VCopy defaults for BOM usage - item statuses2STLANBOM Usagenvarchar10
26TCS09BOM Control Depending on Category and Usage3STLANBOM Usagenvarchar10
27TCS15BOMs with History Requirement2STLANBOM Usagenvarchar10
28TCS17BOMs with History Requirement3STLANBOM Usagenvarchar10
29TCS41Automatic alternative BOM determination4STLANBOM Usagenvarchar10
30TCSPRUser Profile for BOMs3STLANBOM Usagenvarchar10
31TPSTLink Between Functional Location and BOM4STLANBOM Usagenvarchar10
TOPConfiguration management
32TCM_LC_PH_USAGECM: LC-Phase: Selected usage3STLANBOM Usagenvarchar10
TOPCross-Application Components
33MMARCPlant Data for Material106STLANBOM Usagenvarchar10
34PDS_COMPComponent Data for PDS10STLANBOM Usagenvarchar10
35PDS_KEYKey Table for PDS Data from PDS Maintenance8STLANBOM Usagenvarchar10
TOPForeign Trade
36/SAPSLL/TBTCUR3GTS: BOM Transfer: BOM Usage - Country5STLANBOM Usagenvarchar10
37/SAPSLL/TBTGUR3GTS: BOM Transfer: BOM Usage - Global4STLANBOM Usagenvarchar10
38/SAPSLL/TBTPUR3GTS: BOM Transfer: BOM Usage - Plant6STLANBOM Usagenvarchar10
TOPGlobal Trade Services
39/SAPSLL/BOMHDSLL: BOM - Header8STLANBOM Usagenvarchar10
40/SAPSLL/PRFPMRSLL: Preference: Log: Products: Result of BOM Calculation6STLANBOM Usagenvarchar10
41/SAPSLL/RXPMRRe-Export: Log: BOPs of Product7STLANBOM Usagenvarchar10
TOPIndustry-Specific Component Automotive
42TCHOBJObjects for Classification in Spec Syst6STLANBOM Usagenvarchar10
TOPIntegrated Product and Process Engineering
43CMIG_USAGECustomizing - iPPE Migration: BOM Usage2STLANBOM Usagenvarchar10
TOPInventory Management
44T159LDefault values for inventory management and physical invent.6STLANBOM Usagenvarchar10
TOPLO Integration
45CURTO_FOCUS_CHGChange Pointer for Order/WBS BOM for PDS Transfer8STLANBOM Usagenvarchar10
46CURTO_PDS_CHGChange Pointer for Production Data Structure6STLANBOM Usagenvarchar10
TOPLocalization
47J_3RFGTDMATBOMBoM for Customs Decl. Tracking3STLANBOM Usagenvarchar10
TOPMaintenance Orders
48/CUM/CUTYPECU: Compatible Unit Type9STLANBOM Usagenvarchar10
TOPMaster Data
49PLAFPlanned Order41STLANBOM Usagenvarchar10
50SAFKRun Schedule Master Data32STLANBOM Usagenvarchar10
TOPMaterial
51TCNIFPProfile for BOM transfer13STLANBOM Usagenvarchar10
TOPMaterial Master
52MARCPlant Data for Material106STLANBOM Usagenvarchar10
53MARC_TMPFile for Incorrect Data in Direct Input109STLANBOM Usagenvarchar10
54MVRCCross-version fields for MARC106STLANBOM Usagenvarchar10
55TMGW2Control for Maintaining Structured Materials3STLANBOM Usagenvarchar10
TOPProduct Cost Planning
56KALMCosting Run: Costing Objects17STLANBOM Usagenvarchar10
57KALOCosting Run: Costing Objects (KVMK)13STLANBOM Usagenvarchar10
58KEKOProduct Costing - Header Data23STLANBOM Usagenvarchar10
TOPProduct Data Management
59PDN_MAP_HEADERProduct Designer: Mapping Table for Headers7STLANBOM Usagenvarchar10
TOPProduct Safety
60ESTWLEHS: BOMBOS - Worklist Table21STLANBOM Usagenvarchar10
TOPProduct Structure Browser
61USROBJECTSTable of Previous Initial Object in Structure Overview17STLANBOM Usagenvarchar10
TOPProduction Optimization Interface POI
62TCLOI3Usage Filter for BOM Selection3STLANBOM Usagenvarchar10
TOPProduction Orders
63AFKOOrder Header Data PP Orders40STLANBOM Usagenvarchar10
TOPRecycling Administration Core Functions
64J_7LC16REA Bill of Material Usage (Company Code)3STLANBill of Materials Usage for Articlenvarchar10
65J_7LC26REA Data Filter: BOM Usage2STLANBOM Usagenvarchar10
66J_7LM06REA Article Master: Bills of Material10STLANBOM Usagenvarchar10
67J_7LV06REA Packaging Master Data: Bills of Material5STLANBOM Usagenvarchar10
TOPResourcen Management
68FRMLT20RMS-FRM: Connection Table BOM - Formula (LoM)7STLANBOM Usagenvarchar10
69MRTRSC_20Define Control Parameters for Master Recipe Transformation14STLANBOM Usagenvarchar10
70MRTRST_HDRRMS-MRTRS : MR Transformation Header20STLANBOM Usagenvarchar10
71RMXTT_TRIAL_MRTrial: Assigned Master Recipes9STLANBOM Usagenvarchar10
TOPSCM Basis
72CIF_IMMBOMIMod Reference Table for Material BOM's4STLANBOM Usagenvarchar10
73CIF_IMPPMInt. Model Reference Table for Production Process Model14STLANBOM Usagenvarchar10
74CIF_MD_CHANGESChanges to BOM, Routing and Production Version11STLANBOM Usagenvarchar10
TOPSimulation
75VSAFKO_CNVersion: Order header data for PP orders41STLANBOM Usagenvarchar10
76VSPLAF_CNVersion: Planned order42STLANBOM Usagenvarchar10
TOPTransformation
77RMXMC_T16Default Values for Plants and Transformation Groups9STLANBOM Usagenvarchar10