I_CABillgPln

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 I_CABillgPln.
-- 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 I_CABillgPln AS
SELECT
  billplanno AS CABillgPlnNumber,
  cast(bipcat as bipcat_gfn_kk preserving type ) AS CABillgPlnCategory,
  biptype AS CABillgPlnType,
  status AS CABillgPlnStatus,
  valid_from AS CABillgPlnStartDate,
  valid_to AS CABillgPlnEndDate,
  requestdate_last AS CABillgPlnLastRequestDate,
  requestdate_next AS CABillgPlnNextRequestDate,
  biptext AS CABillgPlnDescription,
  bipref AS CABillgPlnExternalReference,
  logsys AS LogicalSystem,
  applk AS CAApplicationArea,
  cast(gpart as bu_partner preserving type ) AS BusinessPartner,
  vkont AS ContractAccount,
  mdcat AS CAInvcgMasterDataType,
  vtref AS CAContract,
  vtpid AS CAProviderContractItemUUID,
  subap AS CASubApplication,
  offset_refid AS CAInvcgOffsettingReferenceKey,
  crname AS CABillgPlnCreatedByUser,
  crdate AS CABillgPlnCreationDate,
  crtime AS CABillgPlnCreationTime,
  chname AS CABillgPlnChangedByUser,
  chdate AS CABillgPlnChangeDate,
  chtime AS CABillgPlnChangeTime,
  crmode AS CABillgPlnCreationMode,
  bit_number AS CABillgPlnNumberBllbleItm,
  completion_date AS CABillgPlnCompletionDate,
  xtemp AS CABillgPlnIsTemplate,
  version AS CABillgPlnVersion
FROM dfkkbix_bip_h
LEFT OUTER JOIN I_CABillgPlnCategory AS _CABillgPlnCategory ON CABillgPlnCategory = _CABillgPlnCategory.CABillgPlnCategory  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnType AS _CABillgPlnType ON CABillgPlnType = _CABillgPlnType.CABillgPlnType  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnStatus AS _CABillgPlnStatus ON CABillgPlnStatus = _CABillgPlnStatus.CABillgPlnStatus  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnCreationMode AS _CABillgPlnCreationMode ON CABillgPlnCreationMode = _CABillgPlnCreationMode.CABillgPlnCreationMode  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgMasterDataType AS _CAInvcgMasterDataType ON CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAMasterAgreement AS _CAMasterAgreement ON CAMasterAgreement = _CAMasterAgreement.CAMasterAgreement  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_CABillgPln AS _Extension ON CABillgPlnNumber = _Extension.CABillgPlnNumber  -- association [1..1]
;