P_ProductPlantBasic

@AbapCatalog:{
    sqlViewName: 'PPRDPLANTBASIC',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel:{
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #XL,
    usageType.dataClass: #MASTER
}
@VDM.viewType: #BASIC
@VDM.private: true

// Scope of this view is V_MARC_MD no fields from redirect views should be added

define view P_ProductPlantBasic
  as select from marc as Plant
  association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
{
  key    cast ( Plant.matnr as productnumber preserving type )                                as Product,
  key    Plant.werks                                                                          as Plant,
         Plant.pstat                                                                          as MaintenanceStatus,
         Plant.lvorm                                                                          as IsMarkedForDeletion,
         Plant.bwtty                                                                          as ValuationCategory,
         Plant.xchar                                                                          as IsInternalBatchManaged,
         Plant.mmsta                                                                          as ProfileCode,
         Plant.mmstd                                                                          as ProfileValidityStartDate,
         Plant.maabc                                                                          as ABCIndicator,
         Plant.kzkri                                                                          as ProductIsCriticalPrt,
         Plant.ekgrp                                                                          as PurchasingGroup,
         Plant.ausme                                                                          as GoodsIssueUnit,
         Plant.dispr                                                                          as MRPProfile,
         Plant.dismm                                                                          as MRPType,
         Plant.dispo                                                                          as MRPResponsible,
         Plant.plifz                                                                          as PlannedDeliveryDurationInDays,
         Plant.webaz                                                                          as GoodsReceiptDuration,
         Plant.perkz                                                                          as PeriodType,
         Plant.ausss                                                                          as AssemblyScrapPercent,
         Plant.disls                                                                          as LotSizingProcedure,
         Plant.beskz                                                                          as ProcurementType,
         Plant.sobsl                                                                          as ProcurementSubType,
         Plant.minbe                                                                          as ReorderThresholdQuantity,
         Plant.eisbe                                                                          as SafetyStockQuantity,
         Plant.bstmi                                                                          as MinimumLotSizeQuantity,
         Plant.bstma                                                                          as MaximumLotSizeQuantity,
         Plant.bstfe                                                                          as FixedLotSizeQuantity,
         Plant.bstrf                                                                          as LotSizeRoundingQuantity,
         Plant.mabst                                                                          as MaximumStockQuantity,
         Plant.losfx                                                                          as LotSizeIndependentCosts,
         Plant.sbdkz                                                                          as DependentRequirementsType,
         Plant.lagpr                                                                          as StorageCostsPercentageCode,
         Plant.kzaus                                                                          as ProductIsToBeDiscontinued,
         Plant.ausdt                                                                          as EffectiveOutDate,
         Plant.nfmat                                                                          as FollowUpProduct,
         Plant.kzbed                                                                          as ProdRqmtsAreConsolidated,
         Plant.miskz                                                                          as MRPAvailabilityType,
         cast( Plant.fhori as vdm_fhori preserving type )                                     as SchedulingMarginKey,
         Plant.rgekz                                                                          as MatlCompIsMarkedForBackflush,
         Plant.fevor                                                                          as ProductionSupervisor,
         Plant.bearz                                                                          as ProcessingTimeInDays,
         Plant.ruezt                                                                          as SetupAndTeardownTime,
         Plant.tranz                                                                          as TransitionTime,
         Plant.basmg                                                                          as MaterialBaseQuantity,
         Plant.dzeit                                                                          as InHouseProductionTime,
         Plant.maxlz                                                                          as MaximumStoragePeriod,
         Plant.lzeih                                                                          as ProdMaximumStoragePeriodUnit,
         Plant.kzpro                                                                          as ProdIsWithdrawnFrmProdnBin,
         Plant.ueeto                                                                          as OverDelivToleranceLimit,
         Plant.ueetk                                                                          as UnlimitedOverDelivIsAllowed,
         Plant.uneto                                                                          as UnderDelivToleranceLimit,
         Plant.wzeit                                                                          as TotalReplenishmentLeadTime,
         Plant.atpkz                                                                          as ReplacementPartType,
         cast (Plant.insmk as hasposttoinspectionstock preserving type )                      as HasPostToInspectionStock,
         Plant.sproz                                                                          as InspLotSampleQuantityInPercent,
         Plant.ssqss                                                                          as QualityMgmtCtrlKey,
         Plant.mpdau                                                                          as InspLotDurationInDays,
         Plant.kzdkz                                                                          as InspLotDocumentationIsRequired,
         Plant.prfrq                                                                          as RecrrgInspIntervalTimeInDays,
         Plant.ladgr                                                                          as LoadingGroup,
         Plant.xchpf                                                                          as IsBatchManagementRequired,
         Plant.usequ                                                                          as QuotaArrangementUsage,
         Plant.lgrad                                                                          as SrvcLvl,
         Plant.auftl                                                                          as ForecastRequirementsAreSplit,
         Plant.mtvfp                                                                          as AvailabilityCheckType,
         Plant.periv                                                                          as FiscalYearVariant,
         Plant.kzkfk                                                                          as CorrectionFactorIsRequired,
         Plant.vrvez                                                                          as WrkCentersShipgSetupTimeInDays,
         Plant.vbamg                                                                          as CapPlanningQuantityInBaseUoM,
         Plant.vbeaz                                                                          as ProductShippingProcessingTime,
         Plant.bwscl                                                                          as SourceOfSupplyCategory,
         Plant.kautb                                                                          as IsAutoPurOrdCreationAllowed,
         Plant.kordb                                                                          as IsSourceListRequired,
         cast ( Plant.herkl as cmd_prd_countryoforigin preserving type )                      as CountryOfOrigin,
         cast ( Plant.herkr as regionoforigin preserving type )                               as RegionOfOrigin,
         Plant.expme                                                                          as CommoditiyCodeNumberUnit,
         Plant.mtver                                                                          as ExportAndImportProductGroup,
         Plant.prctr                                                                          as ProfitCenter,
         Plant.mrppp                                                                          as MRPPlanningCalendar,
         cast ( Plant.sauft as cmd_prd_rem_enabled preserving type )                          as RepetitiveManufacturingIsAllwd,
         Plant.fxhor                                                                          as PlanningTimeFence,
         Plant.vrmod                                                                          as ProdRqmtsConsumptionMode,
         cast ( Plant.vint1 as backwardcnsmpnperiodinworkdays preserving type )               as BackwardCnsmpnPeriodInWorkDays,
         cast ( Plant.vint2 as fwdconsumptionperiodinworkdays preserving type )               as FwdConsumptionPeriodInWorkDays,
         Plant.verkz                                                                          as HasProductionVersion,
         Plant.stlal                                                                          as SourceBOMAlternative,
         Plant.stlan                                                                          as ProductBOMUsage,
         Plant.plnnr                                                                          as TaskListGroup,
         Plant.aplal                                                                          as TaskListGroupCounter,
         Plant.losgr                                                                          as CostingLotSize,
         cast ( Plant.sobsk as specialprocurementtype preserving type )                       as CostingSpecialProcurementType,
         Plant.frtme                                                                          as ProductProductionQuantityUnit,
         Plant.lgpro                                                                          as ProductionInvtryManagedLoc,
         Plant.disgr                                                                          as MRPGroup,
         Plant.kausf                                                                          as ComponentScrapInPercent,
         Plant.qzgtp                                                                          as ProductQualityCertificateType,
         Plant.qmatv                                                                          as ProductPlantHasInspectionSetup,
         Plant.takzt                                                                          as RqmtQtyRcptTaktTmeInWrkgDays,
         Plant.rwpro                                                                          as RangeOfCvrgPrflCode,
         Plant.abcin                                                                          as InventoryForCycleCountInd,
         Plant.awsls                                                                          as VarianceKey,
         Plant.sernp                                                                          as SerialNumberProfile,
         Plant.cuobj                                                                          as ProductConfiguration,
         Plant.stdpd                                                                          as ConfigurableProduct,
         cast ( Plant.sfepr as cmd_prd_rem_profile preserving type )                          as RepetitiveManufacturingProfile,
         Plant.xmcng                                                                          as IsNegativeStockAllowed,
         Plant.qssys                                                                          as SuplrQualityManagementSystem,
         Plant.lfrhy                                                                          as PlanAndOrderDayDetermination,
         Plant.rdprf                                                                          as RoundingProfile,
         Plant.vrbmt                                                                          as ConsumptionReferenceProduct,
         Plant.vrbwk                                                                          as ConsumptionReferencePlant,
         Plant.vrbdt                                                                          as ConsumptionRefUsageEndDate,
         Plant.vrbfk                                                                          as ConsumptionQtyMultiplier,
         Plant.autru                                                                          as ForecastModelIsReset,
         Plant.servg                                                                          as ProvisioningServiceLevel,
         Plant.kzkup                                                                          as IsCoProduct,
         Plant.strgr                                                                          as PlanningStrategyGroup,
         Plant.lgfsb                                                                          as DfltStorageLocationExtProcmt,
         Plant.schgt                                                                          as IsBulkMaterialComponent,
         Plant.ccfix                                                                          as CycleCountingIndicatorIsFixed,
         Plant.eprio                                                                          as StockDeterminationGroup,
         Plant.qmata                                                                          as MatlQualityAuthorizationGroup,
         Plant.plnty                                                                          as TaskListType,
         cast ( Plant.sfcpf  as productionschedulingprofile preserving type )                 as ProductionSchedulingProfile,
         Plant.shflg                                                                          as IsSafetyTime,
         Plant.shzet                                                                          as SafetyDuration,
         Plant.mdach                                                                          as PlannedOrderActionControl,
         Plant.kzech                                                                          as ProdnOrderIsBatchRequired,
         cast( Plant.megru as productunitgroup preserving type )                              as ProductUnitGroup,
         Plant.mfrgr                                                                          as MaterialFreightGroup,
         Plant.fvidk                                                                          as CostingProductionVersion,
         Plant.fxpru                                                                          as IsFixedPriceCoProduct,
         Plant.loggr                                                                          as ProductLogisticsHandlingGroup,
         Plant.fprfm                                                                          as DistrCntrDistributionProfile,
         Plant.indus                                                                          as ProductCFOPCategory,
         Plant.casnr                                                                          as ProductCASNumber,
         Plant.gpnum                                                                          as ProdIntlTradeClassification,
         Plant.steuc                                                                          as ConsumptionTaxCtrlCode,
         Plant.fabkz                                                                          as ItmIsRlvtToJITDelivSchedules,
         Plant.matgr                                                                          as TransitionMatrixProductsGroup,
         Plant.vspvb                                                                          as ProposedProductSupplyArea,
         Plant.shpro                                                                          as PerdPrflForSftyTme,
         Plant.ahdis                                                                          as IsMRPDependentRqmt,
         Plant.kzpsp                                                                          as ProductIsForCrossProject,
         Plant.ocmpf                                                                          as OrderChangeManagementProfile,
         Plant.eislo                                                                          as MinimumSafetyStockQuantity,
         cast ( Plant.ncost as productiscostingrelevant preserving type )                     as ProductIsCostingRelevant,
         Plant.rotation_date                                                                  as WrhsMgmtPtwyAndStkRemovalStrgy,
         Plant.uchkz                                                                          as OriglBatchManagementIsRequired,
         Plant.ucmat                                                                          as OriginalBatchReferenceMaterial,
         Plant.excise_tax_rlvnce                                                              as ProductIsExciseTaxRelevant,
         Plant.ppskz                                                                          as IsAdvancedPlanningUsed,
         Plant.cons_procg                                                                     as ConsignmentControl,
         Plant.gi_pr_time                                                                     as GoodIssueProcessingDays,
         Plant.multiple_ekgrp                                                                 as IsPurgAcrossPurgGroup,
         cast ( Plant.scm_grprt as cmd_prd_good_rcpt_proc_time_n preserving type )            as LocProdGoodsReceiptProcHours,

         cast ( Plant.scm_giprt as cmd_prd_good_issue_proc_time_n preserving type )           as LocProdGoodsIssueProcHours,
         Plant.scm_scost                                                                      as LocProdStorageCostValue,
         Plant.scm_reldt                                                                      as ReplenishmentLeadTimeDays,
         Plant.scm_rrp_type                                                                   as PPPlanningProcedure,
         Plant.scm_heur_id                                                                    as ProdnPlngHeuristic,
         Plant.scm_package_id                                                                 as ProductPlanningPackage,
         Plant.scm_sspen                                                                      as SftyStkVioltnPnltyCostValue,
         Plant.scm_get_alerts                                                                 as ProductAlertRelevanceCode,
         Plant.scm_res_net_name                                                               as ResourceNetworkName,
         Plant.scm_conhap                                                                     as GRHandlingCapacityQuantity,
         Plant.scm_hunit                                                                      as GRHandlingCapacityUnit,
         Plant.scm_conhap_out                                                                 as GIHandlingCapacityQuantity,
         Plant.scm_hunit_out                                                                  as GIHandlingCapacityUnit,
         Plant.scm_shelf_life_loc                                                             as IsLocDependentShelfLifeUsed,
         cast( Plant.scm_shelf_life_dur as cmd_prd_shelf_life_dur_l_n preserving type )       as ShelfLifeLocDependent,
         cast (Plant.scm_maturity_dur as cmd_prd_maturity_dur_l_n preserving type )           as MaturationDurnLocDependent,
         cast (Plant.scm_shlf_lfe_req_min as cmd_prd_shelf_life_req_min_l_n preserving type ) as RqdMinShelfLifeLocDepdnt,
         cast (Plant.scm_shlf_lfe_req_max as cmd_prd_shelf_life_req_max_l_n preserving type ) as RqdMaxShelfLifeLocDepdnt,
         Plant.scm_lsuom                                                                      as LotSizeUnit,
         cast (Plant.scm_reord_dur as cmd_prd_reord_dur_n preserving type )                   as ReorderDaysSupplyInWorkDays,
         cast (Plant.scm_target_dur as cmd_prd_target_dur_n preserving type )                 as TargetDaysSupplyInWorkDays,
         Plant.scm_tstrid                                                                     as PlngCalendarPerdcLotSizing,
         Plant.scm_stra1                                                                      as RequirementStrategy,
         cast (Plant.scm_peg_past_alert as cmd_prd_dm_pegging_past_alert preserving type )    as AlertThldForDlydRcptDurn,
         cast (Plant.scm_peg_future_alert as cmd_prd_dm_pegging_futur_alert preserving type ) as AlertThldForEarlyRcptDurn,
         Plant.scm_peg_strategy                                                               as PeggingStrategy,
         Plant.scm_peg_wo_alert_fst                                                           as IsAlertsInPeggingAvoided,
         Plant.scm_fixpeg_prod_set                                                            as IsFixedPeggingForProdRetained,
         Plant.scm_whatbom                                                                    as BOMTypeExplosionUsed,
         Plant.scm_rrp_sel_group                                                              as ProductPlanningGroup,
         Plant.scm_intsrc_prof                                                                as InteractiveSourcingProfile,
         Plant.scm_prio                                                                       as ProductPriority,
         Plant.scm_min_pass_amount                                                            as MinPassingAmtContinuousPegging,
         Plant.scm_profid                                                                     as ConversionRule,
         Plant.scm_ges_mng_use                                                                as IsTotalQtyReceiptElement,
         Plant.scm_ges_bst_use                                                                as IsTotalQtyStockElement,
         Plant.esppflg                                                                        as ESPPIsUsed,
         cast(Plant.scm_thruput_time  as cmd_prd_srvc_prts_thruput_time preserving type )     as SrvcPartsThroughputTimeDurn,
         Plant.scm_tpop                                                                       as ThirdPartyOrderProcessing,
         Plant.scm_safty_v                                                                    as VCLSafetyStockQuantity,
         Plant.scm_ppsaftystk                                                                 as ParLocSafetyStockQuantity,
         Plant.scm_ppsaftystk_v                                                               as VCLParLocSafetyStockQuantity,
         Plant.scm_repsafty                                                                   as RepairSafetyStockQuantity,
         Plant.scm_repsafty_v                                                                 as VCLRepairSafetyStockQuantity,
         Plant.scm_reord_v                                                                    as VCLReorderPointQuantity,
         Plant.scm_maxstock_v                                                                 as VCLMaximumStockQuantity,
         Plant.scm_scost_prcnt                                                                as CostFactorForStockHoldingVal,
         Plant.scm_proc_cost                                                                  as ProductProcurementCostsVal,
         Plant.scm_ndcostwe                                                                   as GoodsReceiptHandlingCost,
         Plant.scm_ndcostwa                                                                   as GoodsIssueHandlingCost,
         Plant.scm_coninp                                                                     as ConsumptionOfStorageCapacity,
         Plant.conf_gmsync                                                                    as GIPostingIsSynchronous,
         Plant.scm_iunit                                                                      as ConsumptionOfStorageCapUnit,
         Plant.sfty_stk_meth                                                                  as MRPSafetyStockMethod,
         Plant.temp_ctrl_max                                                                  as ProductMaxControlTemperature,
         Plant.temp_ctrl_min                                                                  as ProductMinControlTemperature,
         Plant.temp_uom                                                                       as ProductControlTemperatureUnit,
         Plant.jitprodnconfprofile                                                            as JITProdnConfProfile,
         Plant.sgt_covs                                                                       as SegmentationStrategyForPlant,
         Plant.sgt_defsc                                                                      as DefaultSegmentValue,
         Plant.sgt_mrpsi                                                                      as SgmtHasPrioInProductStockSort,
         Plant.iuid_relevant                                                                  as ItemUniqueIdentifierIsRelevant,
         Plant.iuid_type                                                                      as ItemUniqueIdentifierType,
         Plant.uid_iea                                                                        as ExtAllocOfItmUnqIdtIsRelevant,
         
         _Product

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARC"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/