I_CASampleDocBPItemLogical

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_CASampleDocBPItemLogical.
-- 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: ICASDOCBPITMLOGI

CREATE VIEW I_CASampleDocBPItemLogical AS
SELECT
  BPItem.CADocumentNumber AS CADocumentNumber,
  BPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  BPItem.CABPItemNumber AS CABPItemNumber,
  BPItem.CASubItemNumber AS CASubItemNumber,
  BPItem.CompanyCode AS CompanyCode,
  BPItem.BusinessArea AS BusinessArea,
  BPItem.BusinessPlace AS BusinessPlace,
  BPItem.Segment AS Segment,
  BPItem.ProfitCenter AS ProfitCenter,
  BPItem.Division AS Division,
  BPItem.PersonnelNumber AS PersonnelNumber,
  BPItem.PartnerCompany AS PartnerCompany,
  BPItem.BusinessPartner AS BusinessPartner,
  BPItem.CAContract AS CAContract,
  BPItem.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  BPItem.CAAdditionalContract AS CAAdditionalContract,
  BPItem.ContractAccount AS ContractAccount,
  BPItem.CASubApplication AS CASubApplication,
  BPItem.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  BPItem.CAReconciliationAccount AS CAReconciliationAccount,
  BPItem.CAApplicationArea AS CAApplicationArea,
  BPItem.CAMainTransaction AS CAMainTransaction,
  BPItem.CASubTransaction AS CASubTransaction,
  BPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  BPItem.CADoubtfulOrValueAdjmtCode AS CADoubtfulOrValueAdjmtCode,
  BPItem.CAAccountAssignmentCategory AS CAAccountAssignmentCategory,
  BPItem.CAAccountAssignment AS CAAccountAssignment,
  BPItem.CADocumentType AS CADocumentType,
  BPItem.CAIsDownPaymentRequest AS CAIsDownPaymentRequest,
  BPItem.CAItemIsOnlyForSettlement AS CAItemIsOnlyForSettlement,
  BPItem.CABPItemText AS CABPItemText,
  BPItem.CANumberOfRepetitionItems AS CANumberOfRepetitionItems,
  BPItem.CARepetitionGroup AS CARepetitionGroup,
  BPItem.CAEndDateOfBillingPeriod AS CAEndDateOfBillingPeriod,
  BPItem.CAGroupingCodeForBPItems AS CAGroupingCodeForBPItems,
  BPItem.CAPeriodCode AS CAPeriodCode,
  BPItem.CAChangeIsForbidden AS CAChangeIsForbidden,
  BPItem.CAInterestCode AS CAInterestCode,
  BPItem.CARoundingItemCode AS CARoundingItemCode,
  BPItem.CAReceivingCountry AS CAReceivingCountry,
  BPItem.CAInternalPostingReasonCode AS CAInternalPostingReasonCode,
  BPItem.CAWorkflowCheckReason AS CAWorkflowCheckReason,
  BPItem.CAWorkflowCheckProcess AS CAWorkflowCheckProcess,
  BPItem.CANegativePostingControlCode AS CANegativePostingControlCode,
  BPItem.CAPartnerSettlementStatus AS CAPartnerSettlementStatus,
  BPItem.CAIsPartOfJointLiability AS CAIsPartOfJointLiability,
  BPItem.CASubstituteDocumentNumber AS CASubstituteDocumentNumber,
  BPItem.CASubstituteDocumentCategory AS CASubstituteDocumentCategory,
  BPItem.CADocumentNumberOfOriginItem AS CADocumentNumberOfOriginItem,
  BPItem.CAReferenceDocument AS CAReferenceDocument,
  BPItem.DocumentDate AS DocumentDate,
  BPItem.CAPostingDate AS CAPostingDate,
  BPItem.CANetDueDate AS CANetDueDate,
  BPItem.CADeferralDate AS CADeferralDate,
  BPItem.TransactionCurrency AS TransactionCurrency,
  BPItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  BPItem.CAExchangeRate AS CAExchangeRate,
  BPItem.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  BPItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  BPItem.CAAmountInSecondCurrency AS CAAmountInSecondCurrency,
  BPItem.CAAmountInThirdCurrency AS CAAmountInThirdCurrency,
  BPItem.CACashDiscountDueDate AS CACashDiscountDueDate,
  BPItem.CACashDiscountRate AS CACashDiscountRate,
  BPItem.CAEligibleAmountForCshDiscount AS CAEligibleAmountForCshDiscount,
  BPItem.CACashDiscAmountInClearingCrcy AS CACashDiscAmountInClearingCrcy,
  BPItem.TaxCode AS TaxCode,
  BPItem.CASupplementaryTaxCode AS CASupplementaryTaxCode,
  BPItem.CATaxAmountInLocalCurrency AS CATaxAmountInLocalCurrency,
  BPItem.CATaxAmountInTransCurrency AS CATaxAmountInTransCurrency,
  BPItem.CATaxAmountInSecondCurrency AS CATaxAmountInSecondCurrency,
  BPItem.CATaxAmountInThirdCurrency AS CATaxAmountInThirdCurrency,
  BPItem.CADownPaymentTaxAccount AS CADownPaymentTaxAccount,
  BPItem.CADownPaymentOffsetTaxAccount AS CADownPaymentOffsetTaxAccount,
  BPItem.TaxJurisdiction AS TaxJurisdiction,
  BPItem.CATaxDate AS CATaxDate,
  BPItem.WithholdingTaxCode AS WithholdingTaxCode,
  BPItem.CAWithholdingTaxSupplement AS CAWithholdingTaxSupplement,
  BPItem.CAWithholdingTaxCategory AS CAWithholdingTaxCategory,
  BPItem.CABaseAmountForWithholdingTax AS CABaseAmountForWithholdingTax,
  BPItem.CAWithholdingTaxAmount AS CAWithholdingTaxAmount,
  BPItem.CAWithholdingTaxPercentage AS CAWithholdingTaxPercentage,
  BPItem.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  BPItem.CAOtherTaxCode AS CAOtherTaxCode,
  BPItem.CAGroupingCodeForTaxItems AS CAGroupingCodeForTaxItems,
  BPItem.CATaxPortionInLocalCurrency AS CATaxPortionInLocalCurrency,
  BPItem.CATaxPortionInTransCurrency AS CATaxPortionInTransCurrency,
  BPItem.CATaxIsCalculatedExternally AS CATaxIsCalculatedExternally,
  BPItem.CAPaymentMethod AS CAPaymentMethod,
  BPItem.CAPaymentCompanyCode AS CAPaymentCompanyCode,
  BPItem.CAGroupingForPayment AS CAGroupingForPayment,
  BPItem.CAPaymentSpecificationCategory AS CAPaymentSpecificationCategory,
  BPItem.CAClearingStatus AS CAClearingStatus,
  BPItem.CAClearingDate AS CAClearingDate,
  BPItem.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  BPItem.CAPostingDateOfClearingDoc AS CAPostingDateOfClearingDoc,
  BPItem.CAClearingReason AS CAClearingReason,
  BPItem.CAClearingCurrency AS CAClearingCurrency,
  BPItem.CAClearingAmountInClearingCrcy AS CAClearingAmountInClearingCrcy,
  BPItem.CATaxAmountInClearingCrcy AS CATaxAmountInClearingCrcy,
  BPItem.CAValueDateForClearing AS CAValueDateForClearing,
  BPItem.CAClearingRestrictionCode AS CAClearingRestrictionCode,
  BPItem.CAClearingPostingIsReset AS CAClearingPostingIsReset,
  BPItem.CAItemIsWithdrawn AS CAItemIsWithdrawn,
  BPItem.CAItemIsExcludedFromDunning AS CAItemIsExcludedFromDunning,
  BPItem.CADunningProcedure AS CADunningProcedure,
  BPItem.CAGrpgCodeForTransfToCollAgcy AS CAGrpgCodeForTransfToCollAgcy,
  BPItem.CAIsIncludedInCollectionCase AS CAIsIncludedInCollectionCase,
  BPItem.CashPlanningGroup AS CashPlanningGroup,
  BPItem.PlanningLevel AS PlanningLevel,
  BPItem.CAAdditionalDaysForCashMgmt AS CAAdditionalDaysForCashMgmt,
  BPItem.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  BPItem.CAAltvBPForPayment AS CAAltvBPForPayment,
  BPItem.CABankOfAltvBPForPayment AS CABankOfAltvBPForPayment,
  BPItem.CAAddressOfAltvBPForPayment AS CAAddressOfAltvBPForPayment,
  BPItem.CACardOfAltvBPForPayment AS CACardOfAltvBPForPayment,
  BPItem.CAGLPostingCurrency AS CAGLPostingCurrency,
  BPItem.CAGLPostingAmount AS CAGLPostingAmount,
  BPItem.CAGLPostingTaxAmount AS CAGLPostingTaxAmount,
  BPItem.CAIsSeparateLineItemInGL AS CAIsSeparateLineItemInGL,
  BPItem.CAIsCashFlowItem AS CAIsCashFlowItem,
  BPItem.CACashFlowAccount AS CACashFlowAccount,
  BPItem.CACashFlowCompanyCode AS CACashFlowCompanyCode,
  BPItem.CAPaymentPreNotificationCode AS CAPaymentPreNotificationCode,
  BPItem._CompCode AS _CompCode,
  BPItem._CompCodePayt AS _CompCodePayt,
  BPItem._DocHeader AS _DocHeader,
  RepItem._SubstitDocHeader AS _SubstitDocHeader,
  RepItem._ClearingDocHeader AS _ClearingDocHeader,
  BPItem._OriginDocHeader AS _OriginDocHeader,
  BPItem._BusinessArea AS _BusinessArea,
  BPItem._Segment AS _Segment,
  BPItem._Division AS _Division,
  RepItem._BusinessPartner AS _BusinessPartner,
  BPItem._AltvBPForPayment AS _AltvBPForPayment,
  RepItem._CAPartner AS _CAPartner,
  RepItem._CAHeader AS _CAHeader,
  BPItem._CAHeaderCollvBills AS _CAHeaderCollvBills,
  BPItem._DocType AS _DocType,
  BPItem._MainTransaction AS _MainTransaction,
  BPItem._SubTransaction AS _SubTransaction,
  BPItem._CompCodeCashFlow AS _CompCodeCashFlow,
  BPItem._Currency AS _Currency,
  BPItem._ClearingCurrency AS _ClearingCurrency,
  BPItem._GLPostingCurrency AS _GLPostingCurrency,
  BPItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  BPItem._InterestCode AS _InterestCode,
  BPItem._DunningProcedure AS _DunningProcedure,
  BPItem._CashPlanningGrp AS _CashPlanningGrp,
  BPItem._PlanningLevel AS _PlanningLevel,
  BPItem._PartnerCompany AS _PartnerCompany,
  BPItem._ReceivingCountry AS _ReceivingCountry,
  BPItem._WorkflowCheckReason AS _WorkflowCheckReason,
  RepItem._PeriodCode AS _PeriodCode,
  RepItem._ClearingReason AS _ClearingReason,
  BPItem._AcctAssgmtCat AS _AcctAssgmtCat
FROM I_CASampleDocBPItemPhysical AS BPItem
-- UNION ALL with additional select branch(es): I_CASampleDocBPItemPhysical
;