SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

101 columns | Print definition?ERP 6.0  | PAKET

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT2PAKETNumber of the changeover packagenvarchar30
2FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT2PAKETNumber of the changeover packagenvarchar30
TOPBank Customer Accounts
3BKKSO_PACKSaving Packages for Standing Order Posting3PAKETInterval Numberint100
TOPBasic Functions
4EWULC02FI-LC: Ledgers for conversion2PAKETNumber of the changeover packagenvarchar30
5EWULC03FI-LC: Companies for conversion2PAKETNumber of the changeover packagenvarchar30
TOPBusiness Application Support
6CNVWDCNV watchdog: Customizing table4PAKETConversion: Conversion package numbernvarchar50
7CNVWDMCNV watchdog: sent messages2PAKETConversion: Conversion package numbernvarchar50
TOPConsolidation
8EWUCS10SAP Cons.-EURO: Consolidation Units for Euro Conversion2PAKETNumber of the changeover packagenvarchar30
9EWUCS11SAP Cons.-EURO: Ledger for Conversion2PAKETNumber of the changeover packagenvarchar30
TOPConstruction Equipment Management
10J_3GERLMTARTAllowed Material Types3PAKETMaterial Type Allowed in Package?nvarchar10
TOPGeneral Ledger Accounting
11EWUFI_SPLITEMU Implementation: Table of FAGL_SPLINFO* to Be Corrected2PAKETNumber of the changeover packagenvarchar30
TOPIncentive and Commission Management ICM
12CACS_LCC_MATCHLCC: Control Table for Matching Programs2PAKETNumber of the changeover packagenvarchar30
13CACS_LCC_TSTMPLCC: Timestamp2PAKETNumber of the changeover packagenvarchar30
14CACS_PACKRANKPackage Ranking1PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
15TCACS_APPLPACKPackages from a Commission Application2PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
16TCACS_PACKCONTCOBSOLETE! Customizing Components of a Commission Package1PAKETnvarchar60
17TCACS_PACKCONTROBSOLETE! Repository Components of a Commission Package2PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
18TCACS_PACKDEFList of All Packages1PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
19TCACS_PACKDEF_TDescriptive Text for Packages1PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
20TCACS_PACKDEPENDDependencies Between Packages1PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
21TCACS_PACKNOMODStructures to be generated, without model1PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
22TCACS_PATCH_A02Patch Manager: Shadow Table Active Packages2PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
23TCACS_PATCH_INFODelivered Versions and Patches (Info Documents)7PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
24TCACS_PATCH_PACKDelivered Versions and Patches (Assigned Packages)3PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
25TCACS_PATCH_STEPDelivered Versions and Patches (Steps)6PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
26TCACS_RESPACKReserved Areas for ISF Packages4PAKETPakage ID in Incentive & Sales Force Managementnvarchar60
TOPLocal Currency Changeover
27EUROFISLEMU: Information on record level for FI-SL2PAKETNumber of the changeover packagenvarchar30
28EUROFISL_TEMU: Information on Table Level for FI-SL2PAKETNumber of the changeover packagenvarchar30
29EWUABLEMU Conversion: Derivation rules per table2PAKETNumber of the changeover packagenvarchar30
30EWUAFABEEMU: Currencies for the participating depreciation areas2PAKETNumber of the changeover packagenvarchar30
31EWUAFAPLEMU: Currencies for the participating investment supports2PAKETNumber of the changeover packagenvarchar30
32EWUANLAVOREWU conversion: Table for marking assets before conversion2PAKETNumber of the changeover packagenvarchar30
33EWUARCHIVCritical archiving objects2PAKETNumber of the changeover packagenvarchar30
34EWUARREMU Tables: Conversion Sequence and Server Assignment2PAKETNumber of the changeover packagenvarchar30
35EWUCKMLWEMU: Currencies for material ledger2PAKETNumber of the changeover packagenvarchar30
36EWUCLCTEMU Cnv: Control Table for Conversion with Clusters2PAKETNumber of the changeover packagenvarchar30
37EWUCLERREMU Cnv: Table for Faulty/Unconverted Entries2PAKETNumber of the changeover packagenvarchar30
38EWUCLSTATEMU Cnv: Status Table for Conversion with Clusters2PAKETNumber of the changeover packagenvarchar30
39EWUCOKException table for TWAER conversion2PAKETNumber of the changeover packagenvarchar30
40EWUCOKALException table for conversion of TWAER in detailed planning2PAKETNumber of the changeover packagenvarchar30
41EWUCOOEMU: Controlling object currencies2PAKETNumber of the changeover packagenvarchar30
42EWUCUPAKETContains the individual packages for user-defined objects3PAKETNumber of the changeover packagenvarchar30
43EWUCUREMU conversion: Participating currencies2PAKETNumber of the changeover packagenvarchar30
44EWUDUPRECSDouble entries generated in a table due to conversion2PAKETNumber of the changeover packagenvarchar30
45EWUEISEMU: Currencies for EIS objects2PAKETNumber of the changeover packagenvarchar30
46EWUFIAASUMEWU conversion: Table for asset totals at account level2PAKETNumber of the changeover packagenvarchar30
47EWUFICRDOCEMU conversion: Documents to RFEWUDOC2PAKETNumber of the changeover packagenvarchar30
48EWUFI_ARCHRead Using Company Code Archive? (SAPF070)2PAKETNumber of the changeover packagenvarchar30
49EWUFI_BALEMU conversion: Logging transaction figures change2PAKETNumber of the changeover packagenvarchar30
50EWUFI_BALPEMU conversion: Logging transaction figures change2PAKETNumber of the changeover packagenvarchar30
51EWUFI_CDOCEMU conversion: Documents to RFEWUDOC2PAKETNumber of the changeover packagenvarchar30
52EWUFI_INTVIntervals for document conversion for EMU conversion2PAKETNumber of the changeover packagenvarchar30
53EWUFI_SCAEMU conversion: Table of the clearings to be adjusted2PAKETNumber of the changeover packagenvarchar30
54EWUFI_SOPEMU conversion: Table for open items total2PAKETNumber of the changeover packagenvarchar30
55EWUFMProcess-related form routines2PAKETNumber of the changeover packagenvarchar30
56EWUFMPEMU conv.: Params for process-rel.form routines per package2PAKETNumber of the changeover packagenvarchar30
57EWUFZField-related control2PAKETNumber of the changeover packagenvarchar30
58EWUFZPEMU conversion: Parameters for field-related control2PAKETNumber of the changeover packagenvarchar30
59EWUFZPSFEMU conversion: Parameters for field-related control2PAKETNumber of the changeover packagenvarchar30
60EWUFZSFField-related control2PAKETNumber of the changeover packagenvarchar30
61EWUGTCLocal Currency Changeovers: Target Currencies2PAKETNumber of the changeover packagenvarchar30
62EWUIMTPEMU: Currencies for the participating investment programs2PAKETNumber of the changeover packagenvarchar30
63EWUMAXTABLargest Tables Relevant to Conversion in System2PAKETNumber of the changeover packagenvarchar30
64EWUMMFIEMU: transfer table for clearing entries MM-FI2PAKETNumber of the changeover packagenvarchar30
65EWUORGEMU: Currencies for the participating organizational objects2PAKETNumber of the changeover packagenvarchar30
66EWUORG2EMU: Currencies for the participating organizational objects2PAKETNumber of the changeover packagenvarchar30
67EWUORG3EMU: Currencies for partic.org.objects with three key fields2PAKETNumber of the changeover packagenvarchar30
68EWUPEMU conversion: Overview of Changeover Packages per Client2PAKETNumber of the changeover packagenvarchar30
69EWUPAKEuro conversion packages2PAKETNumber of the changeover packagenvarchar30
70EWUPAKOParts of changeover package2PAKETNumber of the changeover packagenvarchar30
71EWUPAKTEMU conversion: Name of the packages3PAKETNumber of the changeover packagenvarchar30
72EWUPGCTEMU: Program check for conversion2PAKETNumber of the changeover packagenvarchar30
73EWUPGFACHUser department tasks completed2PAKETNumber of the changeover packagenvarchar30
74EWUPGFACH1Collection of user department's EMU programs2PAKETNumber of the changeover packagenvarchar30
75EWUPGSTATConversion programs status2PAKETNumber of the changeover packagenvarchar30
76EWUPGTABEMU conversion: Program/tables data2PAKETNumber of the changeover packagenvarchar30
77EWUPRAEFAssign EMU package to generated programs prefix2PAKETNumber of the changeover packagenvarchar30
78EWUPTEMU conversion: Name of the packages per client3PAKETNumber of the changeover packagenvarchar30
79EWUSAKEMU: Currencies for participating G/L accounts2PAKETNumber of the changeover packagenvarchar30
80EWUSELEMU conversion: Selection parameters2PAKETNumber of the changeover packagenvarchar30
81EWUSLEMU: Currencies from special ledger2PAKETNumber of the changeover packagenvarchar30
82EWUTABCTEMU: Table check2PAKETNumber of the changeover packagenvarchar30
83EWUTABPRTable Prefix for Long Table Names2PAKETNumber of the changeover packagenvarchar30
84EWUTABZEMU conversion: Tables: Number of records2PAKETNumber of the changeover packagenvarchar30
85EWUTFEMU: Table flags2PAKETNumber of the changeover packagenvarchar30
86EWUTMEMU conversion: Process-related control per table2PAKETNumber of the changeover packagenvarchar30
87EWUTMPEMU conversion: Params for process-related control per table2PAKETNumber of the changeover packagenvarchar30
88EWUTMPSFEMU conversion: Params for process-related control per table2PAKETNumber of the changeover packagenvarchar30
89EWUTMSFEMU conversion: Process-related control per table2PAKETNumber of the changeover packagenvarchar30
90EWUTSLEMU: Combinations for TSL fields to be converted in FI-SL2PAKETNumber of the changeover packagenvarchar30
91EWUWTEMU: Participating currency types2PAKETNumber of the changeover packagenvarchar30
TOPMaintenance Task Lists
92PLWPAllocation of maintenance packages to task list operations7PAKETMaintenance Package Numbernvarchar20
93T351XMaintenance strategy package texts4PAKETMaintenance Package Numbernvarchar20
TOPOnline Text Repository
94SOTR_ALIAGlobal Alias Name Management in the OTR3PAKETPackagenvarchar300
95SOTR_ALIAUGlobal Alias Name Management in the OTR3PAKETPackagenvarchar300
96SOTR_HEADHeader Table for OTR Texts2PAKETPackagenvarchar300
97SOTR_HEADUHeader Table for Strings in the OTR2PAKETPackagenvarchar300
TOPPeriodical Sales and Distribution
98TJF31IS-M/SD: Collective Transfer Run to RF/FI14PAKETIS-M: 6-digit sequence numbernvarchar60
TOPPlant Maintenance
99Z9I_STK_MAIL_ADRMail-Adressen für Stillstandsrückmeldungen4PAKETKZ für Auftragsvergabe an Lieferantnvarchar10
TOPScreen Painter
100ACC_INPH3_DYNPRORegister of screens for field pairs from ACC_INPH3_PAIRS4PAKETPackagenvarchar300
TOPTransport Management System
101LISPARAMSLIS: Additional Parameters for Systems6PAKETLIS: Packagenvarchar300