I_CABillgPlnItem

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_CABillgPlnItem.
-- 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_CABillgPlnItem AS
SELECT
  billplanno AS CABillgPlnNumber,
  billplanitem AS CABillgPlnItem,
  bipitemcat AS CABillgPlnItmCat,
  bipitemtype AS CABillgPlnItmType,
  bipitemtext AS CABillgPlnItmTxt,
  bipitemref AS CABillgPlnItemExtRef,
  betrw AS CABillgPlnItemAmount,
  waers AS TransactionCurrency,
  tax_included AS CATaxIsIncluded,
  bip_quantity AS CABillgPlnItemQuantity,
  bip_qty_unit AS CABillgPlnItemQuantityUnit,
  valid_from AS CABillgPlnItemStartDate,
  valid_to AS CABillgPlnItmEndDate,
  term_from AS CABillgPlnItemTermStartDate,
  term_to AS CABillgPlnItemTermEndDate,
  recurring AS CABillgPlnItemRecurring,
  cycle AS CABillgCycle,
  kschl AS CAConditionType,
  cast(amount_det_type as bip_amount_det_type_gfn_kk preserving type ) AS CABillgPlnItemAmountDetnType,
  cast(amount_date_type as bip_amount_date_type_gfn_kk preserving type ) AS CABillgPlnItemAmountDateType,
  price_date_type AS CABillgPlnItemPriceDateType,
  vtpos AS CAProviderContractItemNumber,
  subap AS CASubApplication,
  vtpid AS CAProviderContractItemUUID,
  spart AS Division,
  bukrs AS CompanyCode,
  gsber AS BusinessArea,
  Segment,
  service_type AS CABillgPlnItemServiceType,
  cast(dittype as dittype_gfn_kk preserving type ) AS CADependentItemType,
  matnr AS Material,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  kofiz AS CAAccountDeterminationCode,
  offset_action AS CAInvcgOffsettingAction,
  offset_cat AS CAInvcgOffsettingCategory,
  offset_proc AS CAInvcgOffsettingProcedure,
  offset_refid AS CAInvcgOffsettingReferenceKey,
  requestdate_last AS CABillgPlnItemReqDteLast,
  requestdate_next AS CABillgPlnItemReqDteNext,
  requestdate_next_dev AS CABillgPlnDvtgNextRequestDate,
  requested_to AS CABillgPlnItemRequestedToDte,
  cancelled AS CABillgPlnItemCanceled,
  subitem_exists AS CABillgPlnSubItmExist,
  main_bipitem AS CABillgPlnItemMain,
  item_excreason AS CABillgPlnItmExcptnReason,
  child_exists AS CABillgPlnItemChildExist,
  parent_bipitem AS CABillgPlnItemParent,
  status AS CABillgPlnItemStatus,
  bit_number AS CABillgPlnItemNrOfBllbleItm,
  raoirel AS CAIsRevnAcctgTransfRecordRlvt,
  condition_type AS ConditionType,
  condition_statistic AS ConditionIsForStatistics,
  faedn AS CANetDueDate,
  cast(co_type as co_type_gfn_kk preserving type) AS CABllbleItmCostType,
  cast(co_subtype as co_subtype_gfn_kk preserving type) AS CABllbleItmCostSubType,
  ico_bukrs_req AS CAIntcoCompanyCodeRequesting,
  ico_bukrs_sup AS CAIntcoCompanyCodeSupplying,
  cast(ico_type as ico_type_gfn_kk preserving type) AS CAIntcoType,
  cast(ico_subtype as ico_subtype_gfn_kk preserving type) AS CAIntcoSubtype
FROM dfkkbix_bip_i
LEFT OUTER JOIN I_CABillgPln AS _CABillgPln ON CABillgPlnNumber = _CABillgPln.CABillgPlnNumber  -- association [1..1]
LEFT OUTER JOIN I_CABillgPlnItmType AS _CABillgPlnItmType ON CABillgPlnItmType = _CABillgPlnItmType.CABillgPlnItmType  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnItmCat AS _CABillgPlnItmCat ON CABillgPlnItmCat = _CABillgPlnItmCat.CABillgPlnItmCat  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CABillgCycle AS _CABillgCycle ON CABillgCycle = _CABillgCycle.CABillgCycle  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnItmStatus AS _CABillgPlnItmStatus ON CABillgPlnItemStatus = _CABillgPlnItmStatus.CABillgPlnItemStatus  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnItmExcptnReason AS _ExcptnRsn ON CABillgPlnItmExcptnReason = _ExcptnRsn.CABillgPlnItmExcptnReason  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnItmAmtDetnType AS _CABillgPlnItmAmtDetnType ON CABillgPlnItemAmountDetnType = _CABillgPlnItmAmtDetnType.CABillgPlnItemAmountDetnType  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnItmAmtDateType AS _CABillgPlnItmAmtDateType ON CABillgPlnItemAmountDateType = _CABillgPlnItmAmtDateType.CABillgPlnItemAmountDateType  -- association [0..1]
LEFT OUTER JOIN I_CABillgPlnItmPrcDateType AS _CABillgPlnItmPrcDateType ON CABillgPlnItemPriceDateType = _CABillgPlnItmPrcDateType.CABillgPlnItemPriceDateType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CABillgPlnItemQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _SubApplication ON CASubApplication = _SubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractItem AS _CAProviderContractItem ON CAContract = _CAProviderContractItem.CAProviderContract AND CAProviderContractItemNumber = _CAProviderContractItem.CAProviderContractItemNumber  -- association [0..1]
LEFT OUTER JOIN I_ConditionType AS _ConditionType ON CAConditionType = _ConditionType.ConditionType AND _ConditionType.ConditionUsage = 'A' AND _ConditionType.ConditionApplication = 'V'  -- association [0..1]
LEFT OUTER JOIN I_ConditionType AS _CondType ON ConditionType = _CondType.ConditionType AND _CondType.ConditionUsage = 'A' AND _CondType.ConditionApplication = 'V'  -- association [0..1]
LEFT OUTER JOIN I_CARevnAcctgServiceType AS _CARevnAcctgServiceType ON CABillgPlnItemServiceType = _CARevnAcctgServiceType.CARevenueAccountingServiceType  -- association [0..1]
LEFT OUTER JOIN I_CADependentItemType AS _CADependentItemType ON CADependentItemType = _CADependentItemType.CADependentItemType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CAAccountDetnCode AS _CAAccountDetnCode ON CAAccountDeterminationCode = _CAAccountDetnCode.CAAccountDeterminationCode  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgOffsettingAction AS _CAInvcgOffsettingAction ON CAInvcgOffsettingAction = _CAInvcgOffsettingAction.CAInvcgOffsettingAction  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgOffsettingCategory AS _CAInvcgOffsettingCategory ON CAInvcgOffsettingCategory = _CAInvcgOffsettingCategory.CAInvcgOffsettingCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgOffsettingProcedure AS _CAInvcgOffsettingProcedure ON CAInvcgOffsettingProcedure = _CAInvcgOffsettingProcedure.CAInvcgOffsettingProcedure  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmCostType AS _CABllbleItmCostType ON CABllbleItmCostType = _CABllbleItmCostType.CABllbleItmCostType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmCostSubtype AS _CABllbleItmCostSubtype ON CABllbleItmCostType = _CABllbleItmCostSubtype.CABllbleItmCostType AND CABllbleItmCostSubType = _CABllbleItmCostSubtype.CABllbleItmCostSubType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CAIntcoCompanyCodeRequesting ON CAIntcoCompanyCodeRequesting = _CAIntcoCompanyCodeRequesting.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CAIntcoCompanyCodeSupplying ON CAIntcoCompanyCodeSupplying = _CAIntcoCompanyCodeSupplying.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CAIntcoType AS _CAIntcoType ON CAIntcoType = _CAIntcoType.CAIntcoType  -- association [0..1]
LEFT OUTER JOIN I_CAIntcoSubtype AS _CAIntcoSubtype ON CAIntcoType = _CAIntcoSubtype.CAIntcoType AND CAIntcoSubtype = _CAIntcoSubtype.CAIntcoSubtype  -- association [0..1]
LEFT OUTER JOIN E_CABillgPlnItem AS _Extension ON CABillgPlnNumber = _Extension.CABillgPlnNumber AND CABillgPlnItem = _Extension.CABillgPlnItem  -- association [1..1]
;