C_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 C_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: CUSERSETTINGITEM

CREATE VIEW C_UserDefaultSettingItem AS
SELECT
  I_Userdefaultsettingitemwd.Employee AS Employee,
  I_Userdefaultsettingitemwd.PersonalizationID AS PersonalizationID,
  I_Userdefaultsettingitemwd.BusinessObjectType AS BusinessObjectType,
  I_Userdefaultsettingitemwd.EmployeeForEdit AS EmployeeForEdit,
  I_Userdefaultsettingitemwd.BusinessObjectTypeForEdit AS BusinessObjectTypeForEdit,
  I_Userdefaultsettingitemwd.Plant AS Plant,
  I_Userdefaultsettingitemwd.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_Userdefaultsettingitemwd.MaterialGroup AS MaterialGroup,
  I_Userdefaultsettingitemwd.DeliveryDate AS DeliveryDate,
  I_Userdefaultsettingitemwd.Currency AS Currency,
  I_Userdefaultsettingitemwd.PurchasingGroup AS PurchasingGroup,
  I_Userdefaultsettingitemwd.SourceDetermination AS SourceDetermination,
  I_Userdefaultsettingitemwd.SupplyingPlant AS SupplyingPlant,
  I_Userdefaultsettingitemwd.StorageLocation AS StorageLocation,
  I_Userdefaultsettingitemwd.RequisitionerName AS RequisitionerName,
  I_Userdefaultsettingitemwd.CostCenter AS CostCenter,
  I_Userdefaultsettingitemwd.PurchasingOrganization AS PurchasingOrganization,
  I_Userdefaultsettingitemwd.CompanyCode AS CompanyCode,
  I_Userdefaultsettingitemwd.PurchasingDocumentType AS PurchasingDocumentType,
  I_Userdefaultsettingitemwd.ExtPurchaseRequisitionType AS ExtPurchaseRequisitionType,
  I_Userdefaultsettingitemwd.LastChangeDateTime AS LastChangeDateTime,
  I_Userdefaultsettingitemwd.ChangedBy AS ChangedBy,
  I_Userdefaultsettingitemwd.WBSElementInternalID AS WBSElementInternalID,
  I_Userdefaultsettingitemwd.WBSElement AS WBSElement,
  I_Userdefaultsettingitemwd.ProjectNetwork AS ProjectNetwork,
  I_Userdefaultsettingitemwd.OrderID AS OrderID,
  I_Userdefaultsettingitemwd.GLAccount AS GLAccount,
  I_Userdefaultsettingitemwd.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_Userdefaultsettingitemwd.Asset AS Asset,
  I_Userdefaultsettingitemwd.AssetSubNumber AS AssetSubNumber,
  I_Userdefaultsettingitemwd.GoodsRecipientName AS GoodsRecipientName,
  I_Userdefaultsettingitemwd.UnloadingPointName AS UnloadingPointName,
  I_Userdefaultsettingitemwd.CommSyst AS CommSyst,
  I_Userdefaultsettingitemwd.SourceSystem AS SourceSystem,
  I_Userdefaultsettingitemwd.LogicalSystem AS LogicalSystem,
  I_Userdefaultsettingitemwd.ShopOnBehalfType AS ShopOnBehalfType,
  I_Userdefaultsettingitemwd.ProcmtHubSSPExpertAuthorIsActv AS ProcmtHubSSPExpertAuthorIsActv,
  I_Userdefaultsettingitemwd.PurchaseOrderPriceType AS PurchaseOrderPriceType,
  I_Userdefaultsettingitemwd.PurReqnHeaderCurrencySource AS PurReqnHeaderCurrencySource,
  I_Userdefaultsettingitemwd.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_Userdefaultsettingitemwd.AuthorizationGroup AS AuthorizationGroup,
  I_Userdefaultsettingitemwd.UserID AS UserID,
  I_Userdefaultsettingitemwd.PlantName AS PlantName,
  I_Userdefaultsettingitemwd.CompanyCodeName AS CompanyCodeName,
  I_Userdefaultsettingitemwd.PurchasingGroupName AS PurchasingGroupName,
  I_Userdefaultsettingitemwd.SupplyingPlantName AS SupplyingPlantName,
  I_Userdefaultsettingitemwd.StorageLocationName AS StorageLocationName,
  I_Userdefaultsettingitemwd.ProjectNetworkDescription AS ProjectNetworkDescription,
  _SSPPurgOrgVH.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_Userdefaultsettingitemwd.IsExtPurgScenario AS IsExtPurgScenario,
  I_Userdefaultsettingitemwd.Person AS Person,
  I_Userdefaultsettingitemwd.FullName AS FullName,
  I_Userdefaultsettingitemwd.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg,
  I_Userdefaultsettingitemwd._Plant AS _Plant,
  I_Userdefaultsettingitemwd._AccAssgnmtCategory AS _AccAssgnmtCategory,
  I_Userdefaultsettingitemwd._MaterialGroup AS _MaterialGroup,
  I_Userdefaultsettingitemwd._Currency AS _Currency,
  I_Userdefaultsettingitemwd._PurchasingGroup AS _PurchasingGroup,
  I_Userdefaultsettingitemwd._SupplyingPlant AS _SupplyingPlant,
  I_Userdefaultsettingitemwd._StorageLocation AS _StorageLocation,
  I_Userdefaultsettingitemwd._User AS _User,
  I_Userdefaultsettingitemwd._CompanyCode AS _CompanyCode
FROM I_Userdefaultsettingitemwd
LEFT OUTER JOIN C_Userdefaultsetting AS _UserdefaultSettingWd ON _UserdefaultSettingWd.Employee = Employee AND _UserdefaultSettingWd.PersonalizationID = PersonalizationID  -- association [1..1]
LEFT OUTER JOIN C_Usercatalogs AS _Usercatalogswithdraft ON _Usercatalogswithdraft.Employee = Employee AND _Usercatalogswithdraft.PersonalizationID = PersonalizationID AND _Usercatalogswithdraft.BusinessObjectType = BusinessObjectType  -- association [1..*]
LEFT OUTER JOIN I_ProcmtEmployeeUserDetails AS _Userdetails ON Employee = _Userdetails.UserID  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON _PurchasingDocumentType.PurchasingDocumentCategory = 'B' AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_SSPPurchasingDocumentType AS _ExtPurchasingDocumentType ON _ExtPurchasingDocumentType.PurchasingDocumentCategory = 'B' AND ExtPurchaseRequisitionType = _ExtPurchasingDocumentType.PurchasingDocumentType AND SourceSystem = _ExtPurchasingDocumentType.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON AccountAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON Currency = _CurrencyText.Currency  -- association [0..*]
LEFT OUTER JOIN I_MM_WBSElementByIntKeyVH AS _MM_WBSElementByIntKeyVH ON WBSElementInternalID = _MM_WBSElementByIntKeyVH.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN C_SSPWrkBrkdwnStrucElementVH AS _MM_WBSElementValueHelp ON WBSElement = _MM_WBSElementValueHelp.WBSElement AND SourceSystem = _MM_WBSElementValueHelp.ProcurementHubSourceSystem  -- association [0..*]
LEFT OUTER JOIN C_SSPFixedAssetVH AS _MM_FixedAssetValueHelp ON CompanyCode = _MM_FixedAssetValueHelp.CompanyCode AND AssetSubNumber = _MM_FixedAssetValueHelp.FixedAsset AND Asset = _MM_FixedAssetValueHelp.MasterFixedAsset AND SourceSystem = _MM_FixedAssetValueHelp.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_SSPPurgOrgVH AS _SSPPurgOrgVH ON PurchasingOrganization = _SSPPurgOrgVH.PurchasingOrganization AND SourceSystem = _SSPPurgOrgVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_UserRequisitioningGroups AS _UserRequisitioningGroupsWD ON _UserRequisitioningGroupsWD.Employee = Employee AND _UserRequisitioningGroupsWD.PersonalizationID = PersonalizationID AND _UserRequisitioningGroupsWD.BusinessObjectType = BusinessObjectType  -- association [1..*]
;