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

145 columns | Print definition?ERP 6.0  | PRODUCT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/CTRLItem Process Type - Control Key4PRODUCT_TYPEProduct Typenvarchar20
2/SAPPSSRM/SOSIndex-Table con. 'Governm. Proc.'-specific sources of supply26PRODUCT_TYPEProduct Typenvarchar20
3/XLSO/ACCESS_CODAccess Code Details Assigned to a Bulk Sales Order6PRODUCT_TYPEProduct Typenvarchar20
4/XLSO/ADVERTISEAdvertisements4PRODUCT_TYPEProduct Typenvarchar20
5/XLSO/ALERTAlerts5PRODUCT_TYPEProduct Typenvarchar20
6/XLSO/RECOM_LRNRRecommendation for Learner4PRODUCT_TYPEProduct Typenvarchar20
7/XLSO/TAGTags for Products2PRODUCT_TYPEProduct Typenvarchar20
8BBPD_PD_INDEXIndex Table for Fast Access to Contracts and AVLs26PRODUCT_TYPEProduct Typenvarchar20
9BBP_ECIDUMMY_MAPMapping Table for Test Module for ECI Simulation3PRODUCT_TYPEProduct Typenvarchar20
10BBP_PDIGPBusiness Transaction Item-Purchasing Information14PRODUCT_TYPEProduct Typenvarchar20
11BBP_PRODUCT_FAVUser-Specific Favorites for Products7PRODUCT_TYPEProduct Typenvarchar20
12COMC_PR_TEXT_MProduct Master Key Conversion R/3 to CRM5PRODUCT_TYPEProduct Typenvarchar20
13COMC_PR_TEXT_PProduct Master Text Types Allowed for Product Type2PRODUCT_TYPEProduct Typenvarchar20
14EPRODDET_SELIS-U: CRM Product Sel Table (for type def, dont populate)3PRODUCT_TYPEProduct Categorynvarchar20
15SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO41PRODUCT_TYPEProduct Typenvarchar20
16TEXT_CTY_EXPOSCommodity Price Exposure62PRODUCT_TYPEProduct Typenvarchar30
17TISSR_RATING_HBHistorie des Wertpapier-Ratings6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
18TLRC_THM_PROD_IGAssign Products to Instrument Groups4PRODUCT_TYPEProduct Typenvarchar30
19TLRT_RISKM_DERDerivation for Risk Mitigation Indicator4PRODUCT_TYPEProduct Typenvarchar30
20TRCCT_TRANSCurrency Changeover Transaction26PRODUCT_TYPEProduct Typenvarchar30
21TREAT_CLEAR_ASGTreasury: Central Clearing Assignement3PRODUCT_TYPEProduct Typenvarchar30
22TREAT_FUT_DIFFTreasury: TREA Differentiation for Deal Position8PRODUCT_TYPEProduct Typenvarchar30
23TRGC_FICLASS_PTClassification of Product and Transaction Types3PRODUCT_TYPEProduct Typenvarchar30
24TRSTC_BUFFERActivation for Security Cash flow buffering2PRODUCT_TYPEProduct Typenvarchar30
25ZMTMPERSCM MtM Persistency13PRODUCT_TYPEProduct Typenvarchar30
TOPBack Office
26TREC_TRANS_TYPETransaction Types for Endowment Investments2PRODUCT_TYPEProduct Typenvarchar30
27TRFC_RATE_TYPERate Type to Convert Margins2PRODUCT_TYPEProduct Typenvarchar30
28TRSC_DFTYPE_NCCFM: Update Types for Nominal Adjustment2PRODUCT_TYPEProduct Typenvarchar30
29TRSC_DFTYPE_SDCFM: Update Type for 'Capitalize Dividends'2PRODUCT_TYPEProduct Typenvarchar30
30TRSC_LEND_TRANSUpdate Types for Securities Account Transfer for Sec.Lending2PRODUCT_TYPEProduct Typenvarchar30
31TRSC_SECACCTRANSTreasury: Update Type for Securities Account Transfer2PRODUCT_TYPEProduct Typenvarchar30
TOPCentral Part of Product Master
32COMC_PRT_ALTIDPRAssign ID Profile to Product Type2PRODUCT_TYPEProduct Typenvarchar20
33COMC_PRVIEW_DEFProduct Workbench Default Setting Views1PRODUCT_TYPEProduct Typenvarchar20
34COMC_PRWB_SM_NEWAssignment: Locator Search Type <--> Product Type1PRODUCT_TYPEProduct Typenvarchar20
35COMC_PR_LOGSYSStorage Form in Logical Systems3PRODUCT_TYPEProduct Typenvarchar20
36COMC_PR_OBJ_FAMObject Family2PRODUCT_TYPEProduct Typenvarchar20
37COMC_PR_TEMPLATEProduct Template for Configurable Products2PRODUCT_TYPEProduct Typenvarchar20
38COMC_PR_TYPEProduct Master Definition of Product Types1PRODUCT_TYPEProduct Typenvarchar20
39COMC_PR_TYPE_GENGeneral Settings for Product Type2PRODUCT_TYPEProduct Typenvarchar20
40COMC_PR_TYPE_NRONumber Assignment Control2PRODUCT_TYPEProduct Typenvarchar20
41COMC_PR_TYPE_TDescription of the Product Types1PRODUCT_TYPEProduct Typenvarchar20
42COMC_PR_TYPE_UPLProduct-Type-Specific Settings for Upload2PRODUCT_TYPEProduct Typenvarchar20
43COMC_SETTYPE_SFWDefinition of Switch per Set Type and Product Type2PRODUCT_TYPEProduct Typenvarchar20
44COMM_IPRODUCTInactive Product4PRODUCT_TYPEProduct Typenvarchar20
45COMM_PRAPPL_HIERProduct Type-Specific Application Area of a Hierarchy3PRODUCT_TYPEProduct Typenvarchar20
46COMM_PRCATProduct Category3PRODUCT_TYPEProduct Typenvarchar20
47COMM_PRCATHProduct Category: History4PRODUCT_TYPEProduct Typenvarchar20
48COMM_PRODUCTProduct4PRODUCT_TYPEProduct Typenvarchar20
49COMM_PRODUCTHProduct History5PRODUCT_TYPEProduct Typenvarchar20
50COMM_PRODUCT_IDXIndex Table for Products6PRODUCT_TYPEProduct Typenvarchar20
51COMM_PROD_FRGProduct Type - Set Type Assignment1PRODUCT_TYPEProduct Typenvarchar20
52COMM_PT_FT_CREATWhich Sets May Be Created for Which Product Type1PRODUCT_TYPEProduct Typenvarchar20
53COMS_PR_TYPE_UOMProduct Type-Specific Settings for Units of Measure1PRODUCT_TYPEProduct Typenvarchar20
TOPClaims Management
54TICL055Benefit Type7PRODUCT_TYPEProduct Type in Procurement Systemnvarchar20
TOPDialog People-Centric UI for Products
55COMC_SETTYPE_BSPSet-Type Customizing for BSP Application3PRODUCT_TYPEProduct Typenvarchar20
TOPeCATT Extended Computer Aided Test Tool
56TZRR_PCITestZone Result Rep.: SUT Product Component Information5PRODUCT_TYPEnvarchar100
TOPInformation System
57TRGC_PAY_REL_LOPayment Relevance of Flow Type for Loans, Operative4PRODUCT_TYPEProduct Typenvarchar30
TOPLoans Management
58TDLOS_DISCHANNELLoan Origination: Assignment of Sales Channels3PRODUCT_TYPEProduct Typenvarchar30
59TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred16PRODUCT_TYPEProduct Typenvarchar30
TOPRegulatory reporting for insurance companies
60ISSRFLDEOObject table 120PRODUCT_TYPEnvarchar80
61ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle10PRODUCT_TYPEISSR: tipo prodotto di reportingnvarchar80
62ISSR_BASI_RGRegistrierungseintrag8PRODUCT_TYPEMeldewesen-Produktartnvarchar80
63ISSR_BASI_RGDONEErledigter Registrierungseintrag8PRODUCT_TYPEMeldewesen-Produktartnvarchar80
64ISSR_IFB_PCPTRTISSR: Beziehungstabelle Mw-PCAT<->Mw-PTYP<->Mw-RANTYP3PRODUCT_TYPEMeldewesen-Produktartnvarchar80
65ISSR_RPI_MFTISSR: Feste und variable Daten Meldewesen7PRODUCT_TYPEMeldewesen-Produktartnvarchar80
66ISSR_RPI_MFT_BCKISSR: Feste und variable Daten Meldewesen als Backuptabelle8PRODUCT_TYPEMeldewesen-Produktartnvarchar80
67TISSR_AA_DS_BCKDurchsicht Fonds unter Berücksichtigung der AnlV6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
68TISSR_ADMIN_FVALFestwertsteuerung für Meldewesen-Stammdatenverwaltung5PRODUCT_TYPEMeldewesen-Produktartnvarchar80
69TISSR_ANL10_DSZuordnung Kennz. Anl.10 zu Fonds für Durchrechnung Fonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
70TISSR_ANLART_DSDurchsicht Fonds unter Berücksichtigung der AnlV6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
71TISSR_ASSET_BCKBACKUP:Stichtagsbezogene Kennzeichen je Anlage gem. R30/20026PRODUCT_TYPEMeldewesen-Produktartnvarchar80
72TISSR_ASSET_R30Stichtagsbezogene Kennzeichen je Anlage gem. R30/20026PRODUCT_TYPEMeldewesen-Produktartnvarchar80
73TISSR_ASSET_R30BStichtagsbez.Kennz. je Anlage gem. R30/2002 (keine WP)7PRODUCT_TYPEMeldewesen-Produktartnvarchar80
74TISSR_BENCHM_DSZuordnung Benchmarkzusammensetzung zum Fonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
75TISSR_BONDTYP_DSZuordnung Wertpapierart um Fonds zur Durchrechnung Fonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
76TISSR_BP_DSDurchsicht Fonds Struktur nach Emittent6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
77TISSR_BRANCH_DSZuordnung Branche zum Fonds für Durchsicht Fonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
78TISSR_CHA_MD_PROProtokoll bei Stammdatenänderung15PRODUCT_TYPEMeldewesen-Produktartnvarchar80
79TISSR_COLL_PL_HCollateral-Pool Historie5PRODUCT_TYPEMeldewesen-Produktartnvarchar80
80TISSR_DS_LOCATDurchsicht nach Sitz und Art des Schuldners6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
81TISSR_EXIT_FEE_HHistorische Darstellung der Exit Fees5PRODUCT_TYPEMeldewesen-Produktartnvarchar80
82TISSR_FOF_RELISSR: Abwicklung Vertragsbedingungen von Dachfonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
83TISSR_FOND_WR_DSEinstellungen zur Fondsdurchsicht je Fonds7PRODUCT_TYPEMeldewesen-Produktartnvarchar80
84TISSR_INDEX_DSZuordnung Fonds zur Wertpapierindexgruppe6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
85TISSR_PCAT_PTYPEISSR: Beziehung MW-Produkttype zu MW-Produktart2PRODUCT_TYPEMeldewesen-Produktartnvarchar80
86TISSR_RATING_DSRatingeinstufung je Fonds für Durchsicht Fonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
87TISSR_RATING_DSRRatingeinstufung je Fonds für Durchsicht Fonds6PRODUCT_TYPEMeldewesen-Produktartnvarchar80
TOPRelationships Between Objects with GUID Identification
88COMC_IL_TYPE_SFWDefinition of Switch per Relationship Type and Product Type2PRODUCT_TYPEProduct Typenvarchar20
TOPReusable Components of Business Suite Foundation
89/BOBF/DM_PRD_HDRProduct Header (Demo)5PRODUCT_TYPEProduct Typenvarchar100
90/BOFU/DM_PRD_HD1Header4PRODUCT_TYPEProduct Typenvarchar100
91/BOFU/DM_PRD_HDRHeader5PRODUCT_TYPEProduct Typenvarchar100
TOPTax Reporting
92OIUX7_WY_PDVLXRFTax 2.0 - WYGP Product Code/Volume Type/Product Type Xref4PRODUCT_TYPETax 2.0 - WYGP Product Typenvarchar20
TOPTransaction Management
93THXC_FLOWTYPETreasury: Update types based on a Product Type2PRODUCT_TYPEProduct Typenvarchar30
94TRIGC_IGI_PTIGT - ProdCat / ProdType in Valn Areas to be Included3PRODUCT_TYPEProduct Typenvarchar30
TOPTransaction Manager
95ATCVC1CRM: Assign General Valuation Class to Product Type2PRODUCT_TYPEProduct Typenvarchar30
96ATCVC2CRM: Assign General Valuation Class to Product Type2PRODUCT_TYPEProduct Typenvarchar30
97ATDEALDFTUpdate Types for Position Update2PRODUCT_TYPEProduct Typenvarchar30
98DIFC_LOT_ASSIGNFactors4PRODUCT_TYPEProduct Typenvarchar30
99DIFT_POS_IDENTPersistent Flow Selectors11PRODUCT_TYPEProduct Typenvarchar30
100FDC1Cash Management Shadow table13PRODUCT_TYPEProduct Typenvarchar30
101IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts10PRODUCT_TYPEProduct Typenvarchar30
102IDCFM_FRAM_DICRIAssignment of Alternative Position Management Procedure5PRODUCT_TYPEProduct Typenvarchar30
103POGT_POS_GUARDLock Objects25PRODUCT_TYPEProduct Typenvarchar30
104SLDT_FLOWSubledger Distributor Transactions10PRODUCT_TYPEProduct Typenvarchar30
105TCORC_ALOWED_BPG(Obsolete)Allowed BP Groups for Deal Corr.activities4PRODUCT_TYPEProduct Typenvarchar30
106TCORC_DEAL_ACTVTCorrespondence Deal's activity assignment4PRODUCT_TYPEProduct Typenvarchar30
107TCORT_CODMDDeal: Main Data18PRODUCT_TYPEProduct Typenvarchar30
108TCORT_CODULDeal: Underlying9PRODUCT_TYPEProduct Type of Underlyingnvarchar30
109TCORT_CODUL2Deal: 2nd Underlying10PRODUCT_TYPEProduct Type of Underlyingnvarchar30
110TCORT_EXT_ASSIGNAssignments of Profiles & BP groups to external recipients8PRODUCT_TYPEProduct Typenvarchar30
111TCORT_INB_ASSIGNBP group assignment for Inbound Correspondence6PRODUCT_TYPEProduct Typenvarchar30
112TCORT_INT_ASSIGNAssignments of Profiles & BP groups to internal recipients8PRODUCT_TYPEProduct Typenvarchar30
113TCORT_SAT_ACTVTCorrespondence Security account transfer activity assignment4PRODUCT_TYPEProduct Typenvarchar30
114TCORT_SAT_ALLBPG(Obsolete) Allowed BP Groups for SAT Corresp. activities4PRODUCT_TYPEProduct Typenvarchar30
115TCORT_TOLERANCETolerance level for dividend payment5PRODUCT_TYPEProduct Typenvarchar30
116TEXC_EXP_TYPEExposure Position Type5PRODUCT_TYPEProduct Typenvarchar30
117TEXT_POSITIONSExposure Positions44PRODUCT_TYPEProduct Typenvarchar30
118THAC_HR_DOCUE-HA: Documentation Control5PRODUCT_TYPEProduct Typenvarchar30
119THAC_HR_DOCU_SFHedge Documentation: Smart Forms for Hedge Docu. Form5PRODUCT_TYPEProduct Typenvarchar30
120TRCT_FLOWTable of business transactions flows6PRODUCT_TYPEProduct Typenvarchar30
121TRDTC_DFT_ASSGNUpdate Types for Legacy Data Transfer2PRODUCT_TYPEProduct Typenvarchar30
122TRDT_FLOWPersistent distributor flows8PRODUCT_TYPEProduct Typenvarchar30
123TRGC_ASYN_FIX_RGAsynchronous Fixing for Each Product Type2PRODUCT_TYPEProduct Typenvarchar30
124TRGC_CVC1Assignment of Product Cat. and Trans. Cat. to GVC Group3PRODUCT_TYPEProduct Typenvarchar30
125TRGC_MIG_PMP_OTCConversion: Assignment of OTC Position Management Procedures3PRODUCT_TYPEProduct Typenvarchar30
126TRGC_PAY_RELPayment Relevance of Update Type4PRODUCT_TYPEProduct Typenvarchar30
127TRGC_PM_PROC_ASSAssignment of Position Management Procedure5PRODUCT_TYPEProduct Typenvarchar30
128TRGC_PT_EXCLProduct Types to be Excluded in the Parallel Val. Areas4PRODUCT_TYPEProduct Typenvarchar30
129TRGT_MIG_CC_PTConverted Company Codes and Product Types4PRODUCT_TYPEProduct Typenvarchar30
130TRLIC_ADTR: Customizing: Accrual/Deferral6PRODUCT_TYPEProduct Typenvarchar30
131TRLIC_AD_EX1TR: Accrual/Deferral: Further Update Types6PRODUCT_TYPEProduct Typenvarchar30
132TRLIC_AD_HEADCustomizing Accrual/Deferral: Differentiation6PRODUCT_TYPEProduct Typenvarchar30
133TRLT_VCL_FLOWFlows Valuation Class Transfer11PRODUCT_TYPEProduct Typenvarchar30
134TRQC_LOT_ACC_2Treasury: Quantity Ledger Position Description3PRODUCT_TYPEProduct Typenvarchar30
135TRQC_POS_IND_2Treasury: Quantity Ledger Position Description3PRODUCT_TYPEProduct Typenvarchar30
136TRQC_POS_IND_3Treasury: Quantity Ledger Position Description3PRODUCT_TYPEProduct Typenvarchar30
137TRQC_POS_IND_4Treasury: Quantity Ledger Position Description3PRODUCT_TYPEProduct Typenvarchar30
138TRTFC_DFTASSUpdate Types for Transfer Posting2PRODUCT_TYPEProduct Typenvarchar30
TOPTransfer to Financial Accounting
139TRACC_POST_RELExclude Product Types from Posting4PRODUCT_TYPEProduct Typenvarchar30
140TRACT_QUEUEResubmission for Reversal6PRODUCT_TYPEProduct Typenvarchar30
141TRLC_IFT_ASSGNAssign Update Types for Initializing Positions2PRODUCT_TYPEProduct Typenvarchar30
TOPTreasury and Risk Management
142TREAC_CLEAR_OPTTreasury: Cent.Clearing Option per Comp.Code/Prod.Tp/TransTp3PRODUCT_TYPEProduct Typenvarchar30
143TREAT_CLEAR_ACCTreasury: Clearing Account Specific Data5PRODUCT_TYPEProduct Typenvarchar30
144TREAT_FHA_DIFFTreasury: TREA Differentiation for Deal Position5PRODUCT_TYPEProduct Typenvarchar30
145ZTR_EXPOTRANCONFMaintain attributes for Exposure creation/change events10PRODUCT_TYPEProduct Typenvarchar30