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

143 columns | Print definition?ERP 6.0  | CURR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FLBOOK_IDXStandard index table45CURRLocal currency of airlinenvarchar50
2/SAPPSSRM/TRESHDIBU PS: Thresholds4CURRCurrency Keynvarchar50
3CMCBD_ENTRY_HISTCash Budgeting Entry History10CURRCurrency Keynvarchar50
4REFXCN_CD_ADJCondition Adjustment7CURRCurrency of condition itemnvarchar50
5T77WWW_ELIGIBLEEmployee Eligibility for Advanced Claims11CURRCurrency Keynvarchar50
6ZMTMPERSCM MtM Persistency25CURRCurrency Keynvarchar50
TOPAccounting Interface
7GLE_BALANC_LINELine Items for Balancing3CURRBalancing Currencynvarchar50
8GLE_BALANC_LINETText Table for Line Items for Balancing3CURRBalancing Currencynvarchar50
TOPAdaptor
9UKM_TRANSFER_ARVData from AR for SAP Credit Management10CURRCurrency Keynvarchar50
TOPAerospace Defence Industry Solution
10ORF2CUSTCustomising Profils for Optimal Rotable Float ORF1,2,413CURRCurrency Keynvarchar50
11ORFECTORF: Essentiality-Code Table5CURRCurrency Keynvarchar50
TOPAgency Business Global Trade
12TMPA1Agency Business: Profit Group5CURRCurrency for minimum profit marginnvarchar50
TOPAssetLiability Management
13JBRBRLQSZAssignment of Liquidation Scenario to Valuation Rule6CURRCurrency Keynvarchar50
TOPBank Customer Accounts
14TBKKIHB6Dispatcher per Account Number6CURRCurrency of External Bank Accountnvarchar50
TOPBasic Functions
15EWULC03FI-LC: Companies for conversion4CURRLocal currency prior to conversionnvarchar50
TOPBusiness Consolidation
16UCF2301C/T: Methods: Target Key Figures4CURRCurrency Keynvarchar50
TOPBusiness Partner
17BP3100Additional information12CURRCurrencynvarchar50
TOPClaims Management
18ICLCCEVENTClaim Bundle11CURRCurrency of Claim Bundle Reservenvarchar50
19ICLCCEVPAYClaim Bundle - Payment Sum6CURRTransaction Currencynvarchar50
20ICLCCEVRESClaim Bundle - Reserve Sum5CURRCurrency of Reserve (Transactn Crcy)nvarchar50
21ICLDIPLDistribution Plan14CURRDistribution Plan: Currencynvarchar50
22ICLDRGITEMDRG Item30CURRCurrency of Evaluated Amountnvarchar50
23ICLINDRESReserve Lot10CURRCurrency of Reserve (Transactn Crcy)nvarchar50
24ICLINDRESAClaim-Independent Reserve - Case Reserve - Assignment7CURRCurrency of Reserve (Transactn Crcy)nvarchar50
25ICLITEMAUDamaged Vehicle51CURRCurrency of Actual Cash Valuenvarchar50
26ICLITEMEQDamaged Item30CURRCurrency of Actual Cash Valuenvarchar50
27ICLITEMREDamaged Real Estate23CURRCurrency of Actual Cash Valuenvarchar50
28ICLITEMSVSalvage Item Evaluation11CURRCurrency of Actual Cash Valuenvarchar50
29ICLPAYClaim Payment26CURRClaim Payment Currencynvarchar50
30ICLPOLPolicy Snapshot17CURRCurrency of Limit and Deductiblenvarchar50
31ICLRESERVECase Reserve6CURRCurrency of Reserve (Transactn Crcy)nvarchar50
32ICSCCEVENTShadow Table Claim Bundle11CURRCurrency of Claim Bundle Reservenvarchar50
33ICSCCEVPAYClaim Bundle - Payment Sum6CURRTransaction Currencynvarchar50
34ICSCCEVRESClaim Bundle - Reserve Sum5CURRCurrency of Reserve (Transactn Crcy)nvarchar50
35ICSDIPLDistribution Plan (Shadow Table)14CURRDistribution Plan: Currencynvarchar50
36ICSDRGITEMDRG Item30CURRCurrency of Evaluated Amountnvarchar50
37ICSITEMAUDamaged Vehicle51CURRCurrency of Actual Cash Valuenvarchar50
38ICSITEMEQDamaged Item30CURRCurrency of Actual Cash Valuenvarchar50
39ICSITEMREDamaged Real Estate23CURRCurrency of Actual Cash Valuenvarchar50
40ICSITEMSVSalvage Item Evaluation11CURRCurrency of Actual Cash Valuenvarchar50
41ICSPAYPayment26CURRClaim Payment Currencynvarchar50
42ICSPOLPolicy Snapshot17CURRCurrency of Limit and Deductiblenvarchar50
43ICSRESERVECase Reserve6CURRCurrency of Reserve (Transactn Crcy)nvarchar50
44TICL003Internal Claim Type Version17CURRCurrency for All Amount Fields of Internal Claim Typenvarchar50
45TICL072Reserving Rules4CURRCurrency of all statistical reservesnvarchar50
46TICL161Version of Benefit Type Tree18CURRCurrency for All Amount Fields of Benefit Type Treenvarchar50
47TICL321Policy Product Version20CURRCurrency for All reserves, Limits and Deductiblesnvarchar50
TOPCollectionsDisbursements
48DIMAPARSCPOSIO: Change to Scheduling Items18CURRCurrency Keynvarchar50
49IBROSTMCFClarif. Cases from Broker Report10CURRCurrency Keynvarchar50
50IBROSTMHISCD: Broker Report - Header Data24CURRCurrency Keynvarchar50
51IBROSTMPISCD: Broker Report - Item Data26CURRCurrency Keynvarchar50
52IBROSTMSUMBroker Summary Postings - Restart Information13CURRCurrency Keynvarchar50
53ITAGCYCONTPItems for a Container6CURRCurrency Keynvarchar50
54ITAGCYTPCOMMReported Commission for Items in a Container4CURRCurrency Keynvarchar50
55VVSCITEMBill Scheduling: Scheduling Document24CURRCurrency Keynvarchar50
56VVSCITEMLBill Scheduling: for General Ledger9CURRCurrency Keynvarchar50
57VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change24CURRCurrency Keynvarchar50
58VVSCLOCKAMTScheduling: Premium Lock Period Share Already Transferred8CURRCurrency Keynvarchar50
59VVSCPOSPayment Plan Item42CURRCurrency Keynvarchar50
TOPCondition
60BKK81Bank Condition10CURRCurrency Keynvarchar50
61BKK82Bank Condition Item20CURRCurrency Keynvarchar50
62BKK83Bank Condition Determination7CURRCurrency Keynvarchar50
63BKK84Bank Account - Individual Condition12CURRCurrency Keynvarchar50
64BKK85Bank Account - Individual Condition Position22CURRCurrency Keynvarchar50
65BKK8RKStandard Conditions: Retroactive Condition Changes11CURRCurrencynvarchar50
66BKK91Value Date Transaction Figures8CURRAccount Currencynvarchar50
67BKK92Account Balancing (Interest and Charges)9CURRAccount Currencynvarchar50
68BKK95Account Specific Amount Limits for Graduated Conditions7CURRCurrency of Current Accountnvarchar50
69BKK96Account Balancing Detail Data22CURRCurrency of Current Accountnvarchar50
70BKK9APosting and Value Date Balances Carried Forward8CURRAccount Currencynvarchar50
71BKK9BValue Date Transaction Figures10CURRAccount Currencynvarchar50
72TBKK8MTrivial Amounts4CURRCurrency Keynvarchar50
TOPConsolidation
73EWUCS10SAP Cons.-EURO: Consolidation Units for Euro Conversion5CURRLocal currencynvarchar50
74TF164Consolidation Unit Year-Dependent5CURRLocal currencynvarchar50
75TF184Consolidation Groups, Version- and Year-Dependent7CURRLocal currencynvarchar50
76TF199CCharacteristic Values of Organizational Elements4CURRCurrencynvarchar50
77TF555Methods for Interunit Elimination13CURRCurrencynvarchar50
78TF557Methods: Threshold Value for Posting Differences4CURRCurrencynvarchar50
TOPContract Accounts Receivable and Payable
79TFK056IMinimum Amounts for Interest Calculation Rule3CURRCurrency Keynvarchar50
TOPDefault Risk and Limit System
80KLDATESHIFTShift Validity Date of Settlement Risk for FX Option2CURRCurrency in which the foreign currency option is soldnvarchar50
TOPDownloadUpload
81/DSD/HH_RACLDSD Route Settlement: Clearing13CURRCurrency Keynvarchar50
82/DSD/HH_RACOCICIDSD Route Settlement: Check-Out/Check-In - Money Item6CURRCurrency Keynvarchar50
83/DSD/HH_RADELCDDSD Route Settlement: Delivery Execution Conditions8CURRCurrency Keynvarchar50
84/DSD/HH_RADELCNDDSD Route Settlement: Delivery Execution Conditions9CURRCurrency Keynvarchar50
85/DSD/HH_RAECDSD Route Settlement: Receipts/Expenditures7CURRCurrency Keynvarchar50
86/DSD/HH_RAIVCDDSD Route Settlement: HH Invoice Header Conditions7CURRCurrency Keynvarchar50
87/DSD/HH_RAIVCNDDSD Route Settlement: HH Invoice Header Conditions8CURRCurrency Keynvarchar50
TOPEnterprise Compensation Management
88T71ADM_SPENT_AMTCompensation Planning: Spent Amounts8CURRCurrency Keynvarchar50
TOPExpenditure Certification
89FMEUFEXPCertified Expenditure Documents20CURRCurrency of the Financing Sourcenvarchar50
90FMEUFFNSFinancing Source12CURRCurrency Keynvarchar50
91FMEUFPRELCONSPreliminarily Certified Amounts8CURRCurrency Keynvarchar50
92FMEUFRUNCertification Run Parameter5CURRCurrency Keynvarchar50
93FMEUFTIMFinancing Source Time Slices8CURRCurrency Keynvarchar50
94FMEUFTYPFinancing Source Type6CURRCurrency of the Financing Sourcenvarchar50
95FMEUF_PREL_FS_COObsolete!! To be removed!!8CURRCurrency Keynvarchar50
TOPFlexible Real Estate Management
96VIXCFCFSFuel Movement12CURRCurrency Keynvarchar50
TOPFSCM In-House Cash
97IHC_DB_CL_ACCTSAccount Determination for AMS Update3CURRCurrency Keynvarchar50
98IHC_DB_DSP_TRAPOTable Structure for displaying the Posted Item Detail9CURRCurrency Keynvarchar50
TOPGlobal Organization Customizing
99/MRSS/D_REQ_CANDTable of Portal demands : Candidates Information11CURRCurrency Keynvarchar50
TOPIndustry-Specific Component-Mining
100/BPR3MI/MIN_CBPMining - Contract additional parameters11CURRMining - Contract Based Pricing Currencynvarchar50
TOPInterest Calculation
101T056ITime-dep.terms for interest calc.rule3CURRCurrency Keynvarchar50
102T056JTime-dependent terms for interest calc.rule - access3CURRCurrency Keynvarchar50
TOPInterestCharge Calculation
103BKKM3BCA: Parameters for Mass Runs in Parallel Processing22CURRTransaction Currencynvarchar50
TOPJoint Venture und Production Sharing Accounting
104PSACRPSA Document Currencies10CURRCurrency Keynvarchar50
105PSCCRPSC document line item amounts10CURRCurrency Keynvarchar50
TOPLand Register
106CMS_LR_DE_2Grundbuch - Section II9CURRCurrency of the Chargenvarchar50
TOPLoans Management
107TDCAP_CONDCondition amount for capitalization6CURRCurrencynvarchar50
108TDDEF_CONDCondition amount for deferral6CURRCurrencynvarchar50
109VDBOINSBusiness Operation Insurance Data16CURRInsurance Policy Currencynvarchar50
TOPLocalization
110J_1IQRDEPQuarterly Returns Depot structure22CURRCurrencynvarchar50
111J_1ISERVCService tax details15CURRCurrency Keynvarchar50
TOPLogistics - General
112EPM_KPI_CATALOGKPIs Available in Company Catalog14CURRCurrency Keynvarchar50
TOPMaster Data
113BKK620Account Hierarchy: Amount Definitions for Cash Concentration6CURRCurrency of Current Accountnvarchar50
114BKK621Cash Concentration: Different Amount Defintions10CURRCurrency of Current Accountnvarchar50
115BKK62_CCValue Date Transaction Figures for Cash Concentration6CURRAccount Currencynvarchar50
116BKK9B_CCValue Date Transaction Figures for Cash Concentration10CURRAccount Currencynvarchar50
117TDCLI_INSURANCETable of Credit Life Insurance Rates12CURRCurrency Keynvarchar50
118TDCLI_INS_1Table of Credit Life Insurance Rates11CURRCurrency Keynvarchar50
TOPPayroll
119T7SKA4Pomocná tabulka HRSK15CURRKlúc menynvarchar50
120T7SKVDPAux table for HSKLVDP010CURRCurrency Keynvarchar50
TOPRevenue
121OIURV03_TAXDTLValuation Tax Master Detail27CURRCurrency Keynvarchar50
122OIURV03_TAXEMPValuation Tax Exempt Detail12CURRCurrency Keynvarchar50
123OIURV03_TAXHDRValuation Tax Header12CURRCurrency Keynvarchar50
124OIURV03_TAXMKTValuation Tax Marketing Detail13CURRCurrency Keynvarchar50
TOPRoute Settlement
125/DSD/SL_POSTSETDSD Collection: Posting Ctrl. Driver Receipts/Expenditures3CURRCurrency Keynvarchar50
TOPSAP Healthcare - Industry-Specific Components for Hospitals
126/ISHFR/TNWFR_CCPIS-H FR: Coordinated Care Path12CURRCurrency Keynvarchar50
TOPSchedule Manager
127T880Global Company Data (for KONS Ledger)11CURRLocal currencynvarchar50
TOPStock Visibility
128/DSD/SV_RACOCICIDSD SV: Check-Out / Check-In - Money Item6CURRCurrency Keynvarchar50
TOPTrading Contract
129WB2_D_STRINGLogistical string,circle and washout9CURRCurrencynvarchar50
130WB2_D_STRING_HHeader: Logistical string,circle and washout4CURRCurrencynvarchar50
TOPTransaction Tax Engine
131TTEC_CURRTax Currencies per Country5CURRCurrency Units in Tax Calculationnvarchar50
132TTEC_ROUNDINGRounding Decimals: Exceptions8CURRCurrency Units in Tax Calculationnvarchar50
TOPValuation
133OIURV_DOC_TAXDTLValuation Tax Master Detail27CURRCurrency Keynvarchar50
134OIURV_DOC_TAXEMPValuation Tax Exempt Detail12CURRCurrency Keynvarchar50
135OIURV_DOC_TAXHDRValuation Tax Header12CURRCurrency Keynvarchar50
136OIURV_DOC_TAXMKTValuation Tax Marketing Detail13CURRCurrency Keynvarchar50
137OIURV_SSTDSettlement statement detail26CURRCurrency Keynvarchar50
138OIURV_SSTD_MKTSettlement statement detail8CURRCurrency Keynvarchar50
139OIURV_SSTD_TAXSettlement statement detail8CURRCurrency Keynvarchar50
140OIURV_TCDTax calculation data13CURRCurrency Keynvarchar50
141OIUVL_SSTHSettlement statement header10CURRCurrency Keynvarchar50
TOPWorkbench Tools Editors, Painters, Modelers
142COVMVHIDTable for Storing History Versions2CURRIndicatornvarchar10
TOPWorkbench Utilities
143FLIGHTMFlight master data9CURRCurrency indicatornvarchar30