SAP ABAP Table U_22627 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure U_22627   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client  
2 INTRENO VVINTRENO VVINTRENO CHAR 13   0   Internal Real Estate Master Data Code  
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
4 SMIVE SMIVE VVSMIVE CHAR 13   0   Lease-Out Number  
5 SWENR SWENR SWENR CHAR 8   0   Business Entity Number VIOB01
6 SMENR SMENR SMENR CHAR 8   0   Number of Rental Unit VIMI01
7 DMIBEG DMIBE DDAT DATS 8   0   Rental start date  
8 DMIEND DMIEN DDAT DATS 8   0   Rental end date  
9 DERZAHL DERZA DDAT DATS 8   0   Date of 1st debit position  
10 SMVART SMVART SMVART CHAR 4   0   External Real Estate contract type TIV26
11 SMVANART SMVAR SMVAR CHAR 1   0   Lease-Out Adjustment Type TIV27
12 DUNTBIS DUNBI DDAT DATS 8   0   Date provisional agreement from  
13 SKAUTART SKAUA SKAUA CHAR 1   0   Type of Rental Collateral TIV18
14 DEINKUE DEKUE DDAT DATS 8   0   Date of receipt of notice  
15 DKUEZU DKUZU DDAT DATS 8   0   Contract Notice Per  
16 JMAHNSP JMASP JANE CHAR 1   0   Dunning block indicator - no longer used!  
17 STECHEM STECHEM STECHEM CHAR 13   0   Heating expenses settlement company evaluation group  
18 JMINDER JMINDER JANEI CHAR 1   0   Rent reduction indicator  
19 AMELDIN AMELDIN INTVJ NUMC 2   0   Sales reporting interval  
20 PPROZ0 PPROZ0 DEC3_2 DEC 5   2   Minimum percentage rate  
21 DSTAEN DSTAEN DSTAEN DATS 8   0   Status change date  
22 DAKTV DAKTV DATUM DATS 8   0   Contract activation  
23 JLOESCH JLOESCH JLOESCH CHAR 1   0   Real Estate Deletion Indicator/Flag  
24 BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk T001S
25 JVERL JVERL VVVERL CHAR 1   0   Contract renewal  
26 JSKUEND JSKUEND JANEI CHAR 1   0   Special right of notice  
27 JKAUFOPT JKAUFOPT JANEI CHAR 1   0   Option to buy  
28 DKAUFOPT DKAUFOPT DDAT DATS 8   0   Purchase option date  
29 SNKS SNKS J_OBJNR CHAR 22   0   Service Charge Collector Number ONR00
30 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
31 DERF DERF DATUM DATS 8   0   First Entered on  
32 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
33 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
34 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
35 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
36 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
37 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
38 DKUEFR DKUEFR NUMC2 NUMC 2   0   Notice period in months  
39 ANKUEN ANKUEN NUMC2 NUMC 2   0   Notification until (for renewal of contract)  
40 DABTR DABTR DATUM DATS 8   0   Declaration of assignment  
41 DFREIS DFREIS DATUM DATS 8   0   Exemption (bank)  
42 DABLF DABLF DATUM DATS 8   0   Expiration Date  
43 VERLG VERLG NUMC3 NUMC 3   0   Contract renewal by ... months  
44 ZSICH VVZSICH JANEI CHAR 1   0   Indicator that other collateral is available  
45 JBETRST JBETRST JANEI CHAR 1   0   Security deposit granted  
46 DBKERH DBKERH DATUM DATS 8   0   Cash deposit received on  
47 ABNNR ABNNR TEXT20 CHAR 20   0   Identification of lease-out at settlement company  
48 ABNUNR ABNUNR NUM3 NUMC 3   0   Customer subnumber  
49 BANKKS BANKK BANKK CHAR 15   0   Bank Keys  
50 SKUEFR SKUEFR SKUEFR NUMC 1   0   Type of notice period  
51 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
52 KUNNR VVRDEBIHVP KUNNR CHAR 10   0   Customer number main contract partner KNA1
53 SPARTNR VVRPARTABW SPARTNR CHAR 10   0   Alternative payer (partner number) SPRT1
54 GSART VVSART VVSART CHAR 3   0   Product Type TZPA
55 MADAT MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
56 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
57 JBKRZ VVJBKRZ JANEI CHAR 1   0   Cash deposit instalment payment  
58 DEINZG VVDEINZG DATS DATS 8   0   Move-in date  
59 DAUSZG VVDAUSZG DATS DATS 8   0   Move-out date  
60 JANPIB VVJANPIB JANE CHAR 1   0   Adjustment being processed (indicator)  
61 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
62 MABER VVMABER MABER CHAR 2   0   Dunning: area T047M
63 PROFL VVAPROF APROF CHAR 6   0   Settlement profile for costs TKB1A
64 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
65 ZUSP VVZUSP JANE CHAR 1   0   Subsidies available, indicator  
66 REFNR VVREFNR TEXT30 CHAR 30   0   Reference number for collateral securities  
67 SBELEGNG VVSBELEGNG VVSBELEGNG CHAR 1   0   RU occupancy by LO (used by third-prty/private/corp.grp)  
68 MANSP VVMANSP MANSP CHAR 1   0   Dunning: Blocking reason T040S
69 DERSTDR VVDERSTDR DATUM DATS 8   0   Date When the Lease-Out was First Printed  
70 DAENDDR VVDAENDDR DATUM DATS 8   0   Date When the Lease-Out was Changed and Printed Out  
71 JMFREI VVJMFREI JANE CHAR 1   0   Condition is not checked  
72 DVMUN VVDVMUN DATUM DATS 8   0   Contract signed by landlord  
73 JRMSCHPR VVJRMSCHPR XFELD CHAR 1   0   Tenant service charge settlement?  
74 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
75 KBK_PARTNR SPARTNR SPARTNR CHAR 10   0   Partner number SPRT1
76 GERSTD VVXGERSTD TEXT35 CHAR 35   0   Jurisdiction  
77 KONDPJ VVKONDPJ JFLAGG CHAR 1   0   Conditions on lease-out effective per year (display)  
78 JMABGR VVJMABGR JFLAGG CHAR 1   0   Accrual/deferral method  
79 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
80 SKUEKEY SKUEKEY SKUEKEY CHAR 12   0   Notice rule  
81 SKUEART SMVKUEART SMVKUEART CHAR 1   0   Notice Type of Lease-Out  
82 E_SMIVE VVESMIVE VVSMIVE CHAR 13   0   Contract No. of Collective Lease-Outs  
83 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
84 SANLF SANLF VVSANLF NUMC 3   0   Product Category  
85 DGUEL_KK DGUEL DATUM DATS 8   0   Date Condition Effective from  
86 NLFD_ANG NLFD_ANG LFNR3 NUMC 3   0   Offer consecutive number  
87 ZLSCH VVZSCHLMV ZLSCH CHAR 1   0   Rental agreement payment method T042Z
88 SZEITANT VVSZEITMV VVSZEITMV NUMC 1   0   Indicator for Pro Rata Temporis Calculations  
89 SZBMETH VVSZBMETMV VVSZBMETMV NUMC 1   0   Calculation method for time-dependent periods  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 U_22627 BUKRS T001 BUKRS KEY 1 CN
2 U_22627 BUSAB T001S BUSAB REF 1 CN
3 U_22627 GSART TZPA GSART KEY 1 CN
4 U_22627 GSBER TGSB GSBER KEY 1 CN
5 U_22627 HBKID T012 HBKID    
6 U_22627 KBK_PARTNR SPRT1 PARTNR KEY 1 CN
7 U_22627 KOKRS TKA01 KOKRS REF C CN
8 U_22627 KUNNR KNA1 KUNNR KEY 1 CN
9 U_22627 MABER T047M MABER KEY 1 CN
10 U_22627 MANSP T040S MANSP KEY 1 CN
11 U_22627 PRCTR CEPC PRCTR KEY 1 CN
12 U_22627 PROFL TKB1A APROF REF C CN
13 U_22627 SKAUTART TIV18 SKAUTART KEY 1 CN
14 U_22627 SMENR VIMI01 SMENR KEY 1 CN
15 U_22627 SMVANART TIV27 SMVANART KEY 1 CN
16 U_22627 SMVART TIV26 SMVART KEY 1 CN
17 U_22627 SNKS ONR00 OBJNR KEY 1 CN
18 U_22627 SPARTNR SPRT1 PARTNR KEY 1 CN
19 U_22627 SWENR VIOB01 SWENR KEY 1 CN
20 U_22627 ZLSCH T042Z ZLSCH KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in