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

85 columns | Print definition?ERP 6.0  | PLNAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMI/GSS_R2M_SUGSS Recipe -> Master Recipe: Sync Units Table13PLNALGroup Counternvarchar20
2SGT_PLKOSTask list - header - Segmentation4PLNALGroup Counternvarchar20
3ZPS12Project system: Text symbol assign. Standard netw/Routing5PLNALGroup Counternvarchar20
4ZPS12FProject system: Text symbol assign. Standard netw/Routing5PLNALGroup Counternvarchar20
TOPActive Quality Control
5QDQLQuality level6PLNALGroup Counternvarchar20
TOPActual CostingMaterial Ledger
6CKMLMV013Assignment table: Process for production order21PLNALGroup Counternvarchar20
7FCML_ALTAlternatives12PLNALGroup Counternvarchar20
8FCML_PROCBusiness Processes14PLNALGroup Counternvarchar20
TOPCapacity Leveling
9PIBAProcess planning interface: Production requirements16PLNALGroup Counternvarchar20
10TCYTMTransition matrix17PLNALGroup Counternvarchar20
TOPControl Plan
11QPCPD_ITEMItem of Control Plan12PLNALGroup Counternvarchar20
TOPCross-Application Components
12MMAPLAllocation of task lists to materials6PLNALGroup Counternvarchar20
TOPData Collection
13S161Inspection Results: General29PLNALGroup Counternvarchar20
14S162Quantitative Inspection Results29PLNALGroup Counternvarchar20
15S163Quantitative Inspection Result: Vendor30PLNALGroup Counternvarchar20
16S164Quantitative Inspection Result: Vendor30PLNALGroup Counternvarchar20
17S165Inspection Results (General): Customers29PLNALGroup Counternvarchar20
18S166Quantitative Inspection Results: Customer30PLNALGroup Counternvarchar20
TOPDistribution Requirements Planning
19PLPLAN_PARAMBOM-dependent planning parameter12PLNALGroup Counternvarchar20
TOPEnvironment, Health and Safety
20EHQMT_IP_MEMORYEH&S-QM: Memorize Created Inspection Plans3PLNALGroup Counternvarchar20
TOPFlow Manufacturing
21LDLBPLine balance items12PLNALGroup Counternvarchar20
TOPInspection Planning
22PLMWMAPL-Dependent Charac. Specifications (Inspection Plan)13PLNALGroup Counternvarchar20
23QMIPD_SPECIP_MATMapping Table Between Inspection Plan and EHS Specification6PLNALGroup Counternvarchar20
24QMIPD_SPECMATLOGStatus of Synchr. Between Inspection Plan and Specification6PLNALGroup Counternvarchar20
TOPIntegrated Product and Process Engineering
25CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)11PLNALGroup Counternvarchar20
TOPLogbook
26ADFSH_PRTDETFlight Scheduling: PRT Detail11PLNALGroup Counternvarchar20
27ADFSH_PRTMASFlight Scheduling: PRT Master11PLNALGroup Counternvarchar20
TOPMaintenance History
28HIKOOrder master data history26PLNALGroup Counternvarchar20
TOPMaintenance Notifications
29QMIHQuality message - maintenance data excerpt36PLNALGroup Counternvarchar20
TOPMaintenance Orders
30/CUM/AFCUCU: CU Instances4PLNALCU: Group Counter for Plant in Task Listnvarchar20
31/CUM/CUNITWERKCU: TL selection: group center for plant, virtual CUI deter.3PLNALCU: Group Counter for Plant in Task Listnvarchar20
TOPMaintenance Program Definition
32MPDITEMMaintenance Plan Items16PLNALGroup Counternvarchar20
33MPDPSDMPD: MPD and MP header data36PLNALGroup Counternvarchar20
TOPMaintenance Task Lists
34EAPLAllocation of task lists to pieces of equipment5PLNALGroup Counternvarchar20
35MPOSMaintenance item17PLNALGroup Counternvarchar20
36PLWPAllocation of maintenance packages to task list operations4PLNALGroup Counternvarchar20
37TAPLAllocation of task lists to functional locations5PLNALGroup Counternvarchar20
TOPMaster Data
38PLAFPlanned Order62PLNALGroup Counternvarchar20
TOPMaster Recipe
39CPC_CMX_DB_CORMaster Recipe: Context Table for Recipe Header5PLNALGroup Counternvarchar20
40CPC_CMX_DB_R_CORRouting: Context Table for Plan Header5PLNALGroup Counternvarchar20
TOPNetwork and Activity
41MLSTMilestone15PLNALAlternative to a standard networknvarchar20
42PLABRelationships4PLNALGroup Counternvarchar20
TOPNetwork Objects
43GHO_IFLOT_EXTFunction location extension table17PLNALGroup Counternvarchar20
TOPPermits
44IHSGObject-Related Permits in Plant Maintenance27PLNALGroup Counternvarchar20
TOPPlant Maintenance
45S180APO: Long-Term Planning4PLNALGroup Counternvarchar20
46S180ES180 - Structure Information4PLNALGroup Counternvarchar20
47Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge9PLNALPlangruppenzählernvarchar20
48Z9MIANFStillstanndsplanung - Daten für Anfragen8PLNALPlangruppenzählernvarchar20
49Z9MISTPStillstandsplanung6PLNALPlangruppenzählernvarchar20
TOPProduct Cost by Period
50CHZPReporting Points - Change History24PLNALGroup Counternvarchar20
51CKPECO-PC Cost Object Hierarchy: Individual Objects8PLNALGroup Counternvarchar20
TOPProduct Cost Planning
52KALMCosting Run: Costing Objects24PLNALGroup Counternvarchar20
53KALOCosting Run: Costing Objects (KVMK)18PLNALGroup Counternvarchar20
54KEKOProduct Costing - Header Data28PLNALGroup Counternvarchar20
TOPProduct Lifecycle Management
55DIWPS_CRWork Package Cross-Reference Notification11PLNALGroup Counternvarchar20
56DIWPS_NOTI_PCOMPTable for Partically Completed Notifications5PLNALGroup Counternvarchar20
57DIWPS_RV_CRRevision: Cross-Reference Notification8PLNALGroup Counternvarchar20
TOPProduction Campaign
58PCMO3Pegged production campaign: recipe10PLNALGroup Counternvarchar20
TOPProduction Orders
59AFFLWork order sequence6PLNALGroup Counternvarchar20
60AFKOOrder Header Data PP Orders21PLNALGroup Counternvarchar20
61AFVCOperation within an order6PLNALGroup Counternvarchar20
TOPQuality Inspection
62QALSInspection lot record70PLNALGroup Counternvarchar20
TOPResourcen Management
63MRTRST_HDRRMS-MRTRS : MR Transformation Header23PLNALGroup Counternvarchar20
64RMXTT_Q11Building Blocks for Stability Study: Planning Data15PLNALGroup Counternvarchar20
65RMXTT_TRIAL_QMPLTrial: Assigned Inspection Plans for Post-Process Control4PLNALGroup Counternvarchar20
TOPRouting
66MAPLAssignment of Task Lists to Materials6PLNALGroup Counternvarchar20
67PLASTask list - selection of operations/activities4PLNALGroup Counternvarchar20
68PLFHTask list - production resources/tools18PLNALGroup Counternvarchar20
69PLFLTask list - sequences4PLNALGroup Counternvarchar20
70PLKOTask list - header4PLNALGroup Counternvarchar20
71PLKZTask list: main header4PLNALGroup Counternvarchar20
72PLMZAllocation of bill of material items to operations11PLNALGroup Counternvarchar20
73PLSRScheduling results7PLNALGroup Counternvarchar20
TOPRouting EBOM Assignment
74/PLMI/RTGRCALNKHRouting Component Assignment Link9PLNALGroup Counternvarchar20
TOPSales Plan
75P445EPlanning Object Index for Rough-Cut Planning Profiles7PLNALGroup Counternvarchar20
TOPSamples and SPC
76QASHQuality control chart8PLNALGroup Counternvarchar20
TOPScheduling
77KBEDCapacity Requirements Records39PLNALGroup Counternvarchar20
78KBKOHeader Record for Capacity Requirements9PLNALGroup Counternvarchar20
TOPSimulation
79VSAFFL_CNVersion: Order sequences PP orders7PLNALGroup Counternvarchar20
80VSAFKO_CNVersion: Order header data for PP orders22PLNALGroup Counternvarchar20
81VSAFVC_CNVersion: Operation in order7PLNALGroup Counternvarchar20
82VSKBED_CNVersion: Capacity requirement records40PLNALGroup Counternvarchar20
83VSKBKO_CNVersion: Capacity requirements header for an order10PLNALGroup Counternvarchar20
84VSMLST_CNVersion: Milestone16PLNALAlternative to a standard networknvarchar20
85VSPLAF_CNVersion: Planned order62PLNALGroup Counternvarchar20