@AbapCatalog.sqlViewName: 'PRTPCPCCOTBPSTD'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'To be posted Event-Based PCC orders'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPC_PCC_OrderToBePosted
with parameters
P_FiscalPeriodStartDate : budat,
P_FiscalPeriodEndDate : budat
as select from P_RTPC_REM_OrderToBePostedKPI(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate
) as _Order
inner join I_Ledger as _Ledger on _Order.Ledger = _Ledger.Ledger
and _Ledger.LedgerType = ''
left outer to one join P_RTPC_REM_Order_Actual_Cost (P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate
) as _ActCst on _Order.OrderID = _ActCst.OrderID
and _Order.Ledger = _ActCst.Ledger
left outer to one join P_RealTimePCCPostedWIP(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate
) as _WIP on _Order.OrderID = _WIP.OrderID
and _Order.Ledger = _WIP.Ledger
left outer to one join P_RealTimePCCPostedVarc(P_FiscalPeriodStartDate : $parameters.P_FiscalPeriodStartDate,
P_FiscalPeriodEndDate : $parameters.P_FiscalPeriodEndDate
) as _Varc on _Order.OrderID = _Varc.OrderID
and _Order.Ledger = _Varc.Ledger
left outer to one join R_EvtBsdProdnCostError as _OrderLog on _Order.OrderID = _OrderLog.OrderID
and _Order.Ledger = _OrderLog.Ledger
and _OrderLog.BusinessTransactionCategory <> 'KZPR'
{
key _Order.OrderID as OrderID,
key _Order.Ledger as Ledger,
_Ledger._Text[1: Language = $session.system_language].LedgerName,
_Order.OrderDescription as OrderDescription,
_Order.ControllingObject as ControllingObject,
_Order.ControllingArea as ControllingArea,
_Order.CompanyCode as CompanyCode,
_Order.OrderType as OrderType,
_Order.Material as Material,
_Order.Plant as Plant,
_Order.OrderCategory as OrderCategory,
_Order.ProfitCenter as ProfitCenter,
_Order.StatusCode as StatusCode,
_Order.ProductionVersion as ProductionVersion,
_OrderLog.SimulationStatus,
_OrderLog.LogNumber,
_OrderLog.LogHandle,
_OrderLog.LogMessageText,
_OrderLog.EventBasedProdnCostWlLogType,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
coalesce(_ActCst.PeriodAmountInCompanyCodeCrcy, 0) as ActualCostAmtInCCCrcy,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
coalesce(_ActCst.PeriodAmountInGlobalCurrency, 0) as ActualCostInGlobalCrcy,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy1, 0) as ActualCostInFreeDfndCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy2, 0) as ActualCostInFreeDfndCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy3, 0) as ActualCostInFreeDfndCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy4, 0) as ActualCostInFreeDfndCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy5, 0) as ActualCostInFreeDfndCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy6, 0) as ActualCostInFreeDfndCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy7, 0) as ActualCostInFreeDfndCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
coalesce(_ActCst.PeriodAmountInFreeDfndCrcy8, 0) as ActualCostInFreeDfndCrcy8,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
coalesce(_WIP.PeriodAmountInCompanyCodeCrcy, 0) as WIPPerdAmtInCoCodeCurrency,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
coalesce(_WIP.PeriodAmountInGlobalCurrency, 0) as WIPPerdAmtInGlobalCurrency,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy1, 0) as WIPPerdAmtInFreeDefinedCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy2, 0) as WIPPerdAmtInFreeDefinedCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy3, 0) as WIPPerdAmtInFreeDefinedCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy4, 0) as WIPPerdAmtInFreeDefinedCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy5, 0) as WIPPerdAmtInFreeDefinedCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy6, 0) as WIPPerdAmtInFreeDefinedCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy7, 0) as WIPPerdAmtInFreeDefinedCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
coalesce(_WIP.PeriodAmountInFreeDfndCrcy8, 0) as WIPPerdAmtInFreeDefinedCrcy8,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
coalesce(_Varc.PeriodAmountInCompanyCodeCrcy, 0) as VarcPerdAmtInCoCodeCurrency,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
coalesce(_Varc.PeriodAmountInGlobalCurrency, 0) as VarcPerdAmtInGlobalCurrency,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy1, 0) as VarcPerdAmtInFreeDefinedCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy2, 0) as VarcPerdAmtInFreeDefinedCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy3, 0) as VarcPerdAmtInFreeDefinedCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy4, 0) as VarcPerdAmtInFreeDefinedCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy5, 0) as VarcPerdAmtInFreeDefinedCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy6, 0) as VarcPerdAmtInFreeDefinedCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy7, 0) as VarcPerdAmtInFreeDefinedCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
coalesce(_Varc.PeriodAmountInFreeDfndCrcy8, 0) as VarcPerdAmtInFreeDefinedCrcy8,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast ( (coalesce(_ActCst.PeriodAmountInCompanyCodeCrcy, 0) - coalesce(_WIP.PeriodAmountInCompanyCodeCrcy, 0) - coalesce(_Varc.PeriodAmountInCompanyCodeCrcy, 0) )as fis_hsl ) as PeriodAmountInCompanyCodeCrcy,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast ( (coalesce(_ActCst.PeriodAmountInGlobalCurrency, 0) - coalesce(_WIP.PeriodAmountInGlobalCurrency, 0) - coalesce(_Varc.PeriodAmountInGlobalCurrency, 0) )as fis_ksl ) as PeriodAmountInGlobalCurrency,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy1, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy1, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy1, 0) )as fis_osl ) as PeriodAmountInFreeDfndCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy2, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy2, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy2, 0) )as fis_vsl ) as PeriodAmountInFreeDfndCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy3, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy3, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy3, 0) )as fis_bsl ) as PeriodAmountInFreeDfndCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy4, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy4, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy4, 0) )as fis_csl ) as PeriodAmountInFreeDfndCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy5, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy5, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy5, 0) )as fis_dsl ) as PeriodAmountInFreeDfndCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy6, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy6, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy6, 0) )as fis_esl ) as PeriodAmountInFreeDfndCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy7, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy7, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy7, 0) )as fis_fsl ) as PeriodAmountInFreeDfndCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast ( (coalesce(_ActCst.PeriodAmountInFreeDfndCrcy8, 0) - coalesce(_WIP.PeriodAmountInFreeDfndCrcy8, 0) - coalesce(_Varc.PeriodAmountInFreeDfndCrcy8, 0) )as fis_gsl ) as PeriodAmountInFreeDfndCrcy8,
// _Order.AmountInCompanyCodeCurrency,
// _Order.AmountInGlobalCurrency,
// _Order.AmountInFreeDefinedCurrency1,
// _Order.AmountInFreeDefinedCurrency2,
// _Order.AmountInFreeDefinedCurrency3,
// _Order.AmountInFreeDefinedCurrency4,
// _Order.AmountInFreeDefinedCurrency5,
// _Order.AmountInFreeDefinedCurrency6,
// _Order.AmountInFreeDefinedCurrency7,
// _Order.AmountInFreeDefinedCurrency8,
_Order.CompanyCodeCurrency,
_Order.GlobalCurrency,
_Order.FreeDefinedCurrency1,
_Order.FreeDefinedCurrency2,
_Order.FreeDefinedCurrency3,
_Order.FreeDefinedCurrency4,
_Order.FreeDefinedCurrency5,
_Order.FreeDefinedCurrency6,
_Order.FreeDefinedCurrency7,
_Order.FreeDefinedCurrency8
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"I_LEDGERTEXT",
"P_REALTIMEPCCPOSTEDVARC",
"P_REALTIMEPCCPOSTEDWIP",
"P_RTPC_REM_ORDERTOBEPOSTEDKPI",
"P_RTPC_REM_ORDER_ACTUAL_COST",
"R_EVTBSDPRODNCOSTERROR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/