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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

72 columns | Print definition?ERP 6.0  | LGTXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_MA_PRTProduct Texts7LGTXTLong Text for Productnvarchar1000
2PA3326HR Master Record: Infotype 332631LGTXTTax Commentnvarchar500
3T578AMedical Doctors4LGTXTPhysiciannvarchar250
4T5FPBS1ATTexte position administrative5LGTXTTexte de longueur 40nvarchar400
5T5WRTWRetro wagetypes configuration5LGTXTLong text of retro codenvarchar500
6T77REWCN_EXT_WTTExtend Wage Type Text for Free Search5LGTXTWage Type Long Textnvarchar250
7T77REWCN_WTG_TAssign Wage Types to Wage Type Groups Text Table6LGTXTWage Type Long Textnvarchar250
TOPBasic Data
8NABGIS-H: Employer (Business Partner)4LGTXTIndicator that Long Text Existsnvarchar10
9NBAUIS-H: Building Units26LGTXTIndicator that Long Text Existsnvarchar10
10NDEBIS-H: Business Partner/IS-H Customer Supplement6LGTXTIndicator that Long Text Existsnvarchar10
11NGPAIS-H: Business Partners30LGTXTIndicator that Long Text Existsnvarchar10
12NKRHIS-H: Hospitals (Business Partners)4LGTXTIndicator that Long Text Existsnvarchar10
13NKTRIS-H: Business Partners/Insurance Providers11LGTXTIndicator that Long Text Existsnvarchar10
14NORGIS-H: Organizational Units18LGTXTIndicator that Long Text Existsnvarchar10
15NPERIS-H: Persons15LGTXTIndicator that Long Text Existsnvarchar10
16TN02TIS-H: Text Table for Events (TN02E)5LGTXTIndicator that Long Text Existsnvarchar10
TOPBelgium
17PA3207Personal-Stammsatz Infotyp 320736LGTXTAdditional Payment Descriptionnvarchar500
TOPClinical System
18N1PRTLNRIS-H*MED: PATREG: Teilnehmerstammdatentabelle8LGTXTPATREG: Bagli sirketteki katilimci adinvarchar250
19N2CLIM_OBSVSVital Signs: Examination9LGTXTIndicator Whether Comment Existsnvarchar10
20N2CLIM_VALVSVital Signs: Measured Values13LGTXTIndicator Whether Comment Existsnvarchar10
TOPContract Accounts Receivable and Payable
21DFKK_VT_PRDTPRD: Texts for Product5LGTXTLong Text for Productnvarchar1000
TOPDenmark
22T5M8EVerify Changes to Wage Type Texts5LGTXTWage Type Long Textnvarchar250
23T5V3DTexts for T5V3C (DK/N)5LGTXTWage Type Long Textnvarchar250
TOPExternal Services
24ESLLLines of Service Package32LGTXTWage Type Long Textnvarchar250
TOPFrance
25T5F63Dynamic Mapping for Interface: Interfaced Wage Types6LGTXTWage Type Long Textnvarchar250
TOPPatient Accounting
26NCIRIS-H: Insurance Relationships of a Case44LGTXTLanguage Keynvarchar10
27NPIRIS-H: Insurance Relationship Proposal Pool43LGTXTLanguage Keynvarchar10
TOPPatient Management
28NAPPIS-H: Provisional Appointments for Visit Scheduling21LGTXTIndicator that Long Text Existsnvarchar10
29NBEWIS-H: Movements for Case20LGTXTIndicator that Long Text Existsnvarchar10
30NDIAIS-H: Diagnoses28LGTXTIndicator that Long Text Existsnvarchar10
31NFFZIS-H: Assignment of a case to another case10LGTXTIndicator that Long Text Existsnvarchar10
32NFKLIS-H: Case classification17LGTXTIndicator that Long Text Existsnvarchar10
33NFPZIS-H: Assignment of a case to a person11LGTXTIndicator that Long Text Existsnvarchar10
34NGEBIS-H: Birth Data of Newborns14LGTXTIndicator that Long Text Existsnvarchar10
35NKSKIS-H: Insurance verification/certificate - Header data28LGTXTIndicator that Long Text Existsnvarchar10
36NPATIS-H: Patient Master Data (General)75LGTXTIndicator that Long Text Existsnvarchar10
37NRSFIS-H: Patient Risk Factors6LGTXTIndicator that Long Text Existsnvarchar10
38NSHIFTIS-H: Results of Case Revision16LGTXTIndicator that Long Text Existsnvarchar10
39NVVFIS-H: Case-Related Insurance Relationships11LGTXTIndicator that Long Text Existsnvarchar10
40NVVPIS-H: Patient-related insurance relationship36LGTXTIndicator that Long Text Existsnvarchar10
41TNPGRIS-H: Patient groups for PPR (Germany)12LGTXTIndicator that Long Text Existsnvarchar10
TOPPayroll
42T5T4BText of lines of forms5LGTXTText of total groupnvarchar500
43T7RO4BForms - field properties5LGTXTText of total groupnvarchar600
44T7SK4BTexts of summary groups of payroll form5LGTXTText of total groupnvarchar500
45T7TRIC01Ücret Türü Tanim Tablosu3LGTXTÜcret Türü Uzun Metninvarchar250
46T7UA_512TWage Type Long Texts5LGTXTWage Type Long Textnvarchar2000
TOPPayroll General Parts
47T512STexts for Cumulation Wage Types in Forms6LGTXTWage Type Long Textnvarchar250
48T52A0_TTexts for Objects in T52A05LGTXTLong Texts for Table T52A0nvarchar700
TOPPersonnel Administration
49T512TWage Type Texts5LGTXTWage Type Long Textnvarchar250
50T703TIncentive Wages: Premium Formula Texts4LGTXTPremium formula textnvarchar300
51T7PLZLA_MODTRemuneration models for PLZLA - texts6LGTXTModel of PLZLA descriptionnvarchar250
52T7SI2TType of Inalidism SI Texts4LGTXTTextsnvarchar300
53T7SI3TArticle 212 Texts4LGTXTTextsnvarchar300
54T7SI4TType of Inalidism SI Texts4LGTXTTextsnvarchar300
55T7SI5TLimitation of work Texts4LGTXTTextsnvarchar300
TOPPersonnel Time Management
56T5550[OBSOLETE; NOW USE T705Q] Ext. Wage Types from Subsystem Txt6LGTXTWage Type Long Textnvarchar250
57T705QExternal Wage Types Long Texts from Subsystem6LGTXTWage Type Long Textnvarchar250
TOPProcess Controls -Automated Controls
58GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)23LGTXTWage Type Long Textnvarchar250
59GRPCRTA_HRDA0267PC HR control data for infotype 026723LGTXTWage Type Long Textnvarchar250
60GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 001523LGTXTWage Type Long Textnvarchar250
TOPReuse Services for Country Development
61PA0860HR Master Record: Infotype 086047LGTXTPrefix for Long Text IDsnvarchar700
62PA0861HR Master Record: Infotype 086140LGTXTPrefix for Long Text IDsnvarchar700
TOPRussia
63PA0298HR Master Record: Infotype 029836LGTXTPrefix for Long Text IDsnvarchar700
TOPSAP Ambulatory Care Management
64NREDOMAIS-H: Table Renewable Documents - Header Data20LGTXTLanguage Keynvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
65NAPXIS-H: Appendix Main Data3LGTXTLanguage Keynvarchar10
66NDAEIS-H: Requesting/borrowing medical records18LGTXTIS-H: Indicator that Borrowing Long Text Existsnvarchar10
TOPTime Tickets
67T703MIncentive Wages: Texts for Time Ticket Types4LGTXTLong text for time ticket typenvarchar300
68T703RIncentive Wages: Text for Premium Formula/Premium Result5LGTXTPremium formula textnvarchar300
TOPVenezuela
69T7VESTDescription of Risks3LGTXTDescription of Hazard Codesnvarchar400
TOPVital Signs
70N1VPSTMaster Data Vital Signs (Language-Dependent Texts)7LGTXTIndicator that Long Text Existsnvarchar10
TOPWithout Description
71RSTT_REP_TTable of Existing BI Reports for RSTT Reporting4LGTXTTrace Tool: General Text Fieldnvarchar1280
72RSTT_TREQ_TTexts for Test Requests3LGTXTDescriptionnvarchar600