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

148 columns | Print definition?ERP 6.0  | KURST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000475TCURF5KURSTnvarchar40
2/1CADMC/00000477TCURR5KURSTnvarchar40
3/1CADMC/00000479TCURV5KURSTnvarchar40
4/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header23KURSTnvarchar40
5/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item13KURSTnvarchar40
6/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item23KURSTnvarchar40
7/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule36KURSTnvarchar40
8/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.26KURSTnvarchar40
9/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.18KURSTnvarchar40
10/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data23KURSTnvarchar40
11/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item19KURSTnvarchar40
12/CEECV/BVFI_CURROfficial Currency for Country4KURSTExchange Rate Typenvarchar40
13/SAPF15/XXBPDJF15 FI DUMMY15KURSTnvarchar40
14/SMD/MD_____00YXSID-Tabelle fuer Exchange Rate Type3KURSTExchange Rate Typenvarchar40
15CMCBC_CBAREACash Budgeting Area7KURSTExchange Rate Typenvarchar40
16CMM_MTM_BUKRSMtM Settings on company code level5KURSTExchange Rate Typenvarchar40
17FUDT_VDOCBKPFVerification Document Header82KURSTExchange Rate Typenvarchar40
18FUDT_VDOCBKPFHVerification Document Header(History)82KURSTExchange Rate Typenvarchar40
19GLPOS_C_CTFI Document: Entry View157KURSTExchange Rate Typenvarchar40
20GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items157KURSTExchange Rate Typenvarchar40
21GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items157KURSTExchange Rate Typenvarchar40
22GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items157KURSTExchange Rate Typenvarchar40
23GLPOS_N_CTNew General Ledger: Line Item with Currency Type159KURSTExchange Rate Typenvarchar40
24GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type159KURSTExchange Rate Typenvarchar40
25IDHU_TAX_LIFNR_KExchange rate type per vendor for tax amount in 2nd or 3rd4KURSTExchange Rate Typenvarchar40
26MEV_D_AD_ITEM_MMPeriod-End Valuation: Accruals Document Item MM27KURSTExchange Rate Typenvarchar40
27MEV_D_WL_MMPeriod-end valuation: Worklist - Materials Management Data27KURSTExchange Rate Typenvarchar40
28PA3306HR Master Record: Infotype 330624KURSTExchange Rate Typenvarchar40
29PB3306Applicant data infotype 3306 (model)24KURSTExchange Rate Typenvarchar40
30T056CFixed Amounts in Interest Calculation9KURSTExchange Rate Typenvarchar40
31T169PParameters, Invoice Verification15KURSTExchange rate typenvarchar40
32TKB8BExchange Rate Type for CO Settlement4KURSTExchange Rate Typenvarchar40
33TKEVSCO-PA version attributes6KURSTExchange Rate Typenvarchar40
34ZEIM_VBAKSales Document: Header Data61KURSTExchange Rate Typenvarchar40
TOPABAP Workbench, Java IDE and Infrastructure
35SCURRExchange rates for Workbench training model BC_Travel2KURSTExchange Rate Typenvarchar40
TOPAddress ManagementBusiness Address
36T005Countries55KURSTExchange Rate Type for Translation into Country Currencynvarchar40
TOPAdvertising Management
37JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset87KURSTExchange Rate Typenvarchar40
38JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order43KURSTExchange Rate Typenvarchar40
39JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header22KURSTExchange Rate Typenvarchar40
40JHTVAABPIS-M/AM: Contract Settlement Item Data36KURSTExchange Rate Typenvarchar40
41JJTBEIS-M/AM: Booking Units40KURSTExchange Rate Typenvarchar40
42JJTVVIS-M/AM: Media Sales Agent Contract25KURSTExchange Rate Typenvarchar40
TOPAgency Business Global Trade
43TMFKAgency Business: Billing Document Types54KURSTExchange Rate Typenvarchar40
44WBRKAgency business: Header86KURSTExchange Rate Typenvarchar40
TOPBalanced Scorecard
45UMB_SC100Scorecard: Header Table32KURSTExchange Rate Typenvarchar40
TOPBank Components
46JBDOBJEURAdditional Fields for Finance Object (EURO Conversion)5KURSTExchange Rate Type used for Conversionnvarchar40
TOPBasic Functions
47FDESCash Management and Forecast: Memo Records13KURSTExchange Rate Typenvarchar40
48FDESDISTCash management memo records (distributed)14KURSTExchange Rate Typenvarchar40
49T091CTranslation methods for Asset Accounting4KURSTExchange Rate Typenvarchar40
50T606Legal Control: License Types13KURSTExchange Rate Typenvarchar40
51UKMCRED_SGM0CSAP Credit Management: Segment Data5KURSTExchange Rate Typenvarchar40
TOPBasic Market Data
52/BA1/TF4_FXKURSTMap Exchange Rate Category to Rate Type4KURSTExchange Rate Typenvarchar40
53/BA1/TF4_FXRTTYPRate Categories for Exchange Rates11KURSTExchange Rate Typenvarchar40
TOPBasic Settings
54T895PCAEC-PCA: Fiscal-Year Dependent Version Parameters9KURSTExchange Rate Typenvarchar40
TOPBilling
55VBRKBilling Document: Header Data63KURSTExchange Rate Typenvarchar40
TOPChina
56T7CN32Tax Area3KURSTExchange Rate Typenvarchar40
TOPCommodity Pricing Engine
57CPED_TCURR_SIMCPE - Exchange Rate Simulation2KURSTExchange Rate Typenvarchar40
TOPConsolidation
58TF361Download: Selection Parameters for General Download7KURSTExchange Rate Typenvarchar40
59TF425Exchange Rate Indicators: ER Type Assignments6KURSTExchange rate typenvarchar40
TOPControlling
60COPPP_HDRCO Postprocessing List - Headers27KURSTExchange Rate Typenvarchar40
TOPCost Object
61CKPHSControl for Cost Object Category23KURSTExchange Rate Typenvarchar40
TOPCross-Application Components
62VVBAKSales Document: Header Data61KURSTExchange Rate Typenvarchar40
TOPCurrency ConversionExpiring Currency
63TCURFConversion Factors2KURSTExchange Rate Typenvarchar40
64TCURRExchange Rates2KURSTExchange Rate Typenvarchar40
65TCURSRate Spreads2KURSTExchange Rate Typenvarchar40
66TCURVExchange rate types for currency translation2KURSTExchange Rate Typenvarchar40
67TCURWUsage of Exchange Rate Types3KURSTExchange Rate Typenvarchar40
TOPCustomer Master
68KNVVCustomer Master Sales Data50KURSTExchange Rate Typenvarchar40
TOPData Collection
69TMCUSParameters for Standard Analyses in LIS12KURSTExchange rate type for conversion to analysis currencynvarchar40
TOPEarly Warning System
70MCYAEarly Warning: Exceptions25KURSTExchange rate type for conversion to analysis currencynvarchar40
TOPEmpties Management
71/BEV1/EMLGBWDPEmpties Movement Account Customer36KURSTExchange Rate Typenvarchar40
TOPFinancial Accounting
72BKPFAccounting Document Header82KURSTExchange Rate Typenvarchar40
73T001AAdditional Local Currencies Control for Company Code4KURSTExchange Rate Typenvarchar40
74T003Document Types19KURSTExch.Rate Type for Determining the Proposed Ratenvarchar40
TOPFinancials Basis
75ACCSYS05Setting for Currency Translation5KURSTExchange Rate Typenvarchar40
76ACCSYS06Settings for Reference Valuation5KURSTExchange Rate Typenvarchar40
TOPFreight Processing
77VFKPShipment Costs: Item Data27KURSTExchange Rate Typenvarchar40
TOPFunds Management
78BPDGTotal Values Entry Document13KURSTExchange Rate Typenvarchar40
79BPDJAnnual Values Entry Document15KURSTExchange Rate Typenvarchar40
80BPEGLine Item Overall Values Controlling Obj.18KURSTExchange Rate Typenvarchar40
81BPEJLine Item Annual Values Controlling Obj.20KURSTExchange Rate Typenvarchar40
82BPEPLine Item Period Values Controlling Obj.48KURSTExchange Rate Typenvarchar40
83BPHICross-hierarchy Data Controlling obj.9KURSTExchange Rate Typenvarchar40
84TBP1CBudget/Plan Profile15KURSTExchange Rate Typenvarchar40
TOPInformation system
85FMCJ_BTRErfassung des Kassenistbestandes5KURSTKurstypnvarchar40
TOPInformation System
86TEURBAltern. Local Currency and Exch.Rate Type for a Company Code6KURSTExchange Rate Typenvarchar40
TOPInvestment Programs
87TAI05CI Program Types15KURSTExch. Rate Type for Currency Translation in IM InfoSystemnvarchar40
TOPJoint Venture und Production Sharing Accounting
88T8JZJV Global Company Parameters49KURSTJV exchange rate typenvarchar40
89T8PSA_CURR_TYPEPSA Currency and Exchange Rate Types4KURSTExchange Rate Typenvarchar40
TOPLocal Currency Changeover
90EWUEXCLKT_40Exch.rate types for which histor.rates are to be maintained2KURSTExchange Rate Typenvarchar40
91EWUKEYSCurrency key, exchange rate type and date for EMU4KURSTExchange rate type for fixed Monetary Union exchange ratesnvarchar40
TOPLocalization
92IDCN_EXCH_RATEExchange Rate Types (Golden Audit)3KURSTExchange Rate Typenvarchar40
TOPLogistics - General
93WBHKTrading Contract: Header Data25KURSTExchange Rate Typenvarchar40
TOPLogistics Execution
94/DSD/PE_CONVFACTPricing: Conversion factors3KURSTExchange Rate Typenvarchar40
95/DSD/PE_EXCHRATEPricing: Exchange rates3KURSTExchange Rate Typenvarchar40
TOPMarket Risk Analyzer
96FTBB_MDG_VAR_FXTable for Saving Start Parameters for Foreign Currency4KURSTExchange Rate Typenvarchar40
TOPMaster Data
97JGTBVIS-M/SD: Employment Relationship18KURSTExchange Rate Typenvarchar40
98JGTVSGVIS-M/SD: Sales Area Data for Service Company9KURSTExchange Rate Typenvarchar40
99JGTVSMAIS-M/SD: Default Settlement Data for Service Company8KURSTExchange Rate Typenvarchar40
100JGTZUSTIS-M/SD: Carrier13KURSTExchange Rate Typenvarchar40
TOPMerchandise and Assortment Planning
101TWISPC_VRSIORetail Planning: Add-Ons to the LIS Plan Version6KURSTExchange Rate Typenvarchar40
TOPOverhead Cost Controlling
102COBKCO Object: Document Header26KURSTExchange Rate Typenvarchar40
103TKA07Fiscal-Year Dependent Version Parameters10KURSTExchange Rate Typenvarchar40
TOPOverhead Cost Orders
104AUAKDocument Header for Settlement8KURSTExchange Rate Typenvarchar40
TOPPatient Accounting
105NVBRKIS-H: Billing document header data45KURSTExchange Rate Typenvarchar40
TOPPayment Transactions
106REGUVControl records for the payment program12KURSTAlternative Ex.Rate Type for Payments in Foreign Currencynvarchar40
TOPPayroll
107T7TRP03Bordroda kullanilacak yabanci kurun gün belirleme tablosu4KURSTKur tipinvarchar40
TOPPeriodical Sales and Distribution
108JFREVLIABACCIS-M/SD: Accr.Table for Rev.Dist.w/Liab.Acct for Transfer11KURSTExchange Rate Typenvarchar40
109JFREVLIABACC_REVIS-M/SD: Reverse Revenue Dist. w/Liability Acct for Trans.14KURSTExchange Rate Typenvarchar40
110JFREVPERIS-M/SD: Accrual Table for Period-Related Revenue Dist.11KURSTExchange Rate Typenvarchar40
111JFREVPER_REVERSEIS-M/SD: Reverse Period-Related Revenue Distribution14KURSTExchange Rate Typenvarchar40
112JFREVVAIS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct11KURSTExchange Rate Typenvarchar40
113JFREVVAACCIS-M/SD: Accr.Table for Issue-Related Rev.Dist.w/Liab.Acct11KURSTExchange Rate Typenvarchar40
114JFREVVAACC_REVERIS-M/SD: Reverse Issue-Related Revenue Dist. w/Liab. Account14KURSTExchange Rate Typenvarchar40
115JFREVVA_REVERSEIS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct14KURSTExchange Rate Typenvarchar40
116JFRKIS-M/SD: Billing - Header Data48KURSTExchange Rate Typenvarchar40
117JKACCOUNTIS-M/SD: Liability Account for Subscription16KURSTExchange Rate Typenvarchar40
118JKACCOUNT_GOLIVEIS-M/SD: Shadow Table for JKACCOUNT After Data Transfer15KURSTExchange Rate Typenvarchar40
119JKAKSales Order Header Data24KURSTExchange Rate Typenvarchar40
120JKKUENDSales Order: Termination Data31KURSTIS-M/SD: Exchange Rate Type for Liability Account Transfernvarchar40
121JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet9KURSTExchange Rate Typenvarchar40
122JLRKIS-M/SD: Settlement Header Data36KURSTExchange Rate Typenvarchar40
123JVTZAEM2Sales Order Header Data26KURSTExchange Rate Typenvarchar40
124TJKWWW_FIXIS-M/SD: WWW, Combinations of Fixed Order Values9KURSTExchange Rate Typenvarchar40
TOPPOS Interface
125TWPFIPOS outbound profile6KURSTExchange Rate Typenvarchar40
TOPPricing
126PRCD_HEADPrice Condition Set (Header)9KURSTExchange Rate Typenvarchar40
TOPProduct Cost Planning
127CKHSHeader: Unit Costing (Control + Totals)36KURSTExchange Rate Typenvarchar40
128CKKSHeader: Unit Costing (Control + Totals)24KURSTExchange Rate Typenvarchar40
129KEKOProduct Costing - Header Data115KURSTExchange Rate Typenvarchar40
130TCK32Costing Versions6KURSTExchange Rate Typenvarchar40
TOPReal Estate Management
131IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)23KURSTExchange Rate Typenvarchar40
TOPRecycling Administration Core Functions
132J_7LE02REA Partner Master Record: Company Code11KURSTRate Type: Price List Translation REAnvarchar40
133J_7LV1KREA Document: Header Data25KURSTExchange Rate Typenvarchar40
TOPRemaining Beverage - Obsolete Objects
134/BEV1/RBVBAKSales Document: Header Data61KURSTExchange Rate Typenvarchar40
TOPReporting
135MCRSVSelection versions: Header data10KURSTExchange rate type for conversion to analysis currencynvarchar40
TOPRetail Pricing
136TWKGSales Price Calculation: Pricing Type9KURSTExchange Rate Typenvarchar40
137TWWKAMarket-Basket Pricing Type7KURSTExchange Rate Typenvarchar40
TOPSales
138VBAKSales Document: Header Data61KURSTExchange Rate Typenvarchar40
TOPSales Plan
139T445APlanning Configuration for Info Structure11KURSTExchange Rate Typenvarchar40
TOPSimulation
140VSVBAK_CNVersion: Sales document: Header data62KURSTExchange Rate Typenvarchar40
TOPTechnical Application Support
141CNV_20365_ORGControlling area currencies for conversion13KURSTExchange Rate Typenvarchar40
TOPTrading Contract
142TPROFIT2_CALCTrading Contract:7KURSTExchange Rate Typenvarchar40
143TSTATUSCUST_PROFTrading Contract: Table of Status Fields7KURSTExchange Rate Typenvarchar40
TOPTransaction Manager
144AT15BTreasury: Forex Swap Rates (New)3KURSTExchange Rate Typenvarchar40
145VWKMKOCorporate actions (header)36KURSTExchange Rate Typenvarchar40
TOPTravel Expenses
146T706DDefault Values for Dialog10KURSTExchange Rate Typenvarchar40
TOPTreasury
147AT15Treasury: Foreign exchange swap rates3KURSTExchange Rate Typenvarchar40
148MDUCVMkt Data: Assign New Key for Curr.Type4KURSTExchange Rate Typenvarchar40