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

42 columns | Print definition?ERP 6.0  | KENNZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T056Interest settlement3KENNZInterest Calculation Typenvarchar10
2T535QHR Test Cases: no longer supported2KENNZIndicatornvarchar30
3T582BInfotypes That Are Created Automatically4KENNZReserved Field/Unused Fieldnvarchar10
TOPAustria
4T5A7GPayslip AT Assignment Evaluation View Period Time4KENNZReserved field/unused field of length 1nvarchar10
TOPConstruction Equipment Management
5J_3GPMCO2Cost Structure: Job Key Figures (PMIS)2KENNZKey Figure: Cost of the Maintenance Order (PMIS)nvarchar100
6J_3GTPMKTTexts for Cost Key Figures of the Maintenance Order3KENNZKey Figure: Cost of the Maintenance Order (PMIS)nvarchar100
TOPContract Accounts Receivable and Payable
7DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment21KENNZDbtfl/IVA (manual/automatic)nvarchar10
8DFKKZWDoubtful/Individual Val. Adjust. for Receivables - Trigger12KENNZDbtfl/IVA (manual/automatic)nvarchar10
9DFKKZWFHDoubtful/Individually Adjusted Receivables: History14KENNZDbtfl/IVA (manual/automatic)nvarchar10
10DFKKZWFTDoubtful/Individually Adjusted Receivables: Trigger Table13KENNZDbtfl/IVA (manual/automatic)nvarchar10
11DFKKZWHDoubtful/Ind.Val.Adj.Receivables - History12KENNZDbtfl/IVA (manual/automatic)nvarchar10
TOPControlling
12TKA03Statistical key figures8KENNZKey Figure from LISnvarchar300
TOPPayroll
13PA0776Personel ana verileri: Bilgi tipi 077636KENNZKidem veya Ihbarnvarchar10
TOPPayroll General Parts
14T512GSupplementary Group Texts7KENNZIndicator for text positionnvarchar10
TOPPersonnel Administration
15T529FFast Data Entry for Actions6KENNZIndicator: Dialog module or featurenvarchar10
16T588ZDynamic Actions7KENNZIndicator for stepnvarchar10
17T5D2WStADÜV kazalniki2KENNZStADÜV: Kennzahlnvarchar20
TOPProfitability Analysis
18TKEPEAdmin.table for transferring plan data from CO-PA to SOP6KENNZCharacteristic/Value Field Indicatornvarchar10
TOPRegulatory reporting for insurance companies
19TZB10VMeldewesen Österreich: Beteiligungsformen5KENNZKennzeichen für Meldewesennvarchar10
20TZB2VMelderelevante Produktarten Österreich4KENNZKennzeichen für Meldewesennvarchar10
TOPRemaining Beverage - Obsolete Objects
21/BEV1/RPFZVehicle Master (Route Planning)17KENNZRegistration Numbernvarchar150
22/DSD/ME_CPT_VEHIMaintenance Table for Vehicles in DSD Cockpit17KENNZRegistration Numbernvarchar150
TOPReporting
23PMCO2Cost structure: Job key figures (PMIS)2KENNZKey figure: cost of the maintenance order (PMIS)nvarchar100
24TPMKCost key figures of the maintenance order2KENNZKey figure: cost of the maintenance order (PMIS)nvarchar100
25TPMKTTexts for cost key figures of the maintenance order3KENNZKey figure: cost of the maintenance order (PMIS)nvarchar100
TOPSales Plan
26T445BUser Parameters for Planning Type25KENNZSingle-Character Indicatornvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
27NAH03IS-H AT: Honorar-Aufteilung Österreich5KENNZIS-H AT: Kennzeichennvarchar10
28NAH05IS-H AT: Aufteilungstabelle für Honorarabrechnung6KENNZIS-H AT: Kennzeichennvarchar10
29NAH06IS-H AT: Honorarabrechnung: Tab. für Aufteilung (Abteilung)6KENNZIS-H AT: Kennzeichennvarchar10
30TNWCHHONHEADFee Header Table for Released Breakdown Data5KENNZCode/Pool Indicatornvarchar10
31TNWCHHONHEADCDFee Header Table for Released Breakdown Codes5KENNZCode/Pool Indicatornvarchar10
TOPSCM Basis
32/SAPAPO/DP440GMaster Forecast Profile (APO0300)9KENNZKey Figurenvarchar200
33/SAPAPO/DP440PUnivariate Forecast Profile (APO0326)6KENNZKey Figurenvarchar200
34/SAPAPO/DP_ALERTProfile for Filtering Output to Alert Monitor4KENNZKey Figurenvarchar200
TOPTax
35P01T_A_BTGETNotif.: Tax Amounts in Employment Tax Notification7KENNZETNotif.: Key Figurenvarchar20
36P01T_A_EXTETNotif.: External Data6KENNZETNotif.: Key Figurenvarchar20
37T5D2JStADUEV Form Control4KENNZStADUEV: Key Figurenvarchar20
38T5D2OETNotif.: Asssignment - Cumulation Wage Type to Key Figure5KENNZETNotif.: Key Figurenvarchar20
39T5D2PETNotif.: Key Figures2KENNZETNotif.: Key Figurenvarchar20
40T5D2QETNotif.: Totals Formation for Key Figures2KENNZETNotif.: Key Figurenvarchar20
41T5D2ZStADUEV Key Figures2KENNZStADUEV: Key Figurenvarchar20
TOPTools
42T532BHR: Connection to Third-Party Payroll: Choice of Wage Types22KENNZComponent 709: Free indicatornvarchar30