C_CABusinessPartnerLineItem

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_CABusinessPartnerLineItem.
-- 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.
-- SQL view name: CCABUSPARLITEM

CREATE VIEW C_CABusinessPartnerLineItem AS
SELECT
  CADocumentNumber AS CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  BusinessPartner,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  cast(_BusinessPartner.BusinessPartnerFullName as gpart_text_gfn_kk preserving type ) AS BusinessPartnerFullName,
  ContractAccount,
  cast(_ContractAccount.ContractAccountName as vkbez_text_gfn_kk preserving type ) AS ContractAccountName,
  CAPostingDate,
  CAClearingStatus,
  cast('' as augst_text_gfn_kk) AS CAClearingStatusName,
  CAClearingReason,
  cast(_CAClearingReason._Text[1: Language=$session.system_language].CAClearingReasonName as augrd_text_gfn_kk ) AS CAClearingReasonName,
  CAClearingDate,
  CAClearingDocumentNumber,
  CANetDueDate,
  CAAmountInTransactionCurrency,
  CAMainTransaction,
  _CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  CASubTransaction,
  _CASubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  CADeferralDate,
  CompanyCode,
  cast( _CompanyCode.CompanyCodeName as bukrs_text_gfn_kk preserving type ) AS CompanyCodeName,
  BusinessArea,
  _BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  Segment,
  cast(_Segment._Text[1: Language=$session.system_language].SegmentName as segmt_text_kk preserving type ) AS SegmentName,
  PartnerCompany,
  cast(_PartnerCompany.CompanyName as rassc_text_kk preserving type ) AS PartnerCompanyName,
  CAContract,
  cast(_CAProviderContract.CAProviderContractName as vtref_text_gfn_kk preserving type) AS CAProviderContractName,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  CAProviderContractItemNumber,
  CASubApplication,
  _CASubApplication._CASubApplicationText[1:Language = $session.system_language].CASubApplicationText AS CASubApplicationText,
  CAReconciliationAccount,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode,
  cast(PlannedAmtInTransactionCrcy as fdwbt) AS PlannedAmtInTransactionCrcy,
  ProfitCenter,
  cast(_ProfitCenter._Text[1: Language=$session.system_language].ProfitCenterName as prctr_text_gfn_kk preserving type ) AS ProfitCenterName,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  CACashDiscountDueDate,
  CACashDiscountRate,
  cast('%' as unit) AS CAPercentageUnit,
  CAEligibleAmountForCshDiscount,
  CACashDiscAmountInClearingCrcy,
  CashPlanningGroup,
  _CashPlanningGroup._Text[1: Language=$session.system_language].CashPlanningGroupName AS CashPlanningGroupName,
  PlanningLevel,
  cast(_PlanningLevel._Text[1: Language=$session.system_language].PlanningLevelName as fdlev_text_kk preserving type ) AS PlanningLevelName,
  CAPostingDateOfClearingDoc,
  CAClearingCurrency,
  CAClearingAmountInClearingCrcy,
  CAValueDateForClearing,
  CAClearingRestrictionCode,
  CAItemIsExcludedFromDunning,
  cast('' as val_text) AS CAItemIsExcludedFromDunText,
  CADunningProcedure,
  CACurrentFactoringStatusOfRbl,
  cast('' as val_text) AS CACurrentFactoringStsNameOfRbl,
  CAFactoringCheckStsForClrgInfo,
  cast('' as val_text) AS CAFactoringClrgInfoChkStsName,
  BusinessPlace,
  CAReceivingCountry,
  cast(_ReceivingCountry._Text[1: Language=$session.system_language].CountryName as landl_text_kk) AS CAReceivingCountryName,
  CAWorkflowCheckReason,
  CAGrpgCodeForTransfToCollAgcy,
  CAIsIncludedInCollectionCase,
  cast('' as xcolc_text_kk) AS CAIsIncludedInCollCaseText,
  CADocumentType,
  _CADocumentType._Text[1: Language=$session.system_language].CADocumentTypeName AS CADocumentTypeName,
  CASubstituteDocumentNumber,
  CASubstituteDocumentCategory,
  cast('' as abwtp_text_gfn_kk) AS CASubstituteDocCategoryName,
  CADocumentNumberOfOriginItem,
  CAReferenceDocument,
  CADoubtfulOrValueAdjmtCode,
  cast('' as infoz_text_gfn_kk) AS CADoubtfulOrValueAdjmtCodeName,
  CAInterestCode,
  CAPaymentPreNotificationCode,
  cast('' as xpyor_text_gfn_kk) AS CAPaymentPreNotifCodeName,
  CAItemIsOnlyForSettlement,
  cast('' as val_text) AS CAItemIsOnlyForSettlementText,
  CAIsDownPaymentRequest,
  cast('' as val_text) AS CAIsDownPaymentRequestText,
  CAPaymentMethod,
  _CAPaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  CAPaymentCompanyCode,
  cast(_PaymentCompanyCode.CompanyCodeName as pybuk_text_kk preserving type ) AS CAPaymentCompanyCodeName,
  CAGroupingForPayment,
  CAPaymentSpecificationCategory,
  cast('' as pdtyp_text_gfn_kk) AS CAPaymentSpecificationCatName,
  CAAltvBPForPayment,
  cast(_PaytAltvBusinessPartner.BusinessPartnerFullName as emgpa_text_kk) AS CAAltvBPForPaymentFullName,
  CABankOfAltvBPForPayment,
  CACardOfAltvBPForPayment,
  CARevenueDistrFinalRecipient,
  cast(_RevnDistrFnlRcpntContrAccount.ContractAccountName as finre_text_kk preserving type) AS CARevenueDistrFinalRcpntName,
  CAPartnerSettlementStatus,
  cast('' as ptitm_text_gfn_kk) AS CAPartnerSettlementStatusName,
  CARevenueDistrCurrentStatus,
  cast('' as rdsta_text_gfn_kk) AS CARevenueDistrCurrentStsName,
  CARevenueDistrLastStatus,
  cast('' as rdstb_text_kk) AS CARevenueDistrLastStatusName,
  TaxCode,
  cast(_TaxCode._Text[1: Language=$session.system_language].TaxCodeName as mwskz_text_kk preserving type) AS TaxCodeName,
  CATaxAmountInLocalCurrency,
  CATaxAmountInTransCurrency,
  CADownPaymentTaxAccount,
  CADownPaymentOffsetTaxAccount,
  TaxJurisdiction,
  TaxCalculationProcedure,
  CAWithholdingTaxPercentage,
  CAOtherTaxCode,
  CATaxPortionInLocalCurrency,
  CATaxPortionInTransCurrency,
  WithholdingTaxCode,
  cast(_WithholdingTaxCode.WhldgTaxCodeName as qsskz_text_kk preserving type) AS WhldgTaxCodeName,
  CAWithholdingTaxSupplement,
  CAWithholdingTaxCategory,
  cast('' as qsptp_text_gfn_kk) AS CAWithholdingTaxCategoryName,
  CAWithholdingTaxAmount,
  WithholdingTaxCertificate,
  TransactionCurrency,
  CAPeriodCode,
  _CAPeriodCode._Text[1: Language=$session.system_language].CAPeriodCodeName AS CAPeriodCodeName,
  CAEndDateOfBillingPeriod,
  CAItemIsWithdrawn,
  cast('' as val_text) AS CAItemIsWithdrawnText,
  CompanyCodeCurrency,
  CAAmountInLocalCurrency,
  AdditionalCurrency1,
  CAAmountInSecondCurrency,
  AdditionalCurrency2,
  CAAmountInThirdCurrency,
  CABPItemText,
  CAChangeIsForbidden,
  CASEPAPreNotifOriginCode,
  cast('' as pnhkf_text_gfn_kk) AS CASEPAPreNotifOriginCodeText,
  cast('' as abap.char(120)) AS UICT_FieldsChangedToEmpty,
  concat(LastChangeDate, LastChangeTime) AS ETag,
  _ContractAccountPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CAProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADocumentBPItemEnhanced AS BPItem
LEFT OUTER JOIN E_CADocumentBPItemPhysical AS _Extension ON CADocument = _Extension.CADocumentNumber AND CARepetitionItemNumber = _Extension.CARepetitionItemNumber AND CABPItemNumber = _Extension.CABPItemNumber AND CASubItemNumber = _Extension.CASubItemNumber  -- association [1..1]
;