Accueil Explorer Aide
S'inscrire Connexion
GlobalCube
/
ETL_DWH_LOCOSOFT
3
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Branche: main
Branches Tags
ETL_DWH_LOCOSOF...
/
schema
/
GC_ETL_LOCOSOFT
/
views
/
xtract.accounts_characteristics.sql

xtract.accounts_characteristics.sql 2.6 KB
Lien permanent Historique Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 
  1. SET QUOTED_IDENTIFIER ON 
    2. 

  2. GO
    3. 

  3. SET ANSI_NULLS ON 
    4. 

  4. GO
    5. 

  5. CREATE   VIEW [xtract].[accounts_characteristics] AS
    6. 

  6. 

  7. WITH
    8. 

  8.     "accounts_chars"
    9. 

  9.         AS (SELECT [client_db]
    10. 

  10.                  , [subsidiary_to_company_ref]
    11. 

  11.                  , [skr51_branch]
    12. 

  12.                  , [skr51_make]
    13. 

  13.                  , [skr51_cost_center]
    14. 

  14.                  , [skr51_sales_channel]
    15. 

  15.                  , [skr51_cost_unit]
    16. 

  16.                  , [skr51_brach_name]
    17. 

  17.                  , [skr51_make_description]
    18. 

  18.                  , [skr51_cost_center_name]
    19. 

  19.                  , [skr51_sales_channel_name]
    20. 

  20.                  , [skr51_cost_unit_name]
    21. 

  21.                  , convert(varchar(10), [skr51_branch]) AS [Standort_Code]
    22. 

  22.                  , convert(varchar(10), [skr51_make]) AS [Marke_Code]
    23. 

  23.                  , right('0' + convert(varchar(10), [skr51_cost_center]), 2) AS [Kostenstelle_Code]
    24. 

  24.                  , right('0' + convert(varchar(10), [skr51_sales_channel]), 2) AS [Absatzkanal_Code]
    25. 

  25.                  , right('0' + convert(varchar(10), [skr51_cost_unit]), 2) AS [Kostenträger_Code]
    26. 

  26.             FROM [LOCOSOFT].[dbo].[accounts_characteristics])
    27. 

  27. 

  28. SELECT [client_db]
    29. 

  29.      , [subsidiary_to_company_ref]
    30. 

  30.      , [skr51_branch]
    31. 

  31.      , [skr51_make]
    32. 

  32.      , [skr51_cost_center]
    33. 

  33.      , [skr51_sales_channel]
    34. 

  34.      , [skr51_cost_unit]
    35. 

  35.      , [skr51_brach_name]
    36. 

  36.      , [skr51_make_description]
    37. 

  37.      , [skr51_cost_center_name]
    38. 

  38.      , [skr51_sales_channel_name]
    39. 

  39.      , [skr51_cost_unit_name]
    40. 

  40.      , [Standort_Code]
    41. 

  41.      , [skr51_brach_name] AS [Standort_Name]
    42. 

  42.      , [Standort_Code] + ' - ' + [skr51_brach_name] AS [Standort_mit_Bez]
    43. 

  43.      , [Marke_Code]
    44. 

  44.      , [skr51_make_description] AS [Marke_Name]
    45. 

  45.      , + ' - ' + [skr51_make_description] AS [Marke_mit_Bez]
    46. 

  46.      , [Kostenstelle_Code]
    47. 

  47.      , left([Kostenstelle_Code], 1) AS [Kostenstelle_1_Stelle]
    48. 

  48.      , [skr51_cost_center_name] AS [Kostenstelle_Name]
    49. 

  49.      , [Kostenstelle_Code] + ' - ' + [skr51_cost_center_name] AS [Kostenstelle_mit_Bez]
    50. 

  50.      , [Absatzkanal_Code]
    51. 

  51.      , left([Absatzkanal_Code], 1) AS [Absatzkanal_1_Stelle]
    52. 

  52.      , [skr51_sales_channel_name] AS [Absatzkanal_Name]
    53. 

  53.      , [Absatzkanal_Code] + ' - ' + [skr51_sales_channel_name] AS [Absatzkanal_mit_Bez]
    54. 

  54.      , [Kostenträger_Code]
    55. 

  55.      , left([Kostenträger_Code], 1) AS [Kostenträger_1_Stelle]
    56. 

  56.      , [skr51_cost_unit_name] AS [Kostenträger_Name]
    57. 

  57.      , [Kostenträger_Code] + ' - ' + [skr51_cost_unit_name] AS [Kostenträger_mit_Bez]
    58. 

  58.      , [Marke_Code] + ' - ' + [Kostenträger_Code] + ' - ' + [skr51_cost_unit_name] AS [Kostenträger_Marke_mit_Bez]
    59. 

  59. 

  60. FROM [accounts_chars]
    61. 

  61. GO
    62. 

  62. SET QUOTED_IDENTIFIER OFF 
    63. 

  63. GO
    64. 

  64. SET ANSI_NULLS OFF 
    65. 

  65. GO
    66. 

  66. 

  67. GO
    68.