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

70 columns | Print definition?ERP 6.0  | INDUSTRY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_HDRMaster Project Header21INDUSTRYIndustrynvarchar50
2/CPD/D_MP_REP_ATReporting Attribute Node12INDUSTRYIndustrynvarchar50
3BBP_INDUSTRY_FAVUser-Specific Favorites for Industry Sectors3INDUSTRYIndustrynvarchar100
4BTP_DL_KW_CTXTable to maintain Knowledge Warehouse context3INDUSTRYKW: Industry (Description for a product)nvarchar100
5FTBB_YC_REF_ENTAttributes of Reference Entity10INDUSTRYIndustrynvarchar100
TOPABAP Authorization and Role Management
6CUS_INDUComparison Values for Industry1INDUSTRYIndustrynvarchar150
TOPASAP AcceleratedSAP
7SASAPIALPUser Parameters for ASAP Transactions4INDUSTRYEnhancementnvarchar100
TOPConditions
8A600IDES_Global Agreement for Valuation, depend on the Catagory6INDUSTRYIndustry Sectornvarchar40
TOPCross-Application Components
9/KYK/A_INDUSTRYActive industries2INDUSTRYSupported industrynvarchar100
10/KYK/INDUSTRIESSupported industries1INDUSTRYSupported industrynvarchar100
11/KYK/INDUSTRIESTSupported industries - description1INDUSTRYSupported industrynvarchar100
12/KYK/TAGSTransaction tags2INDUSTRYSupported industrynvarchar100
TOPE-Recruiting
13HRP5103DB Table for Infotype 510322INDUSTRYIndustrynvarchar40
14HRP5106DB Table for Infotype 510621INDUSTRYIndustrynvarchar40
15HRP5121DB Table for Infotype 512125INDUSTRYIndustrynvarchar40
16HRP5126DB Table for Infotype 512619INDUSTRYIndustrynvarchar40
17HRP9901eQuest Posting Information45INDUSTRYeQuest Industry Codenvarchar80
18T77RCF_INDUIndustries2INDUSTRYIndustrynvarchar40
19T77RCF_INDU_TIndustries3INDUSTRYIndustrynvarchar40
TOPGeneral Ledger
20/EACA/TGLTEMPLATCustomizing Templates in the G/L1INDUSTRYIndustry that uses general ledgers in e-Accountingnvarchar100
TOPIncentive and Commission Management ICM
21A197A1976INDUSTRYSector industrialnvarchar40
22A198A1985INDUSTRYSector industrialnvarchar40
23YCRM01_B_VAR_OBJVariants for Commission Case Object Data17INDUSTRYIndustry Sectornvarchar40
24YCRM01_DOCVACommission Document, Valuation6INDUSTRYIndustry Sectornvarchar40
25YCRM01_OBJCommission Case Object Data8INDUSTRYIndustry Sectornvarchar40
26YHITEC_B_VAR_OBJVariants for Commission Case Object Data5INDUSTRYIndustry Sectornvarchar40
27YHITEC_DOCVACommission Document, Valuation5INDUSTRYIndustry Sectornvarchar40
28YHITEC_OBJCommission Case Object Data7INDUSTRYIndustry Sectornvarchar40
29YTEL05_B_VAR_OBJVariants for Commission Case Object Data17INDUSTRYIndustry Sectornvarchar40
30YTEL05_DOCVACommission Document, Valuation5INDUSTRYIndustry Sectornvarchar40
31YTEL05_OBJCommission Case Object Data20INDUSTRYIndustry Sectornvarchar40
TOPIntegration Customer Relationship Management
32ECRM_REPL_HDHeader Data for IS-U Sales Replication Error Handling7INDUSTRYIndustry Sector (Master Data Generator)nvarchar10
TOPJob Pricing
33T71JPR08Survey Statistical Data9INDUSTRYSurvey Industry Codenvarchar40
34T71JPR11Survey Industry4INDUSTRYSurvey Industry Codenvarchar40
35T71JPR12Survey Industry Code3INDUSTRYSurvey Industry Codenvarchar40
36T71JPR12TSurvey Industry Code Text4INDUSTRYSurvey Industry Codenvarchar40
TOPKnowledge Warehouse
37IWBENTRY_SKEn: Info Object Browser Defaults7INDUSTRYEnhancementnvarchar100
38IWBKEYWRDInfo Workbench: Keywords (language-independent information)5INDUSTRYIndustry sector (localization)nvarchar100
39IWBKEYWRDTInfo Workbench: Keywords (language-dependent information)6INDUSTRYIndustry sector (localization)nvarchar100
40IWB_EHP_CONTEXTHAssignments Between EHP / SP / APPL and KW Contexts6INDUSTRYEnhancementnvarchar100
41IWB_EHP_CONTEXTVAssignments: EHP / SP / APPL and KW Contexts (History)6INDUSTRYEnhancementnvarchar100
42IWFTRANSFolders and IOs Scheduled for Translation10INDUSTRYEnhancementnvarchar100
43IWH_31_LNK3.1: Help Links (only for customer solution for 3.1)14INDUSTRYEnhancementnvarchar100
44IWINDUSTRYKEN: Industry sectors and their root sectors1INDUSTRYName of an Add-On Productnvarchar100
45IWR3LRESResults of Help Links Check26INDUSTRYEnhancementnvarchar100
46IWREFERENCIWB: Info Object Where-Used References14INDUSTRYEnhancementnvarchar100
47IWSTRANSStructures Designated for Translation9INDUSTRYEnhancementnvarchar100
48IWTREFERENCIWB: Info Object Where-Used References16INDUSTRYEnhancementnvarchar100
49KWCHAINKEN: Industry sectors and their root sectors1INDUSTRYName of an Add-On Productnvarchar100
50KWD_RFC2BIRFC Destinations for Different Contexts2INDUSTRYName of an Add-On Productnvarchar100
TOPLocalization
51J_1BBRANCHBusiness Place8INDUSTRYBusiness Place CFOP Categorynvarchar20
TOPManagement of Internal Controls
52HRP1800DB Table for InfoType 180018INDUSTRYIndustrynvarchar100
53HRT1800Table Section for InfoType 18004INDUSTRYIndustrynvarchar100
TOPMaster Data
54EPDPRODIS-U Master Data Generator: Master Data Template12INDUSTRYIndustry Sector (Master Data Generator)nvarchar10
55EPDTYPEIS-U Master Data Generator: Master Data Template Category12INDUSTRYIndustry Sector (Master Data Generator)nvarchar10
TOPOffer and Rental Request
56VIOROFContract Offer28INDUSTRYIndustrynvarchar100
TOPProcess Controls
57HRP5300DB Table for Infotype 530018INDUSTRYIndustrynvarchar100
TOPProfitability Analysis
58/EACA/TPMVARIASSVariant: Assignments6INDUSTRYIndustry for Templates from Profitability Analysisnvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
59DFMCA_BRF920BRF: Update Business Partner Industry Code8INDUSTRYBRF: Expressionnvarchar200
TOPReal Estate Contract
60VICNCNReal Estate Contract29INDUSTRYIndustrynvarchar100
TOPReal Estate Management
61VICN01Real Estate Contract: Contract Data100INDUSTRYIndustrynvarchar100
TOPTalent Management
62HRP7403External Work Experience22INDUSTRYIndustrynvarchar40
63T77TMC_INDUIndustries2INDUSTRYIndustrynvarchar40
64T77TMC_INDUTIndustries3INDUSTRYIndustrynvarchar40
TOPTerminologyGlossary
65GLOSSARY1Table with Glossary Entries5INDUSTRYNamespacenvarchar100
66STERM_LINKLink Between Concept and Associated Terms7INDUSTRYKW Attribute: Industry in SAPtermnvarchar100
67STERM_Q_CHECKTable for Terminology Check20INDUSTRYKW Attribute: Industry in SAPtermnvarchar100
TOPTranslation Tools
68BRAN1Assignment of Industry Text Editor to Package2INDUSTRYIndustrynvarchar50
69NOINDTables Excluded from Conversion1INDUSTRYIndustrynvarchar50
70TSKTWIndustry short text replacements2INDUSTRYIndustrynvarchar50