I_RealTimeMfgOrderWIPSrceAcct

DDL: I_REALTIMEMFGORDERWIPSRCEACCT SQL: IFIRTPCORDWIPSA Type: view BASIC

Realtime Mfg Order WIP Source Account

I_RealTimeMfgOrderWIPSrceAcct is a Basic CDS View that provides data about "Realtime Mfg Order WIP Source Account" in SAP S/4HANA. It reads from 5 data sources (fcoc_ebw_assg_cc, fcoc_ebw_assg_it, fcoc_ebw_src_cat, fcoc_ebw_src_itm, t001) and exposes 5 fields with key fields CompanyCode, WIPSourceAccountFrom, WIPSourceAccountTo.

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
fcoc_ebw_assg_cc fcoc_ebw_assg_cc from
fcoc_ebw_assg_it fcoc_ebw_assg_it inner
fcoc_ebw_src_cat fcoc_ebw_src_cat inner
fcoc_ebw_src_itm fcoc_ebw_src_itm inner
t001 t001 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFIRTPCORDWIPSA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Realtime Mfg Order WIP Source Account view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode fcoc_ebw_assg_cc company_code
KEY WIPSourceAccountFrom fcoc_ebw_src_itm account_from
KEY WIPSourceAccountTo fcoc_ebw_src_itm account_to
WIPSourceAccountCategory fcoc_ebw_src_cat category
OrderCategory 
@AbapCatalog.sqlViewName: 'IFIRTPCORDWIPSA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@EndUserText.label: 'Realtime Mfg Order WIP Source Account'
define view I_RealTimeMfgOrderWIPSrceAcct
  as select from fcoc_ebw_assg_cc
    inner join   t001             on t001.bukrs = fcoc_ebw_assg_cc.company_code
    inner join   fcoc_ebw_assg_it on  fcoc_ebw_assg_it.chart_of_accts = t001.ktopl
                                  and fcoc_ebw_assg_it.assgmt_id      = fcoc_ebw_assg_cc.assgmt_id
    inner join   fcoc_ebw_src_itm on  fcoc_ebw_src_itm.chart_of_accts = t001.ktopl
                                  and fcoc_ebw_src_itm.source_id      = fcoc_ebw_assg_it.source_id
    inner join   fcoc_ebw_src_cat on fcoc_ebw_src_cat.source_id = fcoc_ebw_src_itm.source_id

{
  key fcoc_ebw_assg_cc.company_code   as CompanyCode,
  key fcoc_ebw_src_itm.account_from   as WIPSourceAccountFrom,
  key fcoc_ebw_src_itm.account_to     as WIPSourceAccountTo,

      fcoc_ebw_src_cat.category       as WIPSourceAccountCategory,
      cast(fcoc_ebw_src_cat.order_category as auftyp) as OrderCategory


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCOC_EBW_ASSG_CC",
"FCOC_EBW_ASSG_IT",
"FCOC_EBW_SRC_CAT",
"FCOC_EBW_SRC_ITM",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More