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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AT10581Transaction TypesTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, SGSART, SFHAART, SFGTYP, NUMKR, NUMKRANG, NUMKRSIM, ABWTYP, SAUTOBUCH, UNUMKR, SLPG, SROUND, RROUND, SBSTDCP, SCOMPCP, AHJFA, SREALGE, SREALVE, SBESTABT, SBESTZUT, SBESTAB, SBESTZU, SRUEBIL, SRUEAUF, SGEWBIL, SGEWAUF, SSWAPERT, SSWAPERAUF, SSWAPAUF, SSWAPAUAUF, SRUESWP, SRUEAUFSWP, SGEWSWP, SGEWAUFSWP, SSWPUMBAUF, SSWPUMBERT, RANTYP, STSMA, DATE_RULE, SREALGET, SREALVET, FLAG_FLAT, SNOMPAY, FLG_INIT_MARGIN, POS_LOCK_CAT, USGSART, USFHAART, LOCK_REASON, AUTOSETTLE, PHYSICALDEL, USENETTING, LOC_CURR_RULE, SIDE_CAT_IN, SIDE_CAT_OUT, SWAP_SYMMETRY, SWAP_CAPTURE_BEH, COM_PRICE_DETERM, COM_AVG_CAPT_CAT FROM AT10
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SGSARTProduct Typenvarchar30CHAR(N' ')NoTZPAVVSART Allow NULL? 
3SFHAARTFinancial Transaction Typenvarchar30CHAR(N' ')NoTB_SFHAART Allow NULL? 
4SFGTYPTransaction Categorynvarchar30NUMC(N'000')YesAT01TB_SFGTYP Allow NULL? 
5NUMKRNumber Range for Transactionsnvarchar20CHAR(N' ')YesTB_NUMKRG Allow NULL? 
6NUMKRANGNumber Range for Offers/Quotationsnvarchar20CHAR(N' ')YesNUMKRANG Allow NULL? 
7NUMKRSIMNumber Range for Simulated Transactionsnvarchar20CHAR(N' ')YesNUMKRSIM Allow NULL? 
8ABWTYPProcessing Categorynvarchar50CHAR(N' ')YesAT05TB_ABWTYP Allow NULL? 
9SAUTOBUCHAutomatic Posting Releasechar10CHAR(N' ')YesTB_SAUTOB Allow NULL? 
10UNUMKRNumber Range for Underlyingnvarchar20CHAR(N' ')YesTB_UNUMKR Allow NULL? 
11SLPGLimit Product Groupnvarchar30CHAR(N' ')YesATLPGTB_SLPG Allow NULL? 
12SROUNDRounding Typechar10CHAR(N' ')YesTB_SROUND Allow NULL? 
13RROUNDRounding unittinyint30INT1((0))YesTB_RROUND
14SBSTDCPBasic Principle of Commercial Paper Positionchar10CHAR(N' ')YesTM_SBSTDCP Allow NULL? 
15SCOMPCPExponential discounting for term over 1 yearchar10CHAR(N' ')YesTM_SCOMPCP Allow NULL? 
16AHJFANumber of Half-Years for Generating Cash Flownvarchar20NUMC(N'00')YesTB_AHJFA Allow NULL? 
17SREALGETreasury: Flow Type for Realized Gainsnvarchar40CHAR(N' ')YesTZB0ATB_SREALGE Allow NULL? 
18SREALVETreasury: Flow Type for Realized Lossesnvarchar40CHAR(N' ')YesTZB0ATB_SREALVE Allow NULL? 
19SBESTABTTreasury: Flow type for position writedownsnvarchar40CHAR(N' ')YesTZB0ATB_SBESTAB Allow NULL? 
20SBESTZUTTreasury: Flow type for position writeupsnvarchar40CHAR(N' ')YesTZB0ATB_SBESTZU Allow NULL? 
21SBESTABTreasury: Flow type for position writedownsnvarchar40CHAR(N' ')YesTZB0ATB_SBESTAB Allow NULL? 
22SBESTZUTreasury: Flow type for position writeupsnvarchar40CHAR(N' ')YesTZB0ATB_SBESTZU Allow NULL? 
23SRUEBILTreasury: Flow type for provisions to be creatednvarchar40CHAR(N' ')YesTZB0ATB_SRUEBIL Allow NULL? 
24SRUEAUFTreasury: Flow type for reversing provisionsnvarchar40CHAR(N' ')YesTZB0ATB_SRUEAUF Allow NULL? 
25SGEWBILTreasury: Flow type for unrealized gains to be disclosednvarchar40CHAR(N' ')YesTZB0ATB_SGEWBIL Allow NULL? 
26SGEWAUFTreasury: Flow type for writing back unrealized gainsnvarchar40CHAR(N' ')YesTZB0ATB_SGEWAUF Allow NULL? 
27SSWAPERTTreasury: flow type for accrued/deferred forex swap revenuenvarchar40CHAR(N' ')YesTZB0ATB_SWAPERT Allow NULL? 
28SSWAPERAUFTreasury: Flow type for writing back accrd/defd fx swap rev.nvarchar40CHAR(N' ')YesTZB0ATB_SWPERAU Allow NULL? 
29SSWAPAUFTreasury: flow type for accrued/deferred forex swap expensesnvarchar40CHAR(N' ')YesTZB0ATB_SWAPAUF Allow NULL? 
30SSWAPAUAUFTreasury: Flow type f. writing back accrd/defrd fx swap exp.nvarchar40CHAR(N' ')YesTZB0ATB_SWPAUAU Allow NULL? 
31SRUESWPTreasury: Flow type for creating provisions - swapnvarchar40CHAR(N' ')YesTZB0ATB_SWRUEBI Allow NULL? 
32SRUEAUFSWPTreasury: Flow type for writing back provisons - swapnvarchar40CHAR(N' ')YesTZB0ATB_SWRUEAU Allow NULL? 
33SGEWSWPTreasury: Flow type for disclosing unrealized gains - swapnvarchar40CHAR(N' ')YesTZB0ATB_SWGWBIL Allow NULL? 
34SGEWAUFSWPTreasury: Flow type for writing back unrealized swap gainsnvarchar40CHAR(N' ')YesTZB0ATB_SWGWAUF Allow NULL? 
35SSWPUMBAUFTreasury: Transfer flow for forex swap expensesnvarchar40CHAR(N' ')YesTZB0ATB_SSWPUMB Allow NULL? 
36SSWPUMBERTTreasury: Transfer flow for foreign exchange swap revenuenvarchar40CHAR(N' ')YesTZB0ATB_SSWPUER Allow NULL? 
37RANTYPContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
38STSMAStatus Profilenvarchar80CHAR(N' ')YesTJ20J_STSMA Allow NULL? 
39DATE_RULEDate Rule to Determine Due Datenvarchar100CHAR(N' ')YesATDRTB_DATE_RULE Allow NULL? 
40SREALGETTreasury: Flow Type for Realized Gainsnvarchar40CHAR(N' ')YesTZB0ATB_SREALGE Allow NULL? 
41SREALVETTreasury: Flow Type for Realized Lossesnvarchar40CHAR(N' ')YesTZB0ATB_SREALVE Allow NULL? 
42FLAG_FLATIndicator: Traded Flatchar10CHAR(N' ')YesTB_FLAG_FLAT Allow NULL? 
43SNOMPAYDifference Between Payment Amount and Nominal Amountchar10CHAR(N' ')YesTM_SNOMPAY Allow NULL? 
44FLG_INIT_MARGINIndicator: Generate Initial Margin Flowchar10CHAR(N' ')YesTB_INIT_MARGIN Allow NULL? 
45POS_LOCK_CATType of Position Lockchar10NUMC(N'0')YesTB_POS_LOCK Allow NULL? 
46USGSARTProduct type of underlyingnvarchar30CHAR(N' ')Yes*TB_USGSART Allow NULL? 
47USFHAARTTransaction Type of Underlyingnvarchar30CHAR(N' ')Yes*TB_USFHAAR Allow NULL? 
48LOCK_REASONBlock type for restraint on disposalnvarchar30CHAR(N' ')YesTW17SSPERR Allow NULL? 
49AUTOSETTLEAutomatic Settlement on Counterconfirmationchar10CHAR(N' ')YesFTR_SETLMNT_FLG Allow NULL? 
50PHYSICALDELConsider physical deliverychar10CHAR(N' ')YesFTR_PHYDEL_FLG Allow NULL? 
51USENETTINGUse Nettingchar10CHAR(N' ')YesFTR_USENETTING Allow NULL? 
52LOC_CURR_RULEExchange rate for translation to local currencychar10CHAR(N' ')YesTB_EXTRANSLOC Allow NULL? 
53SIDE_CAT_INSide Category for the Incoming Side of a Swapchar10NUMC(N'0')YesFTR_SWAP_SIDE_CAT_INCOMING Allow NULL? 
54SIDE_CAT_OUTSide Category for the Outgoing Side of a Swapchar10NUMC(N'0')YesFTR_SWAP_SIDE_CAT_OUTGOING Allow NULL? 
55SWAP_SYMMETRYIndicates How Swap Symmetry Is Handledchar10NUMC(N'0')YesFTR_SWAP_SYMMETRY Allow NULL? 
56SWAP_CAPTURE_BEHActivates Multiple Flow Generation for Commodity Swapschar10CHAR(N' ')YesFTR_COMS_MULTPLE_FLOW_GEN Allow NULL? 
57COM_PRICE_DETERMDetermination of Commodity Pricechar10CHAR(N' ')YesFTR_COM_PRICE_DETERM Allow NULL? 
58COM_AVG_CAPT_CATAverage Price Capture Category for Commodity Forwardchar10CHAR(N' ')YesFTR_COMF_AVG_CAPTURE_CAT Allow NULL? 
NamePrimaryUniqueTypeColumns
AT10~0YesYesCLUSTEREDSFHAART, SGSART, MANDT