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

195 columns | Print definition?ERP 6.0  | STRAS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt18STRASHouse number and streetnvarchar350
2/ATL/KPRCPTKPDetail of temporary receipt18STRASHouse number and streetnvarchar350
3/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)66STRASHouse number and streetnvarchar300
4/OPT/WT_3S_PYMNTSupplier Self Service Payment Information26STRASHouse number and streetnvarchar300
5/OTEI/OCR_TSTGStaging table for HDCC download data11STRASStreet and House Numbernvarchar600
6/SLOAP/KNA1General Data in Customer Master10STRASHouse number and streetnvarchar350
7BSECOne-Time Account Data Document Segment13STRASHouse number and streetnvarchar350
8CNV_20305_CEPCSAP LT: Backup table of CEPC22STRASHouse number and streetnvarchar350
9FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document13STRASHouse number and streetnvarchar350
10FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)13STRASHouse number and streetnvarchar350
11NNL_ZH308_V9_R02ZH308 V09 Record02 Soll Daten23STRASnvarchar50
12P2AR_ARDIMPTax deduction results16STRASHouse number and streetnvarchar300
13P2AR_AROIMPOther employers8STRASHouse number and streetnvarchar300
14P2HK_TAXADRHR-HK: Payroll structure for Tax Quarters - Tax year8STRASHouse number and streetnvarchar300
15P2RB_ADRAddress payroll Belgium4STRASStreet and House Numbernvarchar600
16P2RB_I0125Garnishment payroll Belgium38STRASHouse number and streetnvarchar300
17P2RD_ADRPayroll Results: Address4STRASStreet and House Numbernvarchar600
18P2RF_SARPayroll Results: Garnishment22STRASHouse number and streetnvarchar300
19P2RK_ADRAddress4STRASStreet and House Numbernvarchar600
20P2RN_NADRAddress Data5STRASStreet and House Numbernvarchar600
21P2RU_ADRAddress5STRASStreet and House Numbernvarchar600
22P2RX_BTPayroll Results: Bank Transfers24STRASHouse number and streetnvarchar300
23P2RX_BT_PERSONPayment-Related Information (Person)26STRASHouse number and streetnvarchar300
24T5CSWHR-CH: Work Center ELM 4.09STRASStreet Without House Numbernvarchar600
25T77PAYKZBTBank Transfer Table Image (BTKZ)41STRASHouse number and streetnvarchar300
26T7RU9AAddresses of organizations11STRASStreet and House Numbernvarchar600
27T7RUADKLADR: Streets9STRASStreet and House Numbernvarchar600
28T7RUPA0006PA0006 copy26STRASStreet and House Numbernvarchar600
TOPAddress ManagementBusiness Address
29SADRAddress Management: Company Data14STRASHouse number and streetnvarchar350
TOPArgentina
30PA0390Income Tax: Deductions34STRASStreet and House Numbernvarchar600
31PA0391Income Tax: Information on other employers27STRASStreet and House Numbernvarchar600
32PA0392Social Security: General data42STRASStreet and House Numbernvarchar600
TOPAssortment List
33WBBHAssortment list header16STRASHouse number and streetnvarchar300
TOPAustria
34PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)47STRASTransfer - House number and streetnvarchar300
35T5A1TSocial insurance institutes6STRASHouse number and streetnvarchar300
36T5A2FTax Offices (A)4STRASHouse number and streetnvarchar300
TOPAutomatic Payments
37PAYRQPayment Requests38STRASHouse number and streetnvarchar350
TOPBank
38BNKABank master record8STRASHouse number and streetnvarchar350
TOPBank Customer Accounts
39BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA111STRASStreet and house number 1nvarchar350
TOPBasic Data
40NC301PIS-H EDI Data Collection Points10STRASIS-H: Street Name and Street Number of Business Partnernvarchar300
41NGPAIS-H: Business Partners25STRASIS-H: Street Name and Street Number of Business Partnernvarchar300
42NORGIS-H: Organizational Units13STRASIS-H: Street and Street Number of Organizational Unitnvarchar300
43TN01IS-H: Institutions11STRASHouse number and streetnvarchar300
TOPBasis Components
44ZCUSTOMER_IDESCustomer Master (IDES Demo)10STRASHouse number and streetnvarchar350
TOPBelgium
45PA0125HR Master Record: Infotype 0125 (Garnishment B)45STRASHouse number and streetnvarchar300
46T5BS3Employee information except reductions ( level 3 )19STRASHouse number and streetnvarchar300
TOPBenefits
47PA0219HR Master Record: Infotype 0219 (External Organizations)28STRASStreet and House Numbernvarchar600
TOPBrazil
48PA0736Alimony order for Brazil35STRASStreet and House Numbernvarchar600
TOPCanada
49T5KYSNo longer used9STRASHouse number and streetnvarchar300
50T5UTLTax Company4STRASHouse number and streetnvarchar300
TOPChile
51PA3235HR Master Record: Infotype 323541STRASHouse number and streetnvarchar300
TOPChina
52PA0528HR Master Record: Infotype 0528 (Family information)55STRASStreet and House Numbernvarchar600
TOPClinical System
53N1DOKEMPFIS-H*MED: Recipient of the Documents21STRASIS-H: Streetnvarchar400
54N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle41STRASIS-H: Sokaknvarchar400
55N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle42STRASIS-H: Sokaknvarchar400
56N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal42STRASIS-H: Sokaknvarchar400
57N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient15STRASIS-H: Street Name and Street Number of Business Partnernvarchar300
58N2MV_DISREQDispatch Request Data Table21STRASDispatch Control: Addressnvarchar800
59N2MV_VSDATRecipient Data Table20STRASDispatch Control: Addressnvarchar800
TOPCompany Pension Scheme Germany
60PA0746HR Master Record for Infotype 074634STRASStreetnvarchar350
61T5DC3Pension Organization for Company Pension Scheme10STRASHouse number and streetnvarchar300
TOPConstruction Industry
62PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records25STRASHouse Number and Streetnvarchar300
63T5DB4HR Construction Site File32STRASHouse number and streetnvarchar300
64T5DB5Construction Site File: Work Breakdown Structure Element23STRASHouse number and streetnvarchar300
65T5DB6Construction Site File: Order23STRASHouse number and streetnvarchar300
TOPControlling
66CSKSCost Center Master Data41STRASHouse number and streetnvarchar350
TOPCross-Application Components
67BC490KKNA1General data in customer master10STRASHouse number and streetnvarchar350
68KKNA1General Data in Customer Master10STRASHouse number and streetnvarchar350
69SKNA1Customer Master table for BC417 Course10STRASHouse number and streetnvarchar350
TOPCross-Application Objects in HR
70HRP5583DB Table for Infotype 558323STRASStreet and House Numbernvarchar600
TOPCustomer Master
71KNA1General Data in Customer Master10STRASHouse number and streetnvarchar350
TOPDenmark
72T5M8TDanish Postal Codes5STRASStreet or districtnvarchar400
TOPDunning
73MHNKDunning data (account entries)41STRASHouse number and streetnvarchar350
74MHNKODunning data (acct entries) version before the next change41STRASHouse number and streetnvarchar350
TOPFinancial Accounting
75LFA1Vendor Master (General Section)15STRASHouse number and streetnvarchar350
76VBSECDocument Parking One-Time Data Document Segment13STRASHouse number and streetnvarchar350
TOPFrance
77PA0272Infotype 0272 (Garnishment)41STRASHouse number and streetnvarchar300
78T5F1ESI Organizations - addresses4STRASHouse number and streetnvarchar300
79T5F4EDDTEFP4STRASHouse number and streetnvarchar300
80T5F4E1DDTEPP address5STRASHouse number and streetnvarchar300
TOPFSCM In-House Cash
81IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order15STRASHouse number and streetnvarchar350
TOPFunds Management-Specific Postings
82PAYRCAdditional Header Data for Recovery Order21STRASHouse number and streetnvarchar350
83PSOSECRecurring Request Document Segment, One-Time Data15STRASHouse number and streetnvarchar350
TOPGermany
84T5D2ATax Offices (D)3STRASHouse number and streetnvarchar300
85T5D2KFamily Funds (D)3STRASHouse number and streetnvarchar300
TOPGL Account Posting
86TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items14STRASHouse number and streetnvarchar350
TOPHong Kong
87PA0344HR Master Record: Infotype 0344 (Familiy members HK)25STRASHouse number and streetnvarchar300
TOPIndonesia
88PA0318HR Master Record: Infotype Family data for Indonesia (0318)33STRASHouse number and streetnvarchar300
89T7ID1AJamsostek office address (Indonesia)3STRASHouse number and streetnvarchar300
TOPInformation System
90DKKOSBalance Audit Trail14STRASHouse number and streetnvarchar300
91DKOKSOpen Item Account Balance Audit Trail Master Record15STRASHouse number and streetnvarchar300
92QSTREFI/HR Withholding Tax Report for Spain17STRASHouse number and streetnvarchar350
TOPInvoice Verification
93RBKPDocument Header: Invoice Receipt88STRASHouse number and streetnvarchar350
TOPJapan
94T5JADHR company office address JP9STRASHouse number and streetnvarchar300
95T5JL1HR Address Infomation 1 of Personnel Subarea for LI JP9STRASLine of Address in Kanjinvarchar300
96T5JL2HR Address Infomation 2 of Personnel Subarea for LI JP9STRASLine of Address in Kanjinvarchar300
97T5JSIHR Branch Office Information for Social Insurance JP9STRASLine of Address in Kanjinvarchar300
TOPLoans Management
98VDAUSZDrawings on Disbursement25STRASHouse number and streetnvarchar350
99VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity39STRASHouse number and streetnvarchar350
100VZFZE_VDAUSZCentral Entry Table for Release Procedure27STRASHouse number and streetnvarchar350
101VZFZE_VDNBZECentral Entry Table for Release Procedure59STRASHouse number and streetnvarchar350
TOPLocalization
102J_1BNFCPDNota Fiscal one-time accounts11STRASHouse number and streetnvarchar350
103J_1BNFDOCNota Fiscal Header72STRASHouse number and streetnvarchar350
104J_1BNFNADNota Fiscal partners12STRASHouse number and streetnvarchar350
TOPLogistics Basic Data
105DMF_D_T001WTransferred Sites9STRASHouse number and streetnvarchar300
TOPMalaysia
106PA0213Additional family information - Malaysia35STRASHouse number and streetnvarchar300
TOPMaster Data
107JGTSADRIS-M: Extended Address Management32STRASStreet Namenvarchar350
108JSTALIASIS-M: Alias Table for Streets18STRASStreet Namenvarchar350
TOPMexico
109PA0426Garnishment35STRASStreet and House Numbernvarchar600
110T7MX01Additional Company Informaton6STRASHouse number and streetnvarchar300
111T7MX24IMSS Employer Regis. nos.5STRASHouse number and streetnvarchar300
TOPNetherlands
112T5N9AAuthority Addresses (NL)9STRASHouse number and streetnvarchar300
TOPNon Profit Organizations
113T7UNPAD_EGSNNPO: Education Grant Schools / Colleges12STRASHouse number and streetnvarchar300
TOPNorway
114T5V2CNorwegian <trygdekontor>5STRASHouse number and streetnvarchar300
TOPOrganizational Management
115HRP1028Infotype 1028 DB Table19STRASHouse Number and Streetnvarchar300
116T777ABuilding Addresses5STRASHouse Number and Streetnvarchar300
TOPOverhead Cost Controlling
117CMDT_ADRGeneric Master Record: Address14STRASHouse number and streetnvarchar350
TOPPatient Management
118NADRIS-H: Addresses (Central Address Management)9STRASIS-H: Streetnvarchar400
119NPATIS-H: Patient Master Data (General)32STRASIS-H: Street and House Number of Patientnvarchar300
120NPEZIS-H: Assignment of postal code to geographical area8STRASIS-H: Streetnvarchar400
121NPLZIS-H: Postal code catalog8STRASIS-H: Streetnvarchar400
122NWANIS-H: Bad Debt Parties16STRASIS-H: Street and house number of bad debt partynvarchar300
TOPPayment Transactions
123REGUHSettlement data from payment program20STRASHouse number and streetnvarchar350
TOPPayroll
124PA0773Personel ana verileri: Bilgi tipi 077327STRASSokak ve konut numarasinvarchar300
125T5T1XLast foreign Health insurance - name8STRASStreet of foreign health insurancenvarchar480
126T5TA1External transfers34STRASHouse number and streetnvarchar300
127T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP27STRASStreet and House Numbernvarchar600
128T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP30STRASStreet and House Numbernvarchar600
129T7ROA1Bank transfer - interface table26STRASHouse number and streetnvarchar300
130T7SIA6Bank transfer - interface table29STRASHouse number and streetnvarchar300
131T7SIBTVirman configuration (WT->Accounts)22STRASHouse number and streetnvarchar300
132T7SIBUBank Units Slovenia12STRASUlica in hišna številkanvarchar300
133T7SKA1External transfers34STRASHouse number and streetnvarchar300
134T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000959STRASUlica a císlo domunvarchar300
135T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001160STRASUlica a císlo domunvarchar300
136T7TRG01General information about company.18STRASHouse number and streetnvarchar300
TOPPayroll General Parts
137PA0476HR master record infotype 0476 (Deductions Spain)80STRASPayee Streetnvarchar80
TOPPendulum List Indirect Sales
138/BEV4/PLDUMKDNConversion Table Customer/Object Numbers17STRASHouse number and streetnvarchar350
TOPPension Fund Switzerland
139PA3230Personnel Master Record for Infotype 323044STRASHouse number and streetnvarchar300
TOPPeriodical Sales and Distribution
140JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet18STRASStreet Namenvarchar350
141JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data36STRASStreet Namenvarchar350
142JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data36STRASStreet Namenvarchar350
143JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet17STRASStreet Namenvarchar350
TOPPersonnel Administration
144PA0006HR Master Record: Infotype 0006 (Addresses)26STRASStreet and House Numbernvarchar600
145PA0009HR Master Record: Infotype 0009 (Bank Details)56STRASHouse number and streetnvarchar300
146PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)57STRASHouse number and streetnvarchar300
147PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)40STRASStraße und Hausnummernvarchar300
148PA0517HR Master Record: Infotype 051724STRASStreet and House Numbernvarchar600
149T500PPersonnel Areas7STRASHouse number and streetnvarchar300
150T521BPayee Keys13STRASHouse number and streetnvarchar300
151T7PL01Tax offices6STRASHouse number and streetnvarchar300
152T7SI1PSlovenia items for personal areas18STRASHouse number and streetnvarchar300
TOPPersonnel Management
153/BKC/S21_ANONSol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON5STRASStraße und Hausnummernvarchar300
154T7HRA1Bank transfer - interface table22STRASHouse number and streetnvarchar300
TOPPlant Master
155T001WPlants/Branches9STRASHouse number and streetnvarchar300
TOPProduct Cost Planning
156CKBSBase Planning Object - Unit Costing29STRASHouse number and streetnvarchar350
TOPProfit Center Accounting
157CEPCProfit Center Master Data Table22STRASHouse number and streetnvarchar350
TOPPublic Sector
158P01ZFA_NN_DATAZfA: Notifications Not Assigned29STRASStreet and House Numbernvarchar600
159PA0329HR Master Record: Infotype 0329 (Sideline Job)31STRASHouse number and streetnvarchar300
160PDPBSZVADRAddress (Record Type 81), ZVE-PBS13STRASStreet, ZVE-PBSnvarchar300
161T5D72Houses6STRASHouse Number and Streetnvarchar300
TOPPurchasing
162EKANVendor Address: Purchasing Document10STRASHouse number and streetnvarchar350
TOPReal Estate Management
163VIAKBSEGDocument Line Item from SCS for Interface81STRASData Element Type CHAR Length 35nvarchar350
TOPRecruitment
164PB0006HR Master Record: Infotype 0006 (Addresses)26STRASStreet and House Numbernvarchar600
165PB0009HR Master Record: Infotype 0009 (Bank Details)56STRASHouse number and streetnvarchar300
TOPRecycling Administration Core Functions
166J_7LSADRAddress Management: Company Data14STRASHouse number and streetnvarchar350
TOPRemaining Beverage - Obsolete Objects
167/BEV1/CLDEBCustomer Information16STRASHouse number and streetnvarchar300
TOPReporting
168P05TPRNL_EE_PDPension Return: Personal Data - Pers Level26STRASStreet and House Numbernvarchar600
TOPRussia
169T7RU1BPayee Keys of receiving orders (Russia standard)17STRASHouse number and streetnvarchar300
TOPSAP Ambulatory Care Management
170NKTR_KVIS-H: Ins. Prov. Master acc. to Fed. PPA from PPA Bill.Syst.10STRASIS-H: Streetnvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
171NPNTCASIS-H: Patient Master Data at Case Level (CV IT)15STRASIS-H: Streetnvarchar400
TOPSAP Media
172J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping16STRASStreet Namenvarchar350
TOPShipping
173DVK01R/2-R/3 Link: Delivery Header Data R2 -> R311STRASHouse number and streetnvarchar300
TOPSingapore
174PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)26STRASHouse number and streetnvarchar300
175T5R1AInstitution of Soc. Provident Funds SG8STRASHouse number and streetnvarchar300
TOPSocial Insurance
176T5D32_UVWorkers' Compensation Associations10STRASHouse number and streetnvarchar300
TOPSouth Africa
177T5W2A(Old) Tax Revenue Offices (South Africa)5STRASHouse number and streetnvarchar300
178T5W2PSouth African Revenue Service Offices4STRASHouse number and streetnvarchar300
TOPSpain
179PA0887HR master record, infotype 088749STRASHouse number and streetnvarchar300
180T5EDHLocal tax offices/authorities7STRASHouse number and streetnvarchar300
TOPSwitzerland
181T5C2P_ABRNREmployer Data for WHT Accounting Geneva5STRASStreet Name (GeTIS)nvarchar400
TOPTax
182P01T_LSTETStmt: General Employment Tax Data25STRASETStmt: Streetnvarchar330
TOPThailand
183PA0187Additional family data25STRASAddress Number, Soi Trok (TH)nvarchar600
TOPTransfer Postings
184J_1AAWAYBLWay Bills for asset movements29STRASHouse number and streetnvarchar350
TOPTravel Expenses
185PTRV_TRIPCHN_46CTable of all Trip Destinations f. Processing Recurring Dest.17STRASStreet and House Numbernvarchar600
186PTRV_TRIP_CHAINTable of all Trip Destinations f. Processing Recurring Dest.17STRASStreet and House Numbernvarchar600
TOPTravel Planning
187TA20BUILDINGBuildings3STRASStreet and House Numbernvarchar600
TOPTreasury
188SANS1Address table8STRASHouse number and streetnvarchar350
189VZKNA1Collector for batch input KNA1 from RF-VV34STRASHouse number and streetnvarchar350
TOPUSA
190PA0106HR Master Record: Infotype 0106 (Related Persons NA)31STRASHouse number and streetnvarchar300
191T5UADAddress for US Reporting Units4STRASHouse number and streetnvarchar300
192T5UAPAddress for personnel area/subarea6STRASStreet and House Numbernvarchar600
193T5UP2Establishment/stores for tip processing9STRASHouse number and streetnvarchar300
194T5UTVUnemployment Insurance Work Sites/NC-9901 Locations9STRASHouse number and streetnvarchar300
TOPUser and Authorization Management
195USR03User address data12STRASStreet and House Numbernvarchar300