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

74 columns | Print definition?ERP 6.0  | DTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/EHR/S71_FIELDMaintenance Output Fields (obsolet)3DTYPEData typenvarchar10
2/EHR/S71_OPTYPEOrgPublisher-type of output field4DTYPEData type OrgPublishernvarchar20
3/SOMO/JOBMON02Job fields definition5DTYPEnvarchar40
4CNVMBTSELMEMTYPEMBT PCL Selection group member types8DTYPEData Type in ABAP Dictionarynvarchar40
5FAGL_GCDDC_VERGCD Revision: Data Type of Item6DTYPEData Type in ABAP Dictionarynvarchar40
6FAGL_GCDDC_XBRLGCD-Structure: Data Type of Item4DTYPEData Type in ABAP Dictionarynvarchar40
7PA3331HR Master Record: Infotype 333144DTYPEType of declarationnvarchar20
8T021Fields for Line Item and Document Line Layout11DTYPEData Type in ABAP Dictionarynvarchar40
9T588F- is no longer used (now T588G) -8DTYPEABAP data type (C,D,N,...)nvarchar10
10T5F99VWDAQ File Viewer Customizing8DTYPEData Type Class Namenvarchar300
11T77EIRNL_BCKPRXNElectronic Illness Reporting NL: Association Backend & Proxy9DTYPEData Typenvarchar10
12T7AEPBS13Configure Special Date Types3DTYPESpecial Date Typenvarchar20
13T7AEPBS19Common Eligibility Rule Configuration15DTYPESpecial Date Typenvarchar20
14T7AEPBS53Special Date Type3DTYPESpecial Date Typenvarchar20
15T7AEPBS53TSpecial Date Type Text3DTYPESpecial Date Typenvarchar20
16T7CNRM_RPDATAKReport Data Key8DTYPEData Typenvarchar10
17T7SAPBS13Special Date Type Rule2DTYPESpecial Date Typenvarchar20
18T7SAPBS18Special Time Period Configration3DTYPESpecial Date Typenvarchar20
19T7SAPBS19Common Eligibility Rule Configuration15DTYPESpecial Date Typenvarchar20
20T7SAPBS53Special Date Type2DTYPESpecial Date Typenvarchar20
21T7SAPBS53TSpecial Date Type Text3DTYPESpecial Date Typenvarchar20
22TKSBSFields for Line Structure11DTYPEData Type in ABAP Dictionarynvarchar40
23TST05TemSe data types1DTYPETemSe: Object type namenvarchar120
24YIT_DOCUTYPEIDA: Documentation Type (MSWord,..)1DTYPEIDA: Documentation Type (MSWord,..)nvarchar30
25YIT_DOCUTYPETIDA: Documentation Type (MSWord,..)2DTYPEIDA: Documentation Type (MSWord,..)nvarchar30
26YIT_RDOCUIDA: Reference Table Documents4DTYPEIDA: Documentation Type (MSWord,..)nvarchar30
27ZSA_D_ESTable for final Extract Structure9DTYPEData Type in ABAP Dictionarynvarchar40
TOPAccount Determination
28T180SReporting: Display Variants: Fields14DTYPEData Type in ABAP Dictionarynvarchar40
TOPAustralia
29T5QITCalculation rule for transfer frequency8DTYPEDate type used to determine the leave transfer datenvarchar20
TOPB2A Business to Administration
30PB2ADATEMAILHR-B2A: Data Table for Incoming E-Mails7DTYPEData Typenvarchar40
TOPBelgium
31T5B41Mapping date types to internal date types for IT41(Belg.)3DTYPEDate types for infotype 41 (hardcoded)nvarchar20
TOPBenefit Integration
32T7USBENH1For saving records of issued HIPAA certificates3DTYPEBenefit dependent typenvarchar40
33T7USBENH2For savings records of on-demand printing of HIPAA certs.3DTYPEBenefit dependent typenvarchar40
TOPCAD Integration
34TCIDCAD Field Parameters for Download9DTYPEData type of screen fieldnvarchar40
35TCITConversion Table: Table Field Name <--> Screen Field Name8DTYPEData type of screen fieldnvarchar40
TOPCompany Pension Scheme Germany
36P01CSTStatus Information CPS7DTYPEStatement Typenvarchar20
37T5DC5Process Control Pension Calculation19DTYPEStatement Typenvarchar20
38T5DCHAssignment of Statement Data Type to CPS Table Name2DTYPEStatement Typenvarchar20
39T5DW3Pension Organizations for CPS Statement Information3DTYPEStatement Typenvarchar20
40T5DWJAssignment of Text Elements to Statements2DTYPEStatement Typenvarchar20
41T5DWLControl Logical Pages in CPS Statements3DTYPEStatement Typenvarchar20
TOPContract Accounts Receivable and Payable
42TFK021Line layout variants: Fields11DTYPEData Type in ABAP Dictionarynvarchar40
TOPDefense Forces and Public Security
43PA0805Personnel Master Record Infotype 080524DTYPEType of Decorationnvarchar40
TOPGlobal Trade Services
44/SAPSLL/TLEPR0Foreign Trade Documents: Classification3DTYPEType of Documentnvarchar30
TOPIndia
45T7IND7Dearness allowance calculation rules6DTYPEDearness allowance calculation typesnvarchar20
TOPInvoice Verification
46T169RETTIMEWarranty Period for Security Retention3DTYPEDate Type of Security Retentionnvarchar10
TOPItaly
47T5ITVRdefinizione di variabili di UR per condizioni10DTYPETipo dati per variabile delle condizioni per URnvarchar10
TOPLocalization
48J_3RS_CCD_FIPOSTPosting Rules for Customs Fees and Duties6DTYPEDocument Typenvarchar20
TOPMalaysia
49T5LTKReference Number output attributes8DTYPEDisk format typenvarchar10
TOPNorway
50T5V4ACheck table for infotype 00572DTYPEDeduction typenvarchar10
51T5V4BControl table for garnishments and union dues10DTYPEDeduction typenvarchar10
TOPPension fund Netherlands
52T5NKCTariff Calculation: Tabeltype kolom6DTYPEGegevenstypenvarchar10
53T5NKGTariff Calculation: Tariefsettype parameters4DTYPEGegevenstype (uitgebreid)nvarchar10
54T5NKKTariff Calculation: Tarief type parameter4DTYPEGegevenstype (uitgebreid)nvarchar10
55T5NKRActuarial File: Actuarieel bestandstype kolom5DTYPEGegevenstypenvarchar10
56T5NKVActuarial File: Parameter groep type parameters4DTYPEGegevenstypenvarchar10
57T5NKZSelectiesettype parameter4DTYPEGegevenstypenvarchar10
TOPPersonnel Administration
58T588GField-Specific Retroactive Accounting Recognition9DTYPEABAP data type (C,D,N,...)nvarchar10
59T5H2XPersonal data to income tax refund (persons w/o tax number)3DTYPET5H2X data categorynvarchar20
TOPPersonnel Categories
60/ISDFPS/DECORDecorations3DTYPEType of Decorationnvarchar40
61/ISDFPS/DECORTDecorations4DTYPEType of Decorationnvarchar40
TOPPersonnel Time Management
62T552VDynamic Daily Work Schedule Assignment4DTYPEType for Daily Work Schedule Assignmentnvarchar20
63T552WDynamic Daily WS Assignment: Planned/Actual Overlap4DTYPEType for Daily Work Schedule Assignmentnvarchar20
TOPPlanning
64T8PL01FI-Planning: Summary Table Dimensions to be Planned6DTYPEPlanning dimension typenvarchar10
TOPPrint and Output Management
65TST01TemSe: List of objects and parts4DTYPETemSe: Object type namenvarchar120
TOPPublic Sector
66T5QPBS2ICalculation rule for transfer frequency7DTYPEDate typenvarchar20
TOPPurchasing
67WRFT_DMAINDate Maintenance3DTYPEDate Categorynvarchar10
68WRF_PSCD_DLITDate Line, Dates21DTYPEDate Categorynvarchar10
69WRF_PSCD_TCHAINRTransportation Chain, Legs16DTYPEDate Categorynvarchar10
TOPReuse Services for Country Development
70T5DF6Statement Parameters - Customer Settings9DTYPEStatement Typenvarchar20
TOPSAPscript
71TTDCFTable for style sheet conversion3DTYPEKey: 'S' style, 'F' form, 'D' Word document templatenvarchar10
TOPSingapore
72T5R2APro-rate types for AWS2DTYPEPart month rounding typesnvarchar20
TOPWithout Description
73RSQDIMDimensions in the InfoSet4DTYPEType of Dimension in the InfoSetnvarchar10
74RSQDIMTTexts for Dimensions in the InfoSet5DTYPEType of Dimension in the InfoSetnvarchar10