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  | VDBILL_RES_HEAD
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.0VDBILL_RES_HEAD341Bill Results HeaderPortfolio
SQL:  selectupdate insert create

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

SELECT MANDT, BILL_NUMBER, BUKRS, ACCOUNT, BILL_CATEGORY, REMITTANCE_CODE, MICR_CODE, BILL_DATE, DUE_DATE, GRACE_DATE, MATURITY_DATE, BILL_FORMAT, BEGIN_BALANCE, END_BALANCE, TOTAL_DUE, MINIMUM_DUE, PRIN_BALANCE, ADB, TOTAL_FEES, CURRENCY, APR, PER_RATE, NEXT_RATE, INT_YTD, PARTNER, NAME_LAST, NAME_FIRST, STREETCODE, STREET, HOUSE_NUM, CITY, REGION, POST_CODE1, POST_CODE2 FROM VDBILL_RES_HEAD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BILL_NUMBERBill Numbernvarchar150CHAR(N' ')NoVDBILL_HISTTB_BILL_NUMBER Allow NULL? 
3BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
4ACCOUNTContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
5BILL_CATEGORYBilling Categorynvarchar20NUMC(N'00')YesTDBILL_CATEGTB_BILL_METH Allow NULL? 
6REMITTANCE_CODERemittance Codenvarchar40CHAR(N' ')YesTB_REMIT_CODE Allow NULL? 
7MICR_CODECode for Magnetic Ink Character Recognition (MICR)nvarchar1280CHAR(N' ')YesTB_MICR_CODE Allow NULL? 
8BILL_DATEBill Creation Datenvarchar80DATS(N'00000000')YesTB_BILL_DATE Allow NULL? 
9DUE_DATEDue date/calculation datenvarchar80DATS(N'00000000')YesDFAELLIG Allow NULL? 
10GRACE_DATELast Day of Grace Periodnvarchar80DATS(N'00000000')YesTB_GRACE_DATE Allow NULL? 
11MATURITY_DATEEnd of Loan Termnvarchar80DATS(N'00000000')YesDENDLFZ Allow NULL? 
12BILL_FORMATBill Format Keychar10NUMC(N'0')YesTB_BILL_FORMAT Allow NULL? 
13BEGIN_BALANCERemaining Capital at Start of a Billing Perioddecimal132CURR((0))YesTB_BEG_BALANCE
14END_BALANCEClosing Balance for Billing Perioddecimal132CURR((0))YesTB_END_BALANCE
15TOTAL_DUETotal Due Amount for Billdecimal132CURR((0))YesTB_BILL_DUE
16MINIMUM_DUEMinimum Due Amount for a Billdecimal132CURR((0))YesTB_MIN_DUE
17PRIN_BALANCEOutstanding Net Payoff Amountdecimal132CURR((0))YesTB_PRIN_BALANCE
18ADBAverage Daily Balancedecimal132CURR((0))YesTB_ADB
19TOTAL_FEESCharges per Billing Perioddecimal132CURR((0))YesTB_TOTAL_FEES
20CURRENCYBill Currencynvarchar50CUKY(N' ')Yes*TB_BILL_CURR Allow NULL? 
21APRAnnual Percentage Rate (APR)decimal107DEC((0))YesTB_APR
22PER_RATEDaily Interest Ratedecimal107DEC((0))YesTB_PER_RATE
23NEXT_RATEInterest Rate for Next Perioddecimal107DEC((0))YesTB_NEXT_PER_RATE
24INT_YTDInterest Paid - Year-to-Datedecimal132CURR((0))YesTB_INT_YTD
25PARTNERBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
26NAME_LASTLast namenvarchar400CHAR(N' ')YesAD_NAMELAS Allow NULL? 
27NAME_FIRSTFirst namenvarchar400CHAR(N' ')YesAD_NAMEFIR Allow NULL? 
28STREETCODEStreet Number for City/Street Filenvarchar120CHAR(N' ')Yes*AD_STRNUM Allow NULL? 
29STREETStreetnvarchar600CHAR(N' ')YesAD_STREET Allow NULL? 
30HOUSE_NUMHouse Numbernvarchar100CHAR(N' ')YesAD_HSNM1 Allow NULL? 
31CITYCitynvarchar400CHAR(N' ')YesAD_CITY1 Allow NULL? 
32REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
33POST_CODE1City postal codenvarchar100CHAR(N' ')YesAD_PSTCD1 Allow NULL? 
34POST_CODE2PO Box Postal Codenvarchar100CHAR(N' ')YesAD_PSTCD2 Allow NULL? 
NamePrimaryUniqueTypeColumns
VDBILL_RES_HEAD~0YesYesCLUSTEREDMANDT, BILL_NUMBER

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