I_CABillgDocItem

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_CABillgDocItem.
-- 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_CABillgDocItem AS
SELECT
  billdocno AS CABillgDocument,
  billdocitem AS CABillgDocItem,
  item_simulated AS CAIsDocItemSimulated,
  itemtype AS CABillgDocumentItemType,
  vtref AS CAContract,
  bukrs AS CompanyCode,
  postrel AS CAInvcgIsItemPostingRelevant,
  printrel AS CAInvcgIsItemPrintingRelevant,
  bill_amount AS CABillgDocItemAmount,
  bill_curr AS CABillgCurrency,
  tax_included AS CATaxIsIncluded,
  qty_unit AS UnitOfMeasure,
  refitem AS CABillgDocItemExternalNumber,
  reversalitem AS CABillgDocItemIsReversal,
  reversalitem AS CAInvcgDocItemIsReversal,
  cast(corrcat as corrcat_gfn_kk preserving type ) AS CAInvcgCorrectionCategory,
  not_bprel AS CAInvcgIsNotBPRelevant,
  print_substitute AS CAInvcgSubstituteGroupPrinting,
  date_from AS CAItemPeriodStartDate,
  date_to AS CAItemPeriodEndDate,
  faedn AS CANetDueDate,
  spart AS Division,
  gsber AS BusinessArea,
  cast(bupla as farp_bupla preserving type) AS BusinessPlace,
  segmt AS Segment,
  prctr AS ProfitCenter,
  kofiz AS CAAccountDeterminationCode,
  tax_det_type AS CATaxDetnType,
  tax_country AS CATaxCountry,
  tax_date_type AS CATaxDateType,
  tax_group AS CABillgTaxGroup,
  ext_tax_date AS CAExternalTaxDate,
  ermwskz AS CATaxDeterminationCode,
  cast(ermwskz_b2b as ermwskz_b2b_gfn_kk preserving type ) AS CAAltvTaxDeterminationCode,
  xanza AS CAIsDownPaymentRequest,
  cast(defrev_cat as defrev_cat_gfn_kk preserving type ) AS CABillgDeferredRevenueCategory,
  defrev_pdate AS CABillgDeferredRevenueDate,
  cast(defrev_stat as defrev_stat_gfn_kk preserving type ) AS CAInvcgDfrrdRevenueStatus,
  rarel AS CAIsRevenueAccountingRelevant,
  service_type AS CARevenueAccountingServiceType,
  cast(billac_type as billac_type_gfn_kk preserving type ) AS CAInvcgAccrualPostingType,
  qty_bw_rel AS CABillgDocItemIsBIRelevant,
  qty_fi_co_rel AS CABillgDocItemIsFICORelevant,
  vtpos AS CAProviderContractItemNumber,
  subap AS CASubApplication,
  prepaid AS CAIsPrepaid,
  pprefill AS CABillgIsPrepaidBalanceChg,
  item_crmet AS CABillgDocItemCrtnMethod,
  bill_function AS CABillgFunction,
  cast(add_group as add_group_gfn_kk preserving type ) AS CABillgGrpgOfAdditionalItems,
  py_group AS CABillgGrpgOfPaymentData,
  src_group AS CABillgGroupingSourceItems,
  cast(bit_number as bit_number_gfn_kk preserving type ) AS CABllbleItmNumber,
  disc_group AS CADiscBaseItmGroup,
  sec_reason AS CAReasonSecurityDeposit,
  cast(billreqrsn as billreqrsn_gfn_kk preserving type ) AS CABillgReqReason,
  cast(disckey as disckey_gfn_kk preserving type ) AS CABllbleItmDiscountKey,
  disckey_versno AS CABllbleItmDiscountVersion,
  quantity_pdp AS CABillgQuantityBeforeDecPoint,
  quantity_adp AS CABillgQuantityAfterDecPoint,
  cast(dittype as dittype_gfn_kk preserving type ) AS CADependentItemType,
  condition_type AS ConditionType,
  altmd_orig AS CAAltvMDOriginalIsEnbld
FROM dfkkinvbill_i AS invbill_i
LEFT OUTER JOIN I_CABillgDocumentItemType AS _CABillgDocumentItemType ON CABillgDocumentItemType = _CABillgDocumentItemType.CABillgDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_CARevnAcctgServiceType AS _CARevnAcctgServiceType ON CARevenueAccountingServiceType = _CARevnAcctgServiceType.CARevenueAccountingServiceType  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgAccrualPostingType AS _CAInvcgAccrualPostingType ON CAInvcgAccrualPostingType = _CAInvcgAccrualPostingType.CAInvcgAccrualPostingType  -- association [0..1]
LEFT OUTER JOIN I_CABillgFunction AS _CABillgFunction ON CABillgFunction = _CABillgFunction.CABillgFunction  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmDiscountKey AS _CABllbleItmDiscountKey ON CABllbleItmDiscountKey = _CABllbleItmDiscountKey.CABllbleItmDiscountKey  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CABillgReqReason AS _CABillgReqReason ON CABillgReqReason = _CABillgReqReason.CABillgReqReason  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- 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_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CAAccountDetnCode AS _CAAccountDetnCode ON CAAccountDeterminationCode = _CAAccountDetnCode.CAAccountDeterminationCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CABillgCurrency ON CABillgCurrency = _CABillgCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CATaxCountry ON CATaxCountry = _CATaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCorrectionCat AS _CAInvcgCorrectionCat ON CAInvcgCorrectionCategory = _CAInvcgCorrectionCat.CAInvcgCorrectionCategory  -- association [0..1]
LEFT OUTER JOIN I_CATaxDetnType AS _CATaxDetnType ON CATaxDetnType = _CATaxDetnType.CATaxDetnType  -- association [0..1]
LEFT OUTER JOIN I_CATaxDateType AS _CATaxDateType ON CATaxDateType = _CATaxDateType.CATaxDateType  -- association [0..1]
LEFT OUTER JOIN I_CAStatisticalItemCode AS _CAStatisticalItemCode ON CAStatisticalItemCode = _CAStatisticalItemCode.CAStatisticalItemCode  -- association [0..1]
LEFT OUTER JOIN I_CABillgDeferredRevnCat AS _CABillgDeferredRevnCat ON CABillgDeferredRevenueCategory = _CABillgDeferredRevnCat.CABillgDeferredRevenueCategory  -- association [0..1]
LEFT OUTER JOIN I_CADeferredRevenueStatus AS _CADeferredRevenueStatus ON CAInvcgDfrrdRevenueStatus = _CADeferredRevenueStatus.CAInvcgDfrrdRevenueStatus  -- association [0..1]
LEFT OUTER JOIN I_CAIsRevnAcctgRelevant AS _CAIsRevnAcctgRelevant ON CAIsRevenueAccountingRelevant = _CAIsRevnAcctgRelevant.CAIsRevenueAccountingRelevant  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocItemCrtnMethod AS _CABillgDocItemCrtnMethod ON CABillgDocItemCrtnMethod = _CABillgDocItemCrtnMethod.CABillgDocItemCrtnMethod  -- association [0..1]
LEFT OUTER JOIN I_CADependentItemType AS _CADependentItemType ON CADependentItemType = _CADependentItemType.CADependentItemType  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgDocHeader ON CABillgDocument = _CABillgDocHeader.CABillgDocument  -- association [1..1]
LEFT OUTER JOIN E_CABillgDocItem AS _Extension ON CABillgDocument = _Extension.CABillgDocument AND CABillgDocItem = _Extension.CABillgDocItem  -- association [0..1]
;