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  | VDDEFERRAL
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)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Services :: Loans Management :: Portfolio
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VDDEFERRAL571Deferral DataPortfolio
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, IDEFMANUPROC, MDEFREASON, ADEFERR, DDEFKYDTE, PDEFINTRT, MINTDYMT, DFRSTDUDTE, IULTIDUDTE, IINCLDUDTE, MNUMRTS, MRHYTHM, MWRKDYRL, MPUHOLCAL, IFREEPAYM, MPARTKUNNR, MPARTNER, MBANKTYPE, MPAYMTHD, PEFFINTRT, MEFFINTMT, MNDID FROM VDDEFERRAL
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? 
37IDEFMANUPROCReason for Postprocessing: Keynvarchar30NUMC(N'000')YesTDDEF_POSTPRTB_MAN_POSTPROCESS Allow NULL? 
38MDEFREASONReason for Deferral: Keynvarchar30NUMC(N'000')YesTDDEF_REASONTB_DEFREASON Allow NULL? 
39ADEFERRDeferral Amountdecimal132CURR((0))YesTB_DEFAMO
40DDEFKYDTEKey Date for Deferralnvarchar80DATS(N'00000000')YesTB_DEFKYDTE Allow NULL? 
41PDEFINTRTInterest Rate for the Deferraldecimal107DEC((0))YesTB_DEFINTRT
42MINTDYMTInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
43DFRSTDUDTEDue Date of First Installment Payment for Deferral Plannvarchar80DATS(N'00000000')YesTB_FRSDUDTE Allow NULL? 
44IULTIDUDTEDue Date Is Always on the Last Day of the Monthchar10CHAR(N' ')YesTB_ULTIDUDTE Allow NULL? 
45IINCLDUDTEIncluding Due Datechar10CHAR(N' ')YesTB_INCLDUDTE Allow NULL? 
46MNUMRTSNumber of Payment Installments in the Deferral Plannvarchar30NUMC(N'000')YesTB_NUMRTS Allow NULL? 
47MRHYTHMFrequency of Installment Payments in Monthsnvarchar30NUMC(N'000')YesTB_RHYTHM Allow NULL? 
48MWRKDYRLWorking Day Shift for Calculation Daychar10NUMC(N'0')YesTB_SVWERK Allow NULL? 
49MPUHOLCALFactory calendarnvarchar20CHAR(N' ')Yes*SKALID Allow NULL? 
50IFREEPAYMCustom Deferral Planchar10CHAR(N' ')YesTB_FREEPAYM Allow NULL? 
51MPARTKUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
52MPARTNERBusiness Partner Number for Payer of Deferral Installmentsnvarchar100CHAR(N' ')Yes*TB_DEFPARTNER Allow NULL? 
53MBANKTYPEBank Details ID for Deferral Installmentsnvarchar40CHAR(N' ')YesTB_DEFBVTYP Allow NULL? 
54MPAYMTHDPayment Method for Deferral Installmentschar10CHAR(N' ')Yes*TB_DEFPYMTD Allow NULL? 
55PEFFINTRTEffective Interest Rate for Deferral Agreementdecimal107DEC((0))YesTB_EFFINTRT
56MEFFINTMTEffective Interest Method for Deferral Agreementchar10NUMC(N'0')YesTB_EFFINTMT Allow NULL? 
57MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
NamePrimaryUniqueTypeColumns
VDDEFERRAL~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