P_ProductPlantBasic

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ProductPlantBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_ProductPlantBasic AS
SELECT
  cast ( Plant.matnr as productnumber preserving type ) AS Product,
  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.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.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,
  Plant.atp_check_horizon AS ATPCheckHorizonInDays,
  Plant.atp_chk_hrzn_valdtn_cal AS ATPCheckHorizonFactoryCalendar
FROM marc AS Plant
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;