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

211 columns | Print definition?ERP 6.0  | ORT01

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt16ORT01Citynvarchar350
2/ATL/KPRCPTKPDetail of temporary receipt16ORT01Citynvarchar350
3/BIC/B0000285000PSA for 0PERSON_ATTR T90CLNT090 Person12ORT01nvarchar350
4/OPT/WT_3S_PYMNTSupplier Self Service Payment Information27ORT01Citynvarchar250
5/OTEI/OCR_TSTGStaging table for HDCC download data12ORT01Citynvarchar400
6/SAPSRM/SH_COMPCTable for ERP Search Help Company Codes5ORT01Citynvarchar250
7/SLOAP/KNA1General Data in Customer Master6ORT01Citynvarchar350
8BSECOne-Time Account Data Document Segment11ORT01Citynvarchar350
9CNV_20100_T001CNV backup copy for T0015ORT01Citynvarchar250
10CNV_20305_CEPCSAP LT: Backup table of CEPC20ORT01Citynvarchar350
11CNV_20800_KNVKCNV backup copy: Customer master contact person7ORT01Citynvarchar350
12DMC_IU_T000MWB: Backup Copy of Table T0003ORT01Citynvarchar250
13FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document11ORT01Citynvarchar350
14FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)11ORT01Citynvarchar350
15P2AR_ARDIMPTax deduction results21ORT01Citynvarchar250
16P2AR_AROIMPOther employers13ORT01Citynvarchar250
17P2HK_TAXADRHR-HK: Payroll structure for Tax Quarters - Tax year10ORT01Citynvarchar250
18P2RB_ADRAddress payroll Belgium6ORT01Citynvarchar400
19P2RD_ADRPayroll Results: Address6ORT01Citynvarchar400
20P2RF_SARPayroll Results: Garnishment26ORT01Citynvarchar250
21P2RK_ADRAddress6ORT01Citynvarchar400
22P2RN_NADRAddress Data6ORT01Citynvarchar400
23P2RU_ADRAddress7ORT01Citynvarchar400
24PA0294HR Naster Record Infotype 0294 - reserved !27ORT01Citynvarchar400
25T5CSWHR-CH: Work Center ELM 4.013ORT01Citynvarchar400
26T5FDSNOPSIDList of OPS (Social Protection Agencies)15ORT01Citynvarchar250
27T5W2MCMunicipality Codes3ORT01Citynvarchar400
28T7RU9AAddresses of organizations17ORT01Citynvarchar400
29T7RUAAKLADR: Cities6ORT01Citynvarchar400
30T7RUPA0006PA0006 copy27ORT01Citynvarchar400
31T7SAPBS55Secondment Organization7ORT01Citynvarchar250
32T7SAPBS57Deputation Organization7ORT01Citynvarchar250
33ZSK_T000t0004ORT01Ortnvarchar250
34HRP1718DB Table for Infotype 171819ORT01Location of Employer or Companynvarchar250
TOPAddress ManagementBusiness Address
35SADRAddress Management: Company Data10ORT01Citynvarchar350
TOPArgentina
36PA0390Income Tax: Deductions39ORT01Citynvarchar400
37PA0391Income Tax: Information on other employers32ORT01Citynvarchar400
38PA0392Social Security: General data47ORT01Citynvarchar400
TOPAssortment List
39WBBHAssortment list header20ORT01Citynvarchar250
TOPAustria
40T5A1TSocial insurance institutes8ORT01Citynvarchar250
41T5A2FTax Offices (A)6ORT01Citynvarchar250
TOPAutomatic Payments
42PAYRQPayment Requests36ORT01Citynvarchar350
TOPBank
43BNKABank master record9ORT01Citynvarchar350
44TSWIFSWIFT Codes6ORT01Citynvarchar350
TOPBank Customer Accounts
45BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA114ORT01Citynvarchar350
TOPBasic Functions
46T061ADevelopment Partner3ORT01Citynvarchar350
TOPBasis Components
47ZCUSTOMER_IDESCustomer Master (IDES Demo)6ORT01Citynvarchar350
48ZDS400_T001Buchungskreise4ORT01Ortnvarchar250
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
49TBE12Complementary Software Partner4ORT01Citynvarchar350
TOPBelgium
50T5BS3Employee information except reductions ( level 3 )21ORT01Citynvarchar400
TOPBenefits
51PA0219HR Master Record: Infotype 0219 (External Organizations)30ORT01Citynvarchar400
TOPBrazil
52PA0736Alimony order for Brazil37ORT01Citynvarchar400
TOPCanada
53T5KYSNo longer used10ORT01Citynvarchar250
54T5UTLTax Company5ORT01Citynvarchar250
TOPCapacity and Resource Planning
55/MRSS/SADRPXIS-Zusatzstruktur zu den SADR*-Strukturen7ORT01Citynvarchar350
TOPClient Copy
56CCC_CHECKClient dummy7ORT01Citynvarchar250
57T000Clients3ORT01Citynvarchar250
TOPCompany Pension Scheme Germany
58PA0746HR Master Record for Infotype 074637ORT01Citynvarchar350
59T5DC3Pension Organization for Company Pension Scheme9ORT01Citynvarchar250
TOPConstruction Industry
60PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records26ORT01Citynvarchar250
61T5DB4HR Construction Site File33ORT01Citynvarchar250
62T5DB5Construction Site File: Work Breakdown Structure Element24ORT01Citynvarchar250
63T5DB6Construction Site File: Order24ORT01Citynvarchar250
TOPContract Accounts Receivable and Payable
64DPAYPPayment program - data on paid item24ORT01Citynvarchar400
TOPControlling
65CSKSCost Center Master Data39ORT01Citynvarchar350
TOPCorrespondence Tool
66TFK070CORRBUKRSCorrespondence - Structure for Company Code Search Help3ORT01Citynvarchar250
TOPCross-Application Components
67BC490KKNA1General data in customer master6ORT01Citynvarchar350
68CACNS_SEARCHCUSTFavorites for Customer Search Consultant Portal7ORT01Citynvarchar350
69KKNA1General Data in Customer Master6ORT01Citynvarchar350
70SKNA1Customer Master table for BC417 Course6ORT01Citynvarchar350
71SKNVKCustomer Master Contact table for BC417 Course6ORT01Citynvarchar350
TOPCross-Application Objects in HR
72HRP5583DB Table for Infotype 558320ORT01Citynvarchar400
TOPCustomer Master
73KNA1General Data in Customer Master6ORT01Citynvarchar350
74KNVKCustomer Master Contact Partner6ORT01Citynvarchar350
TOPCustomizing Tools Techniques
75ZC009Information for city1ORT01Citynvarchar250
TOPDunning
76MHNKDunning data (account entries)40ORT01Citynvarchar350
77MHNKODunning data (acct entries) version before the next change40ORT01Citynvarchar350
TOPFinancial Accounting
78LFA1Vendor Master (General Section)8ORT01Citynvarchar350
79T001Company Codes4ORT01Citynvarchar250
80VBSECDocument Parking One-Time Data Document Segment11ORT01Citynvarchar350
TOPFrance
81PA0272Infotype 0272 (Garnishment)45ORT01Citynvarchar250
82T5F1ESI Organizations - addresses6ORT01Citynvarchar250
83T5F4EDDTEFP6ORT01Citynvarchar250
84T5F4E1DDTEPP address7ORT01Citynvarchar250
TOPFSCM In-House Cash
85IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order13ORT01Citynvarchar350
TOPFunds Management-Specific Postings
86PAYRCAdditional Header Data for Recovery Order19ORT01Citynvarchar350
87PSOSECRecurring Request Document Segment, One-Time Data13ORT01Citynvarchar350
TOPGermany
88P01T_AGSAssignment of Postal Code to Municipality Key4ORT01Citynvarchar250
89T5D1HSupplementary Insurance11ORT01Citynvarchar250
90T5D1KBranch Offices13ORT01Citynvarchar250
91T5D2ATax Offices (D)5ORT01Citynvarchar250
92T5D2KFamily Funds (D)5ORT01Citynvarchar250
TOPGL Account Posting
93TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items12ORT01Citynvarchar350
TOPHong Kong
94PA0344HR Master Record: Infotype 0344 (Familiy members HK)27ORT01Citynvarchar250
95PA0351HR Master Record: Infotype 0351 (Country Information)28ORT01Citynvarchar250
96T7HK2HProvider Attributes5ORT01Citynvarchar250
TOPIndonesia
97PA0318HR Master Record: Infotype Family data for Indonesia (0318)35ORT01Citynvarchar250
98T7ID1AJamsostek office address (Indonesia)4ORT01Citynvarchar250
TOPInformation System
99DKKOSBalance Audit Trail12ORT01Citynvarchar250
100DKOKSOpen Item Account Balance Audit Trail Master Record13ORT01Citynvarchar250
101QSTREFI/HR Withholding Tax Report for Spain15ORT01Citynvarchar350
TOPInterfaces
102VRTCORouting Info per Carrier/Country/Location4ORT01Citynvarchar250
TOPInventory Management
103MWZDM07M1ZDM07M157ORT01Citynvarchar250
TOPInvoice Verification
104RBKPDocument Header: Invoice Receipt86ORT01Citynvarchar350
TOPJapan
105T5JADHR company office address JP7ORT01Citynvarchar250
106T5JL1HR Address Infomation 1 of Personnel Subarea for LI JP7ORT01Line of Address in Kanjinvarchar300
107T5JL2HR Address Infomation 2 of Personnel Subarea for LI JP7ORT01Line of Address in Kanjinvarchar300
108T5JSIHR Branch Office Information for Social Insurance JP7ORT01Line of Address in Kanjinvarchar300
TOPLoans Management
109VDAUSZDrawings on Disbursement23ORT01Citynvarchar350
110VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity37ORT01Citynvarchar350
111VZFZE_VDAUSZCentral Entry Table for Release Procedure25ORT01Citynvarchar350
112VZFZE_VDNBZECentral Entry Table for Release Procedure57ORT01Citynvarchar350
TOPLocalization
113J_1BNFCPDNota Fiscal one-time accounts9ORT01Citynvarchar350
114J_1BNFDOCNota Fiscal Header73ORT01Citynvarchar350
115J_1BNFNADNota Fiscal partners13ORT01Citynvarchar350
TOPLogistics Basic Data
116DMF_D_T001WTransferred Sites12ORT01Citynvarchar250
TOPMalaysia
117PA0213Additional family information - Malaysia39ORT01Citynvarchar250
TOPMaster Data
118JGTSADRIS-M: Extended Address Management24ORT01IS-M: Citynvarchar350
119JSTALIASIS-M: Alias Table for Streets10ORT01IS-M: Citynvarchar350
TOPMexico
120PA0426Garnishment36ORT01Citynvarchar400
121T7MX01Additional Company Informaton9ORT01Citynvarchar250
122T7MX24IMSS Employer Regis. nos.8ORT01Citynvarchar250
TOPNetherlands
123T5N9AAuthority Addresses (NL)14ORT01Citynvarchar250
TOPNon Profit Organizations
124PA0965HR Master Record: Infotype 096539ORT01EG: School Citynvarchar400
125T7UNPAD_EGSNNPO: Education Grant Schools / Colleges9ORT01EG: School Citynvarchar400
TOPNorway
126T5V01Table of postal codes (postal code/city)2ORT01Citynvarchar300
TOPOrganizational Management
127HRP1028Infotype 1028 DB Table20ORT01Citynvarchar400
128T777ABuilding Addresses6ORT01Citynvarchar400
TOPOverhead Cost Controlling
129CMDT_ADRGeneric Master Record: Address12ORT01Citynvarchar350
TOPPatient Management
130NPLZIS-H: Postal code catalog4ORT01IS-H: Citynvarchar400
TOPPayment Transactions
131REGUHSettlement data from payment program19ORT01Citynvarchar350
TOPPayroll
132PA0937HR Master Record: Infotype 093725ORT01Citynvarchar250
133PB0937Applicant data infotype 0937 (model)25ORT01Citynvarchar250
134T5HB1EMMA Munkaadó cím (és kieg.) adatok6ORT01Helységnvarchar400
135T5T1JHealth insurance institutions11ORT01Citynvarchar250
136T5T1KHealth insurance institutions13ORT01Citynvarchar250
137T5T1XLast foreign Health insurance - name11ORT01Place CZPnvarchar480
138T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP29ORT01Citynvarchar400
139T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP33ORT01Citynvarchar400
140T7RO30ZIP Codes5ORT01HRRO Citynvarchar1000
141T7SIBUBank Units Slovenia11ORT01Krajnvarchar250
142T7SK1KHealth insurance institutions14ORT01Citynvarchar250
TOPPendulum List Indirect Sales
143/BEV4/PLDUMKDNConversion Table Customer/Object Numbers15ORT01Citynvarchar350
TOPPension Fund Switzerland
144PA3230Personnel Master Record for Infotype 323038ORT01Citynvarchar250
TOPPeriodical Sales and Distribution
145JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet16ORT01IS-M: Citynvarchar350
146JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data34ORT01IS-M: Citynvarchar350
147JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data34ORT01IS-M: Citynvarchar350
148JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet15ORT01IS-M: Citynvarchar350
TOPPersonnel Administration
149PA0006HR Master Record: Infotype 0006 (Addresses)27ORT01Citynvarchar400
150PA0023HR Master Record: Infotype 0023 (Other/Previous Employers)25ORT01Citynvarchar250
151PA0517HR Master Record: Infotype 051728ORT01Citynvarchar400
152PA0835HR master record for infotypes 083554ORT01Citynvarchar350
153T500PPersonnel Areas10ORT01Citynvarchar250
154T521BPayee Keys7ORT01Citynvarchar250
155T7GR4SUBTCompany Subscribers (Text)11ORT01Citynvarchar250
156T7PL01Tax offices10ORT01Citynvarchar250
157T7SI1PSlovenia items for personal areas19ORT01Citynvarchar250
TOPPersonnel Management
158/BKC/S21_ANONSol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON7ORT01Ortnvarchar250
159PA0575HR Master Record: Infotype 057525ORT01Citynvarchar250
160PB0575Applicant data infotype 0575 (model)25ORT01Citynvarchar250
TOPPlant Master
161T001WPlants/Branches12ORT01Citynvarchar250
TOPProduct Cost Planning
162CKBSBase Planning Object - Unit Costing34ORT01Citynvarchar350
TOPProfit Center Accounting
163CEPCProfit Center Master Data Table20ORT01Citynvarchar350
TOPPublic Sector
164P01ZFA_NN_DATAZfA: Notifications Not Assigned32ORT01Citynvarchar400
165PA0329HR Master Record: Infotype 0329 (Sideline Job)32ORT01Citynvarchar250
166T5D72Houses8ORT01Citynvarchar250
TOPPurchasing
167EKANVendor Address: Purchasing Document8ORT01Citynvarchar350
TOPReal Estate Management
168TIVLICAGICI County Rate2ORT01Ortnvarchar350
169TIVLICAHICI County Rate2ORT01Ortnvarchar350
170TIVLICALICI County rate2ORT01Ortnvarchar350
171VIAKBSEGDocument Line Item from SCS for Interface80ORT01Data Element Type CHAR Length 35nvarchar350
172VILICICI Historical Data12ORT01Ortnvarchar350
TOPRecruitment
173PB0006HR Master Record: Infotype 0006 (Addresses)27ORT01Citynvarchar400
174PB0023HR Master Record: Infotype 0023 (Other/Previous Employers)25ORT01Citynvarchar250
TOPRecycling Administration Core Functions
175J_7LSADRAddress Management: Company Data10ORT01Citynvarchar350
TOPRemaining Beverage - Obsolete Objects
176/BEV1/CLDEBCustomer Information8ORT01Citynvarchar350
TOPReporting
177P05TPRNL_EE_PDPension Return: Personal Data - Pers Level31ORT01Citynvarchar400
TOPRussia
178T7RU1BPayee Keys of receiving orders (Russia standard)7ORT01Citynvarchar250
TOPSAP Media
179J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping22ORT01IS-M: Citynvarchar350
TOPService Data Download
180/SDF/CMO_T_53CMO Service: Clients of DEV system3ORT01nvarchar250
181/SDF/CMO_T_54CMO Service: Clients of QAS system3ORT01nvarchar250
182/SDF/SWCM_T000_PClients of PRD3ORT01nvarchar250
TOPShipping
183DVK01R/2-R/3 Link: Delivery Header Data R2 -> R315ORT01Citynvarchar350
TOPSingapore
184PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)28ORT01Citynvarchar250
185T5R1AInstitution of Soc. Provident Funds SG10ORT01Citynvarchar250
TOPSocial Insurance
186T5D32_UVWorkers' Compensation Associations9ORT01Citynvarchar400
TOPSouth Africa
187T5W1KPension Funds and Medical Aid Schemes (RSA)15ORT01Citynvarchar250
188T5W1MSocial insurance companies7ORT01Citynvarchar250
189T5W2A(Old) Tax Revenue Offices (South Africa)7ORT01Citynvarchar250
190T5W2PSouth African Revenue Service Offices6ORT01Citynvarchar250
TOPSpain
191T5E05Social Insurance branch offices6ORT01Citynvarchar250
192T5E70INEM offices6ORT01Citynvarchar250
193T5EDHLocal tax offices/authorities10ORT01Citynvarchar250
TOPTax
194P01T_LSTETStmt: General Employment Tax Data30ORT01ETStmt: City of Residencenvarchar340
TOPTax Reporting
195OIUX3_RPT_PROFTax Reporting - Reporting Profile11ORT01Citynvarchar350
TOPThailand
196PA0187Additional family data26ORT01Provincenvarchar400
TOPTransfer Postings
197J_1AAWAYBLWay Bills for asset movements30ORT01Citynvarchar350
TOPTravel Expenses
198PTRV_TRIPCHN_46CTable of all Trip Destinations f. Processing Recurring Dest.16ORT01Citynvarchar400
199PTRV_TRIP_CHAINTable of all Trip Destinations f. Processing Recurring Dest.16ORT01Citynvarchar400
200T706_CITY_CD_46CTable for Specifying the City Code/Community Code Number4ORT01Citynvarchar400
201T706_CITY_CD_DDefinition: City Codes / Community Code No., Date-Dependent4ORT01Citynvarchar400
202T706_CITY_CD_D_2Definition: City Codes / Community Code No., Date-Dependent4ORT01Citynvarchar400
203T706_CITY_CODETable for Specifying the City Code/Community Code Number4ORT01Citynvarchar400
TOPTravel Planning
204TA20BUILDINGBuildings4ORT01Citynvarchar400
TOPTreasury
205SANS1Address table5ORT01Citynvarchar350
206VZKNA1Collector for batch input KNA1 from RF-VV20ORT01Citynvarchar350
TOPUSA
207PA0106HR Master Record: Infotype 0106 (Related Persons NA)33ORT01Citynvarchar250
208T5UADAddress for US Reporting Units5ORT01Citynvarchar250
209T5UAPAddress for personnel area/subarea8ORT01Citynvarchar400
210T5UTVUnemployment Insurance Work Sites/NC-9901 Locations10ORT01Citynvarchar250
TOPUser and Authorization Management
211USR03User address data15ORT01Locationnvarchar250