C_RRBSalesPricingDynamicItem

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_RRBSalesPricingDynamicItem.
-- 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: CRRBSLSPRDYNITEM

CREATE VIEW C_RRBSalesPricingDynamicItem AS
SELECT
  RRBSalesPricingDocument,
  RRBDynamicItem,
  SalesDocument,
  SalesDocumentItem,
  cast( BillingPlan as ps_s4_fplnr preserving type ) AS BillingPlan,
  cast( BillingPlanItem as ps_s4_fpltr preserving type ) AS BillingPlanItem,
  RRBSalesPricingDynamicItem.SourceLedger AS SourceLedger,
  RRBSalesPricingDynamicItem.CompanyCode AS CompanyCode,
  RRBSalesPricingDynamicItem.FiscalYear AS FiscalYear,
  RRBSalesPricingDynamicItem.AccountingDocument AS AccountingDocument,
  RRBSalesPricingDynamicItem.LedgerGLLineItem AS LedgerGLLineItem,
  RRBSalesPricingDynamicItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _TimeSheetOvertimeCatText.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  RRBSalesPricingDynamicItem.BillingControlCategory AS BillingControlCategory,
  ControllingObject,
  WorkItem,
  cast( PostingDate as ps_s4_fis_bldat preserving type ) AS PostingDate,
  BillingPlanBillingDate,
  cast( Personnel as ps_s4_hr_pernr preserving type ) AS Personnel,
  CostCtrActivityType,
  Material,
  RRBSalesPricingDynamicItem.LastChangeDateTime AS LastChangeDateTime,
  TransactionCurrency,
  DocumentCurrency,
  UnitOfMeasure,
  TotalQuantity,
  PostponedQuantity,
  RejectedQuantity,
  BilledQuantity,
  NetAmount,
  TotalAmountInTransactionCrcy,
  AmountToBeBilledInTransacCrcy,
  AmtToBePostponedInTransacCrcy,
  AmtToBeRejectedInTransacCrcy,
  BaseUnitNetAmount,
  cast(BaseUnitActualCost as wtgxxx_cs ) AS BaseUnitActualCost,
  RRBSalesPricingDynamicItem.CustomerProjectWorkPackage AS CustomerProjectWorkPackage,
  RRBSalesPricingDynamicItem.CustProjWorkPackageName AS CustProjWorkPackageName,
  _PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.DefaultEmailAddress AS DefaultEmailAddress,
  _PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.MobilePhoneNumber AS MobilePhoneNumber,
  _PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.PhoneNumber AS PhoneNumber,
  case when _PersonWorkAgreement._PersonWorkAgrmtOrglDetails[1: StartDate <= $session.system_date and EndDate >= $session.system_date].CompanyCode is null then '' else _PersonWorkAgreement._PersonWorkAgrmtOrglDetails[1: StartDate <= $session.system_date and EndDate >= $session.system_date]._CompanyCode.CompanyCodeName end as CompanyCodeName AS CompanyCodeNameendasCompanyCodeName,
  case when _Material._Text[1:Language = $session.system_language].MaterialName is null then '' else _Material._Text[1:Language = $session.system_language].MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  _WorkPackageWorkItem.WorkItemName AS WorkItemName,
  cast( _SalesDocumentItem.SalesDocumentItemText as ps_s4_arktx preserving type ) AS SalesDocumentItemText,
  RRBSalesPricingDynamicItem.ReferenceDocument AS ReferenceDocument,
  RRBSalesPricingDynamicItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  _SalesDocumentItem._SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocumentItem._SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocumentItem._SalesDocument.OrganizationDivision AS OrganizationDivision,
  _SalesDocumentItem._SalesDocument.DistributionChannel AS DistributionChannel
FROM P_RRBSalesPricingDynamicItem AS RRBSalesPricingDynamicItem
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItem ON RRBSalesPricingDynamicItem.WorkItem = _WorkPackageWorkItem.WorkItem AND RRBSalesPricingDynamicItem.CustomerProjectWorkPackage = _WorkPackageWorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_WorkItem AS _WorkItem ON RRBSalesPricingDynamicItem.WorkItem = _WorkItem.WorkItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _JournalEntryItemExtension ON SourceLedger = _JournalEntryItemExtension.SourceLedger AND CompanyCode = _JournalEntryItemExtension.CompanyCode AND FiscalYear = _JournalEntryItemExtension.FiscalYear AND AccountingDocument = _JournalEntryItemExtension.AccountingDocument AND LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillingControlCategoryText ON BillingControlCategory = _BillingControlCategoryText.BillingControlCategory AND _BillingControlCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON Personnel = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory AND _TimeSheetOvertimeCatText.Language = $session.system_language  -- association [0..1]
;