I_CostCenter

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_CostCenter.
-- 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: IFICOSTCENTER

CREATE VIEW I_CostCenter AS
SELECT
  kokrs AS ControllingArea,
  kostl AS CostCenter,
  datbi AS ValidityEndDate,
  datab AS ValidityStartDate,
  bkzkp AS IsBlkdForPrimaryCostsPosting,
  pkzkp AS IsBlockedForPlanPrimaryCosts,
  bukrs AS CompanyCode,
  gsber AS BusinessArea,
  kosar AS CostCenterCategory,
  verak AS CostCtrResponsiblePersonName,
  verak_user AS CostCtrResponsibleUser,
  waers AS CostCenterCurrency,
  kalsm AS CostingSheet,
  txjcd AS TaxJurisdiction,
  prctr AS ProfitCenter,
  werks AS Plant,
  logsystem AS LogicalSystem,
  ersda AS CostCenterCreationDate,
  usnam AS CostCenterCreatedByUser,
  bkzks AS IsBlkdForSecondaryCostsPosting,
  bkzer AS IsBlockedForRevenuePosting,
  bkzob AS IsBlockedForCommitmentPosting,
  cast(pkzks as fis_pkzks preserving type) AS IsBlockedForPlanSecondaryCosts,
  cast(pkzer as fis_pkzer preserving type) AS IsBlockedForPlanRevenues,
  vmeth AS CostCenterAllocationMethod,
  mgefl AS ConsumptionQtyIsRecorded,
  abtei AS Department,
  nkost AS SubsequentCostCenter,
  kvewe AS ConditionUsage,
  kappl AS ConditionApplication,
  koszschl AS CostCenterAccountingOverhead,
  land1 AS Country,
  anred AS FormOfAddress,
  name1 AS AddressName,
  name2 AS AddressAdditionalName,
  name3 AS CostCenterAddrName3,
  name4 AS CostCenterAddrName4,
  ort01 AS CityName,
  ort02 AS District,
  stras AS StreetAddressName,
  pfach AS POBox,
  pstlz AS PostalCode,
  pstl2 AS POBoxPostalCode,
  regio AS Region,
  spras AS Language,
  telbx AS TeleboxNumber,
  telf1 AS PhoneNumber1,
  telf2 AS PhoneNumber2,
  telfx AS FaxNumber,
  teltx AS TeletexNumber,
  telx1 AS TelexNumber,
  datlt AS DataCommunicationPhoneNumber,
  drnam AS CostCenterPrinterDestination,
  khinr AS CostCenterStandardHierArea,
  cckey AS CostCollector,
  kompl AS CostCenterIsComplete,
  cast(stakz as fins_xkostl_stat preserving type) AS IsStatisticalCostCenter,
  objnr AS ObjectInternalID,
  funkt AS CostCenterFunction,
  afunk AS CostCenterAlternativeFunction,
  func_area AS FunctionalArea,
  cpi_templ AS ActyIndepFormulaPlanningTmpl,
  cpd_templ AS ActyDepdntFormulaPlanningTmpl,
  sci_templ AS ActyIndependentAllocationTmpl,
  scd_templ AS ActyDependentAllocationTmpl,
  ski_templ AS ActlIndepStatisticalKeyFigures,
  skd_templ AS ActlDepStatisticalKeyFigures,
  vname AS JointVenture,
  recid AS JointVentureRecoveryCode,
  etype AS JointVentureEquityType,
  jv_otype AS JointVentureObjectType,
  jv_jibcl AS JointVentureClass,
  jv_jibsa AS JointVentureSubClass,
  budget_carrying_cost_ctr AS BudgetCarryingCostCenter,
  avc_profile AS AvailabilityControlProfile,
  avc_active AS AvailabilityControlIsActive,
  Fund,
  grant_id AS GrantID,
  fund_fix_assigned AS FundIsFixAssigned,
  grant_fix_assigned AS GrantIDIsFixAssigned,
  func_area_fix_assigned AS FunctionalAreaIsFixAssigned
FROM csks
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1]
LEFT OUTER JOIN I_CostCenterText AS _Text ON ControllingArea = _Text.ControllingArea AND CostCenter = _Text.CostCenter AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_CostCenterHierarchyNode AS _CostCenterHierarchyNode ON ControllingArea = _CostCenterHierarchyNode.ControllingArea AND CostCenter = _CostCenterHierarchyNode.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON CostCenterCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterCategory AS _CostCenterCategory ON CostCenterCategory = _CostCenterCategory.CostCenterCategory  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_CostingSheetProcedure AS _CostingSheetProcedure ON _CostingSheetProcedure.ConditionUsage = 'A' AND _CostingSheetProcedure.ConditionApplication = 'KA' AND _CostingSheetProcedure.CostingSheetProcedure = CostingSheet  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserRespContactCard ON CostCtrResponsibleUser = _UserRespContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserCrtedContactCard ON CostCenterCreatedByUser = _UserCrtedContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_AvailabilityCtrlProfile AS _AvailabilityCtrlProfile ON AvailabilityControlProfile = _AvailabilityCtrlProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN E_CostCenter AS _Extension ON ControllingArea = _Extension.ControllingArea AND CostCenter = _Extension.CostCenter AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_ActivityBasedCostingTmpl AS _ActivityBasedCostingTmplCpi ON _ActivityBasedCostingTmplCpi.ControllingArea = ControllingArea AND _ActivityBasedCostingTmplCpi.ActivityBasedCostingEnvrmt = 'CPI' AND _ActivityBasedCostingTmplCpi.ActivityBasedCostingTemplate = ActyIndepFormulaPlanningTmpl  -- association [0..1]
LEFT OUTER JOIN I_ActivityBasedCostingTmpl AS _ActivityBasedCostingTmplCpd ON _ActivityBasedCostingTmplCpd.ControllingArea = ControllingArea AND _ActivityBasedCostingTmplCpd.ActivityBasedCostingEnvrmt = 'CPD' AND _ActivityBasedCostingTmplCpd.ActivityBasedCostingTemplate = ActyDepdntFormulaPlanningTmpl  -- association [0..1]
LEFT OUTER JOIN I_ActivityBasedCostingTmpl AS _ActivityBasedCostingTmplSci ON _ActivityBasedCostingTmplSci.ControllingArea = ControllingArea AND _ActivityBasedCostingTmplSci.ActivityBasedCostingEnvrmt = 'SCI' AND _ActivityBasedCostingTmplSci.ActivityBasedCostingTemplate = ActyIndependentAllocationTmpl  -- association [0..1]
LEFT OUTER JOIN I_ActivityBasedCostingTmpl AS _ActivityBasedCostingTmplScd ON _ActivityBasedCostingTmplScd.ControllingArea = ControllingArea AND _ActivityBasedCostingTmplScd.ActivityBasedCostingEnvrmt = 'SCD' AND _ActivityBasedCostingTmplScd.ActivityBasedCostingTemplate = ActyDependentAllocationTmpl  -- association [0..1]
LEFT OUTER JOIN I_ActivityBasedCostingTmpl AS _ActivityBasedCostingTmplSki ON _ActivityBasedCostingTmplSki.ControllingArea = ControllingArea AND _ActivityBasedCostingTmplSki.ActivityBasedCostingEnvrmt = 'SKI' AND _ActivityBasedCostingTmplSki.ActivityBasedCostingTemplate = ActlIndepStatisticalKeyFigures  -- association [0..1]
LEFT OUTER JOIN I_ActivityBasedCostingTmpl AS _ActivityBasedCostingTmplSkd ON _ActivityBasedCostingTmplSkd.ControllingArea = ControllingArea AND _ActivityBasedCostingTmplSkd.ActivityBasedCostingEnvrmt = 'SKD' AND _ActivityBasedCostingTmplSkd.ActivityBasedCostingTemplate = ActlDepStatisticalKeyFigures  -- association [0..1]
;