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

CREATE VIEW C_CostCenter AS
SELECT
  _SetHeader._SetHeaderText[1:Language = $session.system_language].SetDescription AS SetDescription,
  FunctionalAreaIsFixAssigned,
  Fund,
  _FundStdVH._Text[1:Language = $session.system_language].FundDescription AS FundDescription,
  FinancialManagementArea,
  FundIsFixAssigned,
  GrantID,
  _GrantStdVH._Text[1:Language = $session.system_language].GrantName AS GrantName,
  GrantIDIsFixAssigned,
  BudgetCarryingCostCenter,
  _BudgetCarryingCostCenter._Text[1:Language = $session.system_language].CostCenterName AS BudgetCarryingCostCenterName,
  CostCenterIsBudgetCarrying,
  AvailabilityControlProfile,
  cast( _CostCtrBdgtAvailyCtrlPrflVH.AvailabilityControlProfileName as fco_budgetavlbltctrlprofname preserving type ) AS AvailabilityControlProfileName,
  AvailabilityControlIsActive,
  _Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  I_CostCenterTP._Region._RegionText[1:Language = $session.system_language].RegionName AS RegionName,
  UxFcABCIndicator,
  _JointVentureRecovery._Text[1:Language = $session.system_language].JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  _JntVntrEquityTypeMaster._JntVntrEquityTypeDesc[1:Language = $session.system_language].JointVentureEquityTypeName AS JointVentureEquityTypeName,
  _JntVntrCostCtrType._JntVntrCostCtrTypeText[1:Language = $session.system_language].JntVntrCostCtrTypeText AS JntVntrCostCtrTypeText,
  _JntIntrstBillgClass._JntIntrstBillgClassText[1:Language = $session.system_language].JntIntrstBillgClassText AS JntIntrstBillgClassText,
  _JntIntrstBillgSubclass._JntIntrstBillgSubclassT[1:Language = $session.system_language].JntIntrstBillgSubClassText AS JntIntrstBillgSubClassText,
  UxFcJointVenture,
  CostCenterIsCopied,
  CostCenterTranslationIsHidden,
  CostCenterChangeLogIsHidden,
  I_CostCenterTP.ControllingArea AS ControllingArea,
  I_CostCenterTP.CostCenter AS CostCenter,
  I_CostCenterTP.ValidityEndDate AS ValidityEndDate,
  I_CostCenterTP.ControllingAreaForEdit AS ControllingAreaForEdit,
  I_CostCenterTP.ControllingAreaName AS ControllingAreaName,
  I_CostCenterTP.CostCenterForEdit AS CostCenterForEdit,
  I_CostCenterTP.CostCenterName AS CostCenterName,
  I_CostCenterTP.ValidityEndDateForEdit AS ValidityEndDateForEdit,
  I_CostCenterTP.ValidityStartDate AS ValidityStartDate,
  I_CostCenterTP.CostCenterDescription AS CostCenterDescription,
  I_CostCenterTP.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  I_CostCenterTP.CostCtrResponsiblePersonName AS CostCtrResponsiblePersonName,
  I_CostCenterTP.Department AS Department,
  I_CostCenterTP.CostCenterCategory AS CostCenterCategory,
  I_CostCenterTP.CostCenterCategoryName AS CostCenterCategoryName,
  I_CostCenterTP.CostCenterStandardHierArea AS CostCenterStandardHierArea,
  I_CostCenterTP.CompanyCode AS CompanyCode,
  I_CostCenterTP.CompanyCodeName AS CompanyCodeName,
  I_CostCenterTP.BusinessArea AS BusinessArea,
  I_CostCenterTP.BusinessAreaName AS BusinessAreaName,
  I_CostCenterTP.FunctionalArea AS FunctionalArea,
  I_CostCenterTP.FunctionalAreaName AS FunctionalAreaName,
  I_CostCenterTP.CostCenterCurrency AS CostCenterCurrency,
  I_CostCenterTP.ProfitCenter AS ProfitCenter,
  I_CostCenterTP.ProfitCenterName AS ProfitCenterName,
  I_CostCenterTP.LogicalSystem AS LogicalSystem,
  I_CostCenterTP.IsBlkdForPrimaryCostsPosting AS IsBlkdForPrimaryCostsPosting,
  I_CostCenterTP.IsBlockedForPlanPrimaryCosts AS IsBlockedForPlanPrimaryCosts,
  I_CostCenterTP.IsBlkdForSecondaryCostsPosting AS IsBlkdForSecondaryCostsPosting,
  I_CostCenterTP.IsBlockedForPlanSecondaryCosts AS IsBlockedForPlanSecondaryCosts,
  I_CostCenterTP.IsBlockedForRevenuePosting AS IsBlockedForRevenuePosting,
  I_CostCenterTP.IsBlockedForPlanRevenues AS IsBlockedForPlanRevenues,
  I_CostCenterTP.ConsumptionQtyIsRecorded AS ConsumptionQtyIsRecorded,
  I_CostCenterTP.IsBlockedForCommitmentPosting AS IsBlockedForCommitmentPosting,
  I_CostCenterTP.FormOfAddress AS FormOfAddress,
  I_CostCenterTP.AddressName AS AddressName,
  I_CostCenterTP.AddressAdditionalName AS AddressAdditionalName,
  I_CostCenterTP.CostCenterAddrName3 AS CostCenterAddrName3,
  I_CostCenterTP.CostCenterAddrName4 AS CostCenterAddrName4,
  I_CostCenterTP.StreetAddressName AS StreetAddressName,
  I_CostCenterTP.CityName AS CityName,
  I_CostCenterTP.PostalCode AS PostalCode,
  I_CostCenterTP.District AS District,
  I_CostCenterTP.Country AS Country,
  I_CostCenterTP.TaxJurisdiction AS TaxJurisdiction,
  I_CostCenterTP.POBox AS POBox,
  I_CostCenterTP.POBoxPostalCode AS POBoxPostalCode,
  I_CostCenterTP.Region AS Region,
  I_CostCenterTP.Language AS Language,
  I_CostCenterTP.PhoneNumber1 AS PhoneNumber1,
  I_CostCenterTP.PhoneNumber2 AS PhoneNumber2,
  I_CostCenterTP.TeleboxNumber AS TeleboxNumber,
  I_CostCenterTP.TelexNumber AS TelexNumber,
  I_CostCenterTP.FaxNumber AS FaxNumber,
  I_CostCenterTP.TeletexNumber AS TeletexNumber,
  I_CostCenterTP.CostCenterPrinterDestination AS CostCenterPrinterDestination,
  I_CostCenterTP.DataCommunicationPhoneNumber AS DataCommunicationPhoneNumber,
  I_CostCenterTP.CostCenterCreationDate AS CostCenterCreationDate,
  I_CostCenterTP.CostCenterCreatedByUser AS CostCenterCreatedByUser,
  I_CostCenterTP.ChangeDocObject AS ChangeDocObject,
  I_CostCenterTP.ResponsibleUserFullName AS ResponsibleUserFullName,
  I_CostCenterTP.CreatedByUserFullName AS CreatedByUserFullName,
  I_CostCenterTP.CostCenterResponsibilityArea AS CostCenterResponsibilityArea,
  I_CostCenterTP.CostCenterHierarchyRespyArea AS CostCenterHierarchyRespyArea,
  I_CostCenterTP.CostCenterValidityPeriod AS CostCenterValidityPeriod,
  I_CostCenterTP.UxFcCostCenter AS UxFcCostCenter,
  I_CostCenterTP.ActyIndepFormulaPlanningTmpl AS ActyIndepFormulaPlanningTmpl,
  I_CostCenterTP.ActyDepdntFormulaPlanningTmpl AS ActyDepdntFormulaPlanningTmpl,
  I_CostCenterTP.ActyIndependentAllocationTmpl AS ActyIndependentAllocationTmpl,
  I_CostCenterTP.ActyDependentAllocationTmpl AS ActyDependentAllocationTmpl,
  I_CostCenterTP.ActlIndepStatisticalKeyFigures AS ActlIndepStatisticalKeyFigures,
  I_CostCenterTP.ActlDepStatisticalKeyFigures AS ActlDepStatisticalKeyFigures,
  I_CostCenterTP.CostingSheet AS CostingSheet,
  I_CostCenterTP.JointVenture AS JointVenture,
  I_CostCenterTP.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_CostCenterTP.JointVentureEquityType AS JointVentureEquityType,
  I_CostCenterTP.JointVentureObjectType AS JointVentureObjectType,
  I_CostCenterTP.JointVentureClass AS JointVentureClass,
  I_CostCenterTP.JointVentureSubClass AS JointVentureSubClass,
  I_CostCenterTP._ControllingAreaForEdit AS _ControllingAreaForEdit,
  I_CostCenterTP._CostCenterHierNodeForEdit AS _CostCenterHierNodeForEdit,
  I_CostCenterTP._ControllingArea AS _ControllingArea,
  I_CostCenterTP._Text AS _Text,
  I_CostCenterTP._CostCenterHierarchyNode AS _CostCenterHierarchyNode,
  I_CostCenterTP._Currency AS _Currency,
  I_CostCenterTP._CompanyCode AS _CompanyCode,
  I_CostCenterTP._BusinessArea AS _BusinessArea,
  I_CostCenterTP._ProfitCenter AS _ProfitCenter,
  I_CostCenterTP._FunctionalArea AS _FunctionalArea,
  I_CostCenterTP._CostCenterCategory AS _CostCenterCategory,
  I_CostCenterTP._Country AS _Country,
  I_CostCenterTP._Region AS _Region,
  I_CostCenterTP._Language AS _Language,
  I_CostCenterTP._UserRespContactCard AS _UserRespContactCard,
  I_CostCenterTP._UserCrtedContactCard AS _UserCrtedContactCard,
  I_CostCenterTP._ActivityBasedCostingTmplCpi AS _ActivityBasedCostingTmplCpi,
  I_CostCenterTP._ActivityBasedCostingTmplCpd AS _ActivityBasedCostingTmplCpd,
  I_CostCenterTP._ActivityBasedCostingTmplSci AS _ActivityBasedCostingTmplSci,
  I_CostCenterTP._ActivityBasedCostingTmplScd AS _ActivityBasedCostingTmplScd,
  I_CostCenterTP._ActivityBasedCostingTmplSki AS _ActivityBasedCostingTmplSki,
  I_CostCenterTP._ActivityBasedCostingTmplSkd AS _ActivityBasedCostingTmplSkd,
  _JointVentureMaster.JointVentureName AS JointVentureName
FROM I_CostCenterTP
LEFT OUTER JOIN I_UserContactCard AS _CostCenterUserRespVH ON CostCtrResponsibleUser = _CostCenterUserRespVH.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CostCenterUserCreatedVH ON CostCenterCreatedByUser = _CostCenterUserCreatedVH.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CostCenterChangeDocument AS _CostCenterChangeDocument ON ChangeDocObject = _CostCenterChangeDocument.ChangeDocObject AND _CostCenterChangeDocument.ChangeDocumentSAPClient = $session.client AND ControllingAreaForEdit = _CostCenterChangeDocument.ChangeDocumentControllingArea AND CostCenterForEdit = _CostCenterChangeDocument.ChangeDocumentCostCenter AND ValidityEndDateForEdit = _CostCenterChangeDocument.ChangeDocumentValidityEndDate  -- association [0..*]
LEFT OUTER JOIN C_CostCenterLabel AS _CostCenterLabel ON ControllingArea = _CostCenterLabel.ControllingArea AND CostCenter = _CostCenterLabel.CostCenter AND ValidityEndDate = _CostCenterLabel.ValidityEndDate  -- association [1..*]
LEFT OUTER JOIN I_CostCenter AS _BudgetCarryingCostCenter ON ControllingAreaForEdit = _BudgetCarryingCostCenter.ControllingArea AND BudgetCarryingCostCenter = _BudgetCarryingCostCenter.CostCenter AND _BudgetCarryingCostCenter.ValidityStartDate <= $session.system_date AND _BudgetCarryingCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SetHeader AS _SetHeader ON _SetHeader.SetSubClass = ControllingAreaForEdit AND _SetHeader.SetClass = '0101' AND _SetHeader.SetID = CostCenterStandardHierArea  -- association [0..1]
LEFT OUTER JOIN C_CostCtrBdgtAvailyCtrlPrflVH AS _CostCtrBdgtAvailyCtrlPrflVH ON AvailabilityControlProfile = _CostCtrBdgtAvailyCtrlPrflVH.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON Fund = _FundStdVH.Fund AND FinancialManagementArea = _FundStdVH.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_GrantStdVH AS _GrantStdVH ON GrantID = _GrantStdVH.GrantID  -- association [0..1]
LEFT OUTER JOIN I_JointVentureMaster AS _JointVentureMaster ON JointVenture = _JointVentureMaster.JointVenture AND CompanyCode = _JointVentureMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecovery.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster ON JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType AND CompanyCode = _JntVntrEquityTypeMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrCostCtrType AS _JntVntrCostCtrType ON JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType AND CompanyCode = _JntVntrCostCtrType.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClass AS _JntIntrstBillgClass ON JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgClass.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass AS _JntIntrstBillgSubclass ON CompanyCode = _JntIntrstBillgSubclass.CompanyCode AND JointVentureClass = _JntIntrstBillgSubclass.JntIntrstBillgClass AND JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass  -- association [0..1]
;