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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
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
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SLDT_FLOW872Subledger Distributor TransactionsTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, OS_GUID, PARTITION_CAT, FLOW_NUMBER, PARTITION_NUMBER, DIS_FLOWTYPE, ALLOC_NMBR, COMPANY_CODE, VALUATION_AREA, PRODUCT_TYPE, TRANSACTION_TYPE, COM_VAL_CLASS, VALUATION_CLASS, SECURITY_ID, SECURITY_ACCOUNT, ACCOUNT_GROUP, PORTFOLIO, TRADER, LOANS_CONTRACT, DEAL_NUMBER, FUND, GRANT_NBR, POSITION_ACCOUNT, LOT_ID, FLAG_LONG_SHORT, EXTERNAL_ACCOUNT, DIFF_CURRENCY, UNITS, NOMINAL_CURR, NOMINAL_AMT, NOMINAL_ORG_AMT, POSITION_CURR, POSITION_AMT, POSAMT_IDX_CLEAN, QUANT_CAT, ACTIVE_PASSIVE, LOCAL_CURR, LOCAL_AMT, VALUATION_CURR, VALUATION_AMT, TRL_POS_MAN_CAT, FIXED_AA_REF, SOURCETARGET_FLG, TRANSFER_GROUP, LOT_CREATION, AMOUNT_FACTOR, PAYMENT_CURR, PAYMENT_AMT, SIGN, HOUSE_BANK, HOUSE_BANK_ACC, PAYMENT_DATE, DUE_DATE, RPBANK, RPZAHL, SZART, ZLSCH, UZAWE, SPAYRQ, SPRSNG, SPRGRD, SCSPAY, ZWELS, PAYGR, CALCULATION_DATE, CALC_DATE_INCL, COUPON_DATE, COUPON_SIGN, CALC_BEGIN, CALC_END, EFF_INT_RATE_U, SCHED_EFF_RATE, EFF_INT_RATE_N, SCHED_FIX, LANDL, LZBKZ, RPCODE, RP_TEXT, RFHAZU, NORDEXT, SFGZUSTT, BBASIS, PA_COMPANY_ID, ORIGIN_DATE, HINSTR_OID, HITEM_OID, PAR_USAGE FROM SLDT_FLOW
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2OS_GUIDObject Identity in Database Formatnvarchar320CHAR(N' ')NoSLDT_TRANSACTIONTPM_DB_OS_GUID Allow NULL? 
3PARTITION_CATCategory of Group of Distributor Flow Partitionstinyint30INT1((0))NoTPM_PARTITION_CATEGORY
4FLOW_NUMBERNumber of a Distributor Flowint100INT4((0))NoTPM_TRDFLOWNR Allow NULL? 
5PARTITION_NUMBERNumber of Partition in SLDint100INT4((0))NoTPM_SLD_PARTITIONNR Allow NULL? 
6DIS_FLOWTYPEUpdate Typenvarchar80CHAR(N' ')YesTRDC_DFLOWTYPETPM_DIS_FLOWTYPE Allow NULL? 
7ALLOC_NMBRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
8COMPANY_CODECompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
9VALUATION_AREAValuation Areanvarchar30CHAR(N' ')YesTRGC_VAL_AREATPM_VAL_AREA Allow NULL? 
10PRODUCT_TYPEProduct Typenvarchar30CHAR(N' ')YesTZPAVVSART Allow NULL? 
11TRANSACTION_TYPEFinancial Transaction Typenvarchar30CHAR(N' ')YesAT10TB_SFHAART Allow NULL? 
12COM_VAL_CLASSGeneral Valuation Classnvarchar40NUMC(N'0000')YesTRGC_COM_VALCLTPM_COM_VAL_CLASS Allow NULL? 
13VALUATION_CLASSValuation Classnvarchar40NUMC(N'0000')YesTRGC_VAL_CLASSTPM_VAL_CLASS Allow NULL? 
14SECURITY_IDSecurity ID Numbernvarchar130CHAR(N' ')YesVWPANLAVVRANLW Allow NULL? 
15SECURITY_ACCOUNTSecurities Accountnvarchar100CHAR(N' ')YesTWD01RLDEPO Allow NULL? 
16ACCOUNT_GROUPSecurities Account Groupnvarchar100CHAR(N' ')YesTRGT_SECACCGRPTPM_SEC_ACCT_GRP Allow NULL? 
17PORTFOLIOPortfolionvarchar100CHAR(N' ')YesTWPOBRPORTB Allow NULL? 
18TRADERTradernvarchar120CHAR(N' ')YesTZDEARDEALER Allow NULL? 
19LOANS_CONTRACTContract Numbernvarchar130CHAR(N' ')YesVDARLRANL Allow NULL? 
20DEAL_NUMBERFinancial Transactionnvarchar130CHAR(N' ')YesVTBFHATB_RFHA Allow NULL? 
21FUNDFundnvarchar100CHAR(N' ')Yes*FM_FUND Allow NULL? 
22GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
23POSITION_ACCOUNTFutures Account for Listed Options and Futuresnvarchar100CHAR(N' ')Yes*TPM_POS_ACCOUNT_FUT Allow NULL? 
24LOT_IDIdentifier of the Lotvarbinary160RAWYesTPM_LOT_ID
25FLAG_LONG_SHORTIndicator: Long or Short Positionchar10CHAR(N' ')YesTPM_FLAG_LONG_SHORT Allow NULL? 
26EXTERNAL_ACCOUNTExternal Accountnvarchar100CHAR(N' ')YesTPM_EXT_ACCOUNT Allow NULL? 
27DIFF_CURRENCYCurrency as Differentiation Termnvarchar50CUKY(N' ')Yes*TPM_DIFF_CURRENCY Allow NULL? 
28UNITSUnitsdecimal226DEC((0))YesTPM_UNITS
29NOMINAL_CURRNominal Currencynvarchar50CUKY(N' ')Yes*TPM_NOMINAL_CURR Allow NULL? 
30NOMINAL_AMTNominal Amountdecimal212CURR((0))YesTPM_NOMINAL_AMT
31NOMINAL_ORG_AMTOriginal Nominal Amount in Position Currencydecimal212CURR((0))YesTPM_NOMINAL_ORG_AMT
32POSITION_CURRPosition Currencynvarchar50CUKY(N' ')Yes*TPM_POSITION_CURR Allow NULL? 
33POSITION_AMTAmount (Position Currency)decimal212CURR((0))YesTPM_POSITION_AMT
34POSAMT_IDX_CLEANAmount in Position Currency Index-Cleandecimal212CURR((0))YesTPM_POSITION_AMT_IDX_CLEAN
35QUANT_CATPosition Change Category: Quantitynvarchar40CHAR(N' ')YesTPM_QTY_PM_CAT Allow NULL? 
36ACTIVE_PASSIVEIndicator: Assets/Liabilities Positionchar10CHAR(N' ')YesTPM_ACTIVE_PASSIVE Allow NULL? 
37LOCAL_CURRLocal Currencynvarchar50CUKY(N' ')Yes*TPM_LOCAL_CURR Allow NULL? 
38LOCAL_AMTAmount (Local Currency)decimal212CURR((0))YesTPM_LOCAL_AMT
39VALUATION_CURRValuation Currencynvarchar50CUKY(N' ')Yes*TPM_VALUATION_CURR Allow NULL? 
40VALUATION_AMTAmount in Valuation Currencydecimal212CURR((0))YesTPM_VALUATION_AMT
41TRL_POS_MAN_CATPosition Change Categorynvarchar40CHAR(N' ')Yes*TPM_AMT_PM_CAT Allow NULL? 
42FIXED_AA_REFAccount Assignment Reference of Position Managementnvarchar120CHAR(N' ')YesTRACC_AA_REFTPM_AA_REF Allow NULL? 
43SOURCETARGET_FLGIndicator: Source or Target of a Flowchar10CHAR(N' ')YesTPM_SOURCE_TARGET_FLG Allow NULL? 
44TRANSFER_GROUPGroup of Flows from a Source or Targetnvarchar40NUMC(N'0000')YesTPM_TRANSFER_GROUP Allow NULL? 
45LOT_CREATIONLot Creation Categorychar10NUMC(N'0')YesTPM_LOT_CREATION Allow NULL? 
46AMOUNT_FACTORValue Coefficientfloat1516FLTP((0))YesTPM_AMOUNT_FACTOR
47PAYMENT_CURRPayment Currencynvarchar50CUKY(N' ')Yes*TPM_PAYMENT_CURR Allow NULL? 
48PAYMENT_AMTPayment Amountdecimal212CURR((0))YesTPM_PAYMENT_AMT
49SIGNDirection of flowchar10CHAR(N' ')YesTB_SSIGN Allow NULL? 
50HOUSE_BANKShort key for own house banknvarchar50CHAR(N' ')Yes*TB_RHABKI Allow NULL? 
51HOUSE_BANK_ACCShort key for house bank accountnvarchar50CHAR(N' ')Yes*TB_RHKTID Allow NULL? 
52PAYMENT_DATEPayment Datenvarchar80DATS(N'00000000')YesTPM_PAYMENT_DATE Allow NULL? 
53DUE_DATEDue Datenvarchar80DATS(N'00000000')YesTPM_DUE_DATE Allow NULL? 
54RPBANKPartner bank detailsnvarchar40CHAR(N' ')YesTB_RPBANK Allow NULL? 
55RPZAHLPayer/payeenvarchar100CHAR(N' ')YesBUT000TB_RPZAHL_NEW Allow NULL? 
56SZARTPayment transactionchar10CHAR(N' ')YesTB_SZART Allow NULL? 
57ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
58UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
59SPAYRQPayment request allowedchar10CHAR(N' ')YesTB_SPAYRQ Allow NULL? 
60SPRSNGIndividual payment requiredchar10CHAR(N' ')YesTB_SPRSNG Allow NULL? 
61SPRGRDDetermine grouping definitionchar10CHAR(N' ')YesTB_SPRGRD Allow NULL? 
62SCSPAYSame direction necessary for joint payment?char10CHAR(N' ')YesTB_SCSPAY Allow NULL? 
63ZWELSList of the Payment Methods to be Considerednvarchar100CHAR(N' ')YesDZWELS Allow NULL? 
64PAYGRGrouping Field for Automatic Paymentsnvarchar200CHAR(N' ')YesPAYGR Allow NULL? 
65CALCULATION_DATECalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
66CALC_DATE_INCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
67COUPON_DATEDate of the Next Couponnvarchar80DATS(N'00000000')YesTPM_COUPON_DATE Allow NULL? 
68COUPON_SIGNCoupon ID for Interest and Accrued Interest Calculationchar10CHAR(N' ')YesTPM_COUPON_SIGN Allow NULL? 
69CALC_BEGINStart of Calculation Periodnvarchar80DATS(N'00000000')YesDBERVON Allow NULL? 
70CALC_ENDEnd of Calculation Periodnvarchar80DATS(N'00000000')YesDBERBIS Allow NULL? 
71EFF_INT_RATE_UFor Calculation of Amortization Amts (SAC) for Used EffInRdecimal107DEC((0))YesTPM_TRL_EFF_INT_RATE_USED
72SCHED_EFF_RATEKey for Redemption Schedule that Explains Effect. Int. Rateint100INT4((0))YesRDPT_SCHEDULE_KEY_EFF_RATE Allow NULL? 
73EFF_INT_RATE_NValid Effective Interest Rate for the Next Amortizationdecimal107DEC((0))YesTPM_TRL_EFF_INT_RATE_NEW
74SCHED_FIXKey for Fixed Redemption Scheduleint100INT4((0))YesRDPT_SCHEDULE_KEY_FIX Allow NULL? 
75LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
76LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
77RPCODERepetitive Codenvarchar200CHAR(N' ')Yes*RPCODE Allow NULL? 
78RP_TEXTReference Text for Repetitive Codenvarchar500CHAR(N' ')YesRPCODE_TEXT Allow NULL? 
79RFHAZUTransaction activitynvarchar50NUMC(N'00000')YesTB_RFHAZU Allow NULL? 
80NORDEXTExternal Referencenvarchar160CHAR(N' ')YesTB_NORDEXT Allow NULL? 
81SFGZUSTTTransaction Activity Categorynvarchar20NUMC(N'00')Yes*TB_SFGZUTY Allow NULL? 
82BBASISCalculation base amountdecimal132CURR((0))YesBBASIS
83PA_COMPANY_IDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
84ORIGIN_DATETreasury Ledger Datenvarchar80DATS(N'00000000')YesTPM_TRLDATE Allow NULL? 
85HINSTR_OIDObject Identity in Database Formatnvarchar320CHAR(N' ')YesTPM_DB_OS_GUID Allow NULL? 
86HITEM_OIDObject Identity in Database Formatnvarchar320CHAR(N' ')YesTPM_DB_OS_GUID Allow NULL? 
87PAR_USAGEParameter Usagechar10CHAR(N' ')YesTPM_PAR_USAGE Allow NULL? 
NamePrimaryUniqueTypeColumns
SLDT_FLOW~0YesYesCLUSTEREDPARTITION_NUMBER, FLOW_NUMBER, PARTITION_CAT, OS_GUID, MANDT
SLDT_FLOW~100NoNoNONCLUSTEREDPAYGR, PARTITION_CAT, MANDT