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/SDANP
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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Real Estate Management :: Flexible Real Estate Management :: Real Estate Localization :: Real Estate Localization Czech Republic
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/CEERE/SDANP1412Property tax - masterReal 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, TYPNEMREM, SWENR, KEYNEM, TYPNEM, DRNEM, KODFU, KODOBCE, NAZEVOBCE, KODCOBCE, GEMARK, 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, DATZMENY, CASZMENY, ZMENIL, 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, AGR_PAR1, AGR_PAR2, AGR_PAR3, AGR_PAR4, ANLN1, ANLN2, KOSTL, GSBER, PRCTR, AUFNR, PS_PSP_PNR, XDAN, DATVYPOCTU, CASVYPOCTU, STAVYPOCTU, VYPOCETL, TBUKR2, MBUKR, SOLIDAGR, SOLIDIND, SOLAAGRE, SOLAINDE, YEAGREFR, YEINDEFR, YEAGRETO, YEINDETO, CODEAGRE, CODEINDE, RVZ_PODNIK, VYM_PODNIKPO, KC_ZVDA115PO, KC_DANOSV3PO FROM /CEERE/SDANP
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? 
4TYPNEMREMReal Estate Object Typechar10CHAR(N' ')No/CEERE/TYPNEMREM Allow NULL? 
5SWENRSite Numbernvarchar80CHAR(N' ')NoVIOB01SWENR Allow NULL? 
6KEYNEMProperty Keynvarchar80CHAR(N' ')No*/CEERE/KEYNEM Allow NULL? 
7TYPNEMProperty Categorychar10CHAR(N' ')Yes/CEERE/TPNEM/CEERE/TYPNEM Allow NULL? 
8DRNEMProperty Typechar10CHAR(N' ')Yes/CEERE/DRNEM/CEERE/DRUHNEM Allow NULL? 
9KODFUTax Office Codenvarchar30CHAR(N' ')Yes/CEERE/FUC/CEERE/KODFU Allow NULL? 
10KODOBCECode of Municipality or City Districtnvarchar80CHAR(N' ')Yes/CEERE/OBCE/CEERE/KODOBCE Allow NULL? 
11NAZEVOBCEName of Municipality or City Districtnvarchar350CHAR(N' ')Yes/CEERE/NAZEVOBCE Allow NULL? 
12KODCOBCEDistrict Codenvarchar60CHAR(N' ')Yes*/CEERE/KODCOBCE Allow NULL? 
13GEMARKLocal Subdistrictnvarchar120CHAR(N' ')Yes/CEERE/KUVVGEMARK Allow NULL? 
14NAZEVKUCadastral District Namenvarchar400CHAR(N' ')Yes/CEERE/NAZEVKU Allow NULL? 
15NARPARKProperty Located in National Parkchar10CHAR(N' ')Yes/CEERE/NARPARK Allow NULL? 
16PARCKMENMaster Number of Parcelnvarchar50CHAR(N' ')Yes/CEERE/PARCKMEN Allow NULL? 
17PARCPODAdditional Number of Parcelnvarchar30CHAR(N' ')Yes/CEERE/PARCPOD Allow NULL? 
18PARCDILParcel Sub-Numbernvarchar20CHAR(N' ')Yes/CEERE/PARCDIL Allow NULL? 
19VYMERATotal Areadecimal92DEC((0))Yes/CEERE/VYMERA
20PRAVZTAHLegal Relationsnvarchar40CHAR(N' ')Yes/CEERE/PRAVZTAH Allow NULL? 
21SV_CITATELCo-Ownership Share (Numerator)decimal70DEC((0))Yes/CEERE/SV_CITATEL
22SV_JMENOVATELCo-Ownership Share (Denominator)decimal70DEC((0))Yes/CEERE/SV_JMENOVATEL
23VYMERAOSVArea Exempted From Taxdecimal92DEC((0))Yes/CEERE/VYMERAOSV
24VYMERAPODFloor Area for Businessdecimal92DEC((0))Yes/CEERE/VYMERAPOD
25ZASTPLCovered Areadecimal92DEC((0))Yes/CEERE/ZASTPL
26PLOCHANPTotal Area of Floors Above the Ground Floordecimal92DEC((0))Yes/CEERE/PLOCHANP
27KODOSVOBTax Exemption Codenvarchar50CHAR(N' ')Yes*/CEERE/KODOSVOB5 Allow NULL? 
28ROKOSVODTax Exemption Period: Start Yearnvarchar40NUMC(N'0000')Yes/CEERE/ROKOSVOD Allow NULL? 
29ROKOSVDOTax Exemption Period: End Yearnvarchar40NUMC(N'0000')Yes/CEERE/ROKOSVDO Allow NULL? 
30CENASTODHEstimated Pricechar10CHAR(N' ')Yes/CEERE/CENAODH Allow NULL? 
31CENAODHADEstimated Land Pricedecimal92DEC((0))Yes/CEERE/CENAP
32POCPATERNumber of Other Aboveground Floorsdecimal30DEC((0))Yes/CEERE/POCPATER
33CISLOPRegistration Numbernvarchar60CHAR(N' ')Yes/CEERE/CISLOP Allow NULL? 
34ROKDOKONCCompletion Year of Buildingnvarchar40NUMC(N'0000')Yes/CEERE/ROKDOKONC Allow NULL? 
35POPISName of Property Tax Objectnvarchar800CHAR(N' ')Yes/CEERE/POPISSTAVBY Allow NULL? 
36CIZIPOZBuilding on Third-Party Plotchar10CHAR(N' ')Yes/CEERE/CIZIPOZ Allow NULL? 
37DRUHSTABuilding Typenvarchar20CHAR(N' ')Yes/CEERE/DRUHSTA Allow NULL? 
38BYTKATApartment categorynvarchar40CHAR(N' ')Yes/CEERE/BYTKAT Allow NULL? 
39SVISKONSTVertical supporting structurenvarchar20CHAR(N' ')Yes/CEERE/SVISKONST Allow NULL? 
40JEDNKMENUnit-master partnvarchar60CHAR(N' ')Yes/CEERE/JEDNKMEN Allow NULL? 
41JEDNBYTUnit-apartmentnvarchar30CHAR(N' ')Yes/CEERE/JEDNBYT Allow NULL? 
42PLNOSVOBFull Tax Exemptionchar10CHAR(N' ')Yes/CEERE/PLNOSVOB Allow NULL? 
43DATZMENYDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
44CASZMENYTimenvarchar60TIMS(N'000000')YesUZEIT Allow NULL? 
45ZMENILChanged bynvarchar120CHAR(N' ')YesUSER Allow NULL? 
46WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
47X18Area of Land Typedecimal92DEC((0))Yes/CEERE/X18
48X19Land Price per Square Meterdecimal92DEC((0))Yes/CEERE/X19
49X20Tax Base According to Par.5 (1,2)decimal112CURR((0))Yes/CEERE/X20
50X21Tax Rate (Par. 6(1))decimal52DEC((0))Yes/CEERE/X21
51X22Tax Base (Par.5(3))decimal92DEC((0))Yes/CEERE/X22
52X23Tax Rate (Par 6(2))decimal52DEC((0))Yes/CEERE/X23
53X24Factor According to Par. 6(4)decimal52DEC((0))Yes/CEERE/X24
54X25Land Taxdecimal112CURR((0))Yes/CEERE/X25
55X26Claim for Exemption in Areadecimal92DEC((0))Yes/CEERE/X26
56X27Amount of Claim for Exemption (Par. 4,18(1))decimal112CURR((0))Yes/CEERE/X27
57X28Tax Liabilitydecimal112CURR((0))Yes/CEERE/X28
58X41Covered areadecimal92DEC((0))Yes/CEERE/X41
59X42Basic tax rate §11(1)decimal52DEC((0))Yes/CEERE/X42
60X43Number of above-ground floorsdecimal90DEC((0))Yes/CEERE/X43
61X44Incr.base rate for another above-ground floor §11(2)decimal92DEC((0))Yes/CEERE/X44
62X45Factor according to §11(3,4)decimal52DEC((0))Yes/CEERE/X45
63X46Resulting tax ratedecimal92DEC((0))Yes/CEERE/X46
64X47Building taxdecimal112CURR((0))Yes/CEERE/X47
65X48Business areadecimal92DEC((0))Yes/CEERE/X48
66X49Tax increase according to §11(5)decimal112CURR((0))Yes/CEERE/X49
67X50Area relation §9(2)decimal92DEC((0))Yes/CEERE/X50
68X51Amount of exempt claim §11decimal112CURR((0))Yes/CEERE/X51
69X52Amount of claim for deduction §18(2)decimal112CURR((0))Yes/CEERE/X52
70X53Tax liabilitydecimal112CURR((0))Yes/CEERE/X53
71X54_OTotal land tax - till 2008decimal112CURR((0))Yes/CEERE/X54_O
72X54Total Amount of Land Taxdecimal112CURR((0))Yes/CEERE/X54
73X54_BTotal Amount of Land Taxdecimal112CURR((0))Yes/CEERE/X54
74X55_OTotal building tax - till 2008decimal112CURR((0))Yes/CEERE/X55_O
75X55Total Amount of Building Taxdecimal112CURR((0))Yes/CEERE/X55
76X55_BTotal Amount of Building Taxdecimal112CURR((0))Yes/CEERE/X55
77X56_OTotal property tax - till 2008decimal112CURR((0))Yes/CEERE/X56_O
78X56Total Amount of Property Taxdecimal112CURR((0))Yes/CEERE/X56
79X56_BTotal Amount of Property Taxdecimal112CURR((0))Yes/CEERE/X56
80XKO12Municipality Coefficient (Par. 12)tinyint30INT1((0))Yes/CEERE/XKO12
81X58_1Installment 1decimal112CURR((0))Yes/CEERE/SPLATKA
82X58_2Installment 2decimal112CURR((0))Yes/CEERE/SPLATKA2
83X59_1Installment 1decimal112CURR((0))Yes/CEERE/SPLATKA
84X59_2Installment 2decimal112CURR((0))Yes/CEERE/SPLATKA2
85X59_3Installment 3decimal112CURR((0))Yes/CEERE/SPLATKA3
86X59_4Installment 4decimal112CURR((0))Yes/CEERE/SPLATKA4
87X67Land type areadecimal92DEC((0))Yes/CEERE/X67
88X68ACom.quotient denominatorint100INT4((0))Yes/CEERE/X68A Allow NULL? 
89X68BCom.quotient numeratorint100INT4((0))Yes/CEERE/X68B Allow NULL? 
90X69Co-owned land type aredecimal92DEC((0))Yes/CEERE/X69
91X70Land price per square meterdecimal92DEC((0))Yes/CEERE/X70
92X71Tax base according to p.5 par. 1,2decimal112CURR((0))Yes/CEERE/X71
93X72Tax rate §6(1)decimal52DEC((0))Yes/CEERE/X72
94X73Tax base §5(3)decimal92DEC((0))Yes/CEERE/X73
95X74Tax rate §6(2)decimal52DEC((0))Yes/CEERE/X74
96X75Factor according to §6(4)decimal52DEC((0))Yes/CEERE/X75
97X76Land taxdecimal112CURR((0))Yes/CEERE/X76
98X77Claim for area exemptdecimal92DEC((0))Yes/CEERE/X77
99X78Amount of claim for exempt §4,18(1)decimal112CURR((0))Yes/CEERE/X78
100X79Liability to pay taxesdecimal112CURR((0))Yes/CEERE/X79
101X95Floor area of the unitdecimal92DEC((0))Yes/CEERE/X95
102X96Factor according to §10(2)decimal52DEC((0))Yes/CEERE/X96
103X97Base tax rate according to §10(2)decimal92DEC((0))Yes/CEERE/X97
104X98Base tax rate according to §11(1)decimal52DEC((0))Yes/CEERE/X98
105X99Factor according to §11(3,4)decimal52DEC((0))Yes/CEERE/X99
106X100Resulting tax ratedecimal52DEC((0))Yes/CEERE/X100
107X101Building taxdecimal112CURR((0))Yes/CEERE/X101
108X102Amount of claim for exemption according to §9decimal112CURR((0))Yes/CEERE/X102
109X103Tax liabilitydecimal112CURR((0))Yes/CEERE/X103
110AGR_PAR1Free aggregation parameternvarchar100CHAR(N' ')Yes/CEERE/AGR_PAR Allow NULL? 
111AGR_PAR2Free aggregation parameternvarchar100CHAR(N' ')Yes/CEERE/AGR_PAR Allow NULL? 
112AGR_PAR3Free aggregation parameternvarchar100CHAR(N' ')Yes/CEERE/AGR_PAR Allow NULL? 
113AGR_PAR4Free aggregation parameternvarchar100CHAR(N' ')Yes/CEERE/AGR_PAR Allow NULL? 
114ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
115ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
116KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
117GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
118PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
119AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
120PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
121XDANSubject to Property Taxchar10CHAR(N' ')Yes/CEERE/XDAN Allow NULL? 
122DATVYPOCTUCalculation Datenvarchar80DATS(N'00000000')Yes/CEERE/DATVYPOCTU Allow NULL? 
123CASVYPOCTUCalculation Timenvarchar60TIMS(N'000000')Yes/CEERE/CASVYPOCTU Allow NULL? 
124STAVYPOCTUCalculation statuschar10CHAR(N' ')Yes/CEERE/STAVYPOCTU Allow NULL? 
125VYPOCETLCalculation Executed bynvarchar120CHAR(N' ')Yes/CEERE/VYPOCETL Allow NULL? 
126TBUKR2Dominant Enterprise/Company Codenvarchar40CHAR(N' ')Yes*/CEERE/FOT_TBUKRS Allow NULL? 
127MBUKRIndicator: Dominant Company Codechar10CHAR(N' ')Yes/CEERE/MBUKR Allow NULL? 
128SOLIDAGRPaved Area (Agricultural Purp.)decimal92DEC((0))Yes/CEERE/SOLIDAGR
129SOLIDINDPaved Area (Industrial Purp.)decimal92DEC((0))Yes/CEERE/SOLIDIND
130SOLAAGRETax-Exempt Paved Area (Argicultural Purp.)decimal92DEC((0))Yes/CEERE/SOLAAGRE
131SOLAINDETax-Exempt Paved Area (Industrial Purp.)decimal92DEC((0))Yes/CEERE/SOLAINDE
132YEAGREFRFirst Year of Tax Exemption Period (Agricultural Purp.)nvarchar40NUMC(N'0000')Yes/CEERE/YEAGREFR Allow NULL? 
133YEINDEFRFirst Year of Tax Exemption Period (Industrial Purp.)nvarchar40NUMC(N'0000')Yes/CEERE/YEINDEFR Allow NULL? 
134YEAGRETOLast Year of Tax Exemption Period (Agricultural Purp.)nvarchar40NUMC(N'0000')Yes/CEERE/YEAGRETO Allow NULL? 
135YEINDETOLast Year of Tax Exemption Period (Industrial Purp.)nvarchar40NUMC(N'0000')Yes/CEERE/YEINDETO Allow NULL? 
136CODEAGRETax Exemption Code for Paved Area (Agr. Purp.)nvarchar50CHAR(N' ')Yes*/CEERE/CODEAGRE Allow NULL? 
137CODEINDETax Exemption Code for Paved Area (Ind. Purp.)nvarchar50CHAR(N' ')Yes*/CEERE/CODEINDE Allow NULL? 
138RVZ_PODNIKNon-residential Property Type Used for Businesschar10CHAR(N' ')Yes/CEERE/RVZ_PODNIK Allow NULL? 
139VYM_PODNIKPOLandscaped area designed for businessdecimal92DEC((0))Yes/CEERE/VYM_PODNIKPO
140KC_ZVDA115POThe increase in tax under § 11adecimal112CURR((0))Yes/CEERE/KC_ZVDA115PO
141KC_DANOSV3POProperty Tax increased from amount under § 11 (5)decimal112CURR((0))Yes/CEERE/KC_DANOSV3PO
NamePrimaryUniqueTypeColumns
/CEERE/SDANP~0YesYesCLUSTEREDKEYNEM, SWENR, TYPNEMREM, GJAHR, BUKRS, MANDT
/CEERE/SDANP~FUNoNoNONCLUSTEREDKEYNEM, SWENR, TYPNEM, KODFU, XDAN, 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