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,
  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,
  IsReversal,
  IsReversed,
  Status,
  AllocationPostingType,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReversalReferenceDocument,
  ReversedReferenceDocument,
  PredecessorReferenceDocument,
  SuccessorReferenceDocument,
  DirectActivityAllocationAction,
  PostingFiscalYear,
  ControllingBusTransacType,
  AccountingDocumentType,
  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,
  _AccountingDocumentTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CostRevnReassgmtDocStatusTxt.StatusName AS StatusName,
  _CostRevnReassgmtPostgTypeTxt.AllocationPostingTypeText AS AllocationPostingTypeText,
  _CreatedByContactCard.FullName AS FullName,
  _ReferenceDocumentTypeText.ReferenceDocumentTypeName AS ReferenceDocumentTypeName
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]
;