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

125 columns | Print definition?ERP 6.0  | PLNTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMI/GSS_R2M_SUGSS Recipe -> Master Recipe: Sync Units Table11PLNTYTask List Typenvarchar10
2/SMD/MD_____00SASID-Tabelle fuer Task List Type3PLNTYTask List Typenvarchar10
3/SMERP/STG_MM001Data staging - Material master plant view complex table348PLNTYTask List Typenvarchar10
4PDS_OPR_MAPPINGPersistant operation mapping for PDS integration2PLNTYTask List Typenvarchar10
5SGT_PLKOSTask list - header - Segmentation2PLNTYTask List Typenvarchar10
6T409Relationships between task list types and material types2PLNTYTask List Typenvarchar10
7TCA01Task list types2PLNTYTask List Typenvarchar10
8TCA01ASAP Table for Task List Types2PLNTYTask List Typenvarchar10
9TCA01BTask List Types2PLNTYTask List Typenvarchar10
10TCA02Language-dependent texts for TCA01: Task list types3PLNTYTask List Typenvarchar10
11TCA03Customer Table for Task List Types (Language Dependent)2PLNTYTask List Typenvarchar10
12TCA05Transaction parameters for routings4PLNTYTask List Typenvarchar10
13TCA10Task lists: Messages depending on the task list type3PLNTYTask List Typenvarchar10
14TCA31Add.criteria for controlng. of screen sequence in task lists3PLNTYTask List Typenvarchar10
15TCA33Verification / input facility in task lists4PLNTYTask List Typenvarchar10
16TCA34Task list type table: SAP area2PLNTYTask List Typenvarchar10
17TCA35General control data2PLNTYTask List Typenvarchar10
18TCA43Automatic selection of task lists (alternatives)4PLNTYTask List Typenvarchar10
19TCA44User exit for selection of task lists (alternatives)3PLNTYTask List Typenvarchar10
20TQ33Relevant fields for origin5PLNTYTask List Typenvarchar10
21ZPS1IDES Text Pools6PLNTYTask List Typenvarchar10
22ZPS12Project system: Text symbol assign. Standard netw/Routing3PLNTYTask List Typenvarchar10
23ZPS12FProject system: Text symbol assign. Standard netw/Routing3PLNTYTask List Typenvarchar10
24ZPS13Proj.system: Text symbol assign. proced. std.netw./wrk ctr3PLNTYTask List Typenvarchar10
25ZPS1_OLDIDES: Assign text pool to standard structure6PLNTYTask List Typenvarchar10
TOPActive Quality Control
26QDQLQuality level4PLNTYTask List Typenvarchar10
TOPActual CostingMaterial Ledger
27CKMLMV013Assignment table: Process for production order19PLNTYTask List Typenvarchar10
28FCML_ALTAlternatives10PLNTYTask List Typenvarchar10
29FCML_PROCBusiness Processes12PLNTYTask List Typenvarchar10
TOPBasic Data
30MKALProduction Versions of Material9PLNTYTask List Typenvarchar10
TOPCapacity Leveling
31PIBAProcess planning interface: Production requirements14PLNTYTask List Typenvarchar10
32TCYTMTransition matrix15PLNTYTask List Typenvarchar10
TOPComputer Aided Process Planning
33PLPHCAPP: Sub-operations2PLNTYTask List Typenvarchar10
TOPControl Plan
34QPCPD_ITEMItem of Control Plan10PLNTYTask List Typenvarchar10
TOPCross-Application Components
35MMAPLAllocation of task lists to materials4PLNTYTask List Typenvarchar10
36MMARCPlant Data for Material152PLNTYTask List Typenvarchar10
37PDS_OPERPDS Data for Operations and Dependent Data5PLNTYTask List Typenvarchar10
38PLLPOTask list - operation/activity2PLNTYTask List Typenvarchar10
TOPDistribution Requirements Planning
39PLPLAN_PARAMBOM-dependent planning parameter2PLNTYTask List Typenvarchar10
TOPEngineering Change Management
40TCC01ECH: Object types5PLNTYTask List Typenvarchar10
TOPFlow Manufacturing
41LDLBPLine balance items10PLNTYTask List Typenvarchar10
TOPInspection Planning
42PLMKInspection plan characteristics2PLNTYTask List Typenvarchar10
43PLMWMAPL-Dependent Charac. Specifications (Inspection Plan)2PLNTYTask List Typenvarchar10
44QMIPD_SPECIP_MATMapping Table Between Inspection Plan and EHS Specification4PLNTYTask List Typenvarchar10
45QMIPD_SPECMATLOGStatus of Synchr. Between Inspection Plan and Specification4PLNTYTask List Typenvarchar10
TOPIntegrated Product and Process Engineering
46CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)9PLNTYTask List Typenvarchar10
47CMIG_STATUSStatus Table (iPPE Migration)5PLNTYTask List Typenvarchar10
TOPLO Integration
48CURTO_PDS_CHGChange Pointer for Production Data Structure8PLNTYTask List Typenvarchar10
TOPLogbook
49ADFSH_PRTDETFlight Scheduling: PRT Detail9PLNTYTask List Typenvarchar10
50ADFSH_PRTMASFlight Scheduling: PRT Master9PLNTYTask List Typenvarchar10
TOPMaintenance History
51HIKOOrder master data history24PLNTYTask List Typenvarchar10
52HIVGPM order history - operations7PLNTYTask List Typenvarchar10
TOPMaintenance Notifications
53QMIHQuality message - maintenance data excerpt34PLNTYTask List Typenvarchar10
TOPMaintenance Orders
54IOCI_ORGU_TLOCI Interface: Control Parameter Task List2PLNTYTask List Typenvarchar10
TOPMaintenance Program Definition
55MPDITEMMaintenance Plan Items14PLNTYTask List Typenvarchar10
56MPDPSDMPD: MPD and MP header data34PLNTYTask List Typenvarchar10
TOPMaintenance Task Lists
57EAPLAllocation of task lists to pieces of equipment3PLNTYTask List Typenvarchar10
58MPOSMaintenance item15PLNTYTask List Typenvarchar10
59PLWPAllocation of maintenance packages to task list operations2PLNTYTask List Typenvarchar10
60TAPLAllocation of task lists to functional locations3PLNTYTask List Typenvarchar10
TOPMaster Data
61PLAFPlanned Order63PLNTYTask List Typenvarchar10
62SAFKRun Schedule Master Data33PLNTYTask List Typenvarchar10
TOPMaster Data Distribution
63/ISDFPS/TL1Task List - Operation/Activity2PLNTYTask List Typenvarchar10
TOPMaster Recipe
64CPC_CMX_DB_CORMaster Recipe: Context Table for Recipe Header3PLNTYTask List Typenvarchar10
65CPC_CMX_DB_COSMaster Recipe: Context Table for Recipe Operations/Phases3PLNTYTask List Typenvarchar10
66CPC_CMX_DB_R_CORRouting: Context Table for Plan Header3PLNTYTask List Typenvarchar10
67CPC_CMX_DB_R_COSRouting: Context Table for Operations3PLNTYTask List Typenvarchar10
68PLFTProcess Instructions2PLNTYTask List Typenvarchar10
69PLFVPI Characteristics/Sub-Operation Parameter Values2PLNTYTask List Typenvarchar10
TOPMaterial Master
70MARCPlant Data for Material152PLNTYTask List Typenvarchar10
71MARC_TMPFile for Incorrect Data in Direct Input155PLNTYTask List Typenvarchar10
72MVRCCross-version fields for MARC152PLNTYTask List Typenvarchar10
TOPNetwork and Activity
73MLSTMilestone14PLNTYStandard network typenvarchar10
74PLABRelationships2PLNTYTask List Typenvarchar10
TOPNetwork Objects
75GHO_IFLOT_EXTFunction location extension table15PLNTYTask List Typenvarchar10
TOPPermits
76IHSGObject-Related Permits in Plant Maintenance25PLNTYTask List Typenvarchar10
TOPPlant Maintenance
77Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge7PLNTYPlantypnvarchar10
78Z9MIANFStillstanndsplanung - Daten für Anfragen6PLNTYPlantypnvarchar10
79Z9MISTPStillstandsplanung4PLNTYPlantypnvarchar10
TOPProcess Order
80AFFTOrder - Process Instructions6PLNTYTask List Typenvarchar10
81AFFVOrder - Process Instruction Values7PLNTYTask List Typenvarchar10
TOPProduct Cost by Period
82CHZPReporting Points - Change History22PLNTYTask List Typenvarchar10
TOPProduct Cost Planning
83KALMCosting Run: Costing Objects22PLNTYTask List Typenvarchar10
84KALOCosting Run: Costing Objects (KVMK)16PLNTYTask List Typenvarchar10
85KEKOProduct Costing - Header Data27PLNTYTask List Typenvarchar10
TOPProduct Lifecycle Management
86DIWPS_CRWork Package Cross-Reference Notification9PLNTYTask List Typenvarchar10
87DIWPS_NOTI_PCOMPTable for Partically Completed Notifications3PLNTYTask List Typenvarchar10
88DIWPS_RV_CRRevision: Cross-Reference Notification6PLNTYTask List Typenvarchar10
TOPProduction Campaign
89PCMO3Pegged production campaign: recipe8PLNTYTask List Typenvarchar10
TOPProduction Orders
90AFFLWork order sequence4PLNTYTask List Typenvarchar10
91AFKOOrder Header Data PP Orders18PLNTYTask List Typenvarchar10
92AFVCOperation within an order7PLNTYTask List Typenvarchar10
93T399XParameters dependent on order type4PLNTYTask List Typenvarchar10
TOPQuality Inspection
94QALSInspection lot record67PLNTYTask List Typenvarchar10
TOPRecycling Administration Core Functions
95J_7LC02REA Company Codes: Common Company Codes36PLNTYTask List Typenvarchar10
TOPResourcen Management
96MRTRST_HDRRMS-MRTRS : MR Transformation Header21PLNTYTask List Typenvarchar10
97RMXTT_Q11Building Blocks for Stability Study: Planning Data13PLNTYTask List Typenvarchar10
TOPRouting
98MAPLAssignment of Task Lists to Materials4PLNTYTask List Typenvarchar10
99PLASTask list - selection of operations/activities2PLNTYTask List Typenvarchar10
100PLFHTask list - production resources/tools2PLNTYTask List Typenvarchar10
101PLFLTask list - sequences2PLNTYTask List Typenvarchar10
102PLKOTask list - header2PLNTYTask List Typenvarchar10
103PLKZTask list: main header2PLNTYTask List Typenvarchar10
104PLMZAllocation of bill of material items to operations2PLNTYTask List Typenvarchar10
105PLPOTask list - operation/activity2PLNTYTask List Typenvarchar10
106PLSRScheduling results5PLNTYTask List Typenvarchar10
107PLZURouting data for group2PLNTYTask List Typenvarchar10
108TCA36Task lists: Ctrl.tab. for callng. popups from functn.modules6PLNTYTask List Typenvarchar10
109TCA72Task lists: Verification level of the function modules1PLNTYTask List Typenvarchar10
TOPRouting EBOM Assignment
110/PLMI/RTGRCALNKHRouting Component Assignment Link7PLNTYTask List Typenvarchar10
TOPSales Plan
111P445EPlanning Object Index for Rough-Cut Planning Profiles5PLNTYTask List Typenvarchar10
TOPSamples and SPC
112QASHQuality control chart6PLNTYTask List Typenvarchar10
TOPScheduling
113KBEDCapacity Requirements Records37PLNTYTask List Typenvarchar10
114KBKOHeader Record for Capacity Requirements7PLNTYTask List Typenvarchar10
TOPSCM Basis
115CIF_IMPPMInt. Model Reference Table for Production Process Model8PLNTYTask List Typenvarchar10
116CIF_MD_CHANGESChanges to BOM, Routing and Production Version7PLNTYTask List Typenvarchar10
TOPService Processing
117T399AControl: Automatic Order Creation11PLNTYTask List Typenvarchar10
TOPSimulation
118VSAFFL_CNVersion: Order sequences PP orders5PLNTYTask List Typenvarchar10
119VSAFKO_CNVersion: Order header data for PP orders19PLNTYTask List Typenvarchar10
120VSAFVC_CNVersion: Operation in order8PLNTYTask List Typenvarchar10
121VSKBED_CNVersion: Capacity requirement records38PLNTYTask List Typenvarchar10
122VSKBKO_CNVersion: Capacity requirements header for an order8PLNTYTask List Typenvarchar10
123VSMLST_CNVersion: Milestone15PLNTYStandard network typenvarchar10
124VSPLAF_CNVersion: Planned order63PLNTYTask List Typenvarchar10
TOPWork Center
125TC23AValid types for the work center3PLNTYTask List Typenvarchar10