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/SDANA
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/SDANA1161Property tax return - itemsReal 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, SWENR, KEYNEM, CLISTU, NAZEVOBCE, NAZEVKU, NARPARK, PARCKMEN, PARCPOD, PARCDIL, VYMERA, PRAVZTAH, SV_CITATEL, SV_JMENOVATEL, VYMERAOSV, VYMERAPOD, ZASTPL, PLOCHANP, KODOSVOB, ROKOSVOD, ROKOSVDO, CENASTODH, CENAODHAD, POCPATER, CISLOP, ROKDOKONC, POPIS, CIZIPOZ, DRUHSTA, BYTKAT, SVISKONST, JEDNKMEN, JEDNBYT, PLNOSVOB, 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, X58_1, X58_2, X59_1, X59_2, X59_3, X59_4, X67, X68A, X68B, X69, X70, X71, X72, X73, X74, X75, X76, X77, X78, X79, X95, X96, X97, X98, X99, X100, X101, X102, X103, DATVYPOCTU, CASVYPOCTU, STAVYPOCTU, VYPOCETL, TBUKR2, MBUKR FROM /CEERE/SDANA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
4TYPDANPType of Tax Returnchar10CHAR(N' ')No/CEERE/TYPDANP Allow NULL? 
5TYPNEMProperty Categorychar10CHAR(N' ')No/CEERE/TPNEM/CEERE/TYPNEM Allow NULL? 
6DRNEMProperty Typechar10CHAR(N' ')No/CEERE/DRNEM/CEERE/DRUHNEM Allow NULL? 
7KODFUTax Office Codenvarchar30CHAR(N' ')No/CEERE/FU/CEERE/KODFU Allow NULL? 
8KODOBCECode of Municipality or City Districtnvarchar80CHAR(N' ')No/CEERE/OBCE/CEERE/KODOBCE Allow NULL? 
9GEMARKLocal Subdistrictnvarchar120CHAR(N' ')No/CEERE/KUVVGEMARK 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? 
14SWENRSite Numbernvarchar80CHAR(N' ')NoVIOB01SWENR Allow NULL? 
15KEYNEMProperty Keynvarchar80CHAR(N' ')No*/CEERE/KEYNEM Allow NULL? 
16CLISTUNumber of tax return sheetnvarchar30CHAR(N' ')No/CEERE/CLISTU Allow NULL? 
17NAZEVOBCEName of Municipality or City Districtnvarchar350CHAR(N' ')Yes/CEERE/NAZEVOBCE Allow NULL? 
18NAZEVKUCadastral District Namenvarchar400CHAR(N' ')Yes/CEERE/NAZEVKU Allow NULL? 
19NARPARKProperty Located in National Parkchar10CHAR(N' ')Yes/CEERE/NARPARK Allow NULL? 
20PARCKMENMaster Number of Parcelnvarchar50CHAR(N' ')Yes/CEERE/PARCKMEN Allow NULL? 
21PARCPODAdditional Number of Parcelnvarchar30CHAR(N' ')Yes/CEERE/PARCPOD Allow NULL? 
22PARCDILParcel Sub-Numbernvarchar20CHAR(N' ')Yes/CEERE/PARCDIL Allow NULL? 
23VYMERATotal Areadecimal92DEC((0))Yes/CEERE/VYMERA
24PRAVZTAHLegal Relationsnvarchar40CHAR(N' ')Yes/CEERE/PRAVZTAH Allow NULL? 
25SV_CITATELCo-Ownership Share (Numerator)decimal70DEC((0))Yes/CEERE/SV_CITATEL
26SV_JMENOVATELCo-Ownership Share (Denominator)decimal70DEC((0))Yes/CEERE/SV_JMENOVATEL
27VYMERAOSVArea Exempted From Taxdecimal92DEC((0))Yes/CEERE/VYMERAOSV
28VYMERAPODFloor Area for Businessdecimal92DEC((0))Yes/CEERE/VYMERAPOD
29ZASTPLCovered Areadecimal92DEC((0))Yes/CEERE/ZASTPL
30PLOCHANPTotal Area of Floors Above the Ground Floordecimal92DEC((0))Yes/CEERE/PLOCHANP
31KODOSVOBTax Exemption Codenvarchar50CHAR(N' ')Yes*/CEERE/KODOSVOB5 Allow NULL? 
32ROKOSVODTax Exemption Period: Start Yearnvarchar40NUMC(N'0000')Yes/CEERE/ROKOSVOD Allow NULL? 
33ROKOSVDOTax Exemption Period: End Yearnvarchar40NUMC(N'0000')Yes/CEERE/ROKOSVDO Allow NULL? 
34CENASTODHEstimated Pricechar10CHAR(N' ')Yes/CEERE/CENAODH Allow NULL? 
35CENAODHADEstimated Land Pricedecimal92DEC((0))Yes/CEERE/CENAP
36POCPATERNumber of Other Aboveground Floorsdecimal30DEC((0))Yes/CEERE/POCPATER
37CISLOPRegistration Numbernvarchar60CHAR(N' ')Yes/CEERE/CISLOP Allow NULL? 
38ROKDOKONCCompletion Year of Buildingnvarchar40NUMC(N'0000')Yes/CEERE/ROKDOKONC Allow NULL? 
39POPISName of Property Tax Objectnvarchar800CHAR(N' ')Yes/CEERE/POPISSTAVBY Allow NULL? 
40CIZIPOZBuilding on Third-Party Plotchar10CHAR(N' ')Yes/CEERE/CIZIPOZ Allow NULL? 
41DRUHSTABuilding Typenvarchar20CHAR(N' ')Yes/CEERE/DRUHSTA Allow NULL? 
42BYTKATApartment categorynvarchar40CHAR(N' ')Yes/CEERE/BYTKAT Allow NULL? 
43SVISKONSTVertical supporting structurenvarchar20CHAR(N' ')Yes/CEERE/SVISKONST Allow NULL? 
44JEDNKMENUnit-master partnvarchar60CHAR(N' ')Yes/CEERE/JEDNKMEN Allow NULL? 
45JEDNBYTUnit-apartmentnvarchar30CHAR(N' ')Yes/CEERE/JEDNBYT Allow NULL? 
46PLNOSVOBFull Tax Exemptionchar10CHAR(N' ')Yes/CEERE/PLNOSVOB Allow NULL? 
47WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
48X18Area of Land Typedecimal92DEC((0))Yes/CEERE/X18
49X19Land Price per Square Meterdecimal92DEC((0))Yes/CEERE/X19
50X20Tax Base According to Par.5 (1,2)decimal112CURR((0))Yes/CEERE/X20
51X21Tax Rate (Par. 6(1))decimal52DEC((0))Yes/CEERE/X21
52X22Tax Base (Par.5(3))decimal92DEC((0))Yes/CEERE/X22
53X23Tax Rate (Par 6(2))decimal52DEC((0))Yes/CEERE/X23
54X24Factor According to Par. 6(4)decimal52DEC((0))Yes/CEERE/X24
55X25Land Taxdecimal112CURR((0))Yes/CEERE/X25
56X26Claim for Exemption in Areadecimal92DEC((0))Yes/CEERE/X26
57X27Amount of Claim for Exemption (Par. 4,18(1))decimal112CURR((0))Yes/CEERE/X27
58X28Tax Liabilitydecimal112CURR((0))Yes/CEERE/X28
59X41Covered areadecimal92DEC((0))Yes/CEERE/X41
60X42Basic tax rate §11(1)decimal52DEC((0))Yes/CEERE/X42
61X43Number of above-ground floorsdecimal90DEC((0))Yes/CEERE/X43
62X44Incr.base rate for another above-ground floor §11(2)decimal92DEC((0))Yes/CEERE/X44
63X45Factor according to §11(3,4)decimal52DEC((0))Yes/CEERE/X45
64X46Resulting tax ratedecimal92DEC((0))Yes/CEERE/X46
65X47Building taxdecimal112CURR((0))Yes/CEERE/X47
66X48Business areadecimal92DEC((0))Yes/CEERE/X48
67X49Tax increase according to §11(5)decimal112CURR((0))Yes/CEERE/X49
68X50Area relation §9(2)decimal92DEC((0))Yes/CEERE/X50
69X51Amount of exempt claim §11decimal112CURR((0))Yes/CEERE/X51
70X52Amount of claim for deduction §18(2)decimal112CURR((0))Yes/CEERE/X52
71X53Tax liabilitydecimal112CURR((0))Yes/CEERE/X53
72X54_OTotal land tax - till 2008decimal112CURR((0))Yes/CEERE/X54_O
73X54Total Amount of Land Taxdecimal112CURR((0))Yes/CEERE/X54
74X54_BTotal Amount of Land Taxdecimal112CURR((0))Yes/CEERE/X54
75X55_OTotal building tax - till 2008decimal112CURR((0))Yes/CEERE/X55_O
76X55Total Amount of Building Taxdecimal112CURR((0))Yes/CEERE/X55
77X55_BTotal Amount of Building Taxdecimal112CURR((0))Yes/CEERE/X55
78X56_OTotal property tax - till 2008decimal112CURR((0))Yes/CEERE/X56_O
79X56Total Amount of Property Taxdecimal112CURR((0))Yes/CEERE/X56
80X56_BTotal Amount of Property Taxdecimal112CURR((0))Yes/CEERE/X56
81XKO12Municipality Coefficient (Par. 12)tinyint30INT1((0))Yes/CEERE/XKO12
82X58_1Installment 1decimal112CURR((0))Yes/CEERE/SPLATKA
83X58_2Installment 2decimal112CURR((0))Yes/CEERE/SPLATKA2
84X59_1Installment 1decimal112CURR((0))Yes/CEERE/SPLATKA
85X59_2Installment 2decimal112CURR((0))Yes/CEERE/SPLATKA2
86X59_3Installment 3decimal112CURR((0))Yes/CEERE/SPLATKA3
87X59_4Installment 4decimal112CURR((0))Yes/CEERE/SPLATKA4
88X67Land type areadecimal92DEC((0))Yes/CEERE/X67
89X68ACom.quotient denominatorint100INT4((0))Yes/CEERE/X68A Allow NULL? 
90X68BCom.quotient numeratorint100INT4((0))Yes/CEERE/X68B Allow NULL? 
91X69Co-owned land type aredecimal92DEC((0))Yes/CEERE/X69
92X70Land price per square meterdecimal92DEC((0))Yes/CEERE/X70
93X71Tax base according to p.5 par. 1,2decimal112CURR((0))Yes/CEERE/X71
94X72Tax rate §6(1)decimal52DEC((0))Yes/CEERE/X72
95X73Tax base §5(3)decimal92DEC((0))Yes/CEERE/X73
96X74Tax rate §6(2)decimal52DEC((0))Yes/CEERE/X74
97X75Factor according to §6(4)decimal52DEC((0))Yes/CEERE/X75
98X76Land taxdecimal112CURR((0))Yes/CEERE/X76
99X77Claim for area exemptdecimal92DEC((0))Yes/CEERE/X77
100X78Amount of claim for exempt §4,18(1)decimal112CURR((0))Yes/CEERE/X78
101X79Liability to pay taxesdecimal112CURR((0))Yes/CEERE/X79
102X95Floor area of the unitdecimal92DEC((0))Yes/CEERE/X95
103X96Factor according to §10(2)decimal52DEC((0))Yes/CEERE/X96
104X97Base tax rate according to §10(2)decimal92DEC((0))Yes/CEERE/X97
105X98Base tax rate according to §11(1)decimal52DEC((0))Yes/CEERE/X98
106X99Factor according to §11(3,4)decimal52DEC((0))Yes/CEERE/X99
107X100Resulting tax ratedecimal52DEC((0))Yes/CEERE/X100
108X101Building taxdecimal112CURR((0))Yes/CEERE/X101
109X102Amount of claim for exemption according to §9decimal112CURR((0))Yes/CEERE/X102
110X103Tax liabilitydecimal112CURR((0))Yes/CEERE/X103
111DATVYPOCTUCalculation Datenvarchar80DATS(N'00000000')Yes/CEERE/DATVYPOCTU Allow NULL? 
112CASVYPOCTUCalculation Timenvarchar60TIMS(N'000000')Yes/CEERE/CASVYPOCTU Allow NULL? 
113STAVYPOCTUCalculation statuschar10CHAR(N' ')Yes/CEERE/STAVYPOCTU Allow NULL? 
114VYPOCETLCalculation Executed bynvarchar120CHAR(N' ')Yes/CEERE/VYPOCETL Allow NULL? 
115TBUKR2Dominant Enterprise/Company Codenvarchar40CHAR(N' ')Yes*/CEERE/FOT_TBUKRS Allow NULL? 
116MBUKRIndicator: Dominant Company Codechar10CHAR(N' ')Yes/CEERE/MBUKR Allow NULL? 
NamePrimaryUniqueTypeColumns
/CEERE/SDANA~0YesYesCLUSTEREDCLISTU, KEYNEM, SWENR, AGR_PAR4, AGR_PAR3, AGR_PAR2, AGR_PAR1, GEMARK, KODOBCE, KODFU, DRNEM, TYPNEM, 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