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

50 columns | Print definition?ERP 6.0  | PRODINT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_BCAPRFill Header for BCAPR3PRODINTChar 18 for TDMSnvarchar180
TOPAccount Management
2TBKKNTC_NTCAMTNotice: Calculation of Available Amount3PRODINTInternal Product IDnvarchar180
3TBKK_4EYES_NTCNotice: Dual Control for Each Bank Area/Product/Category3PRODINTInternal Product IDnvarchar180
4TBKK_DC_NTC_AUTHNotice: Amount Authorization3PRODINTInternal Product IDnvarchar180
TOPBank Customer Accounts
5BKKARCPERIODArchived Periods3PRODINTInternal Product IDnvarchar180
6BKKARCPERIODFILEArchived Periods per Archive File4PRODINTInternal Product IDnvarchar180
7TBCA_US_DEA_PROCross Reference Escheat Property Codes4PRODINTInternal Product IDnvarchar180
8TBCA_US_DEA_PROTProperty Type Codes Text Description5PRODINTInternal Product IDnvarchar180
9TBCA_US_PAY_AMTOverdraft transaction sequence for Products3PRODINTInternal Product IDnvarchar180
10TBCA_US_TRAN_SEQOverdraft transaction priority sequence for Products3PRODINTInternal Product IDnvarchar180
11TBKKARCPERIODArchiving Periods3PRODINTInternal Product IDnvarchar180
12TBKKSOAUTHAmount Authorization/Dual Control Standing Order3PRODINTInternal Product IDnvarchar180
13TBKKTRMMINDEPMinimum Deposit for Each Term3PRODINTInternal Product IDnvarchar180
14TFIPR_SETTCOMBFeature Combination2PRODINTInternal Product IDnvarchar180
TOPCondition
15TBKK8IWPeriods for Interest Guarantee for Offers3PRODINTInternal Product IDnvarchar180
TOPDefault Risk and Limit System
16KLARRZU03Assign DRR and Limit Product Group to BCA Product (New)2PRODINTInternal Product IDnvarchar180
TOPInterestCharge Calculation
17BKKM3BCA: Parameters for Mass Runs in Parallel Processing37PRODINTInternal Product IDnvarchar180
18TBKKMNEXTDTIncrease Next Date for Bank Statement Table3PRODINTInternal Product IDnvarchar180
TOPLoans Management
19TDPR_PRODUCTProduct, Master Data2PRODINTInternal Product IDnvarchar180
20TDPR_PRODUCTTProduct Description3PRODINTInternal Product IDnvarchar180
21TDPR_PRODVVersion of a Prodcut, Master Data2PRODINTInternal Product IDnvarchar180
22TDPR_VAVersion Attribute2PRODINTInternal Product IDnvarchar180
23TDPR_VA_FLDVersion Attribute Category Field2PRODINTInternal Product IDnvarchar180
24TDPR_VA_FLDMVersion Attribute Category Field: Multiple Value Fields2PRODINTInternal Product IDnvarchar180
TOPMarket Risk Analyzer
25VTVBKKBW02RM: Assignment of Valuation Rule to BCA Product (New)2PRODINTInternal Product IDnvarchar180
TOPMaster Data
26BKK42Current Account Master Data: Operative Data8PRODINTInternal Product IDnvarchar180
27BKK_4EYES_CLOSAccount Closure Principle of Dual Control3PRODINTInternal Product IDnvarchar180
28BKK_MIN_DEPMinimum Deposit for Each Product3PRODINTInternal Product IDnvarchar180
29TBKKE_FOUR_EYESLimits: Validity of Principle of Dual Control3PRODINTInternal Product IDnvarchar180
30TBKKHLDAUTHAmount Authorization/Permanent Holds3PRODINTInternal Product IDnvarchar180
TOPPayment Item
31TBKK01ECpD-accounts for different processes3PRODINTInternal Product IDnvarchar180
32TBKKG10Assignment of Recipient Payment Details for Product3PRODINTInternal Product IDnvarchar180
33TBKKIAUTHAmount Authorization/Dual Control Payment Items3PRODINTInternal Product IDnvarchar180
34TBKKIO1Posting Day Shift Forward for Automatic Forward Orders3PRODINTInternal Product IDnvarchar180
TOPPayment Order
35TBKKG2_DATE_PLSettings for Date Calculation in Planned Orders3PRODINTInternal Product IDnvarchar180
36TBKKOAUTHAmount Authorization/Dual Control Payment Order3PRODINTInternal Product IDnvarchar180
TOPPortfolio
37VDCO_PRO_ASS1Assignment: Product + Parameters ---> Condition Table2PRODINTInternal Product IDnvarchar180
38VDCO_PRO_ASS2Assignment: Product ---> Condition Table2PRODINTInternal Product IDnvarchar180
TOPProduct definition
39FIPR_PARTPRODAssignment Version Partial Product2PRODINTInternal Product IDnvarchar180
40FIPR_PRODUCTProduct, Master Data2PRODINTInternal Product IDnvarchar180
41FIPR_PRODUCTTProduct Description3PRODINTInternal Product IDnvarchar180
42FIPR_PRODVVersion of a Prodcut, Master Data2PRODINTInternal Product IDnvarchar180
43FIPR_VAVersion Attribute2PRODINTInternal Product IDnvarchar180
44FIPR_VA_FLDVersion Attribute Category Field2PRODINTInternal Product IDnvarchar180
45FIPR_VA_FLDMVersion Attribute Category Field: Multiple Value Fields2PRODINTInternal Product IDnvarchar180
46FIPR_VA_FLDVALVersion Attribute Category Field: Value Restriction2PRODINTInternal Product IDnvarchar180
47FIPR_VA_VALUEVersion Attribute Category List2PRODINTInternal Product IDnvarchar180
48FIPR_VA_VALUE2Version Attribute Category Matrix2PRODINTInternal Product IDnvarchar180
49TBKKH1Permitted Products per Bank Area3PRODINTInternal Product IDnvarchar180
TOPTransaction Data Pool
50JBDTDALLBCAAssignment of BCA Product to Transaction Differentiations2PRODINTInternal Product IDnvarchar180