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

164 columns | Print definition?ERP 6.0  | PRICE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FLBOOK_IDXStandard index table43PRICEFlight booking pricedecimal234
2/ATL/SMR1Inventory value in "hard" currency8PRICEMAP in Cost of Live index unitsfloat1516
3/CPD/FC_PRICINGPricing Master data8PRICEPricedecimal152
4/SAPQUERY/T100Flight5PRICEAirfaredecimal152
5/SAPQUERY/T101Flight cargo5PRICEAirfaredecimal152
6/SAPSRM/SOCO_DOCTable Containing Follow-on Documents Created in Background10PRICETotal Value of Shopping Cart / Target Value of Contractdecimal152
7BBPM_PRGENERALProduct - Purchasing Set4PRICEPrice for Release Proceduredecimal112
8BBPM_PRGENERALHGeneral Purchasing Data on Product (History)5PRICEPrice for Release Proceduredecimal112
9BBP_PDCONPurchase Order Item Confirmation7PRICENet Pricedecimal132
10BBP_PDIGPBusiness Transaction Item-Purchasing Information24PRICENet Pricedecimal132
11DAAG_SFLIGHTFlight5PRICEAirfaredecimal152
12HRP1691DB Table for Infotype 169124PRICEProposed amountdecimal152
13J_1UF_TAX_POSExtended data of tax document positions23PRICEAmount in Local Currencydecimal132
14OIUY6_WY_PRICERoyalty 2.0 - WY - Report Pricing8PRICERoyalty 2.0 - Wyoming Report Pricedecimal94
15REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)68PRICENet price in purchasing document (in document currency)decimal112
16REQLINESRTemporary Line Data: Requirement Coverage Request (Services)65PRICENet Pricedecimal132
17SADL_QE_V_HEADERTable for Unit Tests of ABQI Query Engine6PRICEdecimal150
18SADL_SFLIGHTFlight5PRICEAirfaredecimal152
19SALV_IDA_SFLIGHTFlug5PRICEFlugpreisdecimal152
20SDDLFLIGHTTSTFlight5PRICEAirfaredecimal152
21SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO26PRICENet Pricedecimal132
22TBAT_PRICEQUOTDerivative Contract Specification: Price Quotations10PRICEQuotation Pricedecimal3114
23TBAT_PRICEQUOT_FDerivative Contract Specification: Price Quotations Futures10PRICEQuotation Pricedecimal3114
24TBAT_PRICEQUOT_ODerivative Contract Specification: Price Quotations Options11PRICEQuotation Pricedecimal3114
25TBAT_PRICE_FWDDerivative Contract Specification: Commodity Forward Prices12PRICEQuotation Pricedecimal3114
26TEXT_CTY_EXPOSCommodity Price Exposure35PRICEExposure Amountdecimal172
27TLRT_TARO_CNTTrade Repository: Content34PRICETransaction Data: Pricedecimal156
28TRCPAT2TR: Commodity Price Adjustment-Registration and Fixing (DCS)12PRICEQuotation Pricedecimal3114
29ZCATSDBRecords changed with processing status '10'50PRICEdecimal110
30ZCATSDB2Records changed with processing status '10'51PRICEdecimal110
31ZMATERIALDemo Teched5PRICEPricedecimal112
32ZPPMC_CPL_C_RESPPrice table for CO resources5PRICEPrice for CO Resourcedecimal112
33ZRATEEmployee Actual Hourly Rates/Fiscal Year5PRICEdecimal110
34ZRP1036Infotype 1036 DB table20PRICEProposed amountdecimal152
35ZSFLIGHT99Demotabelle für D40AW Kurs (Suchhilfen...)5PRICEFlugpreisdecimal152
TOPABAP Workbench, Java IDE and Infrastructure
36SFLIGHTFlight5PRICEAirfaredecimal152
TOPActual CostingMaterial Ledger
37CKMLPR_EBPrices for Ending Inventory/Balance Sheet Valuation13PRICEPrice for Ending Inventory Valuationdecimal112
TOPAerospace Defence Industry Solution
38ORF2CUSTCustomising Profils for Optimal Rotable Float ORF1,2,412PRICEPricedecimal112
39ORFECTORF: Essentiality-Code Table4PRICEPricedecimal112
TOPArchiving Engine
40TARCHFLIGHTArchiving Example: Flights5PRICEAirfaredecimal152
TOPAttendancesAbsences
41CATSHRCross-Application Time Sheet (CATS): Transfer to HR56PRICEPrice in Transaction Currencydecimal112
TOPBack Office
42TRET_PROTOCOLTransactions Generated for Endowments11PRICESecurity Price Without Currency Ref. with Unit Quotationdecimal156
TOPBasic Market Data
43/BA1/F4_SEC_RATEMarket Data: Securities Values7PRICEPricedecimal2310
TOPBusiness Server Pages
44BSPARTICLEGoods Table BSP Bookshop8PRICEBSP Bookshop Unit Pricenvarchar100
45TBOOKSHOPTable for the Book Shop5PRICEEntry Pricedecimal102
TOPClinical System
46N1FORMULARYMedication: Drug Formulary78PRICEMedication: Price of the Medication - OBSOLETEdecimal112
TOPCompensation Management
47T71C03Stock Components7PRICEStock pricedecimal132
48T71CDTo be deleted - no longer used!12PRICEStock pricedecimal132
TOPCross-Application Components
49SFLIGHT00Flight demo table5PRICEAirfaredecimal152
50SFLIGHT01Flight demo table5PRICEAirfaredecimal152
51SFLIGHT02Flight demo table5PRICEAirfaredecimal152
52SFLIGHT03Flight demo table5PRICEAirfaredecimal152
53SFLIGHT04Flight demo table5PRICEAirfaredecimal152
54SFLIGHT05Flight demo table5PRICEAirfaredecimal152
55SFLIGHT06Flight demo table5PRICEAirfaredecimal152
56SFLIGHT07Flight demo table5PRICEAirfaredecimal152
57SFLIGHT08Flight demo table5PRICEAirfaredecimal152
58SFLIGHT09Flight demo table5PRICEAirfaredecimal152
59SFLIGHT10Flight demo table5PRICEAirfaredecimal152
60SFLIGHT11Flight demo table5PRICEAirfaredecimal152
61SFLIGHT12Flight demo table5PRICEAirfaredecimal152
62SFLIGHT13Flight demo table5PRICEAirfaredecimal152
63SFLIGHT14Flight demo table5PRICEAirfaredecimal152
64SFLIGHT15Flight demo table5PRICEAirfaredecimal152
65SFLIGHT16Flight demo table5PRICEAirfaredecimal152
66SFLIGHT17Flight demo table5PRICEAirfaredecimal152
67SFLIGHT18Flight demo table5PRICEAirfaredecimal152
68SFLIGHT19Flight5PRICEAirfaredecimal152
69SFLIGHT20Flight demo table5PRICEAirfaredecimal152
70SFLIGHT21Flight demo table5PRICEAirfaredecimal152
71SFLIGHT22Flight demo table5PRICEAirfaredecimal152
72SFLIGHT23Flight demo table5PRICEAirfaredecimal152
73SFLIGHT24Flight demo table5PRICEAirfaredecimal152
74SFLIGHT25Flight demo table5PRICEAirfaredecimal152
75SFLIGHT26Flight demo table5PRICEAirfaredecimal152
76SFLIGHT27Flight demo table5PRICEAirfaredecimal152
77SFLIGHT28Flight demo table5PRICEAirfaredecimal152
78SFLIGHT29Flight demo table5PRICEAirfaredecimal152
79SFLIGHT30Flight demo table5PRICEAirfaredecimal152
80SFLIGHT99Flight5PRICEAirfaredecimal152
TOPDealer Portal
81/SAPDII/SPPARTICTable of Articles6PRICECharacter Field Length = 10nvarchar100
TOPDictionary Maintenance
82AUDDD_SFLIGHTTO (don't use/change it): Flight5PRICEFlugpreisdecimal152
TOPeCATT Extended Computer Aided Test Tool
83ECATTTEST_DB1Test Table for eCATT5PRICEAirfaredecimal152
TOPEnvironment, Health and Safety
84/TDAG/RCSA_EPRECEndpoint data records34PRICEPrice of Endpoint Data Record in Internal Formatdecimal112
85/TDAG/RCSA_LEOAOBSOLETE: Letter of Access28PRICEOBSOLETE: Price of the studydecimal112
86/TDAG/RCSA_LOALetters of access17PRICEPrice of Letter of Access in Internal Formatdecimal112
87/TDAG/RCSA_STUDYOBSOLETE: Studies (for REACH-Compliance)28PRICEOBSOLETE: Price of the studydecimal112
TOPESS Based on WD ABAP
88HRESS_D_CATS_FAVCATS Favorites: database table57PRICEPrice in Transaction Currencydecimal112
TOPFrance
89HRT1684Table Part Infotype 16848PRICEProposed amountdecimal152
TOPIndustry Solution Catch Weight Management
90/FMP/D_MP_HISTMaterial Price History10PRICEPrice for Ending Inventory Valuationdecimal112
91/FMP/D_MP_PRICMaterial Prices9PRICEPrice for Ending Inventory Valuationdecimal112
TOPIntegration Customer Relationship Management
92ECRM_PRICE_MAPMapping of Price Key to Quotation Price Categories2PRICEPrice Key for CRM Connectionnvarchar100
TOPIntercompany Data Exchange
93TINV_INV_LINE_BBill Line with Posting Information9PRICEPricedecimal178
94TINV_INV_LINE_IBill Line Item with Information (Not Relevant to Posting)9PRICEPricedecimal178
95TINV_LINEB_SHORTExtract of Bill Receipt (Evaluation System): Bill Lines9PRICEPricedecimal178
TOPInvoice Forecasting
96IFW_ITEMInvoice forecasting item23PRICECondition Value for Basic Net Pricedecimal132
TOPLocalization
97J_1BTXST1Tax calc.: Sub.Trib. rules11PRICESub.Trib. fixed price per unitdecimal152
98J_1BTXST2Tax calc.: Sub.Trib. rules (general)10PRICESub.Trib. fixed price per unitdecimal152
99J_1BTXST3Dynamic Calculation of Substituição Tributária14PRICESub.Trib. fixed price per unitdecimal152
TOPLogistics - General
100HBSCMPCommunity Plan Data within Home Building Solution10PRICEPlanned Unit Pricedecimal122
TOPMaterials Management
101J_1GVL_WHBLOG2Circular Valuation Log10PRICEFloat fieldfloat1516
TOPNetWeaver Demonstration
102SDEMO_PD_PRSAP NetWeaver Demo Model - Product Price3PRICEPricedecimal152
103SNWD_PDEPM: Product Data Table18PRICEEPM: Product Unit Pricedecimal152
TOPNetWeaver Enterprise Search
104ESH_TST_EH_RTIReal Time Indexing Test Data5PRICENatural Numberint100
TOPPegging, Grouping, and Distribution
105TBLPTransfer/Loan data log table35PRICEStandard pricedecimal112
106TBLP_PPayback data log table20PRICEStandard pricedecimal112
TOPPeriodical Sales and Distribution
107JKWWWTEMP_COMPLIS-M/SD: Temporary Table for Complaints in Internet14PRICEIS-M: Credit/Debit Memo Amount in Document Currencydecimal152
TOPPersonnel Administration
108T7SIF1Price list for food and transport5PRICEPricenvarchar40
TOPPersonnel Time Management
109HRAAITMHR Interface Table: Document Item for Activity Allocation11PRICECurrency amountdecimal162
TOPProcess Monitoring Infrastructure
110SSPIDEMOORDERPMI Demo: Orders6PRICEPMI Demonstration: Pricedecimal102
111SSPIDEMOSTOCKPMI Demo: Stock5PRICEPMI Demonstration: Pricedecimal102
TOPProduction and Revenue Accounting
112OIU_RV_OICQPQuotation Price Information Table6PRICEPrice for quotationdecimal112
TOPProvisions for Awards
113ACE_SOP_SCRT_SECHypothetical Security Price Performance for Simulation6PRICESecurity Pricedecimal156
TOPPublic Sector Contract Accounts Receivable and Payable
114DPSOBTYP_CSAttributes for Citizen Service Products4PRICEAmount in Transaction Currency with +/- Signdecimal132
TOPRetail Information System RIS
115TMCWRIS Enhancement17PRICEIndicator: price revaluations to be enhancednvarchar10
TOPRoom Reservations and Seating Arrangements
116VIORRSCOSTReservation - Costs13PRICEPrice of Reservationdecimal152
TOPSAP List Viewer
117ALV_T_T2Test Data for ALV7PRICEAirfaredecimal152
TOPSyntax, Compiler, Runtime
118DEMO_CR_RESERVTNRental Car Reservations7PRICECar Rental Pricedecimal102
119TPDA_SFLIGHTFlug5PRICEFlugpreisdecimal152
TOPTalent Needs Management
120HRP1689DB Table for Infotype 168922PRICEProposed amountdecimal152
TOPTariffs, Duties and Permits
121OIH_J1B_PPRBrazil Tax: Pondered average price table for final consume9PRICEPMPF pricedecimal154
122OIH_J_1BTXST1Tax calc.: Sub.Trib. rules13PRICESub.Trib. fixed price per unitdecimal152
TOPTime Sheet
123CATSCOCross-Application Time Sheet (CATS): Transfer to CO28PRICEPrice in Transaction Currencydecimal112
124CATSDBCATS: Database Table for Time Sheet50PRICEPrice in Transaction Currencydecimal112
125CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS25PRICEPrice in Transaction Currencydecimal112
126CATSPSCross-Application Time Sheet (CATS): Transfer to PS25PRICEPrice in Transaction Currencydecimal112
127CATS_TEMPCATS: Database Table for Templates52PRICEPrice in Transaction Currencydecimal112
TOPTraining and Event Management
128HRP1036Infotype 1036 DB table20PRICEProposed amountdecimal152
129HRPAD23Additional data PAD2314PRICEAttendance or cancellation feedecimal162
130T77KBCost Items5PRICEProposed amountdecimal152
131T77REFDOCReference Document Table: Training and Event Management18PRICEAmountdecimal162
TOPTransaction Management
132THXT_MD_SECmarket data securities price5PRICEPrice of Unit- or Percentage-Quoted Securitydecimal156
TOPTransaction Manager
133FTR_AVG_ASGNAssign one flow to many adjustments for average17PRICEQuotation Pricedecimal3114
134TERTVWERKOExecutable Rights (Header)12PRICEExercise pricedecimal132
TOPTransfer Prices and Decentralized Responsibility
135KFPETransfer Price Agreement: Allocation History12PRICETransfer Prices: Price per Unit of Measuredecimal152
136KFPPDocument Header: Transfer Prices for Tasks14PRICETransfer Prices: Price per Unit of Measuredecimal152
TOPTravel Planning
137FTPT_CARTravel Request Item - Car Rental Service27PRICECar Rental Price Per Day/Week/Etc.decimal102
138FTPT_HOTELTravel Request Item - Hotel Service39PRICETotal Price for Hotel Staydecimal102
139FTPT_ITEMTravel Service Request Item20PRICEPrice of request itemdecimal102
140FTPT_REQUESTTravel Plan Requests45PRICEPrice of Requestdecimal102
141FTPT_VARIANTTable of Travel Plan Variants8PRICEVariant pricedecimal102
142TA20NCNegotiated rental car rates (corporate nego rates)11PRICEPrice of negotiated ratedecimal102
143TA20NEGOFNegotiated Flight Fares (Corporate Nego Fares)20PRICEPrice of negotiated ratedecimal102
144TA20NFNegotiated Flight Fares (Corporate Nego Fares)14PRICEPrice of negotiated ratedecimal102
145TA20NHNegotiated hotel rates (corporate nego rates)14PRICEPrice of negotiated ratedecimal102
146TA20NHSNegotiated Hotel Rates (Nego Rates) with Catalog Hotel11PRICEPrice of negotiated ratedecimal102
147TA23OSField Control for Travel Res. Request Item: Other Services17PRICEField Control - Pricenvarchar10
148TA23PAF_CONNAssignment of Airline Programs Corporate Cust. - Route/Class13PRICEPrice of negotiated ratedecimal102
TOPTreasury
149OICQPQuotation Price Information Table6PRICEPrice for quotationdecimal112
TOPUSA
150T505ZBonds (NA)5PRICECost of bondsdecimal92
TOPWaste Management
151EWA_CCOC_ASS_EQCO Assignment and Vehicle11PRICEPrice: Total Amountdecimal234
152EWA_CCOC_ASS_IUPAssign CO Data for WD Item and SD Item10PRICEPrice: Total Amountdecimal234
153EWA_CCOC_ASS_IWPAssign CO Data WD Item and Waste/Waste Disposal Facility10PRICEPrice: Total Amountdecimal234
154EWA_CCOC_ASS_REAllocate CO and Container (Rent)12PRICEPrice: Total Amountdecimal234
155EWA_CCOC_ASS_RSAssign CO Data to Resources12PRICEPrice: Total Amountdecimal234
156EWA_CCOC_ASS_WPCO Assignment to Waste Disposal Facility10PRICEPrice: Total Amountdecimal234
157EWA_CCOC_ASS_WPCAllocation of CO Data for Weighing Transaction (Waste)10PRICEPrice: Total Amountdecimal234
158EWA_ORDER_HD_COHeader Table for Waste Disposal Order (CO Data)10PRICEPrice: Total Amountdecimal234
159EWA_ORDER_OBJ_COItem Table in Waste Disposal Order (CO Data)11PRICEPrice: Total Amountdecimal234
160EWA_ORDER_WGH_COWeighing Data Table for Waste Disposal Order (CO Data)11PRICEPrice: Total Amountdecimal234
161EWA_WA_WPROC_COWeighing Transaction (CO Data)10PRICEPrice: Total Amountdecimal234
TOPWeb Dynpro ABAP
162WDBOOK_ARTICLEWD Demo Bookstore: Item List8PRICEWD Bookstore Unit Pricedecimal152
TOPWorkbench Utilities
163ACTFLIABAP/4 book: Flights5PRICEAirfaredecimal152
164FLIGHTMFlight master data8PRICEFlight pricedecimal102