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

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Financial Services :: Loans Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VDREPAYMENT1301Payoff Master DataLoans Management
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_STATUS, SFGKZ, SRELSTAT, SNOTIZ, DFAELL, BRVWR, DEFSZ, BRPWR, SBOTERM, XTEXT, SBWHR, SBRUTTO, SNETTO, BBBWHR, BCWHR, BADDFLOWS, BOVERDUE_ITEMS, BCREDITS, BPROPPAYMENTS, BDEFPAYMENTS, BREGPAYMENTS, BFELD1, BFELD2, BFELD3, BFELD4, BOUTSTANDING, IOA_AMOUNT, BOFFSETNG_FLOWS, BREFUND, BHWHR, KURS1, SINCL, SINCLINT, SVULT, DDISPO, SKALID, SKALID2, SBEWART, SGTXT, BRPWR_FAELL, DELFZ, DELFZ_REPAY, BAVWR, BPARTREDUCTION, BNONSETTLEDREPAY, JREPAY_SETTLEM, JREGPAYMENTS, SKOART, DGUEL_KP, BBASIS, PKOND, BKOND, SCONDCOLL, DDEFERRAL_FROM, DGUEL_KK, SPAYSIM, PSSDKURS, BNWHR, JNOREGSETTLE, DFAELL_ADJ, PARTNR, ZLSCH, BVTYP, SZART, JNODOIP, XNODUNN, KOSTL, SBUST, SZEGEN, DANGAM, DANGBIS, DANNAHME, DKUENDDG, SKUEND, RREJECT_REASON, RREPAY_REASON, KUNNR, ZAHLS, XCONDPAYDATA, MABER, MANSP, REMIT_INFO, MNDID, UZAWE, XNODUNN_OLD, JNODOIP_OLD, DEFSZ_OLD, CHANGED, DFPOSPO, MREQUESTOR, MSTOPCODE, MQUOTE, MCOM_STATUS, DCOM_STATUS, MREMITCODE, AACCRUED, APROJECTED, AINS_DEBIT, AINS_CREDIT, AINTDIEM, MNOINS, LIFE_REPAY, OVERDUE_ITEMS, FIRST_POS_NOTICE, INTERIM_ACCOUNT, ENFORCM_PAYM, STATI_OLD, DUNNING_DATE, DUNNING_LEVEL, CLR_CATEGORY, NO_INST_OLD, INST_NEW, NO_INST_NEW, EXIT_INST_NEW, EXIT_INST_OLD, MONTHS_OLD, MONTHS_NEW, AREIMBURSEMENT, AINSURANCE_CONTR, ADIFFERENCE, ICONSIDER, CALCULATION_DATE, UCLICURR, CLI_FLOW_SBEWART, CLI_CHANGED FROM VDREPAYMENT
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_STATUSBus. operation statuschar10CHAR(N' ')YesTB_SBOSTATUS Allow NULL? 
7SFGKZRelease Workflow Indicator for the Business Operationchar10CHAR(N' ')YesTB_SFGKZA Allow NULL? 
8SRELSTATInternal Release Status in the Business Operationschar10CHAR(N' ')YesTB_SRELSTAT Allow NULL? 
9SNOTIZIndicator for stored memochar10CHAR(N' ')YesSNOTIZ Allow NULL? 
10DFAELLDue Date of Business Operationnvarchar80DATS(N'00000000')YesTB_DFAELLR Allow NULL? 
11BRVWRAvailable Capital on Due Datedecimal152CURR((0))YesTB_BRVWR
12DEFSZDate of End of Fixed-Rate Periodnvarchar80DATS(N'00000000')YesTB_REPAY_DEFSZ Allow NULL? 
13BRPWRRemaining Capital at the End of the Fixed Perioddecimal152CURR((0))YesTB_BRPWR
14SBOTERMRepayment Change During Partial Payoffchar10CHAR(N' ')YesTB_SBOTERM Allow NULL? 
15XTEXTText (15 characters)nvarchar150CHAR(N' ')YesTEXT15 Allow NULL? 
16SBWHRPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')Yes*SBWHR Allow NULL? 
17SBRUTTOGross procedurechar10CHAR(N' ')YesTB_SBRUTTO Allow NULL? 
18SNETTONet procedurechar10CHAR(N' ')YesTB_SNETTO Allow NULL? 
19BBBWHRGross Payoff Amountdecimal132CURR((0))YesTB_BBBWHR
20BCWHRNet Payoff Amountdecimal132CURR((0))YesTB_BBNWHR
21BADDFLOWSOther Flowsdecimal132CURR((0))YesTB_ADDFLOWS
22BOVERDUE_ITEMSOverdue Itemsdecimal132CURR((0))YesTB_OVERDUE_ITEMS
23BCREDITSCredit Balancedecimal132CURR((0))YesTB_CREDITS
24BPROPPAYMENTSProportional Paymentsdecimal132CURR((0))YesTB_PROPPAYMENTS
25BDEFPAYMENTSDeferred Paymentsdecimal132CURR((0))YesTB_DEFPAYMENTS
26BREGPAYMENTSRegular Paymentsdecimal132CURR((0))YesTB_REGPAYMENTS
27BFELD1Amount Field 1decimal132CURR((0))YesTB_FELD1
28BFELD2Amount Field 2decimal132CURR((0))YesTB_FELD2
29BFELD3Amount Field 3decimal132CURR((0))YesTB_FELD3
30BFELD4Amount Field 4decimal132CURR((0))YesTB_FELD4
31BOUTSTANDINGPayments Outstanding Until Payoff Due Datedecimal132CURR((0))YesTB_OUTSTANDING
32IOA_AMOUNTInterest on Arrears Calculateddecimal132CURR((0))YesTB_IOA_CALCULATION_RESULT
33BOFFSETNG_FLOWSOffsetting Flows/Waivers/Write-Offsdecimal132CURR((0))YesTB_OFFSETNG_FLOWS
34BREFUNDRefund for PPIdecimal132CURR((0))YesTB_REFUND_CMLCHN
35BHWHRPayoff Amount in Local Currencydecimal132CURR((0))YesTB_BHNWHR
36KURS1Exchange ratedecimal95DEC((0))YesVVKURSF
37SINCLInclusive Indicator for Due Datechar10CHAR(N' ')YesTB_SINCL Allow NULL? 
38SINCLINTInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
39SVULTMonth-End Indicator for Due Datechar10CHAR(N' ')YesTB_SVULT Allow NULL? 
40DDISPOPayment Datenvarchar80DATS(N'00000000')YesTB_PAYDATE Allow NULL? 
41SKALIDFactory calendarnvarchar20CHAR(N' ')Yes*SKALID Allow NULL? 
42SKALID2Calendar ID 2 (valid in connection with calendar ID 1)nvarchar20CHAR(N' ')Yes*VVSKALID2 Allow NULL? 
43SBEWARTPayoff Flow Typenvarchar40CHAR(N' ')YesTZB0ATB_SBEWART Allow NULL? 
44SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
45BRPWR_FAELLRemaining Capital on Due Datedecimal152CURR((0))YesTB_BRPWR_FAELL
46DELFZPrevious Term End Without Payoff (Calculated)nvarchar80DATS(N'00000000')YesTB_DELFZ_WITHOUT_REPAY Allow NULL? 
47DELFZ_REPAYNew Term End With Payoffnvarchar80DATS(N'00000000')YesTB_DELFZ_WITH_REPAY Allow NULL? 
48BAVWRAvailable Disbursement Obligation on Due Datedecimal152CURR((0))YesTB_BAVVWR
49BPARTREDUCTIONReductiondecimal132CURR((0))YesTB_PARTREDUCTION
50BNONSETTLEDREPAYRepayment not Settleddecimal132CURR((0))YesTB_NONSETTLEDREPAY
51JREPAY_SETTLEMRepayment Settlementchar10CHAR(N' ')YesTB_JREPAY_SETTLEMENT Allow NULL? 
52JREGPAYMENTSTreatment of Regular Paymentschar10CHAR(N' ')YesTB_JREGPAYMENTS Allow NULL? 
53SKOARTPartial Payoff: Condition Type for Repayment ChangeCnvarchar40NUMC(N'0000')YesTZK01TB_SKOART Allow NULL? 
54DGUEL_KPRepayment Change Effective Fromnvarchar80DATS(N'00000000')YesTB_DGUEL_KP_REPAY Allow NULL? 
55BBASISBase Amount for Repayment Changedecimal132CURR((0))YesTB_BBASIS_REPAY
56PKONDRepayment Rate for Repayment Changedecimal107DEC((0))YesTB_PKOND_REPAY
57BKONDPayment Installment for Repayment Changedecimal132CURR((0))YesTB_BKOND_REPAY
58SCONDCOLLRepayment Clashchar10CHAR(N' ')YesTB_SCONDCOLL Allow NULL? 
59DDEFERRAL_FROMStart of Deferral Periodnvarchar80DATS(N'00000000')YesTB_DEFERRAL_FROM Allow NULL? 
60DGUEL_KKDate Condition Effective fromnvarchar80DATS(N'00000000')YesDGUEL Allow NULL? 
61SPAYSIMIndicator: Full Clearing for Actual Principle 1char10CHAR(N' ')YesTB_SPAYSIM Allow NULL? 
62PSSDKURSExchange Rate For Net Posted Borrower's Notesdecimal107DEC((0))YesTB_PSSDKURS
63BNWHRNominal Payoff Amountdecimal132CURR((0))YesTB_REPAY_BNWHR
64JNOREGSETTLEAvailable Capital Contains Regular Repaymentschar10CHAR(N' ')YesTB_NO_REG_SETTLEMENT Allow NULL? 
65DFAELL_ADJDue date adjustment indicatorchar10CHAR(N' ')YesTB_DFAELLR_ADJ_CMLCHN Allow NULL? 
66PARTNRPayer of Payoffnvarchar100CHAR(N' ')Yes*TB_PARTNR_REPAY Allow NULL? 
67ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
68BVTYPBank Details IDnvarchar40CHAR(N' ')YesTB_BVTYP Allow NULL? 
69SZARTPayment transactionchar10CHAR(N' ')YesTB_SZART Allow NULL? 
70JNODOIPBlocked by Payoff: No Open Item Clearing for Loanchar10CHAR(N' ')YesTB_JNODOIP Allow NULL? 
71XNODUNNExclude Loan from Dunning Runchar10CHAR(N' ')YesXNODUNN Allow NULL? 
72KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
73SBUSTPosting control keynvarchar20NUMC(N'00')YesTZB09VVSBUST Allow NULL? 
74SZEGENGenerate incoming payment immediatelynvarchar20NUMC(N'00')YesTD21SZEGEN Allow NULL? 
75DANGAMCreation Date for the Offernvarchar80DATS(N'00000000')YesTB_DANGAM_REPAY Allow NULL? 
76DANGBISEnd of the Validity Period of the Offernvarchar80DATS(N'00000000')YesTB_DANGBIS_REPAY Allow NULL? 
77DANNAHMEAcceptance Date of the Offernvarchar80DATS(N'00000000')YesTB_DANNAHME_REPAY Allow NULL? 
78DKUENDDGDate of Receipt of Noticenvarchar80DATS(N'00000000')YesTB_DKUEND_REPAY Allow NULL? 
79SKUENDReason for Noticenvarchar30NUMC(N'000')YesTD04TB_SKUEND_REPAY Allow NULL? 
80RREJECT_REASONReason for Rejectionnvarchar30CHAR(N' ')YesTDREPAY_REJECTTB_REJECT_REASON Allow NULL? 
81RREPAY_REASONPayoff Reasonnvarchar30NUMC(N'000')YesTD04TB_REPAY_REASON Allow NULL? 
82KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
83ZAHLSBlock Key for Paymentchar10CHAR(N' ')Yes*DZAHLS Allow NULL? 
84XCONDPAYDATAKeep Payment Data for Condition-Based Flows Acc to Cond.char10CHAR(N' ')YesXCONDPAYDATA Allow NULL? 
85MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
86MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
87REMIT_INFOPayment Notes Infonvarchar1400CHAR(N' ')YesTB_REMIT_INFO Allow NULL? 
88MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
89UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
90XNODUNN_OLDExclude Loan from Dunning Runchar10CHAR(N' ')YesXNODUNN Allow NULL? 
91JNODOIP_OLDBlocked by Payoff: No Open Item Clearing for Loanchar10CHAR(N' ')YesTB_JNODOIP Allow NULL? 
92DEFSZ_OLDDate of fixed period endnvarchar80DATS(N'00000000')YesVVDEFSZ Allow NULL? 
93CHANGEDchar10(N' ')Yes Allow NULL? 
94DFPOSPODate of Earliest Possible Payoffnvarchar80DATS(N'00000000')YesTB_DFPOSPO Allow NULL? 
95MREQUESTORBusiness Partner Requesting Payoff (BP Number)nvarchar100CHAR(N' ')YesTB_MREQUESTOR Allow NULL? 
96MSTOPCODETechnical Key for Stopnvarchar30CHAR(N' ')YesTB_STOP Allow NULL? 
97MQUOTEBusiness Operation Is Payoff Quote Or Payoffchar10CHAR(N' ')YesTB_MQUOTE Allow NULL? 
98MCOM_STATUSCommunication Statusnvarchar30NUMC(N'000')YesTDREPAY_COMSTATUTB_MCOM_STATUS Allow NULL? 
99DCOM_STATUSLast Change to Communication Statusnvarchar80DATS(N'00000000')YesTB_DCOM_STATUS Allow NULL? 
100MREMITCODERemittance Codenvarchar40CHAR(N' ')YesTB_REMIT_CODE Allow NULL? 
101AACCRUEDPayments Accrueddecimal132CURR((0))YesTB_AACCRUED
102APROJECTEDProjected Paymentsdecimal132CURR((0))YesTB_APROJECTED
103AINS_DEBITInsurance Receivables (Debit)decimal132CURR((0))YesTB_AINS_DEBIT
104AINS_CREDITInsurance Credit Memos (Credit)decimal132CURR((0))YesTB_AINS_CREDIT
105AINTDIEMInterest per Daydecimal132CURR((0))YesTB_AINTDIEM
106MNOINSNo Insurance Calculationchar10CHAR(N' ')YesTB_NOINS Allow NULL? 
107LIFE_REPAYCurrent Total Term of the Loan in Monthsdecimal60DEC((0))YesTB_LIFE_REPAY
108OVERDUE_ITEMSArrears of Contract Capital as a Percentagedecimal60DEC((0))YesTB_OVERDUE_ITEMS_REPAY
109FIRST_POS_NOTICEEarliest Possible Notice Datenvarchar80DATS(N'00000000')YesTB_FIRST_POS_NOTICE Allow NULL? 
110INTERIM_ACCOUNTReceivables Interim Accountnvarchar100CHAR(N' ')YesTB_INTERIM_ACCOUNT Allow NULL? 
111ENFORCM_PAYMCollectornvarchar100CHAR(N' ')Yes*TB_ENFORCM_PAYM Allow NULL? 
112STATI_OLDContract Status Before Activation of Noticenvarchar20NUMC(N'00')Yes*TB_NOTICE_STATI_OLD Allow NULL? 
113DUNNING_DATEDate of Last Dunning Noticenvarchar80DATS(N'00000000')YesTB_DUNNING_DATE_REPAY Allow NULL? 
114DUNNING_LEVELLast Dunning Levelchar10NUMC(N'0')YesTB_DUNNING_LEVEL_REPAY Allow NULL? 
115CLR_CATEGORYClearing Categorynvarchar20NUMC(N'00')YesTB_REPAY_CLR_CATEGORY Allow NULL? 
116NO_INST_OLDPrevious Total of Loan Installmentsnvarchar30NUMC(N'000')YesTB_NO_INST_OLD Allow NULL? 
117INST_NEWNew Figure for Payment Installmentsdecimal132CURR((0))YesTB_INST_NEW
118NO_INST_NEWNew Total Number of Loan Installmentsnvarchar30NUMC(N'000')YesTB_NO_INST_NEW Allow NULL? 
119EXIT_INST_NEWAmount of the Final Installment Payment for the Contractdecimal132CURR((0))YesTB_EXIT_INST
120EXIT_INST_OLDPrevious Amount of Clearing Installmentdecimal132CURR((0))YesTB_EXIT_INST_OLD
121MONTHS_OLDOverall Term in Months Without Payoffnvarchar30NUMC(N'000')YesTB_MONTHS_OLD Allow NULL? 
122MONTHS_NEWOverall Term in Months with Payoffnvarchar30NUMC(N'000')YesTB_MONTHS_NEW Allow NULL? 
123AREIMBURSEMENTCredit Life Insurance Reimbursementdecimal132CURR((0))YesTB_CLI_RECALC_CONTR
124AINSURANCE_CONTRSingle Premium for Credit Life Insurancedecimal132CURR((0))YesTB_CLI_INSURANCE
125ADIFFERENCECalculated Difference for Credit Life Insurancedecimal132CURR((0))YesTB_LOLIINBAL
126ICONSIDERTransfer CLI Differencechar10CHAR(N' ')YesTB_ICONSIDER Allow NULL? 
127CALCULATION_DATECLI: Key Date for Calculation of Credit Life Insurancenvarchar80DATS(N'00000000')YesTB_CLI_CALCULATION_DATE Allow NULL? 
128UCLICURRPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')Yes*SBWHR Allow NULL? 
129CLI_FLOW_SBEWARTFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
130CLI_CHANGEDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
NamePrimaryUniqueTypeColumns
VDREPAYMENT~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