R_CADocBPItemBusLockSnapshotTP

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 R_CADocBPItemBusLockSnapshotTP.
-- 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.
-- Parameters: P_DisplayCurrency : waers_kk

CREATE VIEW R_CADocBPItemBusLockSnapshotTP AS
SELECT
  I_CADocBPItemBusLockSnapshot.CAFioriApplication AS CAFioriApplication,
  I_CADocBPItemBusLockSnapshot.CABusinessLockSnapshotDateTime AS CABusinessLockSnapshotDateTime,
  I_CADocBPItemBusLockSnapshot.CADocumentNumber AS CADocumentNumber,
  I_CADocBPItemBusLockSnapshot.CARepetitionItemNumber AS CARepetitionItemNumber,
  I_CADocBPItemBusLockSnapshot.CABPItemNumber AS CABPItemNumber,
  I_CADocBPItemBusLockSnapshot.CASubItemNumber AS CASubItemNumber,
  dats_days_between(cast(substring (cast(I_CADocBPItemBusLockSnapshot.CABusinessLockSnapshotDateTime as abap.sstring( 20 )), 1, 8) as abap.dats(8)), $session.system_date) as DifferenceInDays AS system_dateasDifferenceInDays,
  I_CADocBPItemBusLockSnapshot.CAApplicationArea AS CAApplicationArea,
  I_CADocBPItemBusLockSnapshot.CABusinessLockObject AS CABusinessLockObject,
  I_CADocBPItemBusLockSnapshot.CABusinessLockObjectLevel AS CABusinessLockObjectLevel,
  I_CADocBPItemBusLockSnapshot.CABusinessProcess AS CABusinessProcess,
  _CABusinessProcess._Text[1: Language=$session.system_language].CABusinessProcessName AS CABusinessProcessName,
  I_CADocBPItemBusLockSnapshot.CABusinessLockValidFromDate AS CABusinessLockValidFromDate,
  I_CADocBPItemBusLockSnapshot.CABusinessLockValidToDate AS CABusinessLockValidToDate,
  I_CADocBPItemBusLockSnapshot.CABusinessLockDuration AS CABusinessLockDuration,
  I_CADocBPItemBusLockSnapshot.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  I_CADocBPItemBusLockSnapshot.ContractAccount AS ContractAccount,
  _CAPartner.ContractAccountName AS ContractAccountName,
  I_CADocBPItemBusLockSnapshot.CAContract AS CAContract,
  I_CADocBPItemBusLockSnapshot.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  I_CADocBPItemBusLockSnapshot.CAProviderContractItemUUID AS CAProviderContractItemUUID,
  I_CADocBPItemBusLockSnapshot.CASubApplication AS CASubApplication,
  _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  I_CADocBPItemBusLockSnapshot.CABusinessLockObjectCategory AS CABusinessLockObjectCategory,
  I_CADocBPItemBusLockSnapshot.ContractAccountCategory AS ContractAccountCategory,
  _ContractAccountCategory._Text[1: Language=$session.system_language].ContractAccountCategoryName AS ContractAccountCategoryName,
  _CABusinessLockObjCategory._Text[1: Language=$session.system_language].CABusinessLockObjectCatName AS CABusinessLockObjectCatName,
  _CABusinessLockObjectLevel._Text[1: Language=$session.system_language].CABusinessLockObjectLevelText AS CABusinessLockObjectLevelText,
  I_CADocBPItemBusLockSnapshot.CreationDate AS CreationDate,
  I_CADocBPItemBusLockSnapshot.CABusLockNumberOfExtensions AS CABusLockNumberOfExtensions,
  I_CADocBPItemBusLockSnapshot.CompanyCode AS CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  I_CADocBPItemBusLockSnapshot.BusinessArea AS BusinessArea,
  I_CADocBPItemBusLockSnapshot.Segment AS Segment,
  I_CADocBPItemBusLockSnapshot.Division AS Division,
  I_CADocBPItemBusLockSnapshot.CAMainTransaction AS CAMainTransaction,
  _CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  I_CADocBPItemBusLockSnapshot.CASubTransaction AS CASubTransaction,
  _SubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  I_CADocBPItemBusLockSnapshot.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  I_CADocBPItemBusLockSnapshot.TransactionCurrency AS TransactionCurrency,
  I_CADocBPItemBusLockSnapshot.CABusLockValidFromDateYearMnth AS CABusLockValidFromDateYearMnth,
  I_CADocBPItemBusLockSnapshot.CABusLockValidFromDateYear AS CABusLockValidFromDateYear,
  I_CADocBPItemBusLockSnapshot.CABusLockValidFromDateYearWeek AS CABusLockValidFromDateYearWeek,
  I_CADocBPItemBusLockSnapshot.CABusLockValidFromDateYearQtr AS CABusLockValidFromDateYearQtr,
  cast(right(I_CADocBPItemBusLockSnapshot.CABusLockValidFromDateYearMnth,2) as calendarmonth) AS CABusLockValidFromDateMonth,
  I_CADocBPItemBusLockSnapshot.CABusLockValidToDateYearMonth AS CABusLockValidToDateYearMonth,
  I_CADocBPItemBusLockSnapshot.CABusLockValidToDateYear AS CABusLockValidToDateYear,
  I_CADocBPItemBusLockSnapshot.CABusLockValidToDateYearWeek AS CABusLockValidToDateYearWeek,
  I_CADocBPItemBusLockSnapshot.CABusLockValidToDateYearQtr AS CABusLockValidToDateYearQtr,
  cast(right(I_CADocBPItemBusLockSnapshot.CABusLockValidToDateYearMonth,2) as calendarmonth) AS CABusLockValidToDateMonth,
  I_CADocBPItemBusLockSnapshot.LastChangeDateYearMonth AS LastChangeDateYearMonth,
  I_CADocBPItemBusLockSnapshot.LastChangeDateYear AS LastChangeDateYear,
  I_CADocBPItemBusLockSnapshot.LastChangeDateYearWeek AS LastChangeDateYearWeek,
  I_CADocBPItemBusLockSnapshot.LastChangeDateYearQuarter AS LastChangeDateYearQuarter,
  I_CADocBPItemBusLockSnapshot.CABusinessLockDurationInWeeks AS CABusinessLockDurationInWeeks,
  I_CADocBPItemBusLockSnapshot.CABusinessLockDurationInMonths AS CABusinessLockDurationInMonths,
  I_CADocBPItemBusLockSnapshot.CABusinessLockDurationInQtrs AS CABusinessLockDurationInQtrs,
  I_CADocBPItemBusLockSnapshot.CABusinessLockDurationInYears AS CABusinessLockDurationInYears,
  cast(right(I_CADocBPItemBusLockSnapshot.LastChangeDateYearMonth,2) as calendarmonth) AS LastChangeDateMonth,
  I_CADocBPItemBusLockSnapshot.CAProviderContractAuthznGroup AS CAProviderContractAuthznGroup,
  cast(1 as abap.int4) AS NumberOfCABusLockSnpshtBPItems,
  _TotalAmounts.BPBalanceAmountInDC AS BPBalanceAmountInDC,
  _TotalAmounts.BPCreditAmountInDC AS BPCreditAmountInDC,
  _TotalAmounts.BPDebitAmountInDC AS BPDebitAmountInDC
FROM I_CADocBPItemBusLockSnapshot
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CABusinessLockObjCategory AS _CABusinessLockObjCategory ON CABusinessLockObjectCategory = _CABusinessLockObjCategory.CABusinessLockObjectCategory  -- association [1..1]
LEFT OUTER JOIN I_CABusinessLockObjectLevel AS _CABusinessLockObjectLevel ON CABusinessLockObjectLevel = _CABusinessLockObjectLevel.CABusinessLockObjectLevel  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountCategory AS _ContractAccountCategory ON ContractAccountCategory = _ContractAccountCategory.ContractAccountCategory AND CAApplicationArea = _ContractAccountCategory.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CABusinessProcess AS _CABusinessProcess ON CABusinessProcess = _CABusinessProcess.CABusinessProcess  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [1..1]
LEFT OUTER JOIN I_CAMainTransaction AS _CAMainTransaction ON CAMainTransaction = _CAMainTransaction.CAMainTransaction AND CAApplicationArea = _CAMainTransaction.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CASubTransaction AS _SubTransaction ON CAMainTransaction = _SubTransaction.CAMainTransaction AND CASubTransaction = _SubTransaction.CASubTransaction AND CAApplicationArea = _SubTransaction.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CABusPartLastWorklistItem AS _LastWorklistItem ON BusinessPartner = _LastWorklistItem.BusinessPartner AND CAFioriApplication = _LastWorklistItem.CAFioriApplication AND CADocumentBPItemPyblRblCode = _LastWorklistItem.CADocumentBPItemPyblRblCode  -- association [0..1]
LEFT OUTER JOIN I_CAPayableReceivableCode AS _PayableReceivable ON CADocumentBPItemPyblRblCode = _PayableReceivable.CADocumentBPItemPyblRblCode  -- association [0..1]
LEFT OUTER JOIN I_CACalendarMonth AS _ValidFromMonth ON CABusLockValidFromDateMonth = _ValidFromMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CACalendarMonth AS _ValidToMonth ON CABusLockValidToDateMonth = _ValidToMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CACalendarMonth AS _LastChangeMonth ON LastChangeDateMonth = _LastChangeMonth.CalendarMonth  -- association [0..1]
;