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

77 columns | Print definition?ERP 6.0  | XLBEZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TD05TTexts for table TD05 target groups5XLBEZNamenvarchar500
2TD13TText table for TD13 (Contact/offer acceptance type)5XLBEZNamenvarchar500
3TD14TText table for TD14 (Tax preferential treatment ID)6XLBEZNamenvarchar500
4TD15TResidential development financing types (text table)5XLBEZNamenvarchar500
5TD22TTexts for special arrangement indicators5XLBEZNamenvarchar500
6TDBLTText table for TDBL (debit and income types)5XLBEZLong text for form item typesnvarchar700
7TDL1TCollat.securities special treatment ID text table5XLBEZNamenvarchar500
8TDL21TText Table Indicator Guarantee Type 25XLBEZNamenvarchar500
9TDL2TText Table for Guarantee Type 1 Indicator5XLBEZNamenvarchar500
10TDO1TTexts for TD01 Object Construction Methods5XLBEZNamenvarchar500
11TDO2TText table for TD02 part of building name5XLBEZNamenvarchar500
12TDO3TValuation qualification ID// Text for TD035XLBEZNamenvarchar500
13TDO4TType of valuation procedure// Texts for TDO45XLBEZNamenvarchar500
14TDO5TRating base valuation// Texts for TDO55XLBEZNamenvarchar500
15TDO6TText table for land registry indicator6XLBEZLong Description of Land Register Typenvarchar500
16TDO7TText table for administration cost elements6XLBEZNamenvarchar500
17TDP0TSelection, Modification and Reference Field Texts5XLBEZNamenvarchar500
18TDP1TFile register definition texts6XLBEZNamenvarchar500
19TDP2TFile Functions Texts6XLBEZNamenvarchar500
20TDZWTIS-IS: Payment terms with adjustment days6XLBEZNamenvarchar500
21TIV20Rep.list of rents master data3XLBEZDescription of representative list of rentsnvarchar500
22TIV23Fixtures/Fittings Categories4XLBEZDescription of fixture and fitting categorynvarchar500
23TIV70Surcharge/reduction categories4XLBEZNamenvarchar500
24TIV7AFixture and fitting feature texts4XLBEZDescription of characteristicnvarchar500
25TZB0GTexts for relationship indicators3XLBEZNamenvarchar500
26TZB0HTexts for posting control indicator5XLBEZNamenvarchar500
27TZFBTText table for TZFB Calculation base4XLBEZDescription of calculation basenvarchar500
28TZK0GTexts for condition type-dependent detailed description8XLBEZNamenvarchar500
29TZN04Standard check digit procedure table3XLBEZNamenvarchar500
30TZV0FInternal position/employee group text table5XLBEZNamenvarchar500
TOPBusiness Partner
31TD05T_AT_FSIS-IS: Texts for TD05_AT5XLBEZDescription of OeNB Target Groupnvarchar500
TOPBusiness Partner Enhancements for Financial Services
32TZDGAAdditional User-Specific Partner Data 1: Text Table5XLBEZNamenvarchar500
33TZDGBAdditional User-Specific Partner Data 2: Text Table5XLBEZNamenvarchar500
34TZDGCAdditional User-Specific Partner Data 3: Text Table5XLBEZNamenvarchar500
35TZDGDAdditional User-Specific Partner Data 4: Text Table5XLBEZNamenvarchar500
36TZDGEAdditional User-Specific Partner Data 5: Text Table5XLBEZNamenvarchar500
37TZDGFAdditional User-Specific Partner Data 6: Text Table5XLBEZNamenvarchar500
38TZDGGAdditional User-Specific Partner Data 7: Text Table5XLBEZNamenvarchar500
39TZDGHAdditional User-Specific Partner Data 8: Text Table5XLBEZNamenvarchar500
40TZDGIAdditional User-Specific Partner Data 9: Text Table5XLBEZNamenvarchar500
41TZEGAAdditional User-Specific Partner Data 10: Text Table5XLBEZNamenvarchar500
42TZEGBAdditional User-Specific Partner Data 11: Text Table5XLBEZNamenvarchar500
TOPFlexible Real Estate Management
43VIFLURST_HIERARLUM: Reporting - Arbeitstabelle Flurstücke nach Hierarchie5XLBEZHierarchieebenenvarchar500
44VIFLURST_HIERAR2LUM: Reporting - Arbeitstabelle Flurstücke nach Hierarchie5XLBEZHierarchieebenenvarchar500
TOPGermany
45TZA11Output control acc. to circular R96 appendix 113XLBEZLong description for asset type acc. to R96 appendix 11nvarchar600
46TZR96A11Text table for circular R96 Appendix 113XLBEZLong description for asset type acc. to R96 appendix 11nvarchar600
TOPLoans Management
47ATRESERVATIONTOffer/Acceptance Reservation Indicator4XLBEZNamenvarchar500
48TD01TText elements for TD01 Collat.sec.type5XLBEZNamenvarchar500
49TD02TText Table for TD02 Loan Classes5XLBEZNamenvarchar500
50TD03TTexts for Table TD03 security types5XLBEZNamenvarchar500
51TD06AText table for TD061 Type of File5XLBEZNamenvarchar500
52TD07TPurpose of loan (Texts for table TD07)7XLBEZNamenvarchar500
53TD16TTexts for borrower's note loan securities6XLBEZNamenvarchar500
54TDDGAUser-specific loans key 1 text table5XLBEZNamenvarchar500
55TDDGBUser-specific loans key 2 text table5XLBEZNamenvarchar500
56TDDGCUser-specific loan key 3 text tables5XLBEZNamenvarchar500
57TDDGDUser-specific loan key 4 texts5XLBEZNamenvarchar500
58TDL3TPledge status indicator text table5XLBEZNamenvarchar500
59TDMAHNS_MANTLoans: Text for Manual Dunning Level5XLBEZNamenvarchar500
60TDO10TIndicator for Condition of Object (Description)5XLBEZText Fieldnvarchar500
61TDO11TIndicator for Collateral Object Features (Description)5XLBEZNamenvarchar300
62TDO12TObject Area Description Indicator (Description)5XLBEZNamenvarchar300
63TDO8TProperty Conditions for Collateral Objects (Description)5XLBEZNamenvarchar300
64TDP6TFile categories5XLBEZNamenvarchar500
65TDSTOP_ACTION_TText Elements for TDSTOP_ACTION Stop Actions3XLBEZName of Stop Actionnvarchar800
66TDSTOP_TText Elements for TDSTOP Stops4XLBEZName of Stopnvarchar1000
67TZV0EType of restraint on drawing: Text table5XLBEZNamenvarchar500
68VDBLPODebit types-Items13XLBEZLong text for form item typesnvarchar700
69VZFZE_VDNBZECentral Entry Table for Release Procedure17XLBEZField of length 16nvarchar160
TOPReal Estate Contract
70TIVCDREFFLOWRELTRelationship Type Between Flow Type and Ref.Flow Type (Text)3XLBEZNamenvarchar500
TOPReal Estate Management
71TIV2CCharacteristics classes - Names5XLBEZLong text of fixture and fitting categorynvarchar500
72TIV2JRepresentative list of rents master texts4XLBEZDescription of representative list of rentsnvarchar500
73TIV70TSurch./reduction classes - Texts language-dep.5XLBEZNamenvarchar500
TOPTransaction Manager
74VTBFININHeader Table for Financial Products5XLBEZLong description of financial instrumentnvarchar500
TOPTreasury
75TD05T_ATIS-IS: Texts for TD05_AT5XLBEZNamenvarchar500
76TDO9TType of Heritable Building Right (Descriptions)5XLBEZNamenvarchar300
77TZ24TRelationship key contracting party classification (Text)5XLBEZNamenvarchar500