FEE_CDS_ST

@AbapCatalog.sqlViewName: 'STUDENT_INFO'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view FEE_CDS_ST as 
                  select from cmacbpst as A 
                              left outer join  fkkvkp  as B on ( A.client = B.mandt and A.partner = B.gpart )
                              left outer join  t001    as C on ( B.mandt = C.mandt  and B.stdbk = C.bukrs   )
                              left outer join  hrp1702 as D on ( A.client = D.mandt and A.stobjid = D.objid )
                              left outer join  tfk033d as E on ( D.mandt = E.mandt and E.applk = 'P' and E.buber = 'PC02')  
                              left outer join  hrp1706 as f on ( D.mandt = E.mandt and D.plvar = f.plvar and D.otype = f.otype and D.objid = f.objid )
                              left outer join  hrp1712 as g on ( D.mandt = g.mandt and D.plvar = g.plvar and D.otype = g.otype and D.objid = g.objid )
                              left outer join  hrp1001 as h on ( D.mandt = h.mandt and D.plvar = h.plvar and D.otype = h.otype and D.objid = h.objid and 
                                                                 h.rsign = 'A' and h.relat = '502' and h.sclas = 'F' )
                              left outer join  hrp1705 as i on ( D.mandt = i.mandt and D.plvar = i.plvar and D.otype = i.otype and D.objid = i.objid )
                              left outer join  hrp1001 as j on ( D.mandt = j.mandt and D.plvar = j.plvar and D.otype = j.otype and D.objid = j.objid and 
                                                                 j.rsign = 'A' and j.relat = '502' and j.sclas = 'O')
{
    key A.client as CLIENT,
    key A.partner as PARTNER,
    key A.stobjid as STOBJID,
    key A.student12 as STNUMBER,
    key B.opbuk as OPBUK,
    key B.stdbk as BUKRS,
    key C.waers as WAERS,
    key D.plvar as PLVAR,
    key D.natio as NATIO,
    key D.begda as begda_1702,
    key D.endda as endda_1702,
    key f.begda as begda_1706,
    key f.endda as endda_1706,
    key g.begda as begda_1712,
    key g.endda as endda_1712,
    key i.begda as begda_1705,
    key i.endda as endda_1705,
    key E.fun01 as FUN01,
    key f.stfeecat as STFEECAT,
    key f.bencat as BENCAT,
    key f.pdisct1 as PDISCT1,
    key f.pdisct2 as PDISCT2,
    key f.pdisct3 as PDISCT3,
    key f.pdisct4 as PDISCT4,
    key f.pdisct5 as PDISCT5,
    key f.pdisct6 as PDISCT6,
    key g.visatype as VISATYPE,
    key h.sobid as f_objid,
    key i.stgrp as STGRP,
    key i.prevhe as PREVHE,
    key j.sobid as o_objid

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CMACBPST",
"FKKVKP",
"HRP1001",
"HRP1702",
"HRP1705",
"HRP1706",
"HRP1712",
"T001",
"TFK033D"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/