C_DirectActivityAllocation

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_DirectActivityAllocation.
-- 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: CDRCTACTY

CREATE VIEW C_DirectActivityAllocation AS
SELECT
  FiscalYear,
  ReferenceDocument,
  ControllingArea,
  FiscalYearForEdit,
  cast(ReferenceDocumentForEdit as referencedocument) AS ReferenceDocumentForEdit,
  ControllingAreaForEdit,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  cast(_Header.CompanyCode as receivercompanycode) AS CompanyCode,
  CompanyCodeName,
  SenderCompanyCode,
  SourceCompanyCodeName,
  cast(_Header.AccountingDocument as fis_belnr) AS AccountingDocument,
  AccountingDocumentHeaderText,
  DocumentDate,
  PostingDate,
  ExchangeRateDate,
  FiscalPeriod,
  AccountingDocumentCreationDate,
  AccountingDocCreatedByUser,
  _CreatedByContactCard.FullName AS FullName,
  IsReversal,
  IsReversed,
  Status,
  _CostRevnReassgmtDocStatusTxt.StatusName AS StatusName,
  AllocationPostingType,
  _CostRevnReassgmtPostgTypeTxt.AllocationPostingTypeText AS AllocationPostingTypeText,
  ReferenceDocumentType,
  _ReferenceDocumentTypeText.ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  ReferenceDocumentContext,
  ReversalReferenceDocument,
  ReversedReferenceDocument,
  PredecessorReferenceDocument,
  SuccessorReferenceDocument,
  DirectActivityAllocationAction,
  PostingFiscalYear,
  ControllingBusTransacType,
  AccountingDocumentType,
  _AccountingDocumentTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  AccountAssignmentType,
  PartnerAccountAssignmentType,
  CostCtrActivityType,
  OriginCostCenter,
  PartnerCostCenter,
  PartnerWBSElementExternalID,
  PartnerWBSElement,
  PartnerProjectExternalID,
  PartnerProject,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  PartnerProjectNetwork,
  PartnerOrder,
  PartnerProjectNetworkActivity,
  PartnerCostCtrActivityType,
  PartnerCostObject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  WorkItem,
  PersonnelNumber,
  PartnerBusinessProcess,
  Fund,
  FunctionalArea,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerFunctionalArea,
  PartnerGrant,
  PartnerBudgetPeriod,
  GLAccount,
  Plant,
  Material,
  BillableControl,
  JointVentureCostRecoveryCode,
  SenderCostRecoveryCode,
  PartProfitabilitySgmtIsAssgd,
  GlobalCurrency,
  TotalAmountInGlobalCurrency,
  OrderOperation,
  ReceiverRECompanyCode,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  cast('X' as boolean) AS ParallelAccountingIsActive
FROM I_DirectActivityAllocationTP AS _Header
LEFT OUTER JOIN C_DirectActivityAllocationItem AS _Item ON FiscalYear = _Item.FiscalYear AND ReferenceDocument = _Item.ReferenceDocument AND ControllingArea = _Item.ControllingArea  -- association [1..*]
LEFT OUTER JOIN C_DrctActyAllocationActiveItem AS _OriginalItem ON PostingFiscalYear = _OriginalItem.FiscalYearForEdit AND ReversalReferenceDocument = _OriginalItem.ReferenceDocumentForEdit AND ControllingAreaForEdit = _OriginalItem.ControllingAreaForEdit  -- association [1..*]
LEFT OUTER JOIN C_DrctActyAllocJournalEntry AS _JournalEntry ON ControllingAreaForEdit = _JournalEntry.ControllingArea AND ReferenceDocumentForEdit = _JournalEntry.ReferenceDocument AND ReferenceDocumentType = _JournalEntry.ReferenceDocumentType AND ReferenceDocumentContext = _JournalEntry.ReferenceDocumentContext  -- association [1..*]
LEFT OUTER JOIN C_DrctActyAllocCompanyCode AS _DrctActyAllocCompanyCode ON ControllingAreaForEdit = _DrctActyAllocCompanyCode.ControllingArea AND FiscalYearForEdit = _DrctActyAllocCompanyCode.FiscalYear AND ReferenceDocumentForEdit = _DrctActyAllocCompanyCode.ReferenceDocument  -- association [1..*]
LEFT OUTER JOIN C_DrctActyAllocSndrCompanyCode AS _DrctActyAllocSndrCompanyCode ON ControllingAreaForEdit = _DrctActyAllocSndrCompanyCode.ControllingArea AND FiscalYearForEdit = _DrctActyAllocSndrCompanyCode.FiscalYear AND ReferenceDocumentForEdit = _DrctActyAllocSndrCompanyCode.ReferenceDocument  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_DrctActyAllocSuccssrRefItem AS _SuccessorReferenceDocument ON ControllingAreaForEdit = _SuccessorReferenceDocument.ControllingArea AND ReferenceDocumentForEdit = _SuccessorReferenceDocument.PredecessorReferenceDocument  -- association [0..*]
LEFT OUTER JOIN I_CostRevnReassgmtDocStatusTxt AS _CostRevnReassgmtDocStatusTxt ON Status = _CostRevnReassgmtDocStatusTxt.Status AND _CostRevnReassgmtDocStatusTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CostRevnReassgmtPostgTypeTxt AS _CostRevnReassgmtPostgTypeTxt ON AllocationPostingType = _CostRevnReassgmtPostgTypeTxt.AllocationPostingType AND _CostRevnReassgmtPostgTypeTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingAreaForEdit = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType AND _AccountingDocumentTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [1..1]
;