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.0TCORT_CODCO752Deal: ConditionsTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, CODCO_UUID, CODMD_UUID, COMPANYCODE, DEAL_NUMBER, COND_NUMBER, EFF_FROM, DIRECTION, SINGLE_DATES, TYPE, CLASS, CATEGORY, EFF_FROM_EXCL, CREATE_USER, CREATE_DATE, CREATE_TIME, UPDATE_USER, UPDATE_DATE, UPDATE_TIME, ZERO_CONDITION, FIX_PERC_RATE, FIX_PAYMENT_RATE, FIX_BASIS, VAR_INT_REF, VAR_SPREAD, VAR_FORMULA, VAR_FORMULA_NAME, VAR_1ST_PER_RATE, CALC_METHOD, CALC_METHOD_CAL, CALC_TYPE, CALC_EXP_FREQ, CALC_IMM_SETTLE, AMOUNT, AMOUNT_CURRENCY, AMOUNT_TEMP_CALC, CALCDAT, CALCDAT_INCL, CALCDAT_MONTHEND, CALCDAT_WKDAYSFT, CALCDAT_SFTDAYS, CALCDAT_SFTDIR, CALCDAT_PERRULE, CALCDAT_ADJRULE, DUEDAT, DUEDAT_MONTHEND, DUEDAT_SFTEND, DUEDAT_WKDAYSFT, DUEDAT_SFTDAYS, DUEDAT_SFTDIR, DUEDAT_DUERULE, DUEDAT_FIXRULE, DUEDAT_FIXREFDAT, FREQUENCY, FREQUENCY_UNIT, CALENDAR1, CALENDAR2, CALENDAR3, ROUND, ROUND_UNIT, DISCOUNT, VARNAME, ALT_INT_RATE, ALT_INT_REF, STTLM_FREQ, STTLM_FREQ_UNIT, PAYDAT_OFFS_UNIT, COMMON_PRICING, FIXING_DATE_RULE, WEEKDAY_NUMBER, WEEKDAY, AVERAGE_FREQ, QUAN, UNIT_OF_MEASURE, QUAN_RELATED_TO FROM TCORT_CODCO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CODCO_UUIDCorrespondence Object: Deal Conditions UUIDvarbinary160RAWNoFTR_CODCOID
3CODMD_UUIDCorrespondence Object Deal's main data UUIDvarbinary160RAWYesFTR_CODMDID
4COMPANYCODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130CHAR(N' ')Yes*FTI_POSRFHA Allow NULL? 
6COND_NUMBERConditionnvarchar40NUMC(N'0000')YesTB_KOND Allow NULL? 
7EFF_FROMCondition Item Valid Fromnvarchar80DATS(N'00000000')YesDGUEL_KP Allow NULL? 
8DIRECTIONDirection of Transactionchar10NUMC(N'0')YesTB_RKONDGR Allow NULL? 
9SINGLE_DATESLevel number of condition item for recurring paymentsnvarchar20NUMC(N'00')YesNSTUFE Allow NULL? 
10TYPECondition Type (Smallest Subdivision of Condition Records)nvarchar40NUMC(N'0000')Yes*SKOART Allow NULL? 
11CLASSClassification of flows and conditionschar10CHAR(N' ')YesTB_SBKKLAS Allow NULL? 
12CATEGORYCategory of Flows and Conditionsnvarchar20CHAR(N' ')Yes*TB_SBKTYP Allow NULL? 
13EFF_FROM_EXCLExclusive indicator for start date of condition positionchar10NUMC(N'0')YesTFMSEXCLKP Allow NULL? 
14CREATE_USEREntered bynvarchar120CHAR(N' ')YesTB_CRUSER Allow NULL? 
15CREATE_DATEEntered Onnvarchar80DATS(N'00000000')YesTB_DCRDAT Allow NULL? 
16CREATE_TIMEEntry Timenvarchar60CHAR(N' ')YesTB_CRTIM Allow NULL? 
17UPDATE_USERLast Changed bynvarchar120CHAR(N' ')YesTB_UPUSER Allow NULL? 
18UPDATE_DATEChanged onnvarchar80DATS(N'00000000')YesTB_DUPDAT Allow NULL? 
19UPDATE_TIMETime changednvarchar60TIMS(N'000000')YesTB_TUPTIM Allow NULL? 
20ZERO_CONDITIONCondition Formchar10CHAR(N' ')YesJNULLKON Allow NULL? 
21FIX_PERC_RATEPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
22FIX_PAYMENT_RATEPayment Ratedecimal117DEC((0))YesTFM_PPAYMENT
23FIX_BASISCalculation Base Amountdecimal132CURR((0))YesTFM_BBASIS2
24VAR_INT_REFReference Interest Ratenvarchar100CHAR(N' ')Yes*SZSREF Allow NULL? 
25VAR_SPREADSpread for Reference Interest Rate (Variable Interest)decimal107DEC((0))YesFTI_VAR_OFFSET
26VAR_FORMULAFormula Referencenvarchar40CHAR(N' ')Yes*TB_XFORMBE Allow NULL? 
27VAR_FORMULA_NAMEVariable Namenvarchar40CHAR(N' ')YesTB_VARNAME Allow NULL? 
28VAR_1ST_PER_RATEInterest Rate for the First Perioddecimal107DEC((0))YesTFM_PKOND1STPER
29CALC_METHODInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
30CALC_METHOD_CALInterest Calendarnvarchar20CHAR(N' ')Yes*TFMSKALIDWT Allow NULL? 
31CALC_TYPEType of interest calculationchar10NUMC(N'0')YesTFMSINTCALC Allow NULL? 
32CALC_EXP_FREQInterest Settlement Frequency for Exponential Interest Calc.nvarchar20NUMC(N'00')YesTFM_AMMRHYZV Allow NULL? 
33CALC_IMM_SETTLEIndicator for Immediate Settlement (Financial Mathematics)char10CHAR(N' ')YesTFMSOFVERR Allow NULL? 
34AMOUNTCondition item currency amountdecimal132CURR((0))YesBKOND
35AMOUNT_CURRENCYCurrency of Condition Itemnvarchar50CUKY(N' ')Yes*SWHRKOND Allow NULL? 
36AMOUNT_TEMP_CALCIndicator for Pro Rata Temporis Calculationschar10NUMC(N'0')YesVVSZEITANT Allow NULL? 
37CALCDATCalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
38CALCDAT_INCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
39CALCDAT_MONTHENDMonth-end indicator for calculation datechar10CHAR(N' ')YesVVSBULT Allow NULL? 
40CALCDAT_WKDAYSFTWorking Day Shift for Calculation Daychar10NUMC(N'0')YesTB_SVWERK Allow NULL? 
41CALCDAT_SFTDAYSNumber of Days for Relative Calculation of Value Dateint100INT4((0))YesTB_AVGSTAG Allow NULL? 
42CALCDAT_SFTDIRDirection of Daily Shiftchar10CHAR(N' ')YesFTI_SFTDIR Allow NULL? 
43CALCDAT_PERRULEMethod for determining the next value datechar10NUMC(N'0')YesTB_SVMETH Allow NULL? 
44CALCDAT_ADJRULERule for Date Update for Interest Rate Adjustmentchar10NUMC(N'0')YesTFMSRHYZAP Allow NULL? 
45DUEDATDue datenvarchar80DATS(N'00000000')YesDFAELL Allow NULL? 
46DUEDAT_MONTHENDMonth-End Indicator for Due Datechar10CHAR(N' ')YesSFULT Allow NULL? 
47DUEDAT_SFTENDShift Due Datechar10NUMC(N'0')YesTFMSFRANZ Allow NULL? 
48DUEDAT_WKDAYSFTWorking Day Shift for Due Datechar10NUMC(N'0')YesTB_SFWERK Allow NULL? 
49DUEDAT_SFTDAYSNumber of days for rel. determination of due dateint100INT4((0))YesTB_AFGSTAG Allow NULL? 
50DUEDAT_SFTDIRDirection of Daily Shiftchar10CHAR(N' ')YesFTI_SFTDIR Allow NULL? 
51DUEDAT_DUERULEMethod for determining the next due datechar10NUMC(N'0')YesTB_SFMETH Allow NULL? 
52DUEDAT_FIXRULERule for Date Updatechar10NUMC(N'0')YesTFMSRHY Allow NULL? 
53DUEDAT_FIXREFDATReference Date for Interest Rate Fixing Datechar10NUMC(N'0')YesFTI_ZRELDAT Allow NULL? 
54FREQUENCYCyclenvarchar30NUMC(N'000')YesTFMARHY Allow NULL? 
55FREQUENCY_UNITUnit for Frequencychar10NUMC(N'0')YesTFMURHY Allow NULL? 
56CALENDAR1Factory calendarnvarchar20CHAR(N' ')Yes*SKALID Allow NULL? 
57CALENDAR2Factory calendarnvarchar20CHAR(N' ')Yes*SKALID Allow NULL? 
58CALENDAR3Factory calendarnvarchar20CHAR(N' ')Yes*SKALID Allow NULL? 
59ROUNDRounding Categorychar10CHAR(N' ')YesTFM_SROUND Allow NULL? 
60ROUND_UNITRounding Unitdecimal137DEC((0))YesTFMPRUNIT
61DISCOUNTDiscounting Categorychar10NUMC(N'0')YesTFM_SDISCOUNT Allow NULL? 
62VARNAMEVariable Namenvarchar40CHAR(N' ')YesTB_VARNAME Allow NULL? 
63ALT_INT_RATEPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
64ALT_INT_REFReference Interest Ratenvarchar100CHAR(N' ')Yes*SZSREF Allow NULL? 
65STTLM_FREQCOMS: Settlement Frequencytinyint30INT1((0))YesFTR_COMS_SETTLE_FREQUENCY
66STTLM_FREQ_UNITCOMS: Settlement Frequency Unitchar10CHAR(N' ')YesFTR_COMS_SETTFRQ_UNIT Allow NULL? 
67PAYDAT_OFFS_UNITCOMS: Unit for Payment Date Offsetchar10CHAR(N' ')YesFTR_COMS_UNIT_PAYDATOFF Allow NULL? 
68COMMON_PRICINGIndicates Whether Common Pricing Is Used for Average Pricingchar10CHAR(N' ')YesFTR_COMS_AVG_COMMON_PRICING Allow NULL? 
69FIXING_DATE_RULECOMS: Fixing Date Rule for COMSchar10CHAR(N' ')YesFTR_COMS_FIX_DAT_RULE Allow NULL? 
70WEEKDAY_NUMBERCOMS: Frequency of Occurrence of Weekday in Periodtinyint30INT1((0))YesFTR_COMS_OCCURE_OF_WD
71WEEKDAYCOMS: Day of Week for Price Fixingchar10CHAR(N' ')YesFTR_COMS_FIX_WEEKDAY Allow NULL? 
72AVERAGE_FREQCOMS: Frequency for Averagesmallint50INT2((0))YesFTR_COMS_AVERAG_FREQ
73QUANQuantitydecimal133QUAN((0))YesFTR_QUAN
74UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30UNIT(N' ')Yes*TPM_CTY_UOM Allow NULL? 
75QUAN_RELATED_TOQuantity Related Tochar10CHAR(N' ')YesFTR_COMS_QUAN_VAL_PER Allow NULL? 
NamePrimaryUniqueTypeColumns
TCORT_CODCO~0YesYesCLUSTEREDCODCO_UUID, MANDT
TCORT_CODCO~DMDNoNoNONCLUSTEREDCODMD_UUID