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  | XKBEZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TD05TTexts for table TD05 target groups4XKBEZShort Namenvarchar150
2TD13TText table for TD13 (Contact/offer acceptance type)4XKBEZShort Namenvarchar150
3TD14TText table for TD14 (Tax preferential treatment ID)5XKBEZShort Namenvarchar150
4TD15TResidential development financing types (text table)4XKBEZShort Namenvarchar150
5TD22TTexts for special arrangement indicators4XKBEZShort Namenvarchar150
6TDL1TCollat.securities special treatment ID text table4XKBEZShort Namenvarchar150
7TDL21TText Table Indicator Guarantee Type 24XKBEZShort Namenvarchar150
8TDL2TText Table for Guarantee Type 1 Indicator4XKBEZShort Namenvarchar150
9TDO1TTexts for TD01 Object Construction Methods4XKBEZShort Namenvarchar150
10TDO2TText table for TD02 part of building name4XKBEZShort Namenvarchar150
11TDO3TValuation qualification ID// Text for TD034XKBEZShort Namenvarchar150
12TDO4TType of valuation procedure// Texts for TDO44XKBEZShort Namenvarchar150
13TDO5TRating base valuation// Texts for TDO54XKBEZShort Namenvarchar150
14TDO6TText table for land registry indicator4XKBEZShort description of land register typenvarchar150
15TDO7TText table for administration cost elements4XKBEZShort Namenvarchar150
16TDP0TSelection, Modification and Reference Field Texts4XKBEZShort Namenvarchar150
17TDP1TFile register definition texts5XKBEZShort Namenvarchar150
18TDP2TFile Functions Texts5XKBEZShort Namenvarchar150
19TDZWTIS-IS: Payment terms with adjustment days5XKBEZShort Namenvarchar150
20TIV0ARU Usage type ID's5XKBEZShort description of external usage type of rental unitnvarchar150
21TIV10Bus. entity location4XKBEZShort description of location of business entitynvarchar150
22TIV16Maintenance district4XKBEZShort description of maintenance districtnvarchar150
23TIV1CInternal usage types for rental unit: Texts4XKBEZShort Namenvarchar150
24TIV28Corporate group type - Table no longer used3XKBEZShort Namenvarchar150
25TIV30Tenant service in a company3XKBEZShort Namenvarchar150
26TIV5BCost elements text table TIV516XKBEZShort Namenvarchar150
27TIV5DAccountancy firms fuel types - Texts6XKBEZShort Namenvarchar150
28TIV5ETexts for fuel types (Darwin)5XKBEZShort Namenvarchar150
29TIV5TClassification of real estate objects (Text for TIV5A)4XKBEZShort description of object typenvarchar150
30TIV6ANames of institutions supplying credit information4XKBEZShort Namenvarchar150
31TIV6BCredit standing of real estate applicant - Texts4XKBEZDescription of credit standing of applicationnvarchar150
32TIV6TTIV60 Names5XKBEZShort Namenvarchar150
33TZB0GTexts for relationship indicators4XKBEZShort Namenvarchar150
34TZB0HTexts for posting control indicator4XKBEZShort Namenvarchar150
35TZFBTText table for TZFB Calculation base5XKBEZShort description of calculation basenvarchar150
36TZK0GTexts for condition type-dependent detailed description6XKBEZShort Namenvarchar150
37TZV0FInternal position/employee group text table4XKBEZShort Namenvarchar150
38TZW01TText table for TZW01 Application areas for resubmission4XKBEZShort Namenvarchar150
TOPBusiness Partner
39TD05T_AT_FSIS-IS: Texts for TD05_AT4XKBEZShort Description of OeNB Target Groupnvarchar150
TOPBusiness Partner Enhancements for Financial Services
40TZDGAAdditional User-Specific Partner Data 1: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
41TZDGBAdditional User-Specific Partner Data 2: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
42TZDGCAdditional User-Specific Partner Data 3: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
43TZDGDAdditional User-Specific Partner Data 4: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
44TZDGEAdditional User-Specific Partner Data 5: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
45TZDGFAdditional User-Specific Partner Data 6: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
46TZDGGAdditional User-Specific Partner Data 7: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
47TZDGHAdditional User-Specific Partner Data 8: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
48TZDGIAdditional User-Specific Partner Data 9: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
49TZEGAAdditional User-Specific Partner Data 10: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
50TZEGBAdditional User-Specific Partner Data 11: Text Table4XKBEZShort Description of OeNB Target Groupnvarchar150
TOPLoans Management
51TD01TText elements for TD01 Collat.sec.type4XKBEZShort Namenvarchar150
52TD02TText Table for TD02 Loan Classes4XKBEZShort Namenvarchar150
53TD03TTexts for Table TD03 security types4XKBEZShort Namenvarchar150
54TD06AText table for TD061 Type of File4XKBEZShort Namenvarchar150
55TD07TPurpose of loan (Texts for table TD07)6XKBEZShort Namenvarchar150
56TD16TTexts for borrower's note loan securities4XKBEZShort Namenvarchar150
57TDDGAUser-specific loans key 1 text table4XKBEZShort Namenvarchar150
58TDDGBUser-specific loans key 2 text table4XKBEZShort Namenvarchar150
59TDDGCUser-specific loan key 3 text tables4XKBEZShort Namenvarchar150
60TDDGDUser-specific loan key 4 texts4XKBEZShort Namenvarchar150
61TDL3TPledge status indicator text table4XKBEZShort Namenvarchar150
62TDMAHNS_MANTLoans: Text for Manual Dunning Level4XKBEZShort Namenvarchar150
63TDO10TIndicator for Condition of Object (Description)4XKBEZNamenvarchar300
64TDO11TIndicator for Collateral Object Features (Description)4XKBEZNamenvarchar150
65TDO12TObject Area Description Indicator (Description)4XKBEZNamenvarchar150
66TDO8TProperty Conditions for Collateral Objects (Description)4XKBEZNamenvarchar150
67TDP6TFile categories4XKBEZShort Namenvarchar150
68TZV0EType of restraint on drawing: Text table4XKBEZShort Namenvarchar150
TOPReal Estate Management
69TIV1RLanguage table for security deposit types view4XKBEZShort description of type of rental collateralnvarchar150
70TIV2FText table for Real Estate Contract Type (table TIV26)5XKBEZShort description of RE contract typenvarchar150
71TIV2GText Table for Lease-Out Adjustment Type (TIV27)5XKBEZShort description of LO adjustment typenvarchar150
72TIV50Heating Costs / Heating Systems Settlement Company4XKBEZShort name of heating costs/heating systems accountancy firmnvarchar150
73TIVBCUsage type per development plan (texts)5XKBEZShort description usage type acc. to development plannvarchar150
TOPTransaction Manager
74VTBFININHeader Table for Financial Products4XKBEZShort description of financial instrumentnvarchar100
TOPTreasury
75TD05T_ATIS-IS: Texts for TD05_AT4XKBEZShort Namenvarchar150
76TDO9TType of Heritable Building Right (Descriptions)4XKBEZNamenvarchar150
77TZ24TRelationship key contracting party classification (Text)4XKBEZShort Namenvarchar150