P_Foundationa

@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PFOUNDATIONA'
define view P_Foundationa as select from acdoca as a
join t001 as b on a.rclnt = b.mandt
              and a.rbukrs = b.bukrs
{
    rclnt,               //SAP Client

    rldnr,               //Ledger in General Ledger Accounting

    gjahr,               //Local Fiscal Year

    rbukrs,              //Company Code

    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 

    msl,                 //Quantity

    rwcur,               //Transaction Currency

    rhcur,               //Company Code Currency

    rkcur,               //Global Currency

    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

    budat,               //Posting Date in the Document

    timestamp,           //UTC Timestamp when Journal Entry is Saved

    anbwa,               //Asset Transaction Type

    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'