R_SiteMasterTP

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 R_SiteMasterTP.
-- 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 R_SiteMasterTP AS
SELECT
  Site,
  SiteCustomer,
  SiteName,
  SiteSupplier,
  SalesOrganization,
  DistributionChannel,
  Division,
  _DivisionText.DivisionName AS DivisionName,
  FactoryCalendar,
  _FactoryCalendar._Text[1: Language=$session.system_language].FactoryCalendarName AS FactoryCalendarName,
  SiteCategory,
  _SiteCategoryText[1: Language=$session.system_language].PlantCategoryName AS SiteCategoryName,
  ValuationArea,
  _SiteBPMaintStatus.SiteBPMaintStatus AS SiteBPMaintStatus,
  _SiteBPMaintStatus._SiteBPMaintStatusText.SiteBPMaintStatusName AS SiteBPMaintStatusName,
  _SiteBlocking.SiteBlockingFromDate AS SiteBlockingFromDate,
  _SiteBlocking.SiteBlockingToDate AS SiteBlockingToDate,
  _SiteBlocking.SiteBlockingReason AS SiteBlockingReason,
  _SiteOpeningHours.SiteOpeningDate AS SiteOpeningDate,
  _SiteOpeningHours.SiteClosingDate AS SiteClosingDate,
  _SiteOpeningHours.SiteGoodsReceivingHoursCode AS SiteGoodsReceivingHoursCode,
  _SiteOpeningHours._SiteGoodsReceivingHoursCodeT.SiteGoodsReceivingHoursText AS SiteGoodsReceivingHoursText,
  _Address.CityName AS CityName,
  _Address.StreetName AS StreetName,
  _Address.HouseNumber AS HouseNumber,
  _Address.PostalCode AS PostalCode,
  _Address.Country AS Country,
  _Address.PhoneNumber AS PhoneNumber,
  _CustomerBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CustomerBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _SiteMasterCustomizingData.SiteProfile AS SiteProfile,
  _SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  _DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName AS DistributionChannelName,
  I_Site._Customer.CustomerName AS CustomerName,
  I_Site._Supplier.SupplierName AS SupplierName,
  _SiteInventory.ProfitCenter AS ProfitCenter,
  DefaultPurchasingOrganization,
  _DefaultPurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _ValuationArea.CompanyCode AS CompanyCode,
  _ValuationArea._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _SiteMasterAdminFields.LastChangedByUser AS LastChangedByUser,
  _SiteMasterAdminFields.LastChangeDateTime AS LastChangeDateTime,
  _SiteMasterCustomizingData.PointOfSaleCurrency AS PointOfSaleCurrency,
  _SiteMasterCustomizingData._CurrencyText.CurrencyName AS CurrencyName,
  _SiteMasterCustomizingData.PointOfSaleInboundProfile AS PointOfSaleInboundProfile,
  _SiteMasterCustomizingData._PointOfSaleInboundProfileT.PointOfSaleInboundProfileName AS PointOfSaleInboundProfileName,
  _SiteMasterCustomizingData.PointOfSaleOutboundProfile AS PointOfSaleOutboundProfile,
  _SiteMasterCustomizingData._PointOfSaleOutboundProfileT.PointOfSaleOutboundProfileName AS PointOfSaleOutboundProfileName,
  _SiteMasterCustomizingData.RegularSupplierIsTknIntoAcct AS RegularSupplierIsTknIntoAcct,
  cast(_SiteMasterCustomizingData.OrderConversionIsAutomatic as xfeld) AS OrderConversionIsAutomatic,
  _SiteMasterCustomizingData.IsSourceListRequired AS IsSourceListRequired,
  _SiteMasterCustomizingData.SiteLevelCondition AS SiteLevelCondition,
  _SiteMasterCustomizingData.SiteTaxClassification AS SiteTaxClassification,
  _SiteMasterCustomizingData.SiteDistributionProfile AS SiteDistributionProfile,
  _SiteMasterCustomizingData.CountryCode AS CountryCode,
  _SiteMasterCustomizingData.SalesAreaDetermination AS SalesAreaDetermination,
  _SiteMasterCustomizingData.ActualCostingIsActive AS ActualCostingIsActive,
  _SiteMasterCustomizingData.ActualActivitiesUpdated AS ActualActivitiesUpdated,
  _SiteMasterCustomizingData.ControlCreditOfCostCenters AS ControlCreditOfCostCenters,
  _SiteMasterCustomizingData.ValuationGroupingCode AS ValuationGroupingCode,
  _SiteMasterCustomizingData.InventoryManagementProfile AS InventoryManagementProfile,
  _SiteMasterCustomizingData.SalesPriceValuationIsActive AS SalesPriceValuationIsActive,
  _SiteMasterCustomizingData.RevaluationProfile AS RevaluationProfile,
  _SiteMasterCustomizingData.IsNegativeStockAllowed AS IsNegativeStockAllowed,
  _SiteMasterCustomizingData.PriceDeterminationIsBinding AS PriceDeterminationIsBinding,
  _SiteMasterCustomizingData.CostCompSplitIsExisting AS CostCompSplitIsExisting,
  _SiteMasterCustomizingData.MaterialLedgerIsLive AS MaterialLedgerIsLive,
  _SiteMasterCustomizingData.ActualCostingIsLive AS ActualCostingIsLive,
  _SiteMasterCustomizingData.SubsequentListingIsActive AS SubsequentListingIsActive,
  _SiteMasterCustomizingData.PriceDeterminationControl AS PriceDeterminationControl,
  _SiteMasterCustomizingData.SalesOrgForRtlPriceDetn AS SalesOrgForRtlPriceDetn,
  _SiteMasterCustomizingData.DistrChnlForRetailPriceDetn AS DistrChnlForRetailPriceDetn,
  _SiteMasterCustomizingData._InventoryProfileText.InventoryManagementProfileName AS InventoryManagementProfileName,
  _SiteMasterCustomizingData._RevaluationProfileText.RevaluationProfileText AS RevaluationProfileText,
  _SiteMasterCustomizingData._PriceControlText.PriceDeterminationControlName AS PriceDeterminationControlName,
  _SiteMasterCustomizingData._SalesAreaDeterminationText.SalesAreaDeterminationName AS SalesAreaDeterminationName,
  _SiteMasterCustomizingData._ControlCrdtOfCostCentersText.ControlCrdtOfCostCentersName AS ControlCrdtOfCostCentersName,
  _SiteMasterCustomizingData._ConsumptionActivityText.ActualActivitiesUpdatedName AS ActualActivitiesUpdatedName,
  _SiteMasterCustomizingData._SiteTaxClassificationText.SiteTaxClassificationName AS SiteTaxClassificationName,
  _SiteMasterCustomizingData._SiteDistributionProfileText.SiteDistributionProfileName AS SiteDistributionProfileName,
  _SiteMasterCustomizingData._SiteLevelConditionText.SiteLevelConditionName AS SiteLevelConditionName,
  _SiteMasterCustomizingData._SiteProfile.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  _SiteMasterCustomizingData._SubsequentListingText.SubsequentListingName AS SubsequentListingName,
  _SiteMasterCustomizingData._SalesOrgPriceText.SalesOrganizationName AS SalesOrgForRetailPriceDetnName,
  _SiteMasterCustomizingData._DistributionChannelPriceText.DistributionChannelName AS DistrChnlForRetailPrcDetnName,
  _ValuationArea._CompanyCode AS _CompanyCode,
  I_Site._Supplier AS _Supplier,
  _SiteMasterCustomizingData._CurrencyText AS _CurrencyText,
  _SiteMasterCustomizingData._PointOfSaleInboundProfileT AS _PointOfSaleInboundProfileT,
  _SiteMasterCustomizingData._SiteTaxClassificationText AS _SiteTaxClassificationText,
  _SiteMasterCustomizingData._SiteDistributionProfileText AS _SiteDistributionProfileText,
  _SiteMasterCustomizingData._SiteLevelConditionText AS _SiteLevelConditionText
FROM I_Site
LEFT OUTER JOIN I_SiteMasterCustomizingData AS _SiteMasterCustomizingData ON Site = _SiteMasterCustomizingData.Site  -- association [0..1]
LEFT OUTER JOIN I_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_SiteBlockingReasonT AS _SiteBlockingReason ON SiteBlockingReason = _SiteBlockingReason.SiteBlockingReason AND _SiteBlockingReason.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SiteBPMaintenanceStatus AS _SiteBPMaintStatus ON Site = _SiteBPMaintStatus.Site  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON Division = _DivisionText.Division AND _DivisionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SiteBPMaintStatusText AS _SiteBPMaintStatusText ON SiteBPMaintStatus = _SiteBPMaintStatusText.SiteBPMaintStatus AND _SiteBPMaintStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SiteProfileText AS _SiteProfileText ON siteprofile = _SiteProfileText.SiteProfile AND _SiteProfileText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerBusinessPartner ON SiteCustomer = _CustomerBusinessPartner.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON Site = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SiteControllingArea AS _ControllingArea ON companycode = _ControllingArea.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_RetailSite AS _Extension ON SiteCustomer = _Extension.SiteCustomer  -- association [1]
LEFT OUTER JOIN R_SiteSupplyingSiteTP AS _SiteSupplyingSite ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SiteProductGroupTP AS _SiteProductGroup ON /* condition not available in parsed metadata */  -- association [0..*]
;