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  | /CEERE/SDAN
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 :: Real Estate Localization :: Real Estate Localization Czech Republic
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/CEERE/SDAN822Property tax return - sheetsReal Estate Localization Czech Republic
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, GJAHR, TYPDANP, TYPNEM, DRNEM, KODFU, KODOBCE, GEMARK, AGR_PAR1, AGR_PAR2, AGR_PAR3, AGR_PAR4, WAERS, X18, X19, X20, X21, X22, X23, X24, X25, X26, X27, X28, X41, X42, X43, X44, X45, X46, X47, X48, X49, X50, X51, X52, X53, X54_O, X54, X54_B, X55_O, X55, X55_B, X56_O, X56, X56_B, XKO12, X67, X68A, X68B, X69, X70, X71, X72, X73, X74, X75, X76, X77, X78, X79, X95, X96, X97, X98, X99, X100, X101, X102, X103, CLISTU, STAVLISTU, DATVYPOCTU, CASVYPOCTU, VYPOCETL, MBUKR, LISTCISLO, RVZ_PODNIK, VYM_PODNIKPO, KC_ZVDA115PO, KC_DANOSV3PO FROM /CEERE/SDAN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
4TYPDANPType of Tax Returnchar10CHAR(N' ')No/CEERE/TYPDANP Allow NULL? 
5TYPNEMProperty Categorychar10CHAR(N' ')No*/CEERE/TYPNEM Allow NULL? 
6DRNEMProperty Typechar10CHAR(N' ')No*/CEERE/DRUHNEM Allow NULL? 
7KODFUTax Office Codenvarchar30CHAR(N' ')No*/CEERE/KODFU Allow NULL? 
8KODOBCECode of Municipality or City Districtnvarchar80CHAR(N' ')No*/CEERE/KODOBCE Allow NULL? 
9GEMARKLocal Subdistrictnvarchar120CHAR(N' ')No*VVGEMARK Allow NULL? 
10AGR_PAR1Free aggregation parameternvarchar100CHAR(N' ')No/CEERE/AGR_PAR Allow NULL? 
11AGR_PAR2Free aggregation parameternvarchar100CHAR(N' ')No/CEERE/AGR_PAR Allow NULL? 
12AGR_PAR3Free aggregation parameternvarchar100CHAR(N' ')No/CEERE/AGR_PAR Allow NULL? 
13AGR_PAR4Free aggregation parameternvarchar100CHAR(N' ')No/CEERE/AGR_PAR Allow NULL? 
14WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
15X18Area of Land Typedecimal92DEC((0))Yes/CEERE/X18
16X19Land Price per Square Meterdecimal92DEC((0))Yes/CEERE/X19
17X20Tax Base According to Par.5 (1,2)decimal112CURR((0))Yes/CEERE/X20
18X21Tax Rate (Par. 6(1))decimal52DEC((0))Yes/CEERE/X21
19X22Tax Base (Par.5(3))decimal92DEC((0))Yes/CEERE/X22
20X23Tax Rate (Par 6(2))decimal52DEC((0))Yes/CEERE/X23
21X24Factor According to Par. 6(4)decimal52DEC((0))Yes/CEERE/X24
22X25Land Taxdecimal112CURR((0))Yes/CEERE/X25
23X26Claim for Exemption in Areadecimal92DEC((0))Yes/CEERE/X26
24X27Amount of Claim for Exemption (Par. 4,18(1))decimal112CURR((0))Yes/CEERE/X27
25X28Tax Liabilitydecimal112CURR((0))Yes/CEERE/X28
26X41Covered areadecimal92DEC((0))Yes/CEERE/X41
27X42Basic tax rate §11(1)decimal52DEC((0))Yes/CEERE/X42
28X43Number of above-ground floorsdecimal90DEC((0))Yes/CEERE/X43
29X44Incr.base rate for another above-ground floor §11(2)decimal92DEC((0))Yes/CEERE/X44
30X45Factor according to §11(3,4)decimal52DEC((0))Yes/CEERE/X45
31X46Resulting tax ratedecimal92DEC((0))Yes/CEERE/X46
32X47Building taxdecimal112CURR((0))Yes/CEERE/X47
33X48Business areadecimal92DEC((0))Yes/CEERE/X48
34X49Tax increase according to §11(5)decimal112CURR((0))Yes/CEERE/X49
35X50Area relation §9(2)decimal92DEC((0))Yes/CEERE/X50
36X51Amount of exempt claim §11decimal112CURR((0))Yes/CEERE/X51
37X52Amount of claim for deduction §18(2)decimal112CURR((0))Yes/CEERE/X52
38X53Tax liabilitydecimal112CURR((0))Yes/CEERE/X53
39X54_OTotal land tax - till 2008decimal112CURR((0))Yes/CEERE/X54_O
40X54Total Amount of Land Taxdecimal112CURR((0))Yes/CEERE/X54
41X54_BTotal Amount of Land Taxdecimal112CURR((0))Yes/CEERE/X54
42X55_OTotal building tax - till 2008decimal112CURR((0))Yes/CEERE/X55_O
43X55Total Amount of Building Taxdecimal112CURR((0))Yes/CEERE/X55
44X55_BTotal Amount of Building Taxdecimal112CURR((0))Yes/CEERE/X55
45X56_OTotal property tax - till 2008decimal112CURR((0))Yes/CEERE/X56_O
46X56Total Amount of Property Taxdecimal112CURR((0))Yes/CEERE/X56
47X56_BTotal Amount of Property Taxdecimal112CURR((0))Yes/CEERE/X56
48XKO12Municipality Coefficient (Par. 12)tinyint30INT1((0))Yes/CEERE/XKO12
49X67Land type areadecimal92DEC((0))Yes/CEERE/X67
50X68ACom.quotient denominatorint100INT4((0))Yes/CEERE/X68A Allow NULL? 
51X68BCom.quotient numeratorint100INT4((0))Yes/CEERE/X68B Allow NULL? 
52X69Co-owned land type aredecimal92DEC((0))Yes/CEERE/X69
53X70Land price per square meterdecimal92DEC((0))Yes/CEERE/X70
54X71Tax base according to p.5 par. 1,2decimal112CURR((0))Yes/CEERE/X71
55X72Tax rate §6(1)decimal52DEC((0))Yes/CEERE/X72
56X73Tax base §5(3)decimal92DEC((0))Yes/CEERE/X73
57X74Tax rate §6(2)decimal52DEC((0))Yes/CEERE/X74
58X75Factor according to §6(4)decimal52DEC((0))Yes/CEERE/X75
59X76Land taxdecimal112CURR((0))Yes/CEERE/X76
60X77Claim for area exemptdecimal92DEC((0))Yes/CEERE/X77
61X78Amount of claim for exempt §4,18(1)decimal112CURR((0))Yes/CEERE/X78
62X79Liability to pay taxesdecimal112CURR((0))Yes/CEERE/X79
63X95Floor area of the unitdecimal92DEC((0))Yes/CEERE/X95
64X96Factor according to §10(2)decimal52DEC((0))Yes/CEERE/X96
65X97Base tax rate according to §10(2)decimal92DEC((0))Yes/CEERE/X97
66X98Base tax rate according to §11(1)decimal52DEC((0))Yes/CEERE/X98
67X99Factor according to §11(3,4)decimal52DEC((0))Yes/CEERE/X99
68X100Resulting tax ratedecimal52DEC((0))Yes/CEERE/X100
69X101Building taxdecimal112CURR((0))Yes/CEERE/X101
70X102Amount of claim for exemption according to §9decimal112CURR((0))Yes/CEERE/X102
71X103Tax liabilitydecimal112CURR((0))Yes/CEERE/X103
72CLISTUNumber of tax return sheetnvarchar30CHAR(N' ')Yes/CEERE/CLISTU Allow NULL? 
73STAVLISTUStatus of tax return sheetchar10CHAR(N' ')Yes/CEERE/STAVLISTU Allow NULL? 
74DATVYPOCTUCalculation Datenvarchar80DATS(N'00000000')Yes/CEERE/DATVYPOCTU Allow NULL? 
75CASVYPOCTUCalculation Timenvarchar60TIMS(N'000000')Yes/CEERE/CASVYPOCTU Allow NULL? 
76VYPOCETLCalculation Executed bynvarchar120CHAR(N' ')Yes/CEERE/VYPOCETL Allow NULL? 
77MBUKRIndicator: Dominant Company Codechar10CHAR(N' ')Yes/CEERE/MBUKR Allow NULL? 
78LISTCISLONumc3, internal usenvarchar30NUMC(N'000')YesNUMC3 Allow NULL? 
79RVZ_PODNIKNon-residential Property Type Used for Businesschar10CHAR(N' ')Yes/CEERE/RVZ_PODNIK Allow NULL? 
80VYM_PODNIKPOLandscaped area designed for businessdecimal92DEC((0))Yes/CEERE/VYM_PODNIKPO
81KC_ZVDA115POThe increase in tax under § 11adecimal112CURR((0))Yes/CEERE/KC_ZVDA115PO
82KC_DANOSV3POProperty Tax increased from amount under § 11 (5)decimal112CURR((0))Yes/CEERE/KC_DANOSV3PO
NamePrimaryUniqueTypeColumns
/CEERE/SDAN~0YesYesCLUSTEREDAGR_PAR4, AGR_PAR3, AGR_PAR2, AGR_PAR1, GEMARK, KODOBCE, KODFU, DRNEM, TYPNEM, TYPDANP, GJAHR, BUKRS, MANDT
/CEERE/SDAN~FUNoNoNONCLUSTEREDKODFU, TYPDANP, GJAHR, BUKRS, MANDT

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