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

122 columns | Print definition?ERP 6.0  | VRGNG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data114VRGNGTransaction Type for General Ledgernvarchar40
2AUASSettlement Document: Totals Segment4VRGNGCO Business Transactionnvarchar40
3AUATSettlement Document: Totals Segment Per Period5VRGNGCO Business Transactionnvarchar40
4AUAVDocument Segment: Transactions4VRGNGCO Business Transactionnvarchar40
5CNV_20100_COESDuplicate COES keys (target values)9VRGNGCO Business Transactionnvarchar40
6TC34Allocating operation to object type for the check routine2VRGNGBusiness Transactionnvarchar40
7TCO60Sequence keys for input facility and verification4VRGNGIndicator controls: X = activity " " = elementnvarchar10
8TIS01Control of business activities: Real estate depend. activit.2VRGNGBusiness Transactionnvarchar40
TOPAccounting Interface
9TKESUCO-PA: Control Table for Summarization3VRGNGBusiness Transactionnvarchar40
TOPActual Payments and Forecast
10COFPDocument Lines (project cash management)10VRGNGCO Business Transactionnvarchar40
TOPAdvertising Management
11TJH19IS-M/AM: Billing Category11VRGNGBusiness Transactionnvarchar40
TOPAlternative Valuation Run
12CKMLAVR_CPTFUNCFunctions in the Alternative Valuation Run Cockpit3VRGNGBusiness Transactionnvarchar40
13CKMLAVR_CPTFUNCTText Table Func. in Alternative Valuation Run Cockpit4VRGNGBusiness Transactionnvarchar40
TOPBasic Functions
14FDS2CM&F Line Items in SD Documents (fromr Release 4.0)7VRGNGBusiness Transactionnvarchar40
TOPBudgeting
15FMKF_TERM_RBKey Figures - FM Terms13VRGNGKey Figures - Transactionnvarchar40
TOPConstruction Progress Report
16/SAPPCE/TPNV00Definition of planning type for construction progress report3VRGNGCO Business Transactionnvarchar40
TOPControlling
17COPPP_HDRCO Postprocessing List - Headers3VRGNGCO Business Transactionnvarchar40
18COPPP_ITMCO Postprocessing List - Items3VRGNGCO Business Transactionnvarchar40
19KBXXN_TC_ORDERField Sequence in Table Control for Manual Actual Postings1VRGNGCO Business Transactionnvarchar40
20SEND_REC_REL_DEFDefinition of Screen Variants for Manual Actual Postings3VRGNGBusiness transactions for manual actual postings in COnvarchar40
TOPCost Center Accounting
21COSPRCO Objekt: Enhancement to COSP for Dependency Planning9VRGNGCO Business Transactionnvarchar40
TOPCost Element Accounting
22COFIO2Transaction-dependent fields for reconciliation ledger3VRGNGCO Business Transactionnvarchar40
23COFIPSingle plan items for reconciliation ledger34VRGNGCO Business Transactionnvarchar40
24COFISActual line items for reconciliation ledger34VRGNGCO Business Transactionnvarchar40
25COFITTotals Records for Reconciliation Ledger33VRGNGCO Business Transactionnvarchar40
TOPCost Object
26COEPBCO Object: Line Items Variance/Period-Based Results Analysis22VRGNGCO Business Transactionnvarchar40
27COSBCO Object: Total Variances/Results Analyses10VRGNGCO Business Transactionnvarchar40
28PZPELine Items for Measuring Point Update9VRGNGCO Business Transactionnvarchar40
TOPCosting
29COERSales Order Value Revenue8VRGNGCO Business Transactionnvarchar40
30COESCO Object: Sales Order Value Line Items8VRGNGCO Business Transactionnvarchar40
TOPData Retention Tool
31TXW_S_COBKRetrieve COBK from archive9VRGNGCO Business Transactionnvarchar40
32TXW_S_COEPRetrieve COEP from archive13VRGNGCO Business Transactionnvarchar40
TOPFinancial Accounting
33FERC_C8Exceptional handling of CO business transaction types1VRGNGCO Business Transactionnvarchar40
34FERC_F3Totals per source object, transaction type, and CO element4VRGNGCO Business Transactionnvarchar40
TOPFunds Management
35FCABPFI-CA: Document Item11VRGNGCO Business Transactionnvarchar40
36FMCFB_VRGNGFM: Permitted Activities for Balance Carryforward3VRGNGFM Transactionnvarchar40
37FMCFB_VRGNGTFM: Balance Carryfwd Allowed Activities (Language-Dependent)4VRGNGFM Transactionnvarchar40
38FMEPFI-FM Line Items39VRGNGCO Business Transactionnvarchar40
39FMICOHDFM/CO Integration: Document Header8VRGNGCO Business Transactionnvarchar40
40FMICOITFM/CO integration: Line item17VRGNGCO Business Transactionnvarchar40
41FMIFIITFI Line Item Table in Funds Management27VRGNGCO Business Transactionnvarchar40
42FMIOObject Table for Funds Management18VRGNGCO Business Transactionnvarchar40
43FMIOICommitment Documents Funds Management33VRGNGCO Business Transactionnvarchar40
44FMRESINI2Earmarked Funds: Initialization Data3VRGNGBusiness Transactionnvarchar40
45FMUP01Update Control with Value Type Dependency3VRGNGCO Business Transactionnvarchar40
46FMUP02Customizbare Felder zum Fortschreibungsprofil4VRGNGCO Business Transactionnvarchar40
47KBLEDocument Item Processing: Manual Document Entry5VRGNGBusiness Transactionnvarchar40
48KBLESUMTotals Table KBLE4VRGNGBusiness Transactionnvarchar40
49KBLPDocument Item: Manual Document Entry4VRGNGBusiness Transactionnvarchar40
TOPGeneral status management
50TJ01Business Transactions1VRGNGBusiness Transactionnvarchar40
51TJ01TBusiness Transaction Texts1VRGNGBusiness Transactionnvarchar40
52TJ01VResponsible for business processes1VRGNGBusiness Transactionnvarchar40
53TJ05Permitted transactions per object type2VRGNGBusiness Transactionnvarchar40
54TJ06System statuses set/deleted by process1VRGNGBusiness Transactionnvarchar40
55TJ07Influence of system status on transactions2VRGNGBusiness Transactionnvarchar40
56TJ31Process control (user status)3VRGNGBusiness Transactionnvarchar40
TOPInformation system
57FMKF_REPTERMKey Figure Terms for Reporting Because of New Budget Tables11VRGNGKey Figures - Transactionnvarchar40
TOPInformation System, iViews
58COOI_PIBW CO-OM: Commitment Management: Deleted Line Items15VRGNGCO Business Transactionnvarchar40
TOPInventory Management
59MWXVM07MFields: Update Control of Module Pool SAPMM07M146VRGNGBusiness Transactionnvarchar40
60MWZVM07MFields: Update Control of Module Pool SAPMM07M146VRGNGBusiness Transactionnvarchar40
61T156SMovement Type: Quantities/Value Posting (Until Rel. 4.5B)22VRGNGBusiness Transactionnvarchar40
TOPLocal Currency Changeover
62EWUCOKException table for TWAER conversion10VRGNGCO Business Transactionnvarchar40
TOPLocalization
63VIXCFRBUDGETBudget Seasonality Data9VRGNGCO Business Transactionnvarchar40
TOPMaintenance Notifications
64TIWOLControl table for SAPLIWOL - Object list9VRGNGBusiness Transactionnvarchar40
65TWOBLControl table for SAPLIWOL - Object list9VRGNGBusiness Transactionnvarchar40
TOPMaterials Management
66J_1GVL_MLMaterial Ledger117VRGNGCO Business Transactionnvarchar40
TOPOrders for Projects
67COSPPTransfer of the Order in the COSP Table to the Project10VRGNGCO Business Transactionnvarchar40
68COSSPTransfer of the Order COSS Table to the Project10VRGNGCO Business Transactionnvarchar40
TOPOverhead Cost Controlling
69COACTVAssign transaction, activity to CO_ACTION1VRGNGBusiness Transactionnvarchar40
70COBKCO Object: Document Header6VRGNGCO Business Transactionnvarchar40
71COEJCO Object: Line Items (by Fiscal Year)173VRGNGCO Business Transactionnvarchar40
72COEJLCO Object: Line Items for Activity Types (by Fiscal Year)111VRGNGCO Business Transactionnvarchar40
73COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)48VRGNGCO Business Transactionnvarchar40
74COEJTCO Object: Line Items for Prices (by Fiscal Year)108VRGNGCO Business Transactionnvarchar40
75COEPCO Object: Line Items (by Period)23VRGNGCO Business Transactionnvarchar40
76COEPLCO Object: Line Items for Activity Types (by Period)21VRGNGCO Business Transactionnvarchar40
77COEPRCO Object: Line Items for Stat. Key Figs (by Period)18VRGNGCO Business Transactionnvarchar40
78COEPTCO Object: Line Items for Prices (by Period)18VRGNGCO Business Transactionnvarchar40
79COKPCO Object: Control Data for Primary Planning9VRGNGCO Business Transactionnvarchar40
80COKRCO Object: Control Data for Statistical Key Figures9VRGNGCO Business Transactionnvarchar40
81COKSCO Object: Control Data for Secondary Planning9VRGNGCO Business Transactionnvarchar40
82COSLCO Object: Activity Type Totals7VRGNGCO Business Transactionnvarchar40
83COSPCO Object: Cost Totals for External Postings9VRGNGCO Business Transactionnvarchar40
84COSRCO Object: Statistical Key Figure Totals9VRGNGCO Business Transactionnvarchar40
85COSSCO Object: Cost Totals for Internal Postings9VRGNGCO Business Transactionnvarchar40
86COSTCO Object: Price Totals9VRGNGCO Business Transactionnvarchar40
87COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis25VRGNGCO Business Transactionnvarchar40
88KAPSCO Period Locks5VRGNGCO Business Transactionnvarchar40
89TKA09VVersion Table: Separate Bus. Transactions for Delta Version4VRGNGCO Business Transactionnvarchar40
90TKASC_RTActivate Realtime Overhead for Business Transactions3VRGNGCO Business Transactionnvarchar40
91TKAVKPermitted Combinations of Transaction/Cost Element Category1VRGNGBusiness Transactionnvarchar40
92TKSVD_VRGNGAssign Valuation Date Profile to Business Transactions3VRGNGCO Business Transactionnvarchar40
TOPOverhead Cost Orders
93COOICommitments Management: Line Items15VRGNGCO Business Transactionnvarchar40
94COSBDCO Object: Total of variances/accruals, of which settled10VRGNGCO Business Transactionnvarchar40
95COSLDCO Object: Activity Type Totals - of Which Settled7VRGNGCO Business Transactionnvarchar40
96COSPDCO Object: Settled Primary Cost Totals9VRGNGCO Business Transactionnvarchar40
97COSSDCO Object: Settled Secondary Cost Totals9VRGNGCO Business Transactionnvarchar40
TOPPatient Management
98TNVRGCIS-H: Bus.Transaction Check on Single Field Level (Customer)3VRGNGBusiness Transactionnvarchar40
99TNVRGRIS-H: Business Transaction Check on Single Field Level (SAP)1VRGNGBusiness Transactionnvarchar40
TOPPegging, Grouping, and Distribution
100DIS_TOBJSDistribution: cost objects posted to per group6VRGNGCO Business Transactionnvarchar40
101DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)10VRGNGCO Business Transactionnvarchar40
102DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)9VRGNGCO Business Transactionnvarchar40
TOPPlant Maintenance
103T354ADefine business operation for authorization check4VRGNGBusiness Transactionnvarchar40
104T354BBusiness transactions for authorization check1VRGNGBusiness Transactionnvarchar40
TOPProduct Cost by Period
105CEZPReporting Points Line Items12VRGNGCO Business Transactionnvarchar40
TOPProfitability Analysis
106CECOEJCO-PA Account Based Line Items175VRGNGCO Business Transactionnvarchar40
107CECOEPCO-PA Account Based Line Items25VRGNGCO Business Transactionnvarchar40
108CEERRORCO-PA: Incorrect records from SD64VRGNGCO Business Transactionnvarchar40
109TKEIPV00CO-PA: Entry Aids (User-Independent)3VRGNGBusiness Transactionnvarchar40
110TKEIPV00TCO-PA: Entry Aids (User-Independent) - Texts3VRGNGBusiness Transactionnvarchar40
111TKEIPV01CO-PA: Entry Aids (User-Independent) - Characteristics3VRGNGBusiness Transactionnvarchar40
112TKEIPV10CO-PA: Entry Aids (User-Dependent)4VRGNGBusiness Transactionnvarchar40
113TKEIPV10TCO-PA: Entry Aids (User-Dependent) - Texts4VRGNGBusiness Transactionnvarchar40
114TKEIPV11CO-PA: Entry Aids (User-Dependent) - Characteristics4VRGNGBusiness Transactionnvarchar40
115TKEVA01NValuation - Control3VRGNGBusiness Transactionnvarchar40
116TKEVGControl of Profitability Analysis by business function3VRGNGBusiness Transactionnvarchar40
117TKEZUCO-PA: Assignments to CO-PA Characteristics4VRGNGBusiness Transactionnvarchar40
118TKE_CO_ERSCHPA Transfer Structure for Overhead Cost Allocation3VRGNGBusiness Transactionnvarchar40
TOPRouting
119TC33Allocation of function code to the operation to be checked6VRGNGBusiness Transactionnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
120/ISHFR/TJ07Influence of system status on transactions4VRGNGBusiness Transactionnvarchar40
TOPTransfer Prices and Decentralized Responsibility
121KFPETransfer Price Agreement: Allocation History6VRGNGBusiness Transactionnvarchar40
122KFPKDocument Header: Transfer Price Agreement/Allocation6VRGNGBusiness Transactionnvarchar40