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

61 columns | Print definition?ERP 6.0  | ZWECK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)62ZWECKPurpose of Bank Transfersnvarchar400
2HRPADNLP_LOGIMMENL Pens: Immediate Payments - log for Payroll Process11ZWECKPurpose of Bank Transfersnvarchar400
3P2RB_I0125Garnishment payroll Belgium30ZWECKPurpose of Bank Transfersnvarchar400
4P2RG_COURTTypes of Court Order (GB)29ZWECKPurpose of Bank Transfersnvarchar400
5P2RH_HU_MEMBP21MB26ZWECKPurpose of Bank Transfersnvarchar400
6P2RN_SRPayroll Results: Life-Course Savings Scheme22ZWECKPurpose of Bank Transfersnvarchar400
7P2RX_BTPayroll Results: Bank Transfers16ZWECKPurpose of Bank Transfersnvarchar400
8P2RX_BT_PERSONPayment-Related Information (Person)18ZWECKPurpose of Bank Transfersnvarchar400
9T77PAYKZBTBank Transfer Table Image (BTKZ)33ZWECKPurpose of Bank Transfersnvarchar400
TOPAustria
10PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)37ZWECKPurpose of bank transfersnvarchar400
TOPBelgium
11PA0125HR Master Record: Infotype 0125 (Garnishment B)37ZWECKPurpose of Bank Transfersnvarchar400
TOPChile
12PA3235HR Master Record: Infotype 323540ZWECKPurpose of Bank Transfersnvarchar400
TOPCompany Pension Scheme Germany
13P01CBTTransfer Records for Reimbursement of Contributions CPS25ZWECKPurpose of bank transfersnvarchar400
TOPGermany
14P01Y15PAISY: Management Table Subrecord Type 1518ZWECKPurpose of Bank Transfersnvarchar400
15PA0010HR Master Record: Infotype 0010 (Capital Formation)41ZWECKPurpose of Bank Transfersnvarchar400
16PA0026HR Master Record: Infotype 0026 (Company Insurance)51ZWECKPurpose of Bank Transfersnvarchar400
17PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)36ZWECKPurpose of bank transfersnvarchar400
18PA0699Personnel Master Record Infotype 069939ZWECKPurpose of Bank Transfersnvarchar400
TOPGreat Britain
19PA0070HR Master Record: Infotype 0070 (Court Orders - GB)44ZWECKPurpose of Bank Transfersnvarchar400
TOPNetherlands
20PA0854HR Master Record for Infotype 085438ZWECKPurpose of Bank Transfersnvarchar400
TOPPatient Accounting
21TNS09IS-H: Re-Map Services for Service Statistics3ZWECKIS-H: Use of Assignment Type in Evaluationsnvarchar20
22TNT3AUse of Rule Types3ZWECKIS-H: Use of Rule Typenvarchar10
TOPPayroll
23T5TA1External transfers40ZWECKPurpose of Bank Transfersnvarchar400
24T7BGA1Bank transfer - interface table41ZWECKEE Reference (e.g. EE bank account number, ...)nvarchar400
25T7SKA1External transfers40ZWECKPurpose of Bank Transfersnvarchar400
26T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000952ZWECKÚcel použitia pri penažných prevodochnvarchar400
27T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001156ZWECKÚcel použitia pri penažných prevodochnvarchar400
28T7UA_521BPayee Keys (Ukranian extension for table T521B)9ZWECKPurpose of Bank Transfersnvarchar400
TOPPension fund General Parts
29T72T0HR-PF: TS Processing Reason4ZWECKProcessing Reasonnvarchar40
30T72T0THR-PF: TS Processing Reason5ZWECKProcessing Reasonnvarchar40
31T72T1HR-PF: TS Person Grouping4ZWECKProcessing Reasonnvarchar40
32T72T1THR-PF: TS Person Grouping5ZWECKProcessing Reasonnvarchar40
33T72T2HR-PF: TS Data Areas4ZWECKProcessing Reasonnvarchar40
34T72T2THR-PF: TS Data Areas5ZWECKProcessing Reasonnvarchar40
35T72T3HR-PF: TS Characteristics of Data Areas4ZWECKProcessing Reasonnvarchar40
36T72T4HR-PF: TS Master Data4ZWECKProcessing Reasonnvarchar40
37T72T4THR-PF: TS Master Data Field Descriptions5ZWECKProcessing Reasonnvarchar40
38T72T5HR-PF: TS Account Data4ZWECKProcessing Reasonnvarchar40
39T72T6HR-PF: TS Account Data Totals Formation4ZWECKProcessing Reasonnvarchar40
40T72T9HR-PF: TS Payroll Data4ZWECKProcessing Reasonnvarchar40
41T72TAHR-PF: TS Payroll Data Totals Formation4ZWECKProcessing Reasonnvarchar40
42T72TBHR-PF: TS Parameter Values4ZWECKProcessing Reasonnvarchar40
43T72TFHR-PF: TS Characteristics of Processing Reason4ZWECKProcessing Reasonnvarchar40
TOPPension fund Netherlands
44T5NDLHR-PF: TS Ereignisse4ZWECKReden verwerkingnvarchar40
TOPPersonnel Administration
45PA0009HR Master Record: Infotype 0009 (Bank Details)49ZWECKPurpose of Bank Transfersnvarchar400
46PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)53ZWECKPurpose of Bank Transfersnvarchar400
47PA0057HR Master Record: Infotype 0057 (Membership Fees)43ZWECKPurpose of Bank Transfersnvarchar400
48PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)45ZWECKVerwendungszweck bei Überweisungennvarchar400
TOPPersonnel Management
49/BKC/S21_ANONSol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON10ZWECKVerwendungszweck bei Überweisungennvarchar400
50T7HRA1Bank transfer - interface table31ZWECKPurpose of Bank Transfersnvarchar400
51T7HRDOStatutory deductions Croatia17ZWECKPurpose of bank transfersnvarchar400
52T7HRDSControl codes for stat. deductions and company codes Croatia14ZWECKPurpose of bank transfersnvarchar400
53T7HRMUMunicipality codes (Croatia)15ZWECKPurpose of bank transfersnvarchar400
54T7HRMWControl numbers - municipalities and company codes (Croatia)13ZWECKPurpose of bank transfersnvarchar400
55T7HRPGControl codes for payees Croatia14ZWECKPurpose of bank transfersnvarchar400
TOPReal Estate Management
56TIVWB04WB: Zweckbindung2ZWECKWB: Zweckbindungnvarchar30
57TIVWB0DWB: Texte zu Zweckbindung3ZWECKWB: Zweckbindungnvarchar30
58VIWB01Teile der Hauptwirtschaftlichkeitsberechnung10ZWECKWB: Zweckbindungnvarchar30
TOPRecruitment
59PB0009HR Master Record: Infotype 0009 (Bank Details)49ZWECKPurpose of Bank Transfersnvarchar400
TOPSpain
60PA0887HR master record, infotype 088748ZWECKPurpose of Bank Transfersnvarchar400
TOPSwitzerland
61PA0980HR Master Record Infotype 098052ZWECKPurpose of Bank Transfersnvarchar400