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,
  ContractAccount,
  CAPostingDate,
  CAClearingStatus,
  cast('' as char50) AS CAClearingStatusName,
  CAClearingReason,
  _ClearingReason._Text[1: Language=$session.system_language].CAClearingReasonName AS CAClearingReasonName,
  CAClearingDate,
  CAClearingDocumentNumber,
  CANetDueDate,
  CAAmountInTransactionCurrency,
  CAMainTransaction,
  _MainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  CASubTransaction,
  _SubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  CADeferralDate,
  CompanyCode,
  BusinessArea,
  _BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  Segment,
  _Segment._Text[1: Language=$session.system_language].SegmentName AS SegmentName,
  PartnerCompany,
  CAContract,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  CAProviderContractItemNumber,
  CASubApplication,
  _CASubApplication._CASubApplicationText[1:Language = $session.system_language].CASubApplicationText AS CASubApplicationText,
  CAReconciliationAccount,
  _ReconAccount._Text[1: Language=$session.system_language].GLAccountName AS CAReconciliationAccountName,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode,
  cast(PlannedAmtInTransactionCrcy as fdwbt) AS PlannedAmtInTransactionCrcy,
  ProfitCenter,
  _ProfitCenter._Text[1: Language=$session.system_language].ProfitCenterName 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,
  _CashPlanningGrp._Text[1: Language=$session.system_language].CashPlanningGroupName AS CashPlanningGroupName,
  PlanningLevel,
  _PlanningLevel._Text[1: Language=$session.system_language].PlanningLevelName AS PlanningLevelName,
  CAPostingDateOfClearingDoc,
  CAClearingCurrency,
  CAClearingAmountInClearingCrcy,
  CAValueDateForClearing,
  CAClearingRestrictionCode,
  _CAClearingRestrictionCode._Text[1: Language=$session.system_language].CAClearingRestrictionCodeName AS CAClearingRestrictionCodeName,
  CAItemIsExcludedFromDunning,
  cast('' as val_text) AS CAItemIsExcludedFromDunText,
  CADunningProcedure,
  _DunningProcedure._Text[1: Language=$session.system_language].CADunningProcedureName AS CADunningProcedureName,
  CACurrentFactoringStatusOfRbl,
  cast('' as val_text) AS CACurrentFactoringStsNameOfRbl,
  CAFactoringCheckStsForClrgInfo,
  cast('' as val_text) AS CAFactoringClrgInfoChkStsName,
  BusinessPlace,
  CAReceivingCountry,
  _ReceivingCountry._Text[1: Language=$session.system_language].CountryName AS CountryName,
  CAWorkflowCheckReason,
  _CAWorkflowCheckReason._Text[1: Language=$session.system_language].CAWorkflowCheckReasonName AS CAWorkflowCheckReasonName,
  CAGrpgCodeForTransfToCollAgcy,
  CAIsIncludedInCollectionCase,
  cast('' as val_text) AS CAIsIncludedInCollCaseText,
  CADocumentType,
  _DocType._Text[1: Language=$session.system_language].CADocumentTypeName AS CADocumentTypeName,
  CASubstituteDocumentNumber,
  CASubstituteDocumentCategory,
  cast('' as val_text) AS CASubstituteDocCategoryName,
  CADocumentNumberOfOriginItem,
  CAReferenceDocument,
  CADoubtfulOrValueAdjmtCode,
  cast('' as val_text) AS CADoubtfulOrValueAdjmtCodeName,
  CAInterestCode,
  _InterestCode._Text[1: Language=$session.system_language].CAInterestCodeName AS CAInterestCodeName,
  CAPaymentPreNotificationCode,
  cast('' as val_text) AS CAPaymentPreNotifCodeName,
  CAItemIsOnlyForSettlement,
  cast('' as val_text) AS CAItemIsOnlyForSettlementText,
  CAIsDownPaymentRequest,
  cast('' as val_text) AS CAIsDownPaymentRequestText,
  CAPaymentMethod,
  _PaytMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  CAPaymentCompanyCode,
  CAGroupingForPayment,
  CAPaymentSpecificationCategory,
  cast('' as val_text) AS CAPaymentSpecificationCatName,
  CAAltvBPForPayment,
  CABankOfAltvBPForPayment,
  CACardOfAltvBPForPayment,
  CARevenueDistrFinalRecipient,
  CAPartnerSettlementStatus,
  cast('' as val_text) AS CAPartnerSettlementStatusName,
  CARevenueDistrCurrentStatus,
  cast('' as val_text) AS CARevenueDistrCurrentStsName,
  CARevenueDistrLastStatus,
  cast('' as val_text) AS CARevenueDistrLastStatusName,
  TaxCode,
  _TaxCode._Text[1: Language=$session.system_language].TaxCodeName AS TaxCodeName,
  CATaxAmountInLocalCurrency,
  CATaxAmountInTransCurrency,
  CADownPaymentTaxAccount,
  _TaxAccount._Text[1: Language=$session.system_language].GLAccountLongName AS CADownPaymentTaxAcctLongName,
  CADownPaymentOffsetTaxAccount,
  _OffsetTaxAccount._Text[1: Language=$session.system_language].GLAccountName AS CADownPaymentOffsetTaxAcctName,
  TaxJurisdiction,
  _TaxJurisdiction._Text[1: Language=$session.system_language].TaxJurisdictionName AS TaxJurisdictionName,
  TaxCalculationProcedure,
  CAWithholdingTaxPercentage,
  CAOtherTaxCode,
  _OtherTaxCode._Text[1: Language=$session.system_language].CAOtherTaxCodeName AS CAOtherTaxCodeName,
  CATaxPortionInLocalCurrency,
  CATaxPortionInTransCurrency,
  WithholdingTaxCode,
  CAWithholdingTaxSupplement,
  _WhldgTaxSuplmnt._Text[1: Language=$session.system_language].CAWithholdingTaxSuplmntName AS CAWithholdingTaxSuplmntName,
  CAWithholdingTaxCategory,
  cast('' as val_text) AS CAWithholdingTaxCategoryName,
  CAWithholdingTaxAmount,
  WithholdingTaxCertificate,
  TransactionCurrency,
  CAPeriodCode,
  _PeriodCode._Text[1: Language=$session.system_language].CAPeriodCodeName AS CAPeriodCodeName,
  CAEndDateOfBillingPeriod,
  CAItemIsWithdrawn,
  cast('' as val_text) AS CAItemIsWithdrawnText,
  CAAmountInLocalCurrency,
  CAAmountInSecondCurrency,
  CAAmountInThirdCurrency,
  CABPItemText,
  CAChangeIsForbidden,
  CASEPAPreNotifOriginCode,
  cast('' as val_text) AS CASEPAPreNotifOriginCodeText,
  _AltvBPForPayment.BusinessPartnerFullName AS CAAltvBPForPaymentFullName,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CAHeader.ContractAccountName AS ContractAccountName,
  _CAHeaderFinalRec.ContractAccountName AS CARevenueDistrFinalRcpntName,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  _CompCodePayt.CompanyCodeName AS CAPaymentCompanyCodeName,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup,
  _WithholdingTaxCode.WhldgTaxCodeName AS WhldgTaxCodeName
FROM I_CADocumentBPItemLogical AS BPItem
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGrp ON CashPlanningGroup = _CashPlanningGrp.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON BPItem.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure AND BPItem.TaxCode = _TaxCode.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction AND TaxCalculationProcedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure  -- association [0..*]
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]
LEFT OUTER JOIN I_CAStatisticalItemCode AS _CAStatisticalItemCode ON CAStatisticalItemCode = _CAStatisticalItemCode.CAStatisticalItemCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [1..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [1..1]
LEFT OUTER JOIN I_CAClearingRestrictionCode AS _CAClearingRestrictionCode ON CAClearingRestrictionCode = _CAClearingRestrictionCode.CAClearingRestrictionCode  -- association [1..1]
LEFT OUTER JOIN I_CAWorkflowCheckReason AS _CAWorkflowCheckReason ON CAWorkflowCheckReason = _CAWorkflowCheckReason.CAWorkflowCheckReason  -- association [1..1]
;