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

61 columns | Print definition?ERP 6.0  | PORTFOLIO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1QPVP_CHAVisual Inspection Characteristics - Document linkage table7PORTFOLIOVisual Enterprise Portfolio Namenvarchar500
2TEXT_CTY_EXPOSCommodity Price Exposure71PORTFOLIOPortfolionvarchar100
3TLRT_RISKM_DERDerivation for Risk Mitigation Indicator8PORTFOLIOPortfolionvarchar100
TOPBack Office
4TRST_CLASFLOCFM: Class Flows in Securities Account8PORTFOLIOPortfolionvarchar100
5TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account8PORTFOLIOPortfolionvarchar100
6TRST_CLASPOSTreasury: Class position in Securities Account6PORTFOLIOPortfolionvarchar100
7TRST_SECACCTRANSTreasury: Securities Account Transfer27PORTFOLIOPortfolio as Differentiation Characteristicnvarchar100
TOPInformation System
8FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW9PORTFOLIOPortfolionvarchar100
TOPLoans Management
9/FSIH/TC_PORTFInsurance Tracking Vendor Portfolios2PORTFOLIOPortfolionvarchar100
TOPLogistics - General
10WBHITrading Contract: Item Data94PORTFOLIOGlobal Trade: (Internal) Portfolio Numbernvarchar100
TOPPosition Management
11WBCUMULGlobal Trade: Aggregation Table6PORTFOLIOGlobal Trade: (Internal) Portfolio Numbernvarchar100
12WBITAssociation Item at Step Level12PORTFOLIOGlobal Trade: (Internal) Portfolio Numbernvarchar100
TOPRegulatory reporting for insurance companies
13ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle62PORTFOLIOPortafoglionvarchar100
14ISSR_BASI_RGRegistrierungseintrag11PORTFOLIOPortfolio als Unterscheidungsmerkmalnvarchar100
15ISSR_BASI_RGDONEErledigter Registrierungseintrag11PORTFOLIOPortfolio als Unterscheidungsmerkmalnvarchar100
16ISSR_RPI_MFTISSR: Feste und variable Daten Meldewesen10PORTFOLIOPortfolio als Unterscheidungsmerkmalnvarchar100
17TISSR_ASSET_BCKBACKUP:Stichtagsbezogene Kennzeichen je Anlage gem. R30/200224PORTFOLIOArt des Collateral Pools / Referenzaktivums bei ABS/CLNnvarchar20
18TISSR_ASSET_R30Stichtagsbezogene Kennzeichen je Anlage gem. R30/200224PORTFOLIOArt des Collateral Pools / Referenzaktivums bei ABS/CLNnvarchar20
19TISSR_ASSET_R30BStichtagsbez.Kennz. je Anlage gem. R30/2002 (keine WP)20PORTFOLIOArt des Collateral Pools / Referenzaktivums bei ABS/CLNnvarchar20
20TISSR_CHA_MD_PROProtokoll bei Stammdatenänderung18PORTFOLIOPortfolio als Unterscheidungsmerkmalnvarchar100
21TISSR_COLL_PL_HCollateral-Pool Historie8PORTFOLIOArt des Collateral Pools / Referenzaktivums bei ABS/CLNnvarchar20
22TISSR_COLL_POOLDefinition der Collateral Pools3PORTFOLIOArt des Collateral Pools / Referenzaktivums bei ABS/CLNnvarchar20
23TISSR_COLL_POOLTDefinition der Collateral Pools4PORTFOLIOArt des Collateral Pools / Referenzaktivums bei ABS/CLNnvarchar20
TOPRights
24CMS_INSInsurance Application Table34PORTFOLIOInsurance Portfolionvarchar60
25TCMS_INS_PORTInsurance Policy Portfolio2PORTFOLIOInsurance Portfolionvarchar60
26TCMS_INS_PORT_TInsurance Policy Portfolio2PORTFOLIOInsurance Portfolionvarchar60
TOPTransaction Manager
27BCKTCAT_FLOWBACKUP: Flow Table of Capital Actions9PORTFOLIOPortfolionvarchar100
28BCKTERT_FLOWBACKUP: Flow Table for Executable Rights10PORTFOLIOPortfolionvarchar100
29DIFC_LOT_ASSIGNFactors5PORTFOLIOPortfolionvarchar100
30DIFT_POS_IDENTPersistent Flow Selectors14PORTFOLIOPortfolio as Differentiation Characteristicnvarchar100
31IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts20PORTFOLIOPortfolionvarchar100
32IDCFM_DATA_SECValuation-Area-Independent Data for Securities8PORTFOLIOPortfolionvarchar100
33IDCFM_FRAM_DICRIAssignment of Alternative Position Management Procedure8PORTFOLIOPortfolionvarchar100
34IDCFM_FRIM_DATAImpairment Main Data7PORTFOLIOPortfolionvarchar100
35IDCFM_FRIM_DEXPImpairment: BAdI Example Values: Expected & Expert Values7PORTFOLIOPortfolionvarchar100
36POGT_POS_GUARDLock Objects28PORTFOLIOPortfolio as Differentiation Characteristicnvarchar100
37SLDT_FLOWSubledger Distributor Transactions17PORTFOLIOPortfolionvarchar100
38TCAT_FLOWFlow Table of the Corporate Actions12PORTFOLIOPortfolionvarchar100
39TCORT_CODMDDeal: Main Data36PORTFOLIOPortfolionvarchar100
40TERT_FLOWFlow Table for Rights that can be Exercised13PORTFOLIOPortfolionvarchar100
41TERT_TRANSACTIONBusiness Transaction: Exercise of Rights8PORTFOLIOPortfolionvarchar100
42TPMA_DERIV_ASSGNAssignment of Derivation Categories8PORTFOLIOPortfolionvarchar100
43TRDTT_DATA_ADMINLegacy Data Transfer Admin. Entries Business Transactions8PORTFOLIOPortfolionvarchar100
44TRDTT_DATA_SECValuation-Area-Independent Data for Securities7PORTFOLIOPortfolionvarchar100
45TRDTT_IGTDATA_SEIntragroup Transaction (IGT) Data for Securities8PORTFOLIOPortfolionvarchar100
46TRDTT_POS_ADMINLegacy Data Transfer Admin. Entries Subledger Positions7PORTFOLIOPortfolionvarchar100
47TRDTT_POS_SECPosition Information for Securities7PORTFOLIOPortfolionvarchar100
48TRDTT_VADATA_SECValuation-Area-Dependent Data for Securities8PORTFOLIOPortfolionvarchar100
49TRDT_FLOWPersistent distributor flows15PORTFOLIOPortfolionvarchar100
50TRGC_PM_PROC_ASSAssignment of Position Management Procedure8PORTFOLIOPortfolionvarchar100
51TRGT_MIGPS_SECAssignment of PS Account Assignments to Securities Positions6PORTFOLIOPortfolio as Differentiation Characteristicnvarchar100
52TRGT_TRANS_REVALTable with Revaluation Structures for Transfer to TR Ledger9PORTFOLIOIndicatornvarchar10
53TRLT_VCL_FLOWFlows Valuation Class Transfer16PORTFOLIOPortfolionvarchar100
54TRQC_POS_IND_4Treasury: Quantity Ledger Position Description5PORTFOLIOPortfolionvarchar100
55TRXT_WT_ASSIGNTRM Withholding Tax Information Assignment9PORTFOLIOPortfolionvarchar100
TOPTransfer to Financial Accounting
56TLVT_MANUAL_VALBook Values for Manual Valuation of Positions8PORTFOLIOPortfolionvarchar100
57TRACT_QUEUEResubmission for Reversal7PORTFOLIOPortfolionvarchar100
58TRLT_INIT_IGT_SEInitialization Values for Intragroup Transactions11PORTFOLIOPortfolionvarchar100
59TRLT_INIT_VAL_SEInitialization Values for TRL Positions: Securities11PORTFOLIOPortfolionvarchar100
60VALT_SP_VAL_SECSecurity Prices and NPV for Special Valuation7PORTFOLIOPortfolionvarchar100
TOPTreasury and Risk Management
61TREAT_EXT_ACCTreasury: External Account General Master Data8PORTFOLIOPortfolionvarchar100