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

30 columns | Print definition?ERP 6.0  | ROLETYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1VDSEPA_MND_USGOverview of mandates used in Loans Management6ROLETYPBP Rolenvarchar60
TOPBusiness Partner Enhancements for Financial Services
2BP1000BP: Business Partner - Role3ROLETYPBusiness Partner Role Categorynvarchar40
3TPZ13Business Partner: Application Role Category - Assignment3ROLETYPBusiness Partner Role Categorynvarchar40
4TPZ14Business Partner: Role Category Text ID - Assignment2ROLETYPBusiness Partner Role Categorynvarchar40
5TPZ3BP: Business Partner - Role Category2ROLETYPBusiness Partner Role Categorynvarchar40
6TPZ3TBP: Business Partner - Name of Role Category3ROLETYPBusiness Partner Role Categorynvarchar40
7TPZ5BP: Business Partner - Role category-View - Assignment2ROLETYPBusiness Partner Role Categorynvarchar40
8TPZ6BP: Business Partner - Role Type3ROLETYPBusiness Partner Role Categorynvarchar40
TOPFlexible Real Estate Management
9ATIVABGBHEBTab. TIVABGBHEB Änderungsbelegstruktur manuell erzeugt3ROLETYPGeschäftspartner-Rollentypnvarchar40
10TIVABGBHEBLUM: Hebesätze f. Grundsteuerermittlung im Abgabenbescheid3ROLETYPGeschäftspartner-Rollentypnvarchar40
11TIVHOCP01Real Estate Correspondenz: Zuordnung Formular zu KV6ROLETYPGeschäftspartner-Rollentypnvarchar40
12VIFEIGENTLUM: Flurstück - Eigentümer12ROLETYPGeschäftspartner-Rollentypnvarchar40
TOPLoans Management
13TDKK2Predefine Correspondence Class Assignment for Partner3ROLETYPBP Rolenvarchar60
14TDLOAN_CPPARTDefault Sttng of Permitted Roles and Roles for Partner Copy4ROLETYPBP Rolenvarchar60
15TDP6File categories3ROLETYPRole Category of Administratornvarchar60
16TDV07Alloc.of application/role category/dunning parameters3ROLETYPBP Rolenvarchar60
17TDV08Alloc.of application/role category/dunning parameters3ROLETYPBP Rolenvarchar60
18VDGPOLoan: Relationship Partner/Role Object5ROLETYPBP Rolenvarchar60
19VDINSURE_PARTNE0Do Not Use: Link Partner <-> Insurance4ROLETYPBP Rolenvarchar60
TOPReal Estate Management
20S401RE standard analysis partner62ROLETYPBusiness Partner Role Categorynvarchar40
21TIV26Real Estate Contract Type (Entities)17ROLETYPBusiness Partner Role Categorynvarchar40
22TIVCPOI01Recipients4ROLETYPBusiness Partner Role Categorynvarchar40
23TIVCPOI02Partner Assignment in the Includes of the OI Print Structure4ROLETYPBusiness Partner Role Categorynvarchar40
24VIEIGEOwners of real estate objects9ROLETYPBusiness Partner Role Categorynvarchar40
TOPTransaction Manager
25AT81Correspondence type4ROLETYPBusiness Partner Rolenvarchar60
26VTBKORESCorrespondence Data33ROLETYPBusiness Partner Rolenvarchar60
27VTBMAPAMaster Agreement: Permitted Bus. Partners4ROLETYPBP Role Categorynvarchar60
TOPTreasury
28TZV07Alloc.of application/role category/dunning parameters3ROLETYPBusiness Partner Role Categorynvarchar40
29TZZKDIS-IS: Business trans./Role alloc. --> Doc.category7ROLETYPBusiness Partner Role Categorynvarchar40
30VZGPOPartner/role object relationship5ROLETYPBusiness Partner Role Categorynvarchar40