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

36 columns | Print definition?ERP 6.0  | VAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/HNA_CN_OPTDQM on Hana Country Specific Configuration6VALPossible Values for Country Specifc PV Settingsnvarchar200
2/FLDQ/HNA_PV_VALPossible Vlaues for PV on Hana Country Specific Settings3VALPossible Values for Country Specifc PV Settingsnvarchar200
TOPBasic Functions
3T830AFI-SL Master Record Table3VALSet valuenvarchar240
4T830BFI-SL Master Record Table3VALSet valuenvarchar240
5T830DFI-SL Master Record Table3VALSet valuenvarchar240
6T831AFI-SL Master data text4VALSet valuenvarchar240
7T831BFI-SL Master Record Table4VALSet valuenvarchar240
8T831DFI-SL Master data text4VALSet valuenvarchar240
TOPBusiness Package for Manager Self-Service FI
9FPB_LINE_DATAData Store for Line Item Monitors7VALTotal Value in Controlling Area Currencydecimal152
TOPData Collection
10S174Services20VALOrder value in document currencydecimal152
11S174BIW1S174BIW1 * Activities20VALOrder value in document currencydecimal152
12S174BIW2S174BIW2 * Activities20VALOrder value in document currencydecimal152
TOPFinancials Basis
13UBC_TB_ACTVValues for Account Assignment Fields4VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
14UBC_TB_BILDVALAccount Assignment Default Values on Level of Biller5VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
15UBC_TB_CURMax./Min. Amounts per User and Currency5VALAmount in document currencydecimal132
16UBC_TB_INVHACTAccount Assignments on Bill Header5VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
17UBC_TB_INVPACTAccount Assignments on Level of Item6VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
18UBC_TB_ORGDVALAccount Assignment Default Values on Level of Biller4VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
19UBC_TB_RADVALAccount Assignment Default Values on Level of Bill Type6VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
20UBC_TB_RPADVALAccount Assignment Default Values on Level of Bill Item Type6VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
21UBC_TT_ACTVTexts for Values of Account Assignment Fields4VALValue of Account Assignment Field (G/L Account, Project,...)nvarchar200
TOPGraphic
22TBCRRibbon Attributes Generated with Time Scale Wizard8VALValue in value tablenvarchar800
TOPMapping
23SMPPBINDMapping Parameterization: Binding6VALMapping Parameterization: Valuentext10737418230
24SMPPCONTTest for Mapping Parameterization9VALMapping Parameterization: Valuentext10737418230
TOPPlant Maintenance
25Z9I_STK_CUSTStillstandskontrolle: Steuerungsparameter3VALParameterwertnvarchar400
TOPSchedule Manager
26SMEXTInformation on Results Lists That Have Been Saved5VALUnstructured Data Fieldnvarchar1000
27SMRLInformation on Saved Basic Lists5VALUnstructured Data Fieldnvarchar1000
TOPVirtual Machine Container
28SVMCRT_BINDINGSVMC Runtime: Resources6VALBinary Data of Bindingimage21474836470
TOPWithout Description
29IRTEST_URLVariable Replacement CR2VALValue of an installation parameter for CRnvarchar1280
TOPWork Clearance Management
30WCABWCM: Valuation5VALValuationnvarchar10
31WCABQWCM: Log (Valuation)6VALValuationnvarchar10
32WCACGWCM: WCM Object <-> Catalog12VALValuationnvarchar10
33WCACGQWCM: Log (WCM Object <-> Catalog)13VALValuationnvarchar10
34WCADWCM: Approval Group9VALValuationnvarchar10
35WCADQWCM: Log (Approval Group)10VALValuationnvarchar10
36WCCPVWCM: Approval Groups8VALValuationnvarchar10