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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

179 columns | Print definition?ERP 6.0  | POPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items108POPERnvarchar30
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact108POPERnvarchar30
3/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances6POPERnvarchar30
4/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items152POPERnvarchar30
5CNVTDMS_05_CKMLHCollect Table for Material Ledger5POPERPeriodnvarchar30
6FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT52POPERPosting periodnvarchar30
7FAGLFLEXT_DIFDelta Table: G/L Totals13POPERPosting periodnvarchar30
8FARR_D_RECON_KEYReconciliation Key5POPERPosting periodnvarchar30
9GLPCA_CTProfit Center Documents93POPERPosting periodnvarchar30
10GLPCA_T_CTProfit Center Documents109POPERPosting periodnvarchar30
11GLPOS_N_CTNew General Ledger: Line Item with Currency Type197POPERPosting periodnvarchar30
12GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type197POPERPosting periodnvarchar30
13MEV_D_AD_ROOTPeriod-End Valuation: Accruals Document Root7POPERPosting periodnvarchar30
14MEV_D_WL_ITEMPeriod-end valuation: Worklist item9POPERPosting periodnvarchar30
15MLAUFHHistory table for summarized MLAUF data11POPERPosting periodnvarchar30
16RSDHA_009BFiscal year variant periods6POPERPosting periodnvarchar30
17T009BFiscal year variant periods6POPERPosting periodnvarchar30
18T009CPeriod names4POPERPosting periodnvarchar30
19T821VUser distribution key3POPERPosting periodnvarchar30
20T884BAssignment valuation methods to company codes5POPERPosting periodnvarchar30
21T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)15POPERPeriodnvarchar30
22TKMGBBusiness area consolidation: SD assignments3POPEREffective "from" posting periodnvarchar30
23TLMGBBusiness area consolidation: MM assignments3POPEREffective "from" posting periodnvarchar30
24ZSAWAActual line item table10POPERPosting periodnvarchar30
25ZSEMBPSAActual line item table10POPERPosting periodnvarchar30
26ZSPLITAIsteinzelposten-Tabelle10POPERBuchungsperiodenvarchar30
27ZZ001AActual Line Item Table10POPERPosting periodnvarchar30
28ZZLINEAActual line item table10POPERPosting periodnvarchar30
29ZZSL01AActual line item table10POPERPosting periodnvarchar30
30ZZSPECAActual line item table10POPERPosting periodnvarchar30
TOPAccounting - General
31TFC_INSTANCEInstances of a Profile7POPERPosting periodnvarchar30
TOPAccrual Engine
32ACEPSOITLine Items for Accrual Item in Accrual Engine16POPERPosting Period in Financial Accountingnvarchar30
TOPActual CostingMaterial Ledger
33CKMI1Index for Accounting Documents for Material4POPERPosting periodnvarchar30
34CKML1Material Ledger Period Totals Records (Release 3.xx)5POPERPosting periodnvarchar30
35CKMLCRMaterial Ledger: Period Totals Records Values4POPERPosting periodnvarchar30
36CKMLCRWIPMaterial Ledger: WIP Period Records (Values)4POPERPosting periodnvarchar30
37CKMLKEKOMaterial Ledger: Cost Component Split (Header)4POPERPosting periodnvarchar30
38CKMLKEPHMaterial Ledger: Cost Component Split (Elements)4POPERPosting periodnvarchar30
39CKMLKEVMaterial Ledger: Cost Component Split (Control Record)4POPERPosting periodnvarchar30
40CKMLLACRML Activity Type: Period Record/Currency Record4POPERPosting periodnvarchar30
41CKMLLACRWIPML Activity Types: Period/ Currency Records WIP (Values)4POPERPosting periodnvarchar30
42CKMLLAPPML Activity Types: Period Records4POPERPosting periodnvarchar30
43CKMLLAPPWIPMl Activity Types: Period Records WIP (Quantities)4POPERPosting periodnvarchar30
44CKMLMYMPPeriodic Receipt Values for Consumption Sequence Procedure4POPERPosting periodnvarchar30
45CKMLOMaterial Ledger: Organizational Jobs4POPERPosting periodnvarchar30
46CKMLPPMaterial Ledger Period Totals Records Quantity4POPERPosting periodnvarchar30
47CKMLPPWIPMaterial-Ledger: Period Records WIP (Quantities)4POPERPosting periodnvarchar30
48CKMLPRKEKOMaterial Ledger: Cost Component Split (Header) for Prices4POPERPosting periodnvarchar30
49CKMLPRKEPHMaterial Ledger: Cost Component Split (Elements) for Prices4POPERPosting periodnvarchar30
50CKMLPR_EBPrices for Ending Inventory/Balance Sheet Valuation4POPERPosting periodnvarchar30
51CKMLRUNPERIODMaterial ledger costing run for one month6POPERPosting periodnvarchar30
52CKMLRUNPLANTOrganizational units in a material ledger costing run7POPERPosting periodnvarchar30
53CKML_SM_ACActual Costing Data for Schedule Manager8POPERPosting periodnvarchar30
54CKMVFM_EXTRACTTransaction CKMVFM, Extracts, see SAP Note 9129849POPERPosting periodnvarchar30
55CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 9129849POPERPosting periodnvarchar30
56FCML_CCS_REPHDB Reporting Structure for ML3POPERPosting periodnvarchar30
57FCML_REPML Reporting Structure3POPERPosting periodnvarchar30
58MLARC_IDXIndex for ML Document3POPERPosting periodnvarchar30
59MLAUFMaterial Ledger Item Table for Order History10POPERPosting periodnvarchar30
60MLBEMaterial Ledger FS Item Table for GR/IR relevant transaction12POPERPosting periodnvarchar30
61MLBEHMaterial Ledger FS Item Table for GR/IR relevant transaction12POPERPosting periodnvarchar30
62MLCDMaterial Ledger: Summarization Record (from Documents)4POPERPosting periodnvarchar30
63MLCRMaterial Ledger Document: Currencies and Values6POPERPosting periodnvarchar30
64MLCRFMaterial Ledger Document: Field Groups (Currencies)6POPERPosting periodnvarchar30
65MLCRPMaterial Ledger Document: Price Changes (Currencies, Prices)6POPERPosting periodnvarchar30
66MLKEPHML Document: Cost Component Split (Elements) for Values6POPERPosting periodnvarchar30
67MLPPMaterial Ledger Document: Posting Periods and Quantities6POPERPosting periodnvarchar30
68MLPPFMaterial Ledger Document: Field Groups (Posting Periods)6POPERPosting periodnvarchar30
69MLPRKEKOML Document: Cost Component Split (Header)for Prices6POPERPosting periodnvarchar30
70MLPRKEPHML Document: Cost Component Split (Components)for Prices6POPERPosting periodnvarchar30
TOPAdvertising Management
71JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header68POPERPosting periodnvarchar30
TOPAlternative Valuation Run
72CKMLRUNSCALERe-scaling Amounts in the AVR9POPERPosting periodnvarchar30
73CKMLRUNWRuns for Weekly Actual Costing in Material Ledger5POPERPosting periodnvarchar30
TOPAssortment
74WRF_APC_PLIPurchasing List Items34POPERPosting periodnvarchar30
TOPAvailability Control
75FMAVCAActual line item table9POPERPosting periodnvarchar30
TOPBasic Functions
76FILCAFI-LC: Actual journal entry table with 2 object tables10POPERPosting periodnvarchar30
77GGREFAExample for Global FI-SL Line Items (Actual)10POPERPosting periodnvarchar30
78GLFUNCAActual Line Items Table for Cost of Sales Accounting10POPERPosting periodnvarchar30
79GLFUNCURollup line item tables with function area for IDES10POPERPosting periodnvarchar30
80GLREFAExample for Local FI-SL Line Items (Actual)10POPERPosting periodnvarchar30
81GLREFUExample for FI-SL Rollup Line Items (Actual)10POPERPosting periodnvarchar30
82GLSO1FI-SL Line Item Table with Objects for GLTO112POPERPosting periodnvarchar30
83GLSO2FI-SL Table with Objects, Structure corresponds to GLS212POPERPosting periodnvarchar30
84GLSO3FI-SL LI Table with Objects for GLTO312POPERPosting periodnvarchar30
85T807RFI-SL Rollup: History of Executions5POPERPosting periodnvarchar30
86T880BValuation methods5POPERPeriodnvarchar30
TOPBilling
87VBRKBilling Document: Header Data15POPERPosting periodnvarchar30
TOPBudgeting
88FMBDAActual line item table9POPERPosting periodnvarchar30
89FMRBAActual line item table9POPERPosting periodnvarchar30
TOPCollectionsDisbursements
90GLISDEAActual Line Item Tables for Insurance (DE)10POPERPosting periodnvarchar30
91GRISDEAActual Line Item Table for Insurance (DE) - Rollup10POPERPosting periodnvarchar30
TOPConsolidation
92ECMCASAP Cons.: Journal Entry Table (Actual)10POPERPosting periodnvarchar30
TOPCost Element Accounting
93COFISActual line items for reconciliation ledger10POPERPosting periodnvarchar30
TOPCross-Application Components
94VVBKDSales Document: Business Data25POPERPosting periodnvarchar30
TOPData Retention Tool
95TXW_S_COFIRetrieve COFIS from archive8POPERPosting periodnvarchar30
96TXW_S_VBRKRetrieve VBRK from archive41POPERPosting periodnvarchar30
TOPExpense-Related Billing
97PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines5POPERPosting periodnvarchar70
TOPFinancial Accounting
98FBICRC001AICRC: Open Items GL Accounts: Documents9POPERPosting periodnvarchar30
99FBICRC002AICRC: GL Accounts: Documents9POPERPosting periodnvarchar30
100FBICRC003AICRC: Open Items Customers/Vendors: Documents9POPERPosting periodnvarchar30
101FBICRC01025Not in use3POPERPosting periodnvarchar30
102FBICRC01026Not in use4POPERPosting periodnvarchar30
103FBICRC01027Reconciliation: Current Status per Company3POPERPosting periodnvarchar30
104FBICRC01028Reconciliation Process 003: Lock Table for Company Pairs4POPERPosting periodnvarchar30
105FBICRC01040IC Reconciliation: Current Status per Company5POPERPosting periodnvarchar30
106FBICRC01045IC Reconciliation: Lock Table for Company Pairs5POPERPosting periodnvarchar30
107FBICRC01050Differences per Company Pair and Display Category5POPERPosting periodnvarchar30
TOPFinancial Services Localization
108/CEEIS/RUAActual line item table10POPERPosting periodnvarchar30
TOPFlexible Real Estate Management
109VIPRLEDTAGRAIsteinzelposten-Tabelle10POPERBuchungsperiodenvarchar30
TOPFund Accounting
110FMCCAVCAActual line item table9POPERPosting periodnvarchar30
111FMCCAVCRESERVECCAVC aux table for reserved items23POPERPosting periodnvarchar30
112FMGLFLEXAGeneral Ledger: Actual Line Items35POPERPosting periodnvarchar30
113PSGLFLEXAGeneral Ledger: Actual Line Items39POPERPosting periodnvarchar30
TOPFunds Management
114FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 6009POPERPosting periodnvarchar30
115FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 6009POPERPosting periodnvarchar30
116FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 6009POPERPosting periodnvarchar30
117FMIAActual Line Item Table for Funds Management8POPERPosting periodnvarchar30
118FMSPLITAActual line item table9POPERPosting periodnvarchar30
119FMUSFGAActual line item table for US Federal Government.9POPERPosting periodnvarchar30
120FMUSFGFACTS1A4Actual line item table9POPERPosting periodnvarchar30
121FMUSFGFACTS2AActual line item table9POPERPosting periodnvarchar30
TOPGeneral Ledger Accounting
122FAGLFLEXAGeneral Ledger: Actual Line Items37POPERPosting periodnvarchar30
123GLFLEXAFlexible general ledger: Actual line items9POPERPosting periodnvarchar30
TOPGrantee Management
124GMAVCAActual line item table10POPERPosting periodnvarchar30
125GMIAActual Line Item Table9POPERPosting periodnvarchar30
TOPJoint Venture und Production Sharing Accounting
126JVGLFLEXAGeneral Ledger: Actual Line Items39POPERPosting periodnvarchar30
127JVPSC01AActual line item table10POPERPosting periodnvarchar30
128JVSO1JV LI Table with Objects for JVTO110POPERPosting periodnvarchar30
129JVSO2JV Billing FI-SL Line Item9POPERPosting periodnvarchar30
130PSAHDPSA Document Header11POPERPosting periodnvarchar30
131PSCHDPSC document header11POPERPosting periodnvarchar30
132T8JERJoint venture error table5POPERPosting periodnvarchar30
133T8JEVJoint venture event table5POPERPosting periodnvarchar30
134T8JEVPJoint venture event parameters5POPERPosting periodnvarchar30
135T8JEVSJoint venture event select options5POPERPosting periodnvarchar30
136T8JIXJV index table3POPERPosting periodnvarchar30
137T8JTPMJoint Venture Production Month Summary Data11POPERPosting periodnvarchar30
138T8JVBADocuments included in Bank Account Switching8POPERPosting periodnvarchar30
139T8J_GJCB_REVCutback reversal control table5POPERPosting periodnvarchar30
140T8J_JVECJVA equity change document relationship7POPERPosting periodnvarchar30
141T8PSA_ARML_PRICEPSA Manual WAP for Arms Length Sales Transactions8POPERPosting periodnvarchar30
142T8PSA_CLOS_STOCKPSA Closing Stock per Partner8POPERPosting periodnvarchar30
143T8PSA_COST_ADJPSA Cost Adjustment9POPERPosting periodnvarchar30
144T8PSA_EVENTPSA Event table5POPERPosting periodnvarchar30
145T8PSA_EVENT_PARAJoint venture event parameters5POPERPosting periodnvarchar30
146T8PSA_EVENT_SOJoint venture event select options5POPERPosting periodnvarchar30
147T8PSA_PREPOSTPreliminary Posting10POPERPosting periodnvarchar30
148T8PSA_STOCK_ADJPSA Stock Adjustment9POPERPosting periodnvarchar30
149T8PSA_TERM_PRICEPSA Price per terminal8POPERPosting periodnvarchar30
TOPLocal Currency Changeover
150EWUFI_BALEMU conversion: Logging transaction figures change11POPERPosting periodnvarchar30
151EWUFI_BALPEMU conversion: Logging transaction figures change12POPERPosting periodnvarchar30
TOPLocalization
152J_1AINFINVInflation: Invoices for Replacement Value Determination4POPERPosting periodnvarchar30
153J_3RFTAXRATax Accounting: Actual line item table10POPERPosting periodnvarchar30
154J_3RFTAXRVATax Accounting: Actual line item table10POPERPosting periodnvarchar30
TOPPeriodical Sales and Distribution
155JFRKIS-M/SD: Billing - Header Data13POPERPosting periodnvarchar30
156JKKDSales Order: Business Data26POPERPosting periodnvarchar30
157JLRKIS-M/SD: Settlement Header Data13POPERPosting periodnvarchar30
TOPPrice Planning Workbench
158WRF_PPW_WORKLERRPPW Worklist Error Table13POPERPosting Period According to Markdown Profilenvarchar30
159WRF_PPW_WORKLISTPPW Worklist14POPERPosting Period According to Markdown Profilenvarchar30
TOPProduct Cost Planning
160FVMKMarking File for Release of Std Cost Est in Company Code4POPERPosting periodnvarchar30
161KEKOProduct Costing - Header Data64POPERPosting periodnvarchar30
TOPProfit Center Accounting
162GLPCAEC-PCA: Actual Line Items10POPERPosting periodnvarchar30
TOPReal Estate Localization Czech Republic
163/CEERE/BSEGProperty tax: booked FI items6POPERPosting periodnvarchar30
164/CEERE/POMNAKRelative part of property tax to costs3POPERPosting periodnvarchar30
TOPRegulatory reporting for insurance companies
165ISSRFLDEAActual line item table10POPERPosting periodnvarchar30
166ISSR_T009BISSR: Mustertabelle Perioden SR-Geschäftsjahresvariante6POPERBuchungsperiodenvarchar30
TOPRemaining Beverage - Obsolete Objects
167/BEV3/CHFIAActual line item table10POPERPosting periodnvarchar30
168/BEV3/CHVGRAActual line item table10POPERPosting periodnvarchar30
TOPRetail Ledger
169PCRRETAILAActual line item table10POPERPosting periodnvarchar30
TOPRevenues and Earnings
170AD01DLIDynamic items (DI)4POPERPosting periodnvarchar70
TOPSales
171VBKDSales Document: Business Data25POPERPosting periodnvarchar30
TOPSimulation
172VSVBKD_CNVersion: Sales document - commercial data26POPERPosting periodnvarchar30
TOPSpecial Purpose Ledger
173/CCIS/PBU18APBU18: Actual line item table10POPERPosting periodnvarchar30
174/CCIS/PROFTAXAActual Line Items Table for General Ledger47POPERPosting periodnvarchar30
TOPTariffs, Duties and Permits
175OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger10POPERPosting periodnvarchar30
176OIHSLATDP (excise duty) special ledger actual line item table10POPERPosting periodnvarchar30
TOPTechnical Application Support
177CNV_20425_BALEMU conversion: Logging transaction figures change8POPERPosting periodnvarchar30
TOPTransfer to Financial Accounting
178TRACTSLAActual Line Item Table10POPERPosting periodnvarchar30
TOPValue Adjustment
179/IBS/TRB_UIRBD: RBD Record Data Table (Actual)11POPERPosting periodnvarchar30