I_CABillgPlnBllbleItm

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_CABillgPlnBllbleItm.
-- 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_CABillgPlnBllbleItm AS
SELECT
  billplanno AS CABillgPlnNumber,
  billplanitem AS CABillgPlnItem,
  bituuid AS CABllbleItmUUID,
  bitcat AS CABllbleItmClass,
  subprocess AS CABillgSubprocess,
  cast(srctatype as srctatype_gfn_kk preserving type ) AS CABllbleItmSourceTransType,
  cast(srctaid as srctaid_gfn_kk preserving type ) AS CABllbleItmSourceTransId,
  cast(bitpackuuid as bitpackuuid_gfn_kk preserving type ) AS CABllbleItmPackageUUID,
  cast(bitpackcno as bitpackcno_gfn_kk preserving type ) AS CABllbleItmPackNo,
  simulated AS CABllbleItmSimlnSts,
  bitdate AS CABllbleItmDate,
  bittime AS CABllbleItmTime,
  bitdate_from AS CABllbleItmStartDate,
  bitdate_to AS CABllbleItmEndDate,
  bitcrdate AS CABllbleItmCreationDate,
  bitcrtime AS CABllbleItmCreationTime,
  bill_basedate AS CABillgBaseDate,
  bill_first AS CABillgFirstDate,
  bittype AS CABllbleItmType,
  subap AS CASubApplication,
  vtpos AS CAProviderContractItemNumber,
  bit_amount AS CABllbleItmAmount,
  bit_curr AS CABllbleItmCurrency,
  bit_quantity AS CABllbleItmQty,
  bit_qty_unit AS CABllbleItmQtyUnit,
  rarel AS CAIsRevenueAccountingRelevant,
  bitreversed AS CABllbleItmIsReversed,
  requestdate AS CABillgPlnRequestDate,
  requestdate_old AS CABillgPlnLastRequestDate,
  requestdate_next_dev AS CABillgPlnDvtgNextRequestDate,
  log_number AS CABllbleItmHandle,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  vtref AS CAContract
FROM dfkkbixbit_bip
LEFT OUTER JOIN I_CABillgPln AS _CABillgPln ON CABillgPlnNumber = _CABillgPln.CABillgPlnNumber  -- association [1..1]
LEFT OUTER JOIN I_CABillgPlnItem AS _CABillgPlnItem ON CABillgPlnNumber = _CABillgPlnItem.CABillgPlnNumber AND CABillgPlnItem = _CABillgPlnItem.CABillgPlnItem  -- association [1..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_Currency AS _CABllbleItmCurrency ON CABllbleItmCurrency = _CABllbleItmCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CABllbleItmQtyUnit ON CABllbleItmQtyUnit = _CABllbleItmQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmClass AS _CABllbleItmClass ON CABllbleItmClass = _CABllbleItmClass.CABllbleItmClass  -- association [0..1]
LEFT OUTER JOIN I_CABillgSubProcess AS _CABillgSubprocess ON CABillgSubprocess = _CABillgSubprocess.CABillgSubprocess  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmSrceTransType AS _CABllbleItmSrceTransType ON CABllbleItmSourceTransType = _CABllbleItmSrceTransType.CABllbleItmSourceTransType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmSimlnSts AS _CABllbleItmSimlnSts ON CABllbleItmSimlnSts = _CABllbleItmSimlnSts.CABllbleItmSimlnSts  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmType AS _CABllbleItmType ON CABllbleItmType = _CABllbleItmType.CABllbleItmType  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
;