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  | VILMNAVAL
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
Real Estate Management :: Flexible Real Estate Management :: Land Use Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VILMNAVAL511Notice of Assessment: Annual ValuesLand Use Management
SQL:  selectupdate insert create

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

SELECT MANDT, INTRENO, VALIDFROM, VALIDTO, ASSESSDATE, ASSESSVALUE, CURRENCY, TAXVAL1, TAXVAL2, MEASVALUE, MEASUNIT, NAPRTYPE, LOCATION1, LOCATION2, SEARCHTERM, MCLOCATION1, MCLOCATION2, MCSEARCHTERM, NASTMNTTYPE, NAOWNREL, NAMETHOD, NAPRTYPEAR, ZONEMEAS1, ZONEMEASUNIT1, ZONEVALUE1, ZONEMEAS2, ZONEMEASUNIT2, ZONEVALUE2, ZONEMEAS3, ZONEMEASUNIT3, ZONEVALUE3, PROPERTYVAL1, BUILDINGVAL1, GROUNDVAL, BASICVAL, CALCPERCENT, PROPERTYVAL2, BUILDINGVAL2, CALCVALUE, CALCDIFF, DIFFERENCE, MEAS1, MEASUNIT1, MEAS2, MEASUNIT2, MEAS3, MEASUNIT3, MEAS4, MEASUNIT4, MEAS5, MEASUNIT5 FROM VILMNAVAL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2INTRENOInternal Key of Real Estate Objectnvarchar130CHAR(N' ')NoRECAINTRENO Allow NULL? 
3VALIDFROMAssessed Value Valid Fromnvarchar80DATS(N'00000000')NoRELMNAVVALIDFROM Allow NULL? 
4VALIDTOAssessed Value Valid Tonvarchar80DATS(N'00000000')YesRELMNAVVALIDTO Allow NULL? 
5ASSESSDATEDate of Notice of Assessmentnvarchar80DATS(N'00000000')YesRELMNAVALUEDATE Allow NULL? 
6ASSESSVALUEAssessed Value: Landdecimal152CURR((0))YesRELMNAVALUE
7CURRENCYCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
8TAXVAL1Basic Property Tax Amountdecimal152CURR((0))YesRELMNATAXVAL1
9TAXVAL2Assessed Value Based on Valuation Law (Germany)decimal152CURR((0))YesRELMNATAXVAL2
10MEASVALUETotal Size of Areadecimal174QUAN((0))YesRELMNAMEASVALUE
11MEASUNITMeasurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
12NAPRTYPELand Type in Notice of Assessmentnvarchar40CHAR(N' ')YesTIVLMNAPRTYRELMNAPRTYPE Allow NULL? 
13LOCATION1Assessed Value: Location Namenvarchar600CHAR(N' ')YesRELMNALOCATION1 Allow NULL? 
14LOCATION2Assessed Value: Location Name 2nvarchar600CHAR(N' ')YesRELMNALOCATION2 Allow NULL? 
15SEARCHTERMAssessed Value: Custom Search Termnvarchar350CHAR(N' ')YesRELMNASEARCHTERM Allow NULL? 
16MCLOCATION1Assessed Value: Location Namenvarchar600CHAR(N' ')YesRELMNAMCLOCATION1 Allow NULL? 
17MCLOCATION2Assessed Value: Location Namenvarchar600CHAR(N' ')YesRELMNAMCLOCATION2 Allow NULL? 
18MCSEARCHTERMAssessed Value: Custom Search Termnvarchar350CHAR(N' ')YesRELMNALOCSEARCHTERM Allow NULL? 
19NASTMNTTYPEDetermination Type in Notice of Assessmentnvarchar40CHAR(N' ')YesTIVLMNASTTYRELMNASTMNTTYPE Allow NULL? 
20NAOWNRELType of Possession in Notice of Assessmentnvarchar40CHAR(N' ')YesTIVLMNAOWNRELRELMNAOWNREL Allow NULL? 
21NAMETHODType of Method in Notice of Assessmentnvarchar40CHAR(N' ')YesRELMNAMETHOD Allow NULL? 
22NAPRTYPEARLand Type for Assessment Ratenvarchar40CHAR(N' ')YesTIVLMNAPRTYARRELMNAPRTYPEAR Allow NULL? 
23ZONEMEAS1Area of Zone 1decimal174QUAN((0))YesRELMNAZONEMEAS1
24ZONEMEASUNIT1Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
25ZONEVALUE1Value per Measurement Unit Zone 1decimal152CURR((0))YesRELMNAZONEVALUE1
26ZONEMEAS2Area of Zone 2decimal174QUAN((0))YesRELMNAZONEMEAS2
27ZONEMEASUNIT2Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
28ZONEVALUE2Value per Measurement Unit Zone 2decimal152CURR((0))YesRELMNAZONEVALUE2
29ZONEMEAS3Area of Zone 3decimal174QUAN((0))YesRELMNAZONEMEAS3
30ZONEMEASUNIT3Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
31ZONEVALUE3Value per Measurement Unit Zone 3decimal152CURR((0))YesRELMNAZONEVALUE3
32PROPERTYVAL1Land Valuedecimal152CURR((0))YesRELMNAPROPERTYVAL1
33BUILDINGVAL1Building Valuedecimal152CURR((0))YesRELMNABUILDINGVAL1
34GROUNDVALValue of Grounds Improvementsdecimal152CURR((0))YesRELMNAGROUNDVAL
35BASICVALStarting Valuedecimal152CURR((0))YesRELMNABASICVAL
36CALCPERCENTValue Used in Calculating Cost Approach to Appraisaldecimal52DEC((0))YesRELMNACALCPERCENT
37PROPERTYVAL2Land Value Portiondecimal152CURR((0))YesRELMNAPROPERTYVAL2
38BUILDINGVAL2Building Value Portiondecimal152CURR((0))YesRELMNABUILDINGVAL2
39CALCVALUECalculated Assessed Valuedecimal152CURR((0))YesRELMNACALCVALUE
40CALCDIFFCalculated Differencedecimal152CURR((0))YesRELMNACALCDIFF
41DIFFERENCESpecified Differencedecimal152CURR((0))YesRELMNADIFFERENCE
42MEAS1Area Used for Agriculturedecimal174QUAN((0))YesRELMNAMEAS1
43MEASUNIT1Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
44MEAS2Area Is Poorest Quality Landdecimal174QUAN((0))YesRELMNAMEAS2
45MEASUNIT2Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
46MEAS3Area Is Unusable Landdecimal174QUAN((0))YesRELMNAMEAS3
47MEASUNIT3Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
48MEAS4Area of Courtyard and Buildingsdecimal174QUAN((0))YesRELMNAMEAS4
49MEASUNIT4Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
50MEAS5Area Used for Forestrydecimal174QUAN((0))YesRELMNAMEAS5
51MEASUNIT5Measurement Unitnvarchar30UNIT(N' ')YesT006REBDMEASUNIT Allow NULL? 
NamePrimaryUniqueTypeColumns
VILMNAVAL~0YesYesCLUSTEREDMANDT, INTRENO, VALIDFROM

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