I_UserDefaultSettingItem

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 I_UserDefaultSettingItem.
-- 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.
-- SQL view name: IUSERSETTINGITEM

CREATE VIEW I_UserDefaultSettingItem AS
SELECT
  I_ProcmtUsrAdvncdDfltSettings.Employee AS Employee,
  PersonalizationID,
  BusinessObjectType,
  Plant,
  AccountAssignmentCategory,
  MaterialGroup,
  DeliveryDate,
  Currency,
  PurchasingGroup,
  SourceDetermination,
  SupplyingPlant,
  StorageLocation,
  RequisitionerName,
  CostCenter,
  PurchasingDocumentType,
  ExtPurchaseRequisitionType,
  PurchasingOrganization,
  I_ProcmtUsrAdvncdDfltSettings.CompanyCode AS CompanyCode,
  LastChangeDateTime,
  ChangedBy,
  cast( I_ProcmtUsrAdvncdDfltSettings.WBSElementInternalID_2 as ps_psp_pnr ) AS WBSElementInternalID,
  I_ProcmtUsrAdvncdDfltSettings.WBSElementInternalID_2 AS WBSElementInternalID_2,
  WBSElement,
  ProjectNetwork,
  OrderID,
  ProjectNetworkInternalID,
  GLAccount,
  Asset,
  AssetSubNumber,
  GoodsRecipientName,
  UnloadingPointName,
  ProcmtHubSSPExpertAuthorIsActv,
  CommSyst,
  LogicalSystem,
  ProcurementHubSourceSystem AS SourceSystem,
  ShopOnBehalfType,
  _Userdetails.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Userdetails.AuthorizationGroup AS AuthorizationGroup,
  _Userdetails.UserID AS UserID,
  _Userdetails.Person AS Person,
  _Userdetails.FullName AS FullName,
  _Userdetails.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg,
  _Userdetails._BusinessPartner AS _BusinessPartner
FROM I_ProcmtUsrAdvncdDfltSettings
INNER JOIN I_ProcmtEmployeeUserDetails AS _Userdetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProcmtEmployeeUserDetails AS _Userdetails ON Employee = _Userdetails.UserID  -- association [1..1]
LEFT OUTER JOIN I_Usercatalogs AS _UserCatalogs ON PersonalizationID = _UserCatalogs.PersonalizationID  -- association [1..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccAssgnmtCategory ON AccountAssignmentCategory = _AccAssgnmtCategory.AccountAssignmentCategory  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter  -- association [1..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElement = _WBSElement.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON Asset = _FixedAsset.MasterFixedAsset AND AssetSubNumber = _FixedAsset.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON OrderID = _LogisticsOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND _GLAccount.ChartOfAccounts = 'INT'  -- association [0..*]
;