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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

156 tablesERP 6.0 

Personnel Management :: Personnel Administration :: China
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0528591HR Master Record: Infotype 0528 (Family information)China
2ERP EHP76.0PA0529301HR Master Record: Infotype 0529 (Add. Personal Data CN)China
3ERP EHP76.0PA0530301HR Master Record: Infotype 0530 (Public Housing Fund)China
4ERP EHP76.0PA0531421HR Master Record: Infotype 0531 (Income Tax)China
5ERP EHP76.0PA0532311HR Master Record: Infotype 0532 (Insurance)China
6ERP EHP76.0PA0533291HR Master Record: Infotype 0533 (Personal File Managment)China
7ERP EHP76.0PA0534301HR Master Record: Infotype 0534 (Party Infomation)China
8ERP EHP76.0PA0535261HR Master Record: Infotype 0535 (Project & Achievement)China
9ERP EHP76.0PA0536441HR Master Record: Infotype 0536 (Administration)China
10ERP EHP76.0PA0537371HR Master Record: Infotype 0537 (Going Abroad Information)China
11ERP EHP76.0PA3211291HR Master Record: Infotype 3211 (Contract Elements CN)China
12ERP EHP76.0PA3212431HR Master Record: Infotype 3212 (Special Payment CN)China
13ERP EHP76.0PA32241351Contract Termination (CN)China
14ERP EHP76.0PA3532311HR Master Record: Infotype 3532China
15ERP EHP76.0PA3533471HR Master Record: Infotype 3533China
16ERP EHP76.0T7CN0941Periods of Notice (CN)China
17ERP EHP76.0T7CN0P181Personal Areas/Subareas (CHINA)China
18ERP EHP76.0T7CN1381Salary information (CN)China
19ERP EHP76.0T7CN1461Contribution change reasonChina
20ERP EHP76.0T7CN1571Social insurance authority institution informationChina
21ERP EHP76.0T7CN15T51Social insurance authority institution nameChina
22ERP EHP76.0T7CN1661Public Housing Fund authority institution informationChina
23ERP EHP76.0T7CN16T41Public Housing Fund authority institution nameChina
24ERP EHP76.0T7CN1781Minimum SalaryChina
25ERP EHP76.0T7CN17T51Minimum Salary Area DescriptionChina
26ERP EHP76.0T7CN1851Extended insurance authority institution informationChina
27ERP EHP76.0T7CN18T51Supplementary Insurance Authority Institution NameChina
28ERP EHP76.0T7CN1A71Contribution change reason textChina
29ERP EHP76.0T7CN20581Contribution baseChina
30ERP EHP76.0T7CN2121Contribution GroupChina
31ERP EHP76.0T7CN21T41Contribution Group TextChina
32ERP EHP76.0T7CN2241Pass Rule ER-to-EEChina
33ERP EHP76.0T7CN2331Contribution LevelChina
34ERP EHP76.0T7CN23T51Contribution Level TextChina
35ERP EHP76.0T7CN2451Contribution TypeChina
36ERP EHP76.0T7CN2551Contribution AreaChina
37ERP EHP76.0T7CN2651Contribution switch periodChina
38ERP EHP76.0T7CN28111Service Fee to Holding LocationChina
39ERP EHP76.0T7CN28T51Service Fee to Holding LocationChina
40ERP EHP76.0T7CN2971Social insuranceChina
41ERP EHP76.0T7CN2A61Contribution Area TextChina
42ERP EHP76.0T7CN2P61Assign Sup. Insurance Authority Institution to PA/PSAChina
43ERP EHP76.0T7CN2W61Assign Wage Types for Supplementary InsuranceChina
44ERP EHP76.0T7CN2Y71Contribution Type TextChina
45ERP EHP76.0T7CN30101Tax Withholding Fast FormulaChina
46ERP EHP76.0T7CN3131Special rule categoryChina
47ERP EHP76.0T7CN3231Tax AreaChina
48ERP EHP76.0T7CN3371Exempted Amount TableChina
49ERP EHP76.0T7CN3471Special Calculation RuleChina
50ERP EHP76.0T7CN3531Special rule rely on protocolChina
51ERP EHP76.0T7CN36101Tax grouping for companyChina
52ERP EHP76.0T7CN36T51Text Table for Tax grouping for companyChina
53ERP EHP76.0T7CN3761country codes for china taxChina
54ERP EHP76.0T7CN3851Occupation categoryChina
55ERP EHP76.0T7CN38T61Occupation category TextChina
56ERP EHP76.0T7CN3961Income categoryChina
57ERP EHP76.0T7CN39T71Income category TextChina
58ERP EHP76.0T7CN3A41Special rule category textChina
59ERP EHP76.0T7CN3B41Tax Area TextChina
60ERP EHP76.0T7CN3E51Special rule rely on protocolChina
61ERP EHP76.0T7CN3F221Reported Tax DataChina
62ERP EHP76.0T7CN4021Personal File CategoryChina
63ERP EHP76.0T7CN4121From/To CategoryChina
64ERP EHP76.0T7CN4421Social Class StatusChina
65ERP EHP76.0T7CN4521Personal IdentityChina
66ERP EHP76.0T7CN4D41Personnel Class Status TextChina
67ERP EHP76.0T7CN4E41Personal Identity TextChina
68ERP EHP76.0T7CN4T41Personal File Category TextChina
69ERP EHP76.0T7CN4U41Text for From/To CategoryChina
70ERP EHP76.0T7CN5321OccupationChina
71ERP EHP76.0T7CN5421Role in projectChina
72ERP EHP76.0T7CN5521Achievement(Result) Level CodeChina
73ERP EHP76.0T7CN5621Achievement(Reward) CodeChina
74ERP EHP76.0T7CN5721Position Category CodeChina
75ERP EHP76.0T7CN5821Position Name CodeChina
76ERP EHP76.0T7CN5921Political statusChina
77ERP EHP76.0T7CN5P41Position Category Code TextChina
78ERP EHP76.0T7CN5Q41Position nameChina
79ERP EHP76.0T7CN5R41Political status textChina
80ERP EHP76.0T7CN5S41Occupation TextChina
81ERP EHP76.0T7CN5V41Text for role in projectChina
82ERP EHP76.0T7CN5W41Achievement Level Code TextChina
83ERP EHP76.0T7CN5Y41Achievement(Reward) code textChina
84ERP EHP76.0T7CN6021Appointment Reason CodeChina
85ERP EHP76.0T7CN6121Position Level CodeChina
86ERP EHP76.0T7CN6221Position Type CodeChina
87ERP EHP76.0T7CN6321Going Abroad Purpose CategoryChina
88ERP EHP76.0T7CN6421Expense Provider CategoryChina
89ERP EHP76.0T7CN6521Occupation status for family memberChina
90ERP EHP76.0T7CN6721Political Affiliation Exception TypeChina
91ERP EHP76.0T7CN6821Project TypeChina
92ERP EHP76.0T7CN69171Project or Achievement Related InfomationChina
93ERP EHP76.0T7CN6Q41Project Type TextChina
94ERP EHP76.0T7CN6R41Political Affiliation Exception Type TextChina
95ERP EHP76.0T7CN6S41Position LevelChina
96ERP EHP76.0T7CN6T41Appointment Reason TextChina
97ERP EHP76.0T7CN6U41Position Type TextChina
98ERP EHP76.0T7CN6V51Going Abroad Purpose TextChina
99ERP EHP76.0T7CN6W51Expense Provider Category TextChina
100ERP EHP76.0T7CN6X41Occoupation status textChina
101ERP EHP76.0T7CN7141Province Key for CNChina
102ERP EHP76.0T7CN8071Service year Valuation RuleChina
103ERP EHP76.0T7CN8161Sick leave deduction rateChina
104ERP EHP76.0T7CN8261Define Relevant Absence TypesChina
105ERP EHP76.0T7CN8351Long Sick Leave Salary Payment RateChina
106ERP EHP76.0T7CN8461Medical Treatment Entitlment and Accumulation periodChina
107ERP EHP76.0T7CN9071Year end tax declaration reported information - CTXEChina
108ERP EHP76.0T7CNC0191Contribution CalculationChina
109ERP EHP76.0T7CNC1121Define Corporate Pension PlanChina
110ERP EHP76.0T7CNC1T41Text Table for Coporate Pension PlanChina
111ERP EHP76.0T7CNC261Define Status of Corporate Pension PlanChina
112ERP EHP76.0T7CNC2T41Text Table of Corporate Pension Plan StatusChina
113ERP EHP76.0T7CNC321Reason for Changing Plan InformationChina
114ERP EHP76.0T7CNC3T41Text Table of Reason for Changing Plan InformationChina
115ERP EHP76.0T7CNC431Define Employee GroupChina
116ERP EHP76.0T7CNC4T51Text Table of Employee Group DefinitionChina
117ERP EHP76.0T7CNC541Assign Employee Group to Pension PlanChina
118ERP EHP76.0T7CNC651Define Participant StatusChina
119ERP EHP76.0T7CNC6T41Text Table of Participant Status DefinitionChina
120ERP EHP76.0T7CNC731Define Reason for Participant Status ChangeChina
121ERP EHP76.0T7CNC7T51Text Table of Reason for Participant Status ChangeChina
122ERP EHP76.0T7CNC881Define External InstitutionChina
123ERP EHP76.0T7CNC8T41Text Table of External Institution DefinitionChina
124ERP EHP76.0T7CNC941Assign External Institution to Pension PlanChina
125ERP EHP76.0T7CNCA81Define Contribution PeriodChina
126ERP EHP76.0T7CNCB31Define Reason for Suspending ContributionChina
127ERP EHP76.0T7CNCBT51Text Table of Reason for Suspending ContributionChina
128ERP EHP76.0T7CNCC21Define Reason for Benefit EligibilityChina
129ERP EHP76.0T7CNCCT41Text Table of Reason for Benefit EligibilityChina
130ERP EHP76.0T7CNDC21Define Disability ClassificationChina
131ERP EHP76.0T7CNDCT41Text Table for Disability ClassificationChina
132ERP EHP76.0T7CNDE21Employee Grouping of DisabilityChina
133ERP EHP76.0T7CNDET41Text Table for Employee Grouping of DisabilityChina
134ERP EHP76.0T7CNDG31Define Disability GradeChina
135ERP EHP76.0T7CNDGT51Text Table for Disability GradeChina
136ERP EHP76.0T7CNDX201Tax Policy for Disability Employee GroupsChina
137ERP EHP76.0T7CNLC_ACTION41Action TakenChina
138ERP EHP76.0T7CNLC_ACTIONT61Action Taken DescriptionChina
139ERP EHP76.0T7CNLC_ASSOUT41Assignment of OutcomeChina
140ERP EHP76.0T7CNLC_DECTYP21Decision TypeChina
141ERP EHP76.0T7CNLC_DECTYPT41Decision Type DescriptionChina
142ERP EHP76.0T7CNLC_ISSUE41IssueChina
143ERP EHP76.0T7CNLC_ISSUET61Issue DescriptionChina
144ERP EHP76.0T7CNLC_ISUDTL51Issue DetailsChina
145ERP EHP76.0T7CNLC_ISUDTLT71Issue Details DescriptionChina
146ERP EHP76.0T7CNLC_OUTCM21OutcomeChina
147ERP EHP76.0T7CNLC_OUTCMT41Outcome DescriptionChina
148ERP EHP76.0T7CNLC_STRS61CN: Wage Type Assignment for Simulate Termination PY ResultChina
149ERP EHP76.0T7CNLC_TMNGRP21Termination GroupChina
150ERP EHP76.0T7CNLC_TMNGRPT41Termination Group DescriptionChina
151ERP EHP76.0T7CNLC_TMNRSN31Termination ReasonChina
152ERP EHP76.0T7CNLC_TMNRSNT51Termination Reason DescriptionChina
153ERP EHP76.0T7CNLG21wage Type tableChina
154ERP EHP76.0T7CNSI_ADDWT51Define Supplementary Wage Type for SI Report DisplayChina
155ERP EHP76.0T7CNST101CN: Last Result of Simulate Termination Payment for Labor WBChina
156ERP EHP76.0T7CNTX81Tax Rate or Amount Paid by EmployerChina