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

91 columns | Print definition?ERP 6.0  | VERID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMI/GSS_R2M_SUGSS Recipe -> Master Recipe: Sync Units Table6VERIDProduction Versionnvarchar40
2S025ES025 - Structural information6VERIDProduction Versionnvarchar40
3ZDG40Table for Data Generation (Repetitive Manufacturing)10VERIDProduction Versionnvarchar40
4ZEIM_AFPOOrder item43VERIDProduction Versionnvarchar40
5ZMAPPSD-Material Table for Data Generation9VERIDProduction Versionnvarchar40
TOPActual CostingMaterial Ledger
6CKMLMV013Assignment table: Process for production order16VERIDProduction Versionnvarchar40
7FCML_ALTAlternatives7VERIDProduction Version (Alternative)nvarchar40
8FCML_PROCBusiness Processes9VERIDProduction Version (Process)nvarchar40
TOPBasic Data
9MKALProduction Versions of Material4VERIDProduction Versionnvarchar40
10MKAL_AENDChange History of Production Version (Recipes Only)4VERIDProduction Versionnvarchar40
TOPConsumer Products for Food Beverage
11CFB_KALM_TMPTMP Save / CK40N Selected Materials7VERIDProduction Versionnvarchar40
12CFB_VERID_MRPRelease/Lock Production Version for Mat. Req. Planning4VERIDProduction Versionnvarchar40
TOPCross-Application Components
13PDS_KEYKey Table for PDS Data from PDS Maintenance5VERIDProduction Versionnvarchar40
TOPData Collection
14S025SFIS: Run Schedule11VERIDProduction Versionnvarchar40
15S028Reporting Point Statistics11VERIDProduction Versionnvarchar40
16S028ES028 - Structural Information6VERIDProduction Versionnvarchar40
17S225Goods receipts: repetitive manufacturing11VERIDProduction Versionnvarchar40
18S225ES225 - Structural Information6VERIDProduction Versionnvarchar40
19S226Material usage: repetitive manufacturing11VERIDProduction Versionnvarchar40
20S226ES226 - Structural Information6VERIDProduction Versionnvarchar40
21S227Product costs: repetitive manufacturing12VERIDProduction Versionnvarchar40
22S227ES227 - Structural Information7VERIDProduction Versionnvarchar40
TOPDefense Forces and Public Security
23/ISDFPS/ZEBANCopy of EBAN84VERIDProduction Versionnvarchar40
TOPDemand Management
24PBEDIndependent Requirements Data15VERIDProduction Versionnvarchar40
TOPFlow Manufacturing
25LDLBPLine balance items13VERIDProduction Versionnvarchar40
TOPIndia
26T77WWW_INF01Form IDs6VERIDVersion IDnvarchar40
27T77WWW_INF02Section IDs5VERIDVersion IDnvarchar40
28T77WWW_INF03Line Item Details6VERIDVersion IDnvarchar40
29T77WWW_INF03TLine Items Text7VERIDVersion IDnvarchar40
30T77WWW_INF04Column Details6VERIDVersion IDnvarchar40
31T77WWW_INF04TColumn Details Text7VERIDVersion IDnvarchar40
32T77WWW_INF05Value Determination Configuration7VERIDVersion IDnvarchar40
TOPIndustry Solution Oil
33TOI0_REL_PLIS-OIL: Relevance customizing for planned orders13VERIDProduction Versionnvarchar40
TOPInformation System
34MCAFKOVVersions: Order Header Data - PP Orders29VERIDProduction Versionnvarchar40
35MCAFPOVVersions: Order Item33VERIDProduction Versionnvarchar40
36MCSFISR/2 SFIS Data: Old37VERIDProduction Versionnvarchar40
TOPJust-In-Time Processing
37JITBACKFTMPTemporary File for Confirmation Pool4VERIDProduction Versionnvarchar40
38JITPGJIT : Components Groups Types (with Inbound Delivery)7VERIDProduction Version of Components Groups Materialsnvarchar40
TOPKANBAN
39PKHDControl Cycle8VERIDProduction Versionnvarchar40
TOPLO Integration
40CURTO_FOCUS_CHGChange Pointer for Order/WBS BOM for PDS Transfer10VERIDProduction Versionnvarchar40
41CURTO_PDS_CHGChange Pointer for Production Data Structure5VERIDProduction Versionnvarchar40
TOPLogistics Information System LIS
42S284Goods Receipts Repet. Man., BW10VERIDProduction Versionnvarchar40
43S284BIW1S284BIW1 * Goods Receipt Rep. Manufct., BW10VERIDProduction Versionnvarchar40
44S284BIW2S284BIW2 * Goods Receipt Rep. Manufct., BW10VERIDProduction Versionnvarchar40
45S285Material Cons. Repet. Manu. BW10VERIDProduction Versionnvarchar40
46S285BIW1S285BIW1 * Material Consumpt.Repet.Manuf., BW10VERIDProduction Versionnvarchar40
47S285BIW2S285BIW2 * Material Consumpt.Repet.Manuf., BW10VERIDProduction Versionnvarchar40
TOPMaintenance Notifications
48QMELQuality Notification20VERIDProduction Versionnvarchar40
TOPMaster Data
49BLPKDocument log header5VERIDProduction Versionnvarchar40
50MDTBMRP Table51VERIDProduction Versionnvarchar40
51PLAFPlanned Order48VERIDProduction Versionnvarchar40
52RQHDHeader record for requirements total records in MRP5VERIDProduction Versionnvarchar40
53SAFKRun Schedule Master Data24VERIDProduction Versionnvarchar40
54T463Customizing Table Display Filter - Settings -47VERIDProduction versionnvarchar40
TOPMaterials Management
55/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions89VERIDProduction Versionnvarchar40
TOPProduct Cost Planning
56KALMCosting Run: Costing Objects13VERIDProduction Versionnvarchar40
57KALOCosting Run: Costing Objects (KVMK)12VERIDProduction Versionnvarchar40
58KEKOProduct Costing - Header Data21VERIDProduction Versionnvarchar40
TOPProduction Campaign
59PCMO1Pegged production campaign: material12VERIDProduction Versionnvarchar40
TOPProduction Orders
60AFPOOrder item43VERIDProduction Versionnvarchar40
TOPProfitability Analysis Basic Functions
61K840001Summarization level KT: 800 KK 01 KKROBJ 00000119VERIDProduction Versionnvarchar40
62K840003Summarization level KT: 800 KK 01 KKROBJ 00000214VERIDProduction Versionnvarchar40
63K840005Summarization level KT: 800 KK 01 KKROBJ 00000321VERIDProduction Versionnvarchar40
64K840007Summarization level KT: 800 KK 01 KKROBJ 00000416VERIDProduction Versionnvarchar40
65K840009Summarization level KT: 800 KK 01 KKROBJ 00000522VERIDProduction Versionnvarchar40
66K840011Summarization level KT: 800 KK 01 KKROBJ 00000617VERIDProduction Versionnvarchar40
TOPPurchasing
67EBANPurchase Requisition84VERIDProduction Versionnvarchar40
68EINEPurchasing Info Record: Purchasing Organization Data61VERIDProduction Versionnvarchar40
69EKETScheduling Agreement Schedule Lines28VERIDProduction Versionnvarchar40
70EKETHScheduling Agreement Schedules: History Tables28VERIDProduction Versionnvarchar40
71EQUPQuota File: Item12VERIDProduction Versionnvarchar40
72MEREQXPurchase Requisition Change Parameter84VERIDUpdated information in related user data fieldnvarchar10
TOPQuality Inspection
73QALSInspection lot record94VERIDProduction Versionnvarchar40
TOPRepetitive Manufacturing
74RFCLISTRFC Task List5VERIDProduction Versionnvarchar40
75RMIOInput Structure of Repetitive Manufacturing Confirmation8VERIDProduction Versionnvarchar40
76RMUSERUser Settings for REM Backflush Transactions6VERIDProduction Versionnvarchar40
77T437LLinking Production Version and Cost Estimate Version4VERIDProduction Versionnvarchar40
TOPResourcen Management
78MRTRST_HDRRMS-MRTRS : MR Transformation Header19VERIDProduction Versionnvarchar40
79RMXTT_TRIAL_MRTrial: Assigned Master Recipes5VERIDProduction Versionnvarchar40
TOPSample Management
80QPRNSample drawing of phys. samples15VERIDProduction Versionnvarchar40
TOPSCM Basis
81CIF_IMIPPEIMod Reference Table for IPPE4VERIDProduction Versionnvarchar40
82CIF_IMIPRTIMod Reference Table for IPPE Runtime Object4VERIDProduction Versionnvarchar40
83CIF_IMPPMInt. Model Reference Table for Production Process Model4VERIDProduction Versionnvarchar40
84CIF_MD_CHANGESChanges to BOM, Routing and Production Version6VERIDProduction Versionnvarchar40
85CIF_PPM_CHANGEDPPM: Change Transfer - Changed Production Versions4VERIDProduction Versionnvarchar40
86CPVINFRPurchasing info record and production version assignment3VERIDProduction Versionnvarchar40
TOPSimulation
87VSAFPO_CNVersion: Order items in PP orders44VERIDProduction Versionnvarchar40
88VSEBAN_CNVersion: Purchase requisition84VERIDProduction Versionnvarchar40
89VSPLAF_CNVersion: Planned order48VERIDProduction Versionnvarchar40
TOPTraders and Schedulers Workbench
90OIJLOCMATOIL-TSW: Location Rundown/Planning material table79VERIDOIL-TSW: Version ID currently assignednvarchar40
91TOI0_REL_PPIS-OIL: Relevance customizing for PP Documents13VERIDProduction Versionnvarchar40