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

107 columns | Print definition?ERP 6.0  | PLNNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMI/GSS_R2M_SUGSS Recipe -> Master Recipe: Sync Units Table12PLNNRKey for Task List Groupnvarchar80
2/SMERP/STG_MM001Data staging - Material master plant view complex table303PLNNRKey for Task List Groupnvarchar80
3/XFT/QMPPAPT001QM Sampling Header Table12PLNNRTask List Group Keynvarchar80
4PDS_OPR_MAPPINGPersistant operation mapping for PDS integration3PLNNRKey for Task List Groupnvarchar80
5SGT_PLKOSTask list - header - Segmentation3PLNNRKey for Task List Groupnvarchar80
6ZPS1IDES Text Pools7PLNNRKey for Task List Groupnvarchar80
7ZPS12Project system: Text symbol assign. Standard netw/Routing4PLNNRKey for Task List Groupnvarchar80
8ZPS12FProject system: Text symbol assign. Standard netw/Routing4PLNNRKey for Task List Groupnvarchar80
9ZPS13Proj.system: Text symbol assign. proced. std.netw./wrk ctr4PLNNRKey for Task List Groupnvarchar80
10ZPS1_OLDIDES: Assign text pool to standard structure7PLNNRKey for Task List Groupnvarchar80
TOPActive Quality Control
11QDQLQuality level5PLNNRKey for Task List Groupnvarchar80
TOPActual CostingMaterial Ledger
12CKMLMV013Assignment table: Process for production order20PLNNRKey for Task List Groupnvarchar80
13FCML_ALTAlternatives11PLNNRKey for Task List Groupnvarchar80
14FCML_PROCBusiness Processes13PLNNRKey for Task List Groupnvarchar80
TOPBasic Data
15MKALProduction Versions of Material10PLNNRKey for Task List Groupnvarchar80
TOPCapacity Leveling
16PIBAProcess planning interface: Production requirements15PLNNRKey for Task List Groupnvarchar80
17TCYTMTransition matrix16PLNNRKey for Task List Groupnvarchar80
TOPComputer Aided Process Planning
18PLPHCAPP: Sub-operations3PLNNRKey for Task List Groupnvarchar80
TOPControl Plan
19QPCPD_ITEMItem of Control Plan11PLNNRKey for Task List Groupnvarchar80
TOPCross-Application Components
20MMAPLAllocation of task lists to materials5PLNNRKey for Task List Groupnvarchar80
21MMARCPlant Data for Material107PLNNRKey for Task List Groupnvarchar80
22PLLPOTask list - operation/activity3PLNNRKey for Task List Groupnvarchar80
TOPDistribution Requirements Planning
23PLPLAN_PARAMBOM-dependent planning parameter3PLNNRKey for Task List Groupnvarchar80
TOPEnvironment, Health and Safety
24EHQMT_IP_MEMORYEH&S-QM: Memorize Created Inspection Plans2PLNNRKey for Task List Groupnvarchar80
TOPFlow Manufacturing
25LDLBPLine balance items11PLNNRKey for Task List Groupnvarchar80
TOPInspection Planning
26PLMKInspection plan characteristics3PLNNRKey for Task List Groupnvarchar80
27PLMWMAPL-Dependent Charac. Specifications (Inspection Plan)3PLNNRKey for Task List Groupnvarchar80
28QMIPD_SPECIP_MATMapping Table Between Inspection Plan and EHS Specification5PLNNRKey for Task List Groupnvarchar80
29QMIPD_SPECMATLOGStatus of Synchr. Between Inspection Plan and Specification5PLNNRKey for Task List Groupnvarchar80
TOPIntegrated Product and Process Engineering
30CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)10PLNNRKey for Task List Groupnvarchar80
31CMIG_STATUSStatus Table (iPPE Migration)6PLNNRKey for Task List Groupnvarchar80
TOPLO Integration
32CURTO_PDS_CHGChange Pointer for Production Data Structure9PLNNRKey for Task List Groupnvarchar80
TOPLogbook
33ADFSH_PRTDETFlight Scheduling: PRT Detail10PLNNRKey for Task List Groupnvarchar80
34ADFSH_PRTMASFlight Scheduling: PRT Master10PLNNRKey for Task List Groupnvarchar80
TOPMaintenance History
35HIKOOrder master data history25PLNNRKey for Task List Groupnvarchar80
36HIVGPM order history - operations8PLNNRKey for Task List Groupnvarchar80
TOPMaintenance Notifications
37QMIHQuality message - maintenance data excerpt35PLNNRKey for Task List Groupnvarchar80
TOPMaintenance Program Definition
38MPDITEMMaintenance Plan Items15PLNNRKey for Task List Groupnvarchar80
39MPDPSDMPD: MPD and MP header data35PLNNRKey for Task List Groupnvarchar80
TOPMaintenance Task Lists
40EAPLAllocation of task lists to pieces of equipment4PLNNRKey for Task List Groupnvarchar80
41MPOSMaintenance item16PLNNRKey for Task List Groupnvarchar80
42PLWPAllocation of maintenance packages to task list operations3PLNNRKey for Task List Groupnvarchar80
43TAPLAllocation of task lists to functional locations4PLNNRKey for Task List Groupnvarchar80
TOPMaster Data
44PLAFPlanned Order61PLNNRKey for Task List Groupnvarchar80
45SAFKRun Schedule Master Data34PLNNRKey for Task List Groupnvarchar80
TOPMaster Data Distribution
46/ISDFPS/TL1Task List - Operation/Activity3PLNNRKey for Task List Groupnvarchar80
TOPMaster Recipe
47CPC_CMX_DB_CORMaster Recipe: Context Table for Recipe Header4PLNNRKey for Task List Groupnvarchar80
48CPC_CMX_DB_COSMaster Recipe: Context Table for Recipe Operations/Phases4PLNNRKey for Task List Groupnvarchar80
49CPC_CMX_DB_R_CORRouting: Context Table for Plan Header4PLNNRKey for Task List Groupnvarchar80
50CPC_CMX_DB_R_COSRouting: Context Table for Operations4PLNNRKey for Task List Groupnvarchar80
51PLFTProcess Instructions3PLNNRKey for Task List Groupnvarchar80
52PLFVPI Characteristics/Sub-Operation Parameter Values3PLNNRKey for Task List Groupnvarchar80
TOPMaterial Master
53MARCPlant Data for Material107PLNNRKey for Task List Groupnvarchar80
54MARC_TMPFile for Incorrect Data in Direct Input110PLNNRKey for Task List Groupnvarchar80
55MVRCCross-version fields for MARC107PLNNRKey for Task List Groupnvarchar80
TOPNetwork and Activity
56MLSTMilestone13PLNNRStandard network numbernvarchar80
57PLABRelationships3PLNNRNumber of the Standard Networknvarchar80
TOPNetwork Objects
58GHO_IFLOT_EXTFunction location extension table16PLNNRKey for Task List Groupnvarchar80
TOPPermits
59IHSGObject-Related Permits in Plant Maintenance26PLNNRKey for Task List Groupnvarchar80
TOPPlant Maintenance
60S180APO: Long-Term Planning3PLNNRKey for Task List Groupnvarchar80
61S180ES180 - Structure Information3PLNNRKey for Task List Groupnvarchar80
62Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge8PLNNRSchlüssel der Plangruppenvarchar80
63Z9MIANFStillstanndsplanung - Daten für Anfragen7PLNNRSchlüssel der Plangruppenvarchar80
64Z9MISTPStillstandsplanung5PLNNRSchlüssel der Plangruppenvarchar80
TOPProcess Order
65AFFTOrder - Process Instructions7PLNNRKey for Task List Groupnvarchar80
66AFFVOrder - Process Instruction Values8PLNNRKey for Task List Groupnvarchar80
TOPProduct Cost by Period
67CHZPReporting Points - Change History23PLNNRKey for Task List Groupnvarchar80
68CKPECO-PC Cost Object Hierarchy: Individual Objects13PLNNRKey for Task List Groupnvarchar80
TOPProduct Cost Planning
69KALMCosting Run: Costing Objects23PLNNRKey for Task List Groupnvarchar80
70KALOCosting Run: Costing Objects (KVMK)17PLNNRKey for Task List Groupnvarchar80
71KEKOProduct Costing - Header Data26PLNNRKey for Task List Groupnvarchar80
TOPProduct Lifecycle Management
72DIWPS_CRWork Package Cross-Reference Notification10PLNNRKey for Task List Groupnvarchar80
73DIWPS_NOTI_PCOMPTable for Partically Completed Notifications4PLNNRKey for Task List Groupnvarchar80
74DIWPS_RV_CRRevision: Cross-Reference Notification7PLNNRKey for Task List Groupnvarchar80
TOPProduction Campaign
75PCMO3Pegged production campaign: recipe9PLNNRKey for Task List Groupnvarchar80
TOPProduction Orders
76AFFLWork order sequence5PLNNRKey for Task List Groupnvarchar80
77AFKOOrder Header Data PP Orders19PLNNRKey for Task List Groupnvarchar80
78AFVCOperation within an order9PLNNRKey for Task List Groupnvarchar80
TOPQuality Inspection
79QALSInspection lot record68PLNNRKey for Task List Groupnvarchar80
TOPResourcen Management
80MRTRST_HDRRMS-MRTRS : MR Transformation Header22PLNNRKey for Task List Groupnvarchar80
81RMXTT_Q11Building Blocks for Stability Study: Planning Data14PLNNRKey for Task List Groupnvarchar80
82RMXTT_TRIAL_QMPLTrial: Assigned Inspection Plans for Post-Process Control3PLNNRKey for Task List Groupnvarchar80
TOPRouting
83MAPLAssignment of Task Lists to Materials5PLNNRKey for Task List Groupnvarchar80
84PLASTask list - selection of operations/activities3PLNNRKey for Task List Groupnvarchar80
85PLFHTask list - production resources/tools3PLNNRKey for Task List Groupnvarchar80
86PLFLTask list - sequences3PLNNRKey for Task List Groupnvarchar80
87PLKOTask list - header3PLNNRKey for Task List Groupnvarchar80
88PLKZTask list: main header3PLNNRKey for Task List Groupnvarchar80
89PLMZAllocation of bill of material items to operations3PLNNRKey for Task List Groupnvarchar80
90PLPOTask list - operation/activity3PLNNRKey for Task List Groupnvarchar80
91PLPRLog collector for task lists3PLNNRKey for Task List Groupnvarchar80
92PLSRScheduling results6PLNNRKey for Task List Groupnvarchar80
93PLZURouting data for group3PLNNRKey for Task List Groupnvarchar80
TOPRouting EBOM Assignment
94/PLMI/RTGRCALNKHRouting Component Assignment Link8PLNNRKey for Task List Groupnvarchar80
TOPSales Plan
95P445EPlanning Object Index for Rough-Cut Planning Profiles6PLNNRKey for Task List Groupnvarchar80
TOPSamples and SPC
96QASHQuality control chart7PLNNRKey for Task List Groupnvarchar80
TOPScheduling
97KBEDCapacity Requirements Records38PLNNRKey for Task List Groupnvarchar80
98KBKOHeader Record for Capacity Requirements8PLNNRKey for Task List Groupnvarchar80
TOPSCM Basis
99CIF_IMPPMInt. Model Reference Table for Production Process Model9PLNNRKey for Task List Groupnvarchar80
100CIF_MD_CHANGESChanges to BOM, Routing and Production Version8PLNNRKey for Task List Groupnvarchar80
TOPSimulation
101VSAFFL_CNVersion: Order sequences PP orders6PLNNRKey for Task List Groupnvarchar80
102VSAFKO_CNVersion: Order header data for PP orders20PLNNRKey for Task List Groupnvarchar80
103VSAFVC_CNVersion: Operation in order10PLNNRKey for Task List Groupnvarchar80
104VSKBED_CNVersion: Capacity requirement records39PLNNRKey for Task List Groupnvarchar80
105VSKBKO_CNVersion: Capacity requirements header for an order9PLNNRKey for Task List Groupnvarchar80
106VSMLST_CNVersion: Milestone14PLNNRStandard network numbernvarchar80
107VSPLAF_CNVersion: Planned order61PLNNRKey for Task List Groupnvarchar80