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

22 columns | Print definition?ERP 6.0  | KTTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_KTO_PRPRBD Account. Master Data7KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
2P2B2_ZKOHCM Declustering B2 - Quota Changes (Table ZKO)8KTTYPQuota typenvarchar10
TOPBasic Data
3NKTRIS-H: Business Partners/Insurance Providers3KTTYPIS-H: Indicator Denoting Insurance Provider Groupnvarchar10
TOPData Transfer
4T52EPAccount Assignment Type3KTTYPSymbolic Account Typenvarchar10
TOPPension fund General Parts
5T72FAHR-PF: FI Index Table16KTTYPSymbolic Account Typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
6TNNC2IS-H NL: Insurance provider types (internal)7KTTYPIS-H NL: Internal insurance provider typenvarchar40
TOPThird Party Remittance
7T51R6_FUNDINFORemittance detail table for all entities14KTTYPSymbolic Account Typenvarchar10
TOPValue Adjustment
8/IBS/CRB_GATERBD: Assignment of RBD Gate to RBD Flow Types4KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
9/IBS/CRB_IASBEWERBD Relevant Legacy System Flows IAS / IFRS Gate Fill4KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
10/IBS/CRB_KTART_PRBD RBD Account Type3KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
11/IBS/CRB_RANKTYPRBD: Rank of RBD Flow Types for Value Adjustment Creation3KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
12/IBS/CRB_RBAARBD Loss Flow Types5KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
13/IBS/CRB_RBDBW_PRBD RBD Flow Types8KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
14/IBS/CRB_RKLUERBD Transfer Risk Classes per RBD Account Category2KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
15/IBS/CRB_ZKKRBD: Obsolete RBD Assignment RBD Class - RBD Acct Category2KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
16/IBS/CRB_ZKRBWRBD Assignment Capital Source System RBD Flow Type5KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
17/IBS/CRB_ZRBWARBD RBD Flow Type Determination7KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
18/IBS/CRB_ZVSKRBD: Assignment Source System to RBD Class4KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
19/IBS/TRB_KTORBD Account. Master Data7KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
20/IBS/TRB_RBDGATERBD: Universal Data Basis/Worklist8KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
21/IBS/TRB_UERBD RBD Individual Documents6KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20
22/IBS/TRB_UE_HISTRBD RBD History of Individual Documents7KTTYPRBD: Value Adjustment Procedure (RBD Account Category)nvarchar20