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  | VDCAPITAL
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
Financial Services :: Loans Management :: Portfolio
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VDCAPITAL651Data for Capitalization of Overdue ItemsPortfolio
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, SARCHIV, RANL, RBO, SBO_CAT, SBO_STATUS, SBO_STATUS_OLD, XBO_TEXT, SRELSTAT, SFGKZ, UCURR, AARRBAL, AFUDUPAY, ACAPRECS, ACREBAL, ABALNUIT, ABALNCPRECS, IINCL_KYDTE, IULTI_KYDTE, DPAYM_TO, INOTE_ASSIGNED, APRCCHRGE, ICAPITAL, IDEVIATE_PAYM, MNORISKMS, IOA_AMOUNT, MPOSTTYPE, IDUNNBLCK, IIOABLCK, IDUBLDEFI, IIOABLDEFI, IPAYBLCK, DOFFER_FR, DOFFER_TO, DACCEPT, ICAPMANUPROC, MCAPREASON, ACAPITALI, DCAPKYDTE, DENDPROPO, AINSTPROPO, PKAPEFFINTRT, MKAPEFFINTMT, DENDWOCAP, AINSTWOCAP, IENDPROPO, IINSTPROPO, NINSTPROPO, NINSTWOCAP, NOVRTWOCAP, NOVRTPROPO, DSTARTREP, DFIRST_DISB, DOEFFINTPYMNP, OEFFINTPYMNP, NMAXTERM, AREIMBURSEMENT, AINSURANCE_CONTR, ADIFFERENCE, ICONSIDER, CALCULATION_DATE, UCLICURR, CLI_FLOW_SBEWART, CLI_CHANGED FROM VDCAPITAL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3SARCHIVArchiving Category Indicatorchar10CHAR(N' ')NoSARCHIV Allow NULL? 
4RANLContract Numbernvarchar130CHAR(N' ')NoRANL Allow NULL? 
5RBOBusiness Operation Number (Loans)nvarchar150CHAR(N' ')NoRBO Allow NULL? 
6SBO_CATBusiness Operation Categorychar10CHAR(N' ')YesSBO_CAT Allow NULL? 
7SBO_STATUSBus. operation statuschar10CHAR(N' ')YesTB_SBOSTATUS Allow NULL? 
8SBO_STATUS_OLDLoans: Business operation statuschar10CHAR(N' ')YesSBO_STATUS Allow NULL? 
9XBO_TEXTText for Business Operationnvarchar300CHAR(N' ')YesXBOTEXT Allow NULL? 
10SRELSTATInternal Release Status in the Business Operationschar10CHAR(N' ')YesTB_SRELSTAT Allow NULL? 
11SFGKZRelease Workflow Indicator for the Business Operationchar10CHAR(N' ')YesTB_SFGKZA Allow NULL? 
12UCURRPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')Yes*SBWHR Allow NULL? 
13AARRBALTotal Amount of Overdue Itemsdecimal132CURR((0))YesTB_ARRBALANCE
14AFUDUPAYTotal Amount for Payments Due in the Futuredecimal132CURR((0))YesTB_FUDUPAY
15ACAPRECSTotal Amount of Receivables to Be Included in Loandecimal132CURR((0))YesTB_CAPRECS
16ACREBALTotal Amount of Creditdecimal132CURR((0))YesTB_CREBAL
17ABALNUITTotal Amount of Non-Selected Itemsdecimal132CURR((0))YesTB_BALNUIT
18ABALNCPRECSTotal Amount of Receivables Not Included in Loandecimal132CURR((0))YesTB_BALNCPRECS
19IINCL_KYDTETerm Including Key Datechar10CHAR(N' ')YesTB_INCLKYDTE Allow NULL? 
20IULTI_KYDTEKey Date Must Be Last Day of the Monthchar10CHAR(N' ')YesTB_ULTIKYDTE Allow NULL? 
21DPAYM_TOPayments tonvarchar80DATS(N'00000000')YesTB_PAYM_TO Allow NULL? 
22INOTE_ASSIGNEDMemo Existschar10CHAR(N' ')YesTB_IND_NOTE_ASSIGNED Allow NULL? 
23APRCCHRGEProcessing Charge for Deferral or Capitalizationdecimal132CURR((0))YesTB_PRCCHRGE
24ICAPITALInclude Processing Charge in Loanchar10CHAR(N' ')YesTB_ICAPITAL Allow NULL? 
25IDEVIATE_PAYMAlternative Payment Information in Additional Flowschar10CHAR(N' ')YesTB_DEVIATE_PAYM Allow NULL? 
26MNORISKMSNumber of Risk-Increasing Measuresnvarchar20NUMC(N'00')YesTB_NORISKMS Allow NULL? 
27IOA_AMOUNTInterest on Arrears Calculateddecimal132CURR((0))YesTB_IOA_CALCULATION_RESULT
28MPOSTTYPEPosting Controlnvarchar20NUMC(N'00')YesTZB09TB_DEFCAPPOSTTYPE Allow NULL? 
29IDUNNBLCKDunning Block for Items for Deferral or Capitalizationchar10CHAR(N' ')YesT040STB_DUNNBLCK Allow NULL? 
30IIOABLCKInterest on Arrears Block for Items for Deferral/Capitaliz.nvarchar20CHAR(N' ')YesTB_IOABLCK Allow NULL? 
31IDUBLDEFIDunning Block for Deferral Installmentschar10CHAR(N' ')YesT040STB_DUBLDEFR Allow NULL? 
32IIOABLDEFIInterest on Arrears Block for Deferral Installmentsnvarchar20CHAR(N' ')YesTB_IOADEFI Allow NULL? 
33IPAYBLCKPayment Block for Deferral Installmentschar10CHAR(N' ')YesT008TB_PAYBLCK Allow NULL? 
34DOFFER_FRCreation Date for the Offernvarchar80DATS(N'00000000')YesTB_OFFER_FR Allow NULL? 
35DOFFER_TOEnd of the Validity Period of the Offernvarchar80DATS(N'00000000')YesTB_OFFER_TO Allow NULL? 
36DACCEPTAcceptance Date of the Offernvarchar80DATS(N'00000000')YesTB_ACCEPT Allow NULL? 
37ICAPMANUPROCReason for Postprocessing: Keynvarchar30NUMC(N'000')YesTDCAP_POSTPRTB_MAN_POSTPROCESS Allow NULL? 
38MCAPREASONKey for Reason for Capitalizationnvarchar30NUMC(N'000')YesTDCAP_REASONTB_CAPREASON Allow NULL? 
39ACAPITALICapitalization Amountdecimal132CURR((0))YesTB_CAPAMO
40DCAPKYDTEKey Date for Capitalization of Overdue Itemsnvarchar80DATS(N'00000000')YesTB_CAPKYDTE Allow NULL? 
41DENDPROPONew End of Termnvarchar80DATS(N'00000000')YesTB_ENDPROPO Allow NULL? 
42AINSTPROPONew Figure for Payment Installmentsdecimal132CURR((0))YesTB_INSTPROPO
43PKAPEFFINTRTEffective Interest Based on Capitalization of Overdue Itemsdecimal107DEC((0))YesTB_KAPEFFINTRT
44MKAPEFFINTMTCapitalization of Overdue Items: Effective Interest Methodchar10NUMC(N'0')YesTB_KAPEFFINTMT Allow NULL? 
45DENDWOCAPEnd of Term Without Capitalization of Overdue Itemsnvarchar80DATS(N'00000000')YesTB_ENDWOCAP Allow NULL? 
46AINSTWOCAPPayment Installment Amount w/o Capitalizn of Overdue Itemsdecimal132CURR((0))YesTB_INSTWOCAP
47IENDPROPOSpecify New End of Termchar10CHAR(N' ')YesTB_IENDPROPO Allow NULL? 
48IINSTPROPOSpecify New Installmentchar10CHAR(N' ')YesTB_IINSTPROPO Allow NULL? 
49NINSTPROPOTotal No.Pymnt Installments with Capitalizn of Overdue Itemsnvarchar30NUMC(N'000')YesTB_NINSTPROPO Allow NULL? 
50NINSTWOCAPTotal No. Pymnt Installments w/o Capitalizn of Overdue Itemsnvarchar30NUMC(N'000')YesTB_NINSTWOCAP Allow NULL? 
51NOVRTWOCAPOverall Term in Months w/o Capitalization of Overdue Itemsnvarchar30NUMC(N'000')YesTB_NOVRTWOCAP Allow NULL? 
52NOVRTPROPOOverall Term in Months with Capitalization of Overdue Itemsnvarchar30NUMC(N'000')YesTB_NOVRTPROPO Allow NULL? 
53DSTARTREPRepayment Startnvarchar80DATS(N'00000000')YesTB_DSTARTREP Allow NULL? 
54DFIRST_DISBField of type DATSnvarchar80DATS(N'00000000')YesDATS Allow NULL? 
55DOEFFINTPYMNPKey Date for Last Change to Installment Plannvarchar80DATS(N'00000000')YesTB_MODEL_DATE_LAST_PAYMENTPLAN Allow NULL? 
56OEFFINTPYMNPEffective Interest Rate for Last Change to Installment Plandecimal107DEC((0))YesTB_MODEL_EFFECTIV_INTERSTS_PPC
57NMAXTERMNumber of Times Units for Maximum Term of Contractnvarchar40NUMC(N'0000')YesTB_PROD_TERM_MAX_VALUE Allow NULL? 
58AREIMBURSEMENTCredit Life Insurance Reimbursementdecimal132CURR((0))YesTB_CLI_RECALC_CONTR
59AINSURANCE_CONTRSingle Premium for Credit Life Insurancedecimal132CURR((0))YesTB_CLI_INSURANCE
60ADIFFERENCECalculated Difference for Credit Life Insurancedecimal132CURR((0))YesTB_LOLIINBAL
61ICONSIDERTransfer CLI Differencechar10CHAR(N' ')YesTB_ICONSIDER Allow NULL? 
62CALCULATION_DATECLI: Key Date for Calculation of Credit Life Insurancenvarchar80DATS(N'00000000')YesTB_CLI_CALCULATION_DATE Allow NULL? 
63UCLICURRPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')Yes*SBWHR Allow NULL? 
64CLI_FLOW_SBEWARTFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
65CLI_CHANGEDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
NamePrimaryUniqueTypeColumns
VDCAPITAL~0YesYesCLUSTEREDMANDT, BUKRS, SARCHIV, RANL, RBO

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