@AbapCatalog.sqlViewName: 'PPRDPLANTWD'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Product Plant Union (draft)'
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProductPlantWD
as select from I_ProductPlant as ActiveDocument
left outer join P_ProductPlantD as DraftDocument on DraftDocument.ActiveProduct = ActiveDocument.Product
and DraftDocument.ActivePlant = ActiveDocument.Plant
left outer join P_Productplantreferences as Reference on ActiveDocument.Plant = Reference.Plant
and ActiveDocument.Product = Reference.Product
{
key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as Draftkey,
key ActiveDocument.Product as ActiveProduct,
key ActiveDocument.Plant as ActivePlant,
cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as ParentDraftKey,
ActiveDocument.Product,
ActiveDocument.Plant,
ActiveDocument.PurchasingGroup,
ActiveDocument.CountryOfOrigin,
ActiveDocument.RegionOfOrigin,
ActiveDocument.ProductionInvtryManagedLoc,
ActiveDocument.ProfileCode,
ActiveDocument.ProfileValidityStartDate,
ActiveDocument.AvailabilityCheckType,
ActiveDocument.FiscalYearVariant,
ActiveDocument.PeriodType,
ActiveDocument.ProfitCenter,
//ActiveDocument.Commodity, //pstat changes
//ActiveDocument.GoodsReceiptDuration, "PSTAT Changes
ActiveDocument.MaintenanceStatusName,
cast(ActiveDocument.IsMarkedForDeletion as boole_d) as IsMarkedForDeletion,
ActiveDocument.ConsumptionTaxCtrlCode,
ActiveDocument.IsCoProduct,
ActiveDocument.ProductIsConfigurable,
ActiveDocument.StockDeterminationGroup,
ActiveDocument.StockInTransferQuantity,
ActiveDocument.StockInTransitQuantity,
ActiveDocument.HasPostToInspectionStock,
// ActiveDocument.IsBatchManagementRequired, "PSTAT Changes
//ActiveDocument.SerialNumberProfile, "PSTAT Changes
//ActiveDocument.IsNegativeStockAllowed, "PSTAT Changes
ActiveDocument.GoodsReceiptBlockedStockQty,
ActiveDocument.HasConsignmentCtrl,
// ActiveDocument.TiedEmptiesStockQuantity,
//ActiveDocument.FiscalYearCurrentPeriod, //pstat changes
//ActiveDocument.FiscalMonthCurrentPeriod, //pstat changes
ActiveDocument.IsPurgAcrossPurgGroup,
ActiveDocument.IsInternalBatchManaged,
ActiveDocument.ProductCFOPCategory,
// Retail fields added on 21.4.16
// ActiveDocument.GoodsIssueUnit, //pstat changes
ActiveDocument.SourceOfSupplyCategory,
// ActiveDocument.ConsumptionReferenceProduct,
// ActiveDocument.ConsumptionReferencePlant,
// ActiveDocument.ConsumptionRefUsageEndDate,
// ActiveDocument.ConsumptionQtyMultiplier,
ActiveDocument.ProductUnitGroup,
ActiveDocument.DistrCntrDistributionProfile,
ActiveDocument.ConsignmentControl,
ActiveDocument.GoodIssueProcessingDays,
//Reference Handling
Reference.SalesOrganization,
Reference.DistributionChannel,
Reference.PlantCategory,
Reference.ReferenceDistributionCenter,
Reference.ReferenceStore,
Reference.IsReferenceDistributionCenter,
Reference.IsReferenceStore,
cast( 'X' as boole_d ) as IsActiveEntity,
cast( ' ' as boole_d ) as HasActiveEntity,
cast(
case
when DraftDocument.Draftkey is null
then ' '
else 'X'
end as boole_d) as HasDraftEntity,
cast(DraftDocument.Parentdraftkey as sysuuid_x ) as DraftAdministrativeDataUUID
}
union all
select from P_ProductPlantD as DraftDocument
inner join I_DraftAdministrativeData as DraftAdministrativeData on DraftAdministrativeData.DraftUUID = DraftDocument.Parentdraftkey
{
key DraftDocument.Draftkey,
key DraftDocument.ActiveProduct,
key DraftDocument.ActivePlant,
DraftDocument.Parentdraftkey,
DraftDocument.product,
DraftDocument.plant,
DraftDocument.purchasinggroup,
DraftDocument.countryoforigin,
DraftDocument.regionoforigin,
DraftDocument.productioninvtrymanagedloc,
DraftDocument.profilecode,
DraftDocument.profilevaliditystartdate,
DraftDocument.availabilitychecktype,
DraftDocument.fiscalyearvariant,
DraftDocument.periodtype,
DraftDocument.profitcenter,
//DraftDocument.commodity, //pstat changes
//DraftDocument.goodsreceiptduration, "PSTAT Changes
DraftDocument.maintenancestatusname,
cast(DraftDocument.ismarkedfordeletion as boole_d) as IsMarkedForDeletion,
DraftDocument.consumptiontaxctrlcode,
DraftDocument.iscoproduct,
DraftDocument.productisconfigurable,
DraftDocument.stockdeterminationgroup,
DraftDocument.stockintransferquantity,
DraftDocument.stockintransitquantity,
DraftDocument.hasposttoinspectionstock,
//DraftDocument.isbatchmanagementrequired, "PSTAT Changes
// DraftDocument.serialnumberprofile, "PSTAT Changes
//DraftDocument.isnegativestockallowed, "PSTAT Changes
DraftDocument.goodsreceiptblockedstockqty,
DraftDocument.hasconsignmentctrl,
// DraftDocument.tiedemptiesstockquantity,
// DraftDocument.fiscalyearcurrentperiod, //pstat changes
// DraftDocument.fiscalmonthcurrentperiod, //pstat changes
DraftDocument.ispurgacrosspurggroup,
DraftDocument.isinternalbatchmanaged,
DraftDocument.productcfopcategory,
//Retail fields added on 21.4.16
// DraftDocument.goodsissueunit, //pstat changes
DraftDocument.sourceofsupplycategory,
// DraftDocument.consumptionreferenceproduct,
// DraftDocument.consumptionreferenceplant,
// DraftDocument.consumptionrefusageenddate,
// DraftDocument.consumptionqtymultiplier,
DraftDocument.productunitgroup,
DraftDocument.distrcntrdistributionprofile,
DraftDocument.consignmentcontrol,
DraftDocument.goodissueprocessingdays,
DraftDocument.salesorganization,
DraftDocument.distributionchannel,
DraftDocument.plantcategory,
DraftDocument.referencedistributioncenter,
DraftDocument.referencestore,
DraftDocument.isreferencedistributioncenter,
DraftDocument.isreferencestore,
cast( ' ' as boole_d ) as IsActiveEntity,
cast( DraftDocument.HasActiveEntity as boole_d ) as HasActiveEntity,
cast( ' ' as boole_d ) as HasDraftEntity,
cast(DraftDocument.Parentdraftkey as sysuuid_x ) as DraftAdministrativeDataUUID
}
where
DraftAdministrativeData.CreatedByUser = $session.user
or DraftAdministrativeData.InProcessByUser = $session.user
// where DraftAdministrativeData.CreatedByUser = $session.user
// or DraftAdministrativeData.InProcessByUser = $session.user