P_Foundationp

@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PFOUNDATIONP'
define view P_Foundationp as select from acdocp as a
join t001 as b on a.rclnt = b.mandt
              and a.rbukrs = b.bukrs
join P_Consfiscalmapa as c on  a.rclnt = c.client
                          and  a.periv = c.fiscal_year_variant
                          and  a.ryear = c.fiscal_year        
                          and  a.poper = c.fiscal_period
{
    rclnt,               //SAP Client

    rldnr,               //Ledger in General Ledger Accounting

    ryear as gjahr,      //Local Fiscal Year

    rbukrs,              //Company Code

    cast('' as belnr_d) as belnr,       //Accounting Document Number

    b.rcomp,             //Company   

    rcntr,               //Cost Center

    prctr,               //Profit Center

    rfarea,              //Functional Area

    rbusa,               //Business Area

    kokrs,               //Controlling Area

    segment,             //Segment for Segmental Reporting

    pbukrs,              //Partner Company Code

    rassc,               //Company ID of Trading Partner

    scntr,               //Sender Cost Center

    pprctr,              //Partner Profit Center

    sfarea,              //Partner Functional Area

    sbusa,               //Trading Partner's Business Area  

    psegment,            //Partner Segment for Segmental Reporting

    a.ktopl,             //Chart-of-Accounts

    racct,               //Account Number

    rmvct,               //Transaction Type

    wsl,                 //Amount in Transaction Currency

    hsl,                 //Amount in Company Code Currency

    ksl,                 //Amount in Global Currency 

    vmsl as msl,         //Quantity / Valuation Quantity

    rwcur,               //Transaction Currency

    rhcur,               //Company Code Currency

    rkcur,               //Global Currency

    rvunit as runit,     //Base Unit of Measure

    a.periv,             //Local Fiscal Year Variant

    poper,               //Local Fiscal Period

    cast(fiscyearper as fiscalyearperiod) as fiscyearper,         //Local Fiscal Year Period

    c.fiscal_period_start_date as budat,               //Posting Date in the Document

    cast (cast (substring(reqtsn, 1, 14) as abap.numc( 14 )) as timestamp) as timestamp,           //UTC Timestamp when Journal Entry is Saved  

    cast('' as anbwa) as anbwa,               //Asset Transaction Type

    cast('' as anln1) as anln1,               //Main Asset Number  

    matkl,               //Material Group

    kdgrp,               //Customer Group

    vkorg,               //Sales Organization

    vtweg,               //Distribution Channel

    spart,               //Division

    ps_pspid,            //Project Definition

    ps_posid             //WBS Element

}where poper > '000' and rldnr = '0L'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CONSFISCALMAPA",
"ACDOCP",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/