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

Home | ERP 6.0  | TRST_CLASFLO
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Back Office
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TRST_CLASFLO1072CFM: Class Flows in Securities AccountBack Office
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, CLASPOS_GUID, OS_GUID, TRD_BUSTRANSID, TRD_BUSTRANSCAT, TRD_REBUSTRANSID, COM_VAL_CLASS, PORTFOLIO, FUND, GRNT_NUM, LOT_ID, TRD_FLOWNR, TRD_STATE, DIS_FLOWTYPE, FLOWCAT_TRS, QUANT_CAT, POSITION_CURR, POSITION_AMT, POSAMT_IDX_CLEAN, POSITION_DATE, UNITS, NOMINAL_CURR, NOMINAL_AMT, NOMINAL_ORG_AMT, LOCAL_CURR, LOCAL_AMT, PAYMENT_AMT, PAYMENT_CURR, PAYMENT_DATE, COUPON_DATE, COUPON_SIGN, FX_RATE_PAYMT, FX_RATE_PAY_FIX, FX_RATE_LOCAL, RAHABKI, RAHKTID, RPZAHL, RPBANK, SZART, SPAYRQ, RPCODE, RP_TEXT, ZLSCH, UZAWE, ZWELS, SPRSNG, SCSPAY, SPRGRD, SIGN, FIXING_USER, FIXING_DATE, FIXING_TIME, FLG_CL_FLOWS_INC, SNOTDELIVERED, SBERFIMA, SAEND, SPLANIST, SWOHER, BBASIS, SBASIS, DBERVON, SEXCLVON, SULTVON, DBERBIS, SINCLBIS, SULTBIS, DVALUT, SINCL, SVULT, DFAELL, SFULT, DVERRECH, SINCLVERR, SULTVERR, ATAGE, ABASTAGE, APERTAGE, AMMRHY, ATTRHY, STGMETH, STGBASIS, SZBMETH, JEXPOZINS, DBPERIOD, SPAEXCL, SPAULT, DEPERIOD, SPEINCL, SPEULT, SWHRKOND, PKOND, DPKOND, DZFEST, BKOND, KBKOND, SSTCKKZ, SSTCKTG, SFLAT, SKOART, SKALIDWT, DGUEL_KP, NSTUFE, PPAYMENT, JSOFVERR, POS_AMT_FWZE, NOM_AMT_FWZE, SCHED_FIX FROM TRST_CLASFLO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CLASPOS_GUIDObject Identity in Database Formatnvarchar320CHAR(N' ')NoTRST_CLASPOSTPM_DB_OS_GUID Allow NULL? 
3OS_GUIDObject Identity in Database Formatnvarchar320CHAR(N' ')NoTPM_DB_OS_GUID Allow NULL? 
4TRD_BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160RAWYesTPM_BUSTRANSID
5TRD_BUSTRANSCATBusiness Transaction Categorynvarchar40NUMC(N'0000')YesTRDTS_BT_CATTPM_BUSTRANSCAT Allow NULL? 
6TRD_REBUSTRANSIDIdentifier of Referenced Distributor Business Transactionvarbinary160RAWYesTPM_BUSTRANSID_TRS_REF
7COM_VAL_CLASSGeneral Valuation Classnvarchar40NUMC(N'0000')Yes*TPM_COM_VAL_CLASS Allow NULL? 
8PORTFOLIOPortfolionvarchar100CHAR(N' ')Yes*RPORTB Allow NULL? 
9FUNDFundnvarchar100CHAR(N' ')Yes*FM_FUND Allow NULL? 
10GRNT_NUMGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
11LOT_IDIdentifier of the Lotvarbinary160RAWYesTPM_LOT_ID
12TRD_FLOWNRNumber of a Distributor Flowint100INT4((0))YesTPM_TRDFLOWNR Allow NULL? 
13TRD_STATEStatus of Distributor Business Transactionchar10CHAR(N' ')YesTPM_BUSTRANS_STATE Allow NULL? 
14DIS_FLOWTYPEUpdate Typenvarchar80CHAR(N' ')Yes*TPM_DIS_FLOWTYPE Allow NULL? 
15FLOWCAT_TRSFlow Category for Securities Account Managementnvarchar30CHAR(N' ')Yes*TPM_FLOWCAT_TRS Allow NULL? 
16QUANT_CATPosition Change Category: Quantitynvarchar40CHAR(N' ')YesTPM_QTY_PM_CAT Allow NULL? 
17POSITION_CURRPosition Currencynvarchar50CUKY(N' ')YesTCURCTPM_POSITION_CURR Allow NULL? 
18POSITION_AMTAmount (Position Currency)decimal212CURR((0))YesTPM_POSITION_AMT
19POSAMT_IDX_CLEANAmount in Position Currency Index-Cleandecimal212CURR((0))YesTPM_POSITION_AMT_IDX_CLEAN
20POSITION_DATEPosition Value Datenvarchar80DATS(N'00000000')YesTPM_POSITION_DATE Allow NULL? 
21UNITSUnitsdecimal226DEC((0))YesTPM_UNITS
22NOMINAL_CURRNominal Currencynvarchar50CUKY(N' ')YesTCURCTPM_NOMINAL_CURR Allow NULL? 
23NOMINAL_AMTNominal Amountdecimal212CURR((0))YesTPM_NOMINAL_AMT
24NOMINAL_ORG_AMTOriginal Nominal Amount in Position Currencydecimal212CURR((0))YesTPM_NOMINAL_ORG_AMT
25LOCAL_CURRLocal Currencynvarchar50CUKY(N' ')YesTCURCTPM_LOCAL_CURR Allow NULL? 
26LOCAL_AMTAmount (Local Currency)decimal212CURR((0))YesTPM_LOCAL_AMT
27PAYMENT_AMTPayment Amountdecimal212CURR((0))YesTPM_PAYMENT_AMT
28PAYMENT_CURRPayment Currencynvarchar50CUKY(N' ')Yes*TPM_PAYMENT_CURR Allow NULL? 
29PAYMENT_DATEPayment Datenvarchar80DATS(N'00000000')YesTPM_PAYMENT_DATE Allow NULL? 
30COUPON_DATEDate of the Next Couponnvarchar80DATS(N'00000000')YesTPM_COUPON_DATE Allow NULL? 
31COUPON_SIGNCoupon ID for Interest and Accrued Interest Calculationchar10CHAR(N' ')YesTPM_COUPON_SIGN Allow NULL? 
32FX_RATE_PAYMTExchange Rate from Payment Currency to Position Currencydecimal95DEC((0))YesTPM_FX_RATE_PAYMT
33FX_RATE_PAY_FIXFixed exchange ratechar10CHAR(N' ')YesVVSFIXRATE Allow NULL? 
34FX_RATE_LOCALExchange Rate from Payment to Local Currencydecimal95DEC((0))YesTPM_FX_RATE_LOCAL
35RAHABKIShort key for own house banknvarchar50CHAR(N' ')Yes*TB_RHABKI Allow NULL? 
36RAHKTIDShort key for house bank accountnvarchar50CHAR(N' ')Yes*TB_RHKTID Allow NULL? 
37RPZAHLPayer/payeenvarchar100CHAR(N' ')Yes*TB_RPZAHL_NEW Allow NULL? 
38RPBANKPartner bank detailsnvarchar40CHAR(N' ')YesTB_RPBANK Allow NULL? 
39SZARTPayment transactionchar10CHAR(N' ')YesTB_SZART Allow NULL? 
40SPAYRQGenerate payment requestchar10CHAR(N' ')YesTB_SPAYRQK Allow NULL? 
41RPCODERepetitive Codenvarchar200CHAR(N' ')Yes*RPCODE Allow NULL? 
42RP_TEXTReference Text for Repetitive Codenvarchar500CHAR(N' ')YesRPCODE_TEXT Allow NULL? 
43ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
44UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
45ZWELSList of the Payment Methods to be Considerednvarchar100CHAR(N' ')YesDZWELS Allow NULL? 
46SPRSNGIndividual payment requiredchar10CHAR(N' ')YesTB_SPRSNG Allow NULL? 
47SCSPAYSame direction necessary for joint payment?char10CHAR(N' ')YesTB_SCSPAY Allow NULL? 
48SPRGRDDetermine grouping definitionchar10CHAR(N' ')YesTB_SPRGRD Allow NULL? 
49SIGNDirection of flowchar10CHAR(N' ')YesTB_SSIGN Allow NULL? 
50FIXING_USERCFM: Fixing Processornvarchar120CHAR(N' ')YesTPM_FIXING_USER Allow NULL? 
51FIXING_DATECFM: Fixing Datenvarchar80DATS(N'00000000')YesTPM_FIXING_DATE Allow NULL? 
52FIXING_TIMECFM: Fixing Timenvarchar60TIMS(N'000000')YesTPM_FIXING_TIME Allow NULL? 
53FLG_CL_FLOWS_INCFlag: Business Trans. Contains All Incoming Payment Flowschar10CHAR(N' ')YesTPMFLG_CL_FL_INC Allow NULL? 
54SNOTDELIVEREDSecurity not deliveredchar10CHAR(N' ')YesFTR_NOT_DEL_FLG Allow NULL? 
55SBERFIMACalculation category for cash flow calculatornvarchar40CHAR(N' ')YesAT40SBEWFIMA Allow NULL? 
56SAENDChange Indicator for FiMa Flow Recordschar10NUMC(N'0')YesTFM_SAEND Allow NULL? 
57SPLANISTPlan/actual record/record to be released indicatorchar10CHAR(N' ')YesSPLANIST Allow NULL? 
58SWOHERCFM: Origin Indicator TRSchar10CHAR(N' ')YesTPM_SWOHER_TRS Allow NULL? 
59BBASISCalculation Base Amountdecimal132CURR((0))YesTFM_BBASIS2
60SBASISCalculation Base Referencenvarchar40CHAR(N' ')YesTFM_SBASIS Allow NULL? 
61DBERVONStart of Calculation Periodnvarchar80DATS(N'00000000')YesDBERVON Allow NULL? 
62SEXCLVONExclusive Indicator for the Start of a Calculation Periodchar10NUMC(N'0')YesVVSEXCLVON Allow NULL? 
63SULTVONMonth-End Indicator for Start of a Calculation Periodchar10CHAR(N' ')YesVVSULTVON Allow NULL? 
64DBERBISEnd of Calculation Periodnvarchar80DATS(N'00000000')YesDBERBIS Allow NULL? 
65SINCLBISInclusive Indicator for the End of a Calculation Periodchar10NUMC(N'0')YesVVSINCLBIS Allow NULL? 
66SULTBISMonth-End Indicator for the End of a Calculation Periodchar10CHAR(N' ')YesVVSULTBIS Allow NULL? 
67DVALUTCalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
68SINCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
69SVULTMonth-End Indicator for Value Datechar10CHAR(N' ')YesVVSVULT Allow NULL? 
70DFAELLDue datenvarchar80DATS(N'00000000')YesDFAELL Allow NULL? 
71SFULTMonth-End Indicator for Due Datechar10CHAR(N' ')YesSFULT Allow NULL? 
72DVERRECHSettlement datenvarchar80DATS(N'00000000')YesVVDVERRECH Allow NULL? 
73SINCLVERRInclusive Indicator for Clearing Datechar10NUMC(N'0')YesVVSINCLVER Allow NULL? 
74SULTVERRMonth-End Indicator for Clearing Datechar10CHAR(N' ')YesVVSULTVERR Allow NULL? 
75ATAGENumber of Daysint100INT4((0))YesTFMATAGE Allow NULL? 
76ABASTAGEAmount in floating point format for recursive determinationfloat1516FLTP((0))YesBITER
77APERTAGENo. of days of a (calculation) period in cash flownvarchar60NUMC(N'000000')YesVVAPERTAGE Allow NULL? 
78AMMRHYFrequency in monthsnvarchar30NUMC(N'000')YesAMMRHY Allow NULL? 
79ATTRHYFrequency in Daysnvarchar30NUMC(N'000')YesATTRHY Allow NULL? 
80STGMETHDaily Methodchar10NUMC(N'0')YesVVSTGMETH Allow NULL? 
81STGBASISBase Days Methodchar10CHAR(N' ')YesVVSTGBASIS Allow NULL? 
82SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
83JEXPOZINSExponential Interest Calculationchar10CHAR(N' ')YesTB_JZINSRE Allow NULL? 
84DBPERIODPeriod startnvarchar80DATS(N'00000000')YesVVDBPERIOD Allow NULL? 
85SPAEXCLExclusive Indicator for Start Date of a Periodchar10NUMC(N'0')YesTFMSPAEXCL Allow NULL? 
86SPAULTMonth-End Indicator for Start Date of a Periodchar10CHAR(N' ')YesTFMSPAULT Allow NULL? 
87DEPERIODPeriod Endnvarchar80DATS(N'00000000')YesVVDEPERIOD Allow NULL? 
88SPEINCLInclusive Indicator for End Date of a Periodchar10NUMC(N'0')YesTFMSPEINCL Allow NULL? 
89SPEULTMonth-End Indicator for End of a Periodchar10CHAR(N' ')YesTFMSPEULT Allow NULL? 
90SWHRKONDCurrency of Condition Itemnvarchar50CUKY(N' ')Yes*TFMWHRKOND Allow NULL? 
91PKONDPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
92DPKONDDetermination date for percentage rate of condition itemsnvarchar80DATS(N'00000000')YesVVDPKOND Allow NULL? 
93DZFESTInterest rate fixing datenvarchar80DATS(N'00000000')YesTB_DZFEST Allow NULL? 
94BKONDCondition item currency amountdecimal172CURR((0))YesTFM_BKOND
95KBKONDCurrency-independent FiMa condition amountdecimal156DEC((0))YesTFM_KBKOND
96SSTCKKZAccrued interest methodchar10CHAR(N' ')YesSSTCKKZ Allow NULL? 
97SSTCKTGAccrued interest: Daily methodchar10CHAR(N' ')YesSSTCKTG Allow NULL? 
98SFLATIndicator 'Traded flat',i.e.no accrued interest calculationchar10CHAR(N' ')YesVVSFLAT Allow NULL? 
99SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40NUMC(N'0000')YesTZK01SKOART Allow NULL? 
100SKALIDWTInterest Calendarnvarchar20CHAR(N' ')Yes*TFMSKALIDWT Allow NULL? 
101DGUEL_KPCondition Item Valid Fromnvarchar80DATS(N'00000000')YesDGUEL_KP Allow NULL? 
102NSTUFELevel number of condition item for recurring paymentsnvarchar20NUMC(N'00')YesNSTUFE Allow NULL? 
103PPAYMENTPayment Ratedecimal117DEC((0))YesTFM_PPAYMENT
104JSOFVERRIndicator for Immediate Settlement (Financial Mathematics)char10CHAR(N' ')YesTFMSOFVERR Allow NULL? 
105POS_AMT_FWZEAmount (Position Currency)decimal212CURR((0))YesTPM_POSITION_AMT
106NOM_AMT_FWZENominal Amountdecimal212CURR((0))YesTPM_NOMINAL_AMT
107SCHED_FIXKey for Fixed Redemption Scheduleint100INT4((0))YesRDPT_SCHEDULE_KEY_FIX Allow NULL? 
NamePrimaryUniqueTypeColumns
TRST_CLASFLO~0YesYesCLUSTEREDMANDT, CLASPOS_GUID, OS_GUID
TRST_CLASFLO~100NoNoNONCLUSTEREDTRD_BUSTRANSID, TRD_FLOWNR

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy