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

41 columns | Print definition?ERP 6.0  | XLAND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAddress ManagementBusiness Address
1T005Countries10XLANDCountry version flagnvarchar10
TOPGermany
2TZ28T_UMSUmsetzungstab Texte Gesetzesänderung BAV 20023XLANDLändervariante für das Meldewesennvarchar20
3TZ28_ARCHIVAsset Type According to Regulatory Accounting Requirements1XLANDCountry variant for regulatory reportingnvarchar20
4TZ28_ARCHIVTAsset Type in acc. with Reg.Acctng Requirements / Text3XLANDCountry variant for regulatory reportingnvarchar20
5TZ28_UMSUmsetzungstab. Gesetzesänderung BAV 20021XLANDLändervariante für das Meldewesennvarchar20
6TZ41Customizing reg. report. fld. ctrl. for prem. res. fund1XLANDCountry variant for regulatory reportingnvarchar20
7TZBAGOutput control for BAV reports2XLANDCountry variant for regulatory reportingnvarchar20
TOPLoans Management
8TZ34Value Table Credit Type Regulatory Reporting1XLANDCountry variant for regulatory reportingnvarchar20
9TZ34TText Table Credit Type Regulatory Reporting2XLANDCountry variant for regulatory reportingnvarchar20
10TZ35Value table credit class regulatory reporting1XLANDCountry variant for regulatory reportingnvarchar20
11TZ35TText table for credit class regulatory reporting2XLANDCountry variant for regulatory reportingnvarchar20
TOPPayment Transactions
12T015VApplication Area for Instructions in Payment Transactions2XLANDIndicator: Countrynvarchar10
TOPRegulatory reporting for insurance companies
13ISSRBEZCustomizingstabelle für Listandrucke1XLANDVariante paese per il reportingnvarchar20
14TISR1Asset Type According to Regulatory Accounting Requirements1XLANDCountry variant for regulatory reportingnvarchar20
15TISSR_CTR_TO_CVISSR: Zuweisung des Länderkennzeichens zu einerMW-Variante2XLANDLändervariante für das Meldewesennvarchar20
16TISSR_CTR_TO_CVTISSR: Zuweisung des Länderkennzeichens zu einerMW-Variante3XLANDLändervariante für das Meldewesennvarchar20
TOPTreasury
17TZ25Regulatory reporting list control1XLANDCountry variant for regulatory reportingnvarchar20
18TZ25TIndicator for list selection2XLANDCountry variant for regulatory reportingnvarchar20
19TZ28Asset Type According to Regulatory Accounting Requirements1XLANDCountry variant for regulatory reportingnvarchar20
20TZ28TAsset Type in acc. with Reg.Acctng Requirements / Text3XLANDCountry variant for regulatory reportingnvarchar20
21TZ29BAV asset group stmt 6001XLANDCountry variant for regulatory reportingnvarchar20
22TZ29PCheck table for indicator SNW6001XLANDCountry variant for regulatory reportingnvarchar20
23TZ29TBAV asset group stmt 600 / Text3XLANDCountry variant for regulatory reportingnvarchar20
24TZ30Premium reserve fund list1XLANDCountry variant for regulatory reportingnvarchar20
25TZ30TPremium reserve fund list number / Text3XLANDCountry variant for regulatory reportingnvarchar20
26TZ31Subsection1XLANDCountry variant for regulatory reportingnvarchar20
27TZ31TSubsection / Text3XLANDCountry variant for regulatory reportingnvarchar20
28TZ32BAV asset group stmt 1021XLANDCountry variant for regulatory reportingnvarchar20
29TZ32TBAV asset group stmt 102 / Text3XLANDCountry variant for regulatory reportingnvarchar20
30TZ36Check table for R5/97 appendix 3/41XLANDCountry variant for regulatory reportingnvarchar20
31TZ36TText table for indicator appendix 3/4 circular R5/972XLANDCountry variant for regulatory reportingnvarchar20
32TZ37Indicator for circular R5/97 appendix 51XLANDCountry variant for regulatory reportingnvarchar20
33TZ37TText table provision of security according to app. 5 R5/972XLANDCountry variant for regulatory reportingnvarchar20
34TZ38Indicator for circular R5/97 appendix 81XLANDCountry variant for regulatory reportingnvarchar20
35TZ38TText table for indicator reason for message appendix 8 R5/972XLANDCountry variant for regulatory reportingnvarchar20
36TZ39Indicator for circular R5/97 appendix 101XLANDCountry variant for regulatory reportingnvarchar20
37TZ39BRelationship table indicator R5/97 append. 10 for prod. cat.1XLANDCountry variant for regulatory reportingnvarchar20
38TZ39TText table indicator appendix 10 R5/97 mix type2XLANDCountry variant for regulatory reportingnvarchar20
39TZ40Customizing regulatory reporting field control for contract1XLANDCountry variant for regulatory reportingnvarchar20
40TZ45Headings for BAV Lists4XLANDCountry variant for regulatory reportingnvarchar20
41TZBZCompany code: Additional data30XLANDCountry variant for regulatory reportingnvarchar20