C_CADocumentBPItemTransfer

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_CADocumentBPItemTransfer.
-- 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.

CREATE VIEW C_CADocumentBPItemTransfer AS
SELECT
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  case when CAAmountInTransactionCurrency < 0 then cast('05' as abap.char(10)) else cast('' as abap.char(10)) end as CAOpenItemStatus AS char10endasCAOpenItemStatus,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CAHeader.ContractAccountName AS ContractAccountName,
  cast ('' as abap.char(100)) AS CABPItemText,
  BusinessPartner,
  ContractAccount,
  CAContract,
  _ProviderContract.CAProviderContractName AS CAProviderContractName,
  CASubApplication,
  cast('' as subap_kk) AS CASubApplicationPrimary,
  cast('' as abap.char(50)) AS CASubApplicationText,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  _CAContractType.CAContractType AS CAContractType,
  _CAContractType._Text[1:Language=$session.system_language].CAContractTypeText AS CAContractTypeText,
  CANetDueDate,
  CAAmountInTransactionCurrency,
  TransactionCurrency,
  cast('' as abap.char(100)) AS CAPaymentLockReason,
  cast('' as abap.char(50)) AS CAPaymentLockReasonName,
  cast('' as abap.char(100)) AS CADunningLockReason,
  cast('' as abap.char(50)) AS CADunningLockReasonName,
  case when CAStatisticalItemCode = 'R' then cast('CAInstallmentPlan' as abap.char(30)) else cast('CADocument' as abap.char(30)) end as SemanticObject AS char30endasSemanticObject,
  cast('X' as abap.char(1)) AS CADocumentBPItemIsTransferable,
  cast('' as gpart_kk ) AS CASrceDocBusinessPartner,
  cast('' as vkont_kk ) AS CASrceDocContractAccount,
  cast('' as vtref_kk ) AS SourceDocumentCAContract,
  cast('' as umgrd_kk) AS CATransferReason,
  _DocType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  CADocumentType,
  cast('' as fikey_kk) AS CAReconciliationKey,
  cast($session.system_date as budat_kk) AS CAPostingDate,
  cast('' as is_cloud_system ) AS IsCloudSystem,
  BusinessArea,
  CompanyCode,
  CAApplicationArea,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_CADocumentBPItemPhysical
LEFT OUTER JOIN I_CAContractType AS _CAContractType ON CASubApplication = _CAContractType.CASubApplication  -- association [0..1]
;