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

129 columns | Print definition?ERP 6.0  | KTART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_ABWKONTIHCM Declustering B2 - Absence Quotas (Table ABWKONTI)16KTARTAbsence Quota Typenvarchar20
2P2B2_ANWKONTIHCM Declustering B2 - Attendance Quotas (Table ANWKONTI)15KTARTAttendance Quota Typenvarchar20
3P2NZ_ACCRCALCLeave Accrual on Term Calculation5KTARTAbsence Quota Typenvarchar20
4P2NZ_LVAWEPayroll Result: Leave Entitlement LVAWE - NZ5KTARTAbsence Quota Typenvarchar20
5P2NZ_LVPAYPayroll Result: Leave Payment LVPAY - NZ5KTARTAbsence Quota Typenvarchar20
6P2RQ_LSLPRPayroll Results: LSLPR Table28KTARTAbsence Quota Typenvarchar20
7P2RQ_LVEPRPayroll Results: LVEPR Table21KTARTAbsence Quota Typenvarchar20
8P2VE_ABS_EVALHRMS-VE: Wage Management for Valuation of Vacations6KTARTAbsence Quota Typenvarchar20
9PA0613HR Master Record: Infotype 061328KTARTAbsence Quota Typenvarchar20
10PA3253HR Master Record: Infotype 325348KTARTQuota Type for Ticket Entitlementnvarchar20
11PA3254HR Master Record: Infotype 325443KTARTQuota Type for Ticket Entitlementnvarchar20
12PA3304HR Master Record: Infotype 330472KTARTQuota Type for Leave Passage Entitlementnvarchar20
13PA3352HR Master Record: Infotype 335235KTARTQuota Type for Leave Passage Entitlementnvarchar20
14PB3304Applicant data infotype 3304 (model)72KTARTQuota Type for Leave Passage Entitlementnvarchar20
15T5AA0Absence Quota Type for Recognition of Leave4KTARTAbsence Quota Typenvarchar20
16T5R2FQuota Type Gerenation Rule Singapore4KTARTAbsence Quota Typenvarchar20
17T5R2GQuota Generation Rule Lists Singapore4KTARTAbsence Quota Typenvarchar20
18T5UPBSPOOLASick Leave Pool Attributes9KTARTAbsence Quota Typenvarchar20
19T5UPBSPOOL_TRANSSick Leave Donation - transaction history record6KTARTAbsence Quota Typenvarchar20
20T77PADRU_VACRSReasons of reserves for vacations4KTARTAbsence Quota Typenvarchar20
21T7AE20Leave Passage : Evaluation Wage Types per Quota Type4KTARTQuota Type for Ticket Entitlementnvarchar20
22T7INLEMET_WT_MAPMap quota compensation method with WT for 267 infotype7KTARTAbsence Quota Typenvarchar20
23T7KW20Leave Passage : Evaluation Wage Types per Quota Type (KW)4KTARTQuota Type for Leave Passage Entitlementnvarchar20
24T7QA15Addtional Leave Quota Adjustment(QA)5KTARTAbsence Quota Typenvarchar20
25T7QA20Leave Passage : Evaluation Wage Types per Quota Type (QA)4KTARTQuota Type for Leave Passage Entitlementnvarchar20
26T7SA29Leave Passage : Evaluation Wage Types per Quota Type4KTARTQuota Type for Ticket Entitlementnvarchar20
27T7SAPBS30Absence Quota Generation Refinement5KTARTAbsence Quota Typenvarchar20
28TNWCH_EDI_RETCDEDI Antwortcodes4KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
29TNWCH_EDI_RETCDTEDI Antwortcodes - Texte5KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
TOPArgentina
30T7AR69Vacation provision: Calculation wage types4KTARTAbsence Quota Typenvarchar20
TOPAustralia
31T5QIGLeave Quota Grouping4KTARTAbsence Quota Typenvarchar20
32T5QLLAustralian Leave Loading - international leave6KTARTAbsence Quota Typenvarchar20
33T5QPRAust. Leave Provision for international leave6KTARTAbsence Quota Typenvarchar20
34T5QRTTerm. Rules for Long Serv-Leave & Leave Loading Australia5KTARTAbsence Quota Typenvarchar20
35T5QTRTerm. Rules for Long Serv. Leave & Leave Loading Australia8KTARTAbsence Quota Typenvarchar20
TOPBasic Data
36NKIPIS-H: Pre-Approved Insurance Verification Information - Item4KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
37NKTRIS-H: Business Partners/Insurance Providers4KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
38NPTWIS-H: Rules for Charge Factor Value Determ.8KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
39TN18IS-H: Insurance Provider Types2KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
40TN18UIS-H: Texts for Insurance Provider Types3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
41TNF31IS-H: Work Organizers with Ins. Prov. Conditions6KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
42TNF32IS-H: Work Organizers with Billing Type and Ins. Prov. Cond.6KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
TOPBelgium
43T5B31Translation Table BE Educational Leave Quotums4KTARTAbsence Quota Typenvarchar20
44T5B32History Table Declared Courses Educational Leave2KTARTAbsence Quota Typenvarchar20
TOPBrazil
45T7BR86Wage types for saving entitlement to leave reserve4KTARTAbsence Quota Typenvarchar20
46T7BRQTAbsence quota type4KTARTAbsence Quota Typenvarchar20
TOPConstruction Industry
47T5DB_UREGELNLeave Regulations for IT 20065KTARTAbsence Quota Typenvarchar20
TOPFinland
48T7FIWTEMWTE Model (Finland)12KTARTAttendance or absence quota typenvarchar20
TOPIntegration with Time Management
49T5DTM_URLAbsence Quota Types Specific to Germany4KTARTAbsence Quota Typenvarchar20
TOPJapan
50T7JPLA_VADPDDefine Leave Quota Validity for Time Off from Overtime3KTARTAbsence Quota Typenvarchar20
TOPNew Zealand
51HNZLVPAYTable for modified LVPAY cluster table records7KTARTAbsence Quota Typenvarchar20
52PA0312Leave History Adjustments NZ38KTARTAbsence Quota Typenvarchar20
53PT2006HR Time Record: Infotype 2006 (Absence Quotas)27KTARTAbsence Quota Typenvarchar20
54T7NZLCLeave Payment Calculation Table - NZ5KTARTAbsence Quota Typenvarchar20
55T7NZLLLeave Payment Calculation Table - NZ6KTARTAbsence Quota Typenvarchar20
56T7NZLTTermination Wage Types for Leave NZ5KTARTAbsence Quota Typenvarchar20
57T7NZLVLeave accrual payout rules on termination5KTARTAbsence Quota Typenvarchar20
58T7NZPLA/A types with absence quotas affected by parental leave8KTARTAbsence quota impacted by parental leavenvarchar20
TOPNon Profit Organizations
59T7UNPAD_QT_KTARTNPO Quota Types Attributes2KTARTAbsence Quota Typenvarchar20
TOPNorway
60T5V3GLeave quota types4KTARTAbsence Quota Typenvarchar20
TOPPatient Accounting
61NTFIIS-H: Service Catalog Determination Rules8KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
62NVBRKIS-H: Billing document header data62KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
63TN18BIS-H: Propose Contract Scheme by Ins. Prov. Type3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
64TN21AIS-H: Billing Type Determination5KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
65TN22KIS-H: Copayment Amount per Ins. Provider/Ins. Provider Type4KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
66TNHCOBasic Settings HCO12KTARTIS-H: Order type for cost object-based ordersnvarchar40
67TNVSLIS-H: Rules for Determining Multiplication Factors7KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
TOPPayroll
68T5HPBS61Köztisztviseloi pótszabadság megképzését vezérlo tábla7KTARTTávollétkeret-típusnvarchar20
69T5HPBS62Közalkalmazotti pótszabadság megképzését vezérlo tábla8KTARTTávollétkeret-típusnvarchar20
70T5HPBS63Generating leave quotas6KTARTLeave quota categorynvarchar20
71T5HPBS67Long texts for leave quota category5KTARTAbsence Quota Typenvarchar20
72T5HPBS70HR-H: Szabadságkeretek a 2006-os IT-on2KTARTTávollétkeret-típusnvarchar20
73T7BGQ3Vacation debt5KTARTAbsence Quota Typenvarchar20
TOPPersonnel Administration
74T7COQPAbsence quota attributes4KTARTAbsence Quota Typenvarchar20
TOPPersonnel Time Management
75PA2006HR Time Record: Infotype 2006 (Absence Quotas)27KTARTAbsence Quota Typenvarchar20
76PA2007HR Time Record: Infotype 2007 (Attendance Quotas)27KTARTAttendance Quota Typenvarchar20
77PA2013HR Time Record: Infotype 2013 (Quota Corrections)27KTARTAbsence Quota Typenvarchar20
78T554ABreakdown of Absences After Quota Deduction6KTARTAbsence Quota Typenvarchar20
79T554SAttendance and Absence Types18KTARTAttendance or absence quota typenvarchar20
80T556AAbsence Quota Types4KTARTAbsence Quota Typenvarchar20
81T556A_WEBESS Leave Request: Quota Types for Display5KTARTAbsence Quota Typenvarchar20
82T556BAbsence Quota Type Texts5KTARTAbsence Quota Typenvarchar20
83T556PAttendance Quotas4KTARTAttendance Quota Typenvarchar20
84T556P_WEBESS Leave Request: Quota Types to Be Displayed5KTARTAttendance Quota Typenvarchar20
85T556QAttendance Quota Type Texts5KTARTAttendance Quota Typenvarchar20
86T559JConvert Leave Types to Quota Types6KTARTAbsence Quota Typenvarchar20
87T7TIM_BSB_KTARTAAssignment of Business Subject to an Absence Quota4KTARTAbsence Quota Typenvarchar20
88T7TIM_BSB_KTARTPAssignment of Business Subject to an Attendance Quota4KTARTAttendance Quota Typenvarchar20
TOPPortugal
89T5PV2HR-PT: Classification of absence quota types4KTARTAbsence Quota Typenvarchar20
TOPPublic Sector
90T5QPBS2EParallel deduction sequence of quota types6KTARTQuotas to be deducted parallelynvarchar20
91T5QPBS2FLWOP/UNAL impact on individual leave type4KTARTAbsence Quota Typenvarchar20
92T5QPBS2LLeave Provision for Australia - Public sector3KTARTAbsence Quota Typenvarchar20
93T5QPBS2TTo determine the Seniority based on the Anniversary date9KTARTAttendance or absence quota typenvarchar20
94T5QPBS5AHR AU PS:Australian Leave Loading5KTARTAbsence Quota Typenvarchar20
95T5QPBS5BHR AU PS:Australian Leave Loading for varying percentage5KTARTAbsence Quota Typenvarchar20
TOPPublic sector Sweden
96T5SVA_CEVacation debt5KTARTAbsence Quota Typenvarchar20
TOPReuse Services for Country Development
97T799L42Asignment between absence types and legal categories6KTARTAbsence Quota Typenvarchar20
TOPRussia
98T7RU_556BAbsence Quota Type Texts5KTARTAbsence Quota Typenvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
99/ISHFR/TN21AIS-H FR: Determine Billing Type6KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
100/ISHFR/TNWFR_B2IS-H FR: Control Settings for B2 Dispatch5KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
101NAKR1IS-H AT: LKF - Grunddaten32KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
102NKLPIS-H: Individual outpatient srv / ins.providers (AT)3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
103NLDIS_001ISH NL: DIS - Versicherungsgrund3KTARTIS-H: Soort kostendrager (b.v. particulier, wettelijk)nvarchar30
104NNTFIS-H NL: Service Catalog Determination11KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
105NWATLHOIS-H AT: Leistungshöchstwerte5KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
106NWCH_NKTR_PROFAusschluss Pro-forma-Rechnungen an Patienten2KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
107TNA16IS-H: IP Types/Types of Coverage VAT Assessment Austria3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
108TNA21AIS-H: Determining the flat rate type (VERA)5KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
109TNAUMLEIIS-H AT: Umschlüsselung Leistung10KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
110TNNC2IS-H NL: Insurance provider types (internal)3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
111TNNC3IS-H NL: Kostenübernahme von leistungen11KTARTIS-H: Soort kostendrager (b.v. particulier, wettelijk)nvarchar30
112TNNP4IS-H NL: Classes for IP Types / Default Values3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
113TNWAT_DEK_KOSTIS-H AT: Dekaden (Kostenträgerdaten)3KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
114TNWAT_LEIKOM_HDRIS-H AT: Leistungskombinationen umschlüsseln - Header8KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
115TNWCH74IS-H CH: Vertragstypen Zuordnungstabelle7KTARTIS-H: tipo ente pag. (ad es. privato, pubblico)nvarchar30
116TNWCH81IS-H CH: Billing Type Determination6KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
117TNWCH83Ermittlung der Baserate11KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
118TNWCH91Items for Fee Relevance12KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
119TNWCHIVTOEIS-H CH: Zuordnung Fachl. OE zu Tages- und Fallpauschale4KTARTIS-H: tipo ente pag. (ad es. privato, pubblico)nvarchar30
120TNWCHKTRGRIS-H CH: Dynamische Kostenträgergruppen7KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
121TNWCHSDRG01Swiss-DRG - Leistungsregeln DRG-Leistung generieren5KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
122TNWCHTM00IS-H CH: TARMED - Regelwerk für Leistungsregeln5KTARTIS-H: tipo ente pag. (ad es. privato, pubblico)nvarchar30
123TNWCH_EDIKTRIS-H CH: Control Data for EDI Procedure for Ins. Provider3KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory)nvarchar30
124TNWCH_EDIKTR_EOSteuerung EDI-Verfahren für externe Aufträge3KTARTIS-H: Kostenträgerart (z.B. privat, gesetzlich)nvarchar30
TOPSouth Africa
125T5W4ALeave parameter table - Southern Africa6KTARTAttendance or absence quota typenvarchar20
TOPSweden
126T5SVAVacation and Compensation debt4KTARTAbsence Quota Typenvarchar20
TOPTime Data Recording and Administration
127TMW_TDTYPETime Data ID24KTARTAttendance Quota Typenvarchar20
TOPVenezuela
128T7VEA1Transfer of External Payroll Results: Vacations6KTARTAbsence Quota Typenvarchar20
129T7VEQPAbsence quota attributes4KTARTAbsence Quota Typenvarchar20