C_ActyTypeRcvgCostCtrItm

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_ActyTypeRcvgCostCtrItm.
-- 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: CWUATRCCI

CREATE VIEW C_ActyTypeRcvgCostCtrItm AS
SELECT
  cast ('3RCCI' as actytypewhereusedobjecttypevh) AS ActyTypeWhereUsedObjType,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  CostCtrActivityType,
  cast(_CostCtrActivityType._Text[ Language = $session.system_language ].CostCtrActivityTypeName as actytypename preserving type ) AS CostCtrActivityTypeName,
  cast(_CostCtrActivityType._Text[ Language = $session.system_language ].CostCtrActivityTypeDesc as actytypedesc preserving type ) AS CostCtrActivityTypeDesc,
  cast(_CostCenter.ValidityStartDate as costcentervaliditystartdate preserving type ) AS CostCenterValidityStartDate,
  cast(_CostCenter.ValidityEndDate as costcentervalidityenddate preserving type ) AS CostCenterValidityEndDate,
  PartnerCostCenter AS CostCenter,
  CostCenter AS SenderCostCenter,
  _CostCenter._Text[ Language = $session.system_language ].CostCenterName AS CostCenterName,
  PostingDate,
  Quantity,
  cast (BaseUnit as unitofmsmt) AS BaseUnit,
  _BaseUnit._Text[ Language = $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
  cast(AmountInTransactionCurrency as amtintranscrcy preserving type ) AS AmountInTransactionCurrency,
  cast(TransactionCurrency as fis_rwcur preserving type ) AS TransactionCurrency,
  cast(AmountInCompanyCodeCurrency as amtincccrcy preserving type ) AS AmountInCompanyCodeCurrency,
  cast(CompanyCodeCurrency as cccrcy preserving type ) AS CompanyCodeCurrency,
  ControllingArea,
  cast(AmountInGlobalCurrency as amtingcrcy preserving type ) AS AmountInGlobalCurrency,
  cast(GlobalCurrency as fis_rkcur preserving type ) AS GlobalCurrency,
  cast(AmountInBalanceTransacCrcy as amtinbltcrcy preserving type ) AS AmountInBalanceTransacCrcy,
  cast(BalanceTransactionCurrency as bltcrcy preserving type ) AS BalanceTransactionCurrency,
  FiscalPeriod,
  AccountingDocumentItem,
  cast(ReferenceDocumentType as referencedocumenttype preserving type ) AS ReferenceDocumentType,
  cast(ReferenceDocument as referencedocument preserving type ) AS ReferenceDocument,
  _Ledger.IsLeadingLedger AS IsLeadingLedger,
  cast (0 as actytypewhereusedobjcount) AS NumberOfUniqueObjects,
  cast (0 as actytypewhereusedobjmatch) AS NumberOfMatches,
  PostingDate AS ValidityStartDate,
  PostingDate AS ValidityEndDate,
  cast( _CostCtrActivityType.ValidityStartDate as activitytypevaliditystartdate preserving type ) AS CostCtrActyTypeValdtyStartDate,
  cast( _CostCtrActivityType.ValidityEndDate as activitytypevalidityenddate preserving type ) AS CostCtrActyTypeValdtyEndDate,
  I_JournalEntryItem.SalesDocument AS SalesDocument,
  I_JournalEntryItem.FixedAsset AS FixedAsset,
  I_JournalEntryItem.MasterFixedAsset AS MasterFixedAsset,
  I_JournalEntryItem.Customer AS Customer,
  I_JournalEntryItem.Supplier AS Supplier,
  I_JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  I_JournalEntryItem.GLAccount AS GLAccount,
  I_JournalEntryItem.OrderID AS OrderID,
  I_JournalEntryItem.ProfitCenter AS ProfitCenter,
  I_JournalEntryItem.ValuationArea AS ValuationArea,
  I_JournalEntryItem.Plant AS Plant,
  I_JournalEntryItem.SalesOrganization AS SalesOrganization,
  I_JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  I_JournalEntryItem.BusinessArea AS BusinessArea,
  I_JournalEntryItem.Segment AS Segment,
  I_JournalEntryItem.DistributionChannel AS DistributionChannel,
  I_JournalEntryItem.OrganizationDivision AS OrganizationDivision,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType
FROM I_JournalEntryItem
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType AND PostingDate >= _CostCtrActivityType.ValidityStartDate AND PostingDate <= _CostCtrActivityType.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter AND PostingDate >= _CostCenter.ValidityStartDate AND PostingDate <= _CostCenter.ValidityEndDate  -- association [0..1]
;