What is I_CADocumentBPItemPhysical in SAP S/4HANA?

I_CADocumentBPItemPhysical is a composite CDS view in SAP S/4HANA. Document Physical Business Partner Item It contains 209 fields.

Which tables does I_CADocumentBPItemPhysical read from?

I_CADocumentBPItemPhysical reads data from: I_CADocumentBPItem.

What VDM layer is I_CADocumentBPItemPhysical?

I_CADocumentBPItemPhysical is classified as a Composite view that combines data from multiple basic views.

I_CADocumentBPItemPhysical

DDL: I_CADOCUMENTBPITEMPHYSICAL Type: view COMPOSITE Package: FKK_DOCUMENT

209 Fields 1 Data Sources 9 Associations

Document Physical Business Partner Item

I_CADocumentBPItemPhysical (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Contract Accounting

I_CADocumentBPItemPhysical is a Composite CDS View that provides data about "Document Physical Business Partner Item" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItem) and exposes 209 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 9 associations to related views. Part of development package FKK_DOCUMENT.

SAP Help Documentation

Category	CDS Views for Transaction Data

Purpose
This CDS view represents the business partner line item in Contract Accounting . The most important data in the business partner item structure of the Contract Accounting document is comprised of the document number, company code, business partner, contract account, contract reference, main and subtransactions, the amounts in transaction and local currencies, the due date and the clearing information. This CDS view provides the prerequisites for answering the following business questions: How high is the volume of open receivables? How many open receivables are overdue? How high is the volume of the uncleared credit?

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: F_KKKO_BUK ( Contract Accounting Company Code Authorization ) F_KKKO_GSB ( Contract Accounting Business Area Authorization ) F_FAGL_SEG ( General Ledger Segment Authorization ) F_KKKO_BEG ( Contract Accounting Document Contract Account Partner Authorization Group ) F_KKVTD_BG ( Contract Accounting Document Provider Contract Authorization Group )

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	Deprecated
Line of Business	Contract Accounting
Application Component	FI-CA-2CL
Capabilities	Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Contract Accounting for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view represents the business partner line item in Receivables Management and Payment Handling. The most important data in the business partner item structure of the FI-CA document is comprised of the document number, company code, business partner, contract account, contract reference, main and subtransactions, the amounts in transaction and local currencies, the due date and the clearing information.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>How high is the volume of open receivables?</p> </li> <li><p>How many open receivables are overdue?</p> </li> <li><p>How high is the volume of the uncleared credit?</p> </li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CADocumentBPItem	CADocBPItem	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..1]	I_CADocumentHeader	_DocHeader	`$projection.CADocumentNumber = _DocHeader.CADocumentNumber`
[0..1]	I_CADocumentHeader	_SubstitDocHeader	`$projection.CASubstituteDocumentNumber = _SubstitDocHeader.CADocumentNumber`
[0..1]	I_CADocumentHeader	_ClearingDocHeader	`$projection.CAClearingDocumentNumber = _ClearingDocHeader.CADocumentNumber`
[0..1]	I_CADocumentHeader	_OriginDocHeader	`$projection.CADocumentNumberOfOriginItem = _OriginDocHeader.CADocumentNumber`
[1..1]	I_GLAccountInChartOfAccounts	_ReconAccount	`$projection.ChartOfAccounts = _ReconAccount.ChartOfAccounts and $projection.CAReconciliationAccount = _ReconAccount.GLAccount`
[0..1]	I_GLAccountInChartOfAccounts	_TaxAccount	`$projection.ChartOfAccounts = _TaxAccount.ChartOfAccounts and $projection.CADownPaymentTaxAccount = _TaxAccount.GLAccount`
[0..1]	I_GLAccountInChartOfAccounts	_OffsetTaxAccount	`$projection.ChartOfAccounts = _OffsetTaxAccount.ChartOfAccounts and $projection.CADownPaymentOffsetTaxAccount = _OffsetTaxAccount.GLAccount`
[0..1]	I_GLAccountInChartOfAccounts	_CashFlowAccount	`$projection.ChartOfAccounts = _CashFlowAccount.ChartOfAccounts and $projection.CACashFlowAccount = _CashFlowAccount.GLAccount`
[1..1]	E_CADocumentBPItemPhysical	_Extension	`$projection.CADocumentNumber = _Extension.CADocumentNumber and $projection.CARepetitionItemNumber = _Extension.CARepetitionItemNumber and $projection.CABPItemNumber = _Extension.CABPItemNumber and $projection.CASubItemNumber = _Extension.CASubItemNumber`

Annotations (11)

Name	Value	Level
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	ICADOCBPITEMPHYS	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Document Physical Business Partner Item	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Search.searchable	true	view
VDM.viewType	#COMPOSITE	view

Fields (209)

Key	Field	Source Table	Source Field	Description
KEY	CADocumentNumber	I_CADocumentBPItem	CADocumentNumber	Number of a FI-CA Document
KEY	CARepetitionItemNumber	I_CADocumentBPItem	CARepetitionItemNumber	Repetition Item in FI-CA Document
KEY	CABPItemNumber	I_CADocumentBPItem	CABPItemNumber	Item Number in FI-CA Document
KEY	CASubItemNumber	I_CADocumentBPItem	CASubItemNumber	Subitem for a Partial Clearing in Document
	CompanyCode	I_CADocumentBPItem	CompanyCode	Receiver Company Code
	BusinessArea	I_CADocumentBPItem	BusinessArea	Business Area
	BusinessPlace	I_CADocumentBPItem	BusinessPlace	Business place
	Segment	I_CADocumentBPItem	Segment	Segment for Segmental Reporting
	ProfitCenter	I_CADocumentBPItem	ProfitCenter	Profit Center
	Division	I_CADocumentBPItem	Division	Internal Division ID
	PersonnelNumber	I_CADocumentBPItem	PersonnelNumber	Personnel Number
	PartnerCompany	I_CADocumentBPItem	PartnerCompany	Company ID of Trading Partner
	BusinessPartner	I_CADocumentBPItem	BusinessPartner	Business Partner Number
	CAContract	I_CADocumentBPItem	CAContract	Reference Specifications from Contract
	CAProviderContractItemNumber	I_CADocumentBPItem	CAProviderContractItemNumber	Contract: Item Number
	CAAdditionalContract	I_CADocumentBPItem	CAAdditionalContract	Additional Reference Information
	ContractAccount	I_CADocumentBPItem	ContractAccount	Contract Account Number
	CASubApplication	I_CADocumentBPItem	CASubApplication	Subapplication in Contract Accounts Receivable and Payable
	AltvContractAcctForCollvBills	I_CADocumentBPItem	AltvContractAcctForCollvBills	Alternative Contract Account for Collective Bills
	CAReconciliationAccount	I_CADocumentBPItem	CAReconciliationAccount	General ledger account
	CAApplicationArea	I_CADocumentBPItem	CAApplicationArea	Application Area
	CAMainTransaction	I_CADocumentBPItem	CAMainTransaction	Main Transaction for Line Item
	CASubTransaction	I_CADocumentBPItem	CASubTransaction	Subtransaction for Document Item
	CAAccountDeterminationCode	I_CADocumentBPItem	CAAccountDeterminationCode	Account Determination ID
	CADoubtfulOrValueAdjmtCode	I_CADocumentBPItem	CADoubtfulOrValueAdjmtCode	Doubtful Entry / Individual Value Adjustment
	CAAccountAssignmentCategory	I_CADocumentBPItem	CAAccountAssignmentCategory	Account Assignment Category
	CAAccountAssignment	I_CADocumentBPItem	CAAccountAssignment	Account Assgt String for Application-Specific Account Assgts
	CADocumentType	I_CADocumentBPItem	CADocumentType	Document Type
	CAIsDownPaymentRequest	I_CADocumentBPItem	CAIsDownPaymentRequest	Item is a Down Payment/Down Payment Request
	CAItemIsOnlyForSettlement	I_CADocumentBPItem	CAItemIsOnlyForSettlement	Item Can Only Be Cleared
	CABPItemText	I_CADocumentBPItem	CABPItemText	Item text
	CANumberOfRepetitionItems	I_CADocumentBPItem	CANumberOfRepetitionItems	Number of repetition items
	CARepetitionGroup	I_CADocumentBPItem	CARepetitionGroup	Repetition group
	CAEndDateOfBillingPeriod	I_CADocumentBPItem	CAEndDateOfBillingPeriod	Upper Limit of the Billing Period
	CAGroupingCodeForBPItems	I_CADocumentBPItem	CAGroupingCodeForBPItems	Grouping Key for Displaying Open Items
	CAPeriodCode	I_CADocumentBPItem	CAPeriodCode	Key for Period Assignment
	CAChangeIsForbidden	I_CADocumentBPItem	CAChangeIsForbidden	Printing - No Changes Possible
	CAInterestCode	I_CADocumentBPItem	CAInterestCode	Interest key
	CARoundingItemCode	I_CADocumentBPItem	CARoundingItemCode	Type of Rounding Item
	CAReceivingCountry	I_CADocumentBPItem	CAReceivingCountry	Destination Country/Region (for Tax Reports)
	CAInternalPostingReasonCode	I_CADocumentBPItem	CAInternalPostingReasonCode	Reason for Automatic Creation of Posting
	CAWorkflowCheckReason	I_CADocumentBPItem	CAWorkflowCheckReason	Check Reason for Workflows Acc. to Dual Control Principle
	CAWorkflowCheckProcess	I_CADocumentBPItem	CAWorkflowCheckProcess	Editing Process to Be Confirmed
	CANegativePostingControlCode	I_CADocumentBPItem	CANegativePostingControlCode	Control Field for Negative Posting
	CAPartnerSettlementStatus	I_CADocumentBPItem	CAPartnerSettlementStatus	Status of Partner Settlement Using Billable Items
	CAIsPartOfJointLiability	I_CADocumentBPItem	CAIsPartOfJointLiability	Item Is Part of a Collaborative Liability
	CADocumentOriginCode	I_CADocumentBPItem	CADocumentOriginCode	Document Origin Key
	CASubstituteDocumentNumber	I_CADocumentBPItem	CASubstituteDocumentNumber	Number of the Substitute FI-CA Document
	CASubstituteDocumentCategory	I_CADocumentBPItem	CASubstituteDocumentCategory	Category of substitute document in FI-CA
	CADocumentNumberOfOriginItem	I_CADocumentBPItem	CADocumentNumberOfOriginItem	Number of Triggering Document
	CAReferenceDocument	I_CADocumentBPItem	CAReferenceDocument	Reference Document Number
	DocumentDate	I_CADocumentBPItem	DocumentDate	Document Date in Document
	CAPostingDate	I_CADocumentBPItem	CAPostingDate	Posting Date in the Document
	CANetDueDate	I_CADocumentBPItem	CANetDueDate	Due date for net payment
	CADeferralDate	I_CADocumentBPItem	CADeferralDate	Deferral To
	TransactionCurrency	I_CADocumentBPItem	TransactionCurrency	Transaction Currency
	CompanyCodeCurrency	I_CADocumentBPItem	CompanyCodeCurrency	Local Currency
	CAExchangeRate	I_CADocumentBPItem	CAExchangeRate	Absolute Exchange Rate
	ExchRateIsIndirectQuotation	I_CADocumentBPItem	ExchRateIsIndirectQuotation	Exchange Rate Is Indirect Quotation
	CAAmountInLocalCurrency	I_CADocumentBPItem	CAAmountInLocalCurrency	Amount In Local Currency With +/- Signs
	CAAmountInTransactionCurrency	I_CADocumentBPItem	CAAmountInTransactionCurrency	Amount in Transaction Currency with +/- Sign
	CAAmountInSecondCurrency	I_CADocumentBPItem	CAAmountInSecondCurrency	Amount in second parallel currency with +/- sign
	CAAmountInThirdCurrency	I_CADocumentBPItem	CAAmountInThirdCurrency	Amount in third parallel currency with +/- sign
	CADocBPItemTotalAmountInTC	I_CADocumentBPItem	CADocBPItemTotalAmountInTC	Total Amount of Business Partner Item
	CACashDiscountDueDate	I_CADocumentBPItem	CACashDiscountDueDate	Due Date for Cash Discount
	CACashDiscountRate	I_CADocumentBPItem	CACashDiscountRate	Cash Discount Percentage Rate
	CAEligibleAmountForCshDiscount	I_CADocumentBPItem	CAEligibleAmountForCshDiscount	Amount Eligible for Cash Discount in Document Currency
	TaxCode	I_CADocumentBPItem	TaxCode	Tax on Sales/Purchases Code
	CASupplementaryTaxCode	I_CADocumentBPItem	CASupplementaryTaxCode	Supplementary Tax
	CATaxAmountInLocalCurrency	I_CADocumentBPItem	CATaxAmountInLocalCurrency	Tax Amount in Local Currency With +/- Sign
	CATaxAmountInTransCurrency	I_CADocumentBPItem	CATaxAmountInTransCurrency	Tax Amount in Transaction Currency with +/- Sign
	CATaxAmountInSecondCurrency	I_CADocumentBPItem	CATaxAmountInSecondCurrency	Tax Amount in Second Parallel Currency
	CATaxAmountInThirdCurrency	I_CADocumentBPItem	CATaxAmountInThirdCurrency	Tax amount in third parallel currency
	CADownPaymentTaxAccount	I_CADocumentBPItem	CADownPaymentTaxAccount	Account for Posting Sales / Purchase Tax for Down Payments
	CADownPaymentOffsetTaxAccount	I_CADocumentBPItem	CADownPaymentOffsetTaxAccount	Account for Offsetting Tax Posting in Down Payments
	TaxJurisdiction	I_CADocumentBPItem	TaxJurisdiction	Tax Jurisdiction
	CATaxDate	I_CADocumentBPItem	CATaxDate	Decisive Date for Calculating Taxes
	WithholdingTaxCode	I_CADocumentBPItem	WithholdingTaxCode	Withholding Tax Code
	CAWithholdingTaxSupplement	I_CADocumentBPItem	CAWithholdingTaxSupplement	Withholding Tax Supplement
	CAWithholdingTaxCategory	I_CADocumentBPItem	CAWithholdingTaxCategory	Line Item Category From Withholding Tax View
	CABaseAmountForWithholdingTax	I_CADocumentBPItem	CABaseAmountForWithholdingTax	Tax base amount
	CAWithholdingTaxAmount	I_CADocumentBPItem	CAWithholdingTaxAmount	Withholding Tax Amount (in Document Currency)
	CAWithholdingTaxPercentage	I_CADocumentBPItem	CAWithholdingTaxPercentage	Withholding Tax Percentage
	WithholdingTaxCertificate	I_CADocumentBPItem	WithholdingTaxCertificate	Certificate Number of the Withholding Tax Exemption
	CAOtherTaxCode	I_CADocumentBPItem	CAOtherTaxCode	Tax Code for Other Taxes
	CAGroupingCodeForTaxItems	I_CADocumentBPItem	CAGroupingCodeForTaxItems	Grouping Key for Tax Items
	CATaxPortionInLocalCurrency	I_CADocumentBPItem	CATaxPortionInLocalCurrency	Tax Portion in FI-CA Local Currency
	CATaxPortionInTransCurrency	I_CADocumentBPItem	CATaxPortionInTransCurrency	Tax Portion in Document Currency
	CATaxIsCalculatedExternally	I_CADocumentBPItem	CATaxIsCalculatedExternally	Tax on Sales/Purchases Was Calculated by Document
	CATaxAmountIsSetFromExternal	I_CADocumentBPItem	CATaxAmountIsSetFromExternal	Internal Tax Characteristic for Tax Handling
	CAPaymentMethod	I_CADocumentBPItem	CAPaymentMethod	Payment Method
	CAPaymentCompanyCode	I_CADocumentBPItem	CAPaymentCompanyCode	Company Code for Automatic Payment Transactions
	CAGroupingForPayment	I_CADocumentBPItem	CAGroupingForPayment	Grouping field for automatic payments
	CAPaymentSpecificationCategory	I_CADocumentBPItem	CAPaymentSpecificationCategory	Category of Payment Specification
	CAClearingStatus	I_CADocumentBPItem	CAClearingStatus	Clearing Status
	CAClearingDate	I_CADocumentBPItem	CAClearingDate	Clearing Date
	CAClearingDocumentNumber	I_CADocumentBPItem	CAClearingDocumentNumber	Clearing Document or Printed Document
	CAPostingDateOfClearingDoc	I_CADocumentBPItem	CAPostingDateOfClearingDoc	Clearing Document Posting Date
	CAClearingReason	I_CADocumentBPItem	CAClearingReason	Clearing Reason
	CAClearingCurrency	I_CADocumentBPItem	CAClearingCurrency	Clearing Currency
	CAClearingAmountInClearingCrcy	I_CADocumentBPItem	CAClearingAmountInClearingCrcy	Clearing Amount in Clearing Currency
	CATaxAmountInClearingCrcy	I_CADocumentBPItem	CATaxAmountInClearingCrcy	Tax Amount in Clearing Currency
	CACashDiscAmountInClearingCrcy	I_CADocumentBPItem	CACashDiscAmountInClearingCrcy	Cash Discount Granted/Surcharge Levied in Clearing Currency
	CAValueDateForClearing	I_CADocumentBPItem	CAValueDateForClearing	Clearing Value Date
	CAClearingRestrictionCode	I_CADocumentBPItem	CAClearingRestrictionCode	Clearing restriction
	CAClearingPostingIsReset	I_CADocumentBPItem	CAClearingPostingIsReset	Clearing posting reversed
	CAItemIsWithdrawn	I_CADocumentBPItem	CAItemIsWithdrawn	Item Canceled
	CAItemIsExcludedFromDunning	I_CADocumentBPItem	CAItemIsExcludedFromDunning	Exclude Item from Dunning Run
	CADunningProcedure	I_CADocumentBPItem	CADunningProcedure	Dunning Procedure
	CAGrpgCodeForTransfToCollAgcy	I_CADocumentBPItem	CAGrpgCodeForTransfToCollAgcy	Collection item
	CAIsIncludedInCollectionCase	I_CADocumentBPItem	CAIsIncludedInCollectionCase	Item Is Included in Collection Case
	CashPlanningGroup	I_CADocumentBPItem	CashPlanningGroup	Planning Group
	PlanningLevel	I_CADocumentBPItem	PlanningLevel	Planning Level
	CAAdditionalDaysForCashMgmt	I_CADocumentBPItem	CAAdditionalDaysForCashMgmt	Cash Management Extra Days
	PlannedAmtInTransactionCrcy	I_CADocumentBPItem	PlannedAmtInTransactionCrcy	Planned Amount in Transaction Currency
	CAAltvBPForPayment	I_CADocumentBPItem	CAAltvBPForPayment	Alternative Business Partner for Payments
	CABankOfAltvBPForPayment	I_CADocumentBPItem	CABankOfAltvBPForPayment	Bank Details ID of Payee
	CAAddressOfAltvBPForPayment	I_CADocumentBPItem	CAAddressOfAltvBPForPayment	Address Number
	CACardOfAltvBPForPayment	I_CADocumentBPItem	CACardOfAltvBPForPayment	Alternative Payment Card ID in Document
	SEPAMandateCAInternalID	I_CADocumentBPItem	SEPAMandateCAInternalID	Mandate Identifier
	CAGLPostingCurrency	I_CADocumentBPItem	CAGLPostingCurrency	Update Currency for General Ledger Transaction Figures
	CAGLPostingAmount	I_CADocumentBPItem	CAGLPostingAmount	Amount for Updating in General Ledger
	CAGLPostingTaxAmount	I_CADocumentBPItem	CAGLPostingTaxAmount	Tax Amount for Update in General Ledger
	CAIsSeparateLineItemInGL	I_CADocumentBPItem	CAIsSeparateLineItemInGL	Create Line Item in General Ledger
	CAIsCashFlowItem	I_CADocumentBPItem	CAIsCashFlowItem	Document Contains Assignments from Cash Flows
	CACashFlowAccount	I_CADocumentBPItem	CACashFlowAccount	Originating Account in Cash Flow Anlaysis
	CACashFlowCompanyCode	I_CADocumentBPItem	CACashFlowCompanyCode	Partner Company Code for Cash Flow Analysis
	CAPaymentPreNotificationCode	I_CADocumentBPItem	CAPaymentPreNotificationCode	Item Included in a Payment Order
	CASEPAPreNotificationNumber	I_CADocumentBPItem	CASEPAPreNotificationNumber	Number of Debit Memo Notification
	CASEPAPreNotifOriginCode	I_CADocumentBPItem	CASEPAPreNotifOriginCode	Origin of Direct Debit Pre-Notification
	CASEPAPreNotifExecutionDate	I_CADocumentBPItem	CASEPAPreNotifExecutionDate	Date of Execution of Direct Debit Pre-Notifcation
	CASEPAPreNotificationRqmtCode	I_CADocumentBPItem	CASEPAPreNotificationRqmtCode	Necessity of a Notification
	CARevenueDistrFinalRecipient	I_CADocumentBPItem	CARevenueDistrFinalRecipient	Contract Account of Final Recipient
	CARevenueDistrCurrentStatus	I_CADocumentBPItem	CARevenueDistrCurrentStatus	Current Distribution Status
	CARevenueDistrLastStatus	I_CADocumentBPItem	CARevenueDistrLastStatus	Last Distribution Status Reported
	CACurrentFactoringStatusOfRbl	I_CADocumentBPItem	CACurrentFactoringStatusOfRbl	Factoring: Current Status of Receivable
	CAFactoringCheckStsForClrgInfo	I_CADocumentBPItem	CAFactoringCheckStsForClrgInfo	Factoring: Check Status for Clearing Information
	CAFactoringItem	I_CADocumentBPItem	CAFactoringItem	Subitems in Factoring
	ControllingArea	I_CADocumentBPItem	ControllingArea	Controlling Area
	ChartOfAccounts	I_CADocumentBPItem	ChartOfAccounts	Chart of Accounts
	Country	I_CADocumentBPItem	Country	Country/Region Key
	TaxCalculationProcedure			Procedure (Pricing, Output Control, Acct. Det., Costing,...)
	_AcctAssgmtCat	I_CADocumentBPItem	_CAAccountAssignmentCategory
	_AcctDetnCode	I_CADocumentBPItem	_CAAccountDeterminationCode
	_AltvBPForPayment	I_CADocumentBPItem	_PaytAltvBusinessPartner
	_ApplArea	I_CADocumentBPItem	_CAApplicationArea
	_BusinessArea	I_CADocumentBPItem	_BusinessArea
	_BusinessPartner	I_CADocumentBPItem	_BusinessPartner
	_CAHeader	I_CADocumentBPItem	_ContractAccount
	_CAHeaderCollvBills	I_CADocumentBPItem	_CollvBillsAltvContractAccount
	_CAHeaderFinalRec	I_CADocumentBPItem	_RevnDistrFnlRcpntContrAccount
	_CAPartner	I_CADocumentBPItem	_ContractAccountPartner
	_CARevnDistrCurSts	I_CADocumentBPItem	_CARevenueDistrCurrentStatus
	_CARevnDistrLastSts	I_CADocumentBPItem	_CARevenueDistrLastStatus
	_CARoundingItemCode	I_CADocumentBPItem	_CARoundingItemCode
	_SEPAPreNotifOrignCd	I_CADocumentBPItem	_CASEPAPreNotifOriginCode
	_SEPAPreNotifRqmtCode	I_CADocumentBPItem	_CASEPAPreNotificationRqmtCode
	_CashFlowAccount		_CashFlowAccount
	_CASubApplication	I_CADocumentBPItem	_CASubApplication
	_ClearingCurrency	I_CADocumentBPItem	_ClearingCurrency
	_ClearingDocHeader		_ClearingDocHeader
	_ClearingReason	I_CADocumentBPItem	_CAClearingReason
	_ClearingStatus	I_CADocumentBPItem	_CAClearingStatus
	_ClrgRstrcnCode	I_CADocumentBPItem	_CAClearingRestrictionCode
	_Currency	I_CADocumentBPItem	_TransactionCurrency
	_CompanyCodeCurrency	I_CADocumentBPItem	_CompanyCodeCurrency
	_CompCode	I_CADocumentBPItem	_CompanyCode
	_CompCodeCashFlow	I_CADocumentBPItem	_CashFlowCompanyCode
	_CompCodePayt	I_CADocumentBPItem	_PaymentCompanyCode
	_ControllingArea	I_CADocumentBPItem	_ControllingArea
	_ChartOfAccounts	I_CADocumentBPItem	_ChartOfAccounts
	_Country	I_CADocumentBPItem	_Country
	_DbtflOrValAdjmtCode	I_CADocumentBPItem	_CADbtflOrValueAdjmtCode
	_Division	I_CADocumentBPItem	_Division
	_DocHeader		_DocHeader
	_DocType	I_CADocumentBPItem	_CADocumentType
	_DunningProcedure	I_CADocumentBPItem	_CADunningProcedure
	_FactoringRblStatus	I_CADocumentBPItem	_CAFactoringReceivableStatus
	_FctrngClrgChkStatus	I_CADocumentBPItem	_CAFactoringClrgCheckStatus
	_GLPostingCurrency	I_CADocumentBPItem	_GLPostingCurrency
	_InterestCode	I_CADocumentBPItem	_CAInterestCode
	_IntPostingReasonCode	I_CADocumentBPItem	_CAInternalPostingReasonCode
	_MainTransaction	I_CADocumentBPItem	_CAMainTransaction
	_NgtvPostingCtrlCode	I_CADocumentBPItem	_CANegativePostingControlCode
	_OffsetTaxAccount		_OffsetTaxAccount
	_OriginDocHeader		_OriginDocHeader
	_OriglStstclItemCode	I_CADocumentBPItem	_CAOriglStatisticalItemCode
	_OtherTaxCode	I_CADocumentBPItem	_CAOtherTaxCode
	_PartnerCompany	I_CADocumentBPItem	_PartnerCompany
	_PaytMethod	I_CADocumentBPItem	_CAPaymentMethod
	_PaytPreNotifCode	I_CADocumentBPItem	_CAPaytPreNotificationCode
	_PaytSpecCategory	I_CADocumentBPItem	_CAPaytSpecificationCategory
	_PeriodCode	I_CADocumentBPItem	_CAPeriodCode
	_ProfitCenter	I_CADocumentBPItem	_ProfitCenter
	_ProviderContract	I_CADocumentBPItem	_CAProviderContract
	_PrtnSettlementStatus	I_CADocumentBPItem	_CAPartnerSettlementStatus
	_ReceivingCountry	I_CADocumentBPItem	_ReceivingCountry
	_Segment	I_CADocumentBPItem	_Segment
	_StatisticalItemCode	I_CADocumentBPItem	_CAStatisticalItemCode
	_SubstitDocCategory	I_CADocumentBPItem	_CASubstituteDocumentCategory
	_ReconAccount		_ReconAccount
	_SubstitDocHeader		_SubstitDocHeader
	_SubTransaction	I_CADocumentBPItem	_CASubTransaction
	_TaxAccount		_TaxAccount
	_WhldgTaxSuplmnt	I_CADocumentBPItem	_CAWithholdingTaxSupplement
	_CAWithholdingTaxCat	I_CADocumentBPItem	_CAWithholdingTaxCategory
	_WithholdingTaxCode	I_CADocumentBPItem	_WithholdingTaxCode
	_WorkflowCheckProcess	I_CADocumentBPItem	_CAWorkflowCheckProcess
	_WorkflowCheckReason	I_CADocumentBPItem	_CAWorkflowCheckReason

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_CADocumentBPItemPhysical.
-- 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_CADocumentBPItemPhysical AS
SELECT
  CADocBPItem.CADocumentNumber AS CADocumentNumber,
  CADocBPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  CADocBPItem.CABPItemNumber AS CABPItemNumber,
  CADocBPItem.CASubItemNumber AS CASubItemNumber,
  CADocBPItem.CompanyCode AS CompanyCode,
  CADocBPItem.BusinessArea AS BusinessArea,
  CADocBPItem.BusinessPlace AS BusinessPlace,
  CADocBPItem.Segment AS Segment,
  CADocBPItem.ProfitCenter AS ProfitCenter,
  CADocBPItem.Division AS Division,
  CADocBPItem.PersonnelNumber AS PersonnelNumber,
  CADocBPItem.PartnerCompany AS PartnerCompany,
  CADocBPItem.BusinessPartner AS BusinessPartner,
  CADocBPItem.CAContract AS CAContract,
  CADocBPItem.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  CADocBPItem.CAAdditionalContract AS CAAdditionalContract,
  CADocBPItem.ContractAccount AS ContractAccount,
  CADocBPItem.CASubApplication AS CASubApplication,
  CADocBPItem.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  CADocBPItem.CAReconciliationAccount AS CAReconciliationAccount,
  CADocBPItem.CAApplicationArea AS CAApplicationArea,
  CADocBPItem.CAMainTransaction AS CAMainTransaction,
  CADocBPItem.CASubTransaction AS CASubTransaction,
  CADocBPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  CADocBPItem.CADoubtfulOrValueAdjmtCode AS CADoubtfulOrValueAdjmtCode,
  CADocBPItem.CAAccountAssignmentCategory AS CAAccountAssignmentCategory,
  CADocBPItem.CAAccountAssignment AS CAAccountAssignment,
  CADocBPItem.CADocumentType AS CADocumentType,
  CADocBPItem.CAIsDownPaymentRequest AS CAIsDownPaymentRequest,
  CADocBPItem.CAItemIsOnlyForSettlement AS CAItemIsOnlyForSettlement,
  CADocBPItem.CABPItemText AS CABPItemText,
  CADocBPItem.CANumberOfRepetitionItems AS CANumberOfRepetitionItems,
  CADocBPItem.CARepetitionGroup AS CARepetitionGroup,
  CADocBPItem.CAEndDateOfBillingPeriod AS CAEndDateOfBillingPeriod,
  CADocBPItem.CAGroupingCodeForBPItems AS CAGroupingCodeForBPItems,
  CADocBPItem.CAPeriodCode AS CAPeriodCode,
  CADocBPItem.CAChangeIsForbidden AS CAChangeIsForbidden,
  CADocBPItem.CAInterestCode AS CAInterestCode,
  CADocBPItem.CARoundingItemCode AS CARoundingItemCode,
  CADocBPItem.CAReceivingCountry AS CAReceivingCountry,
  CADocBPItem.CAInternalPostingReasonCode AS CAInternalPostingReasonCode,
  CADocBPItem.CAWorkflowCheckReason AS CAWorkflowCheckReason,
  CADocBPItem.CAWorkflowCheckProcess AS CAWorkflowCheckProcess,
  CADocBPItem.CANegativePostingControlCode AS CANegativePostingControlCode,
  CADocBPItem.CAPartnerSettlementStatus AS CAPartnerSettlementStatus,
  CADocBPItem.CAIsPartOfJointLiability AS CAIsPartOfJointLiability,
  CADocBPItem.CADocumentOriginCode AS CADocumentOriginCode,
  CADocBPItem.CASubstituteDocumentNumber AS CASubstituteDocumentNumber,
  CADocBPItem.CASubstituteDocumentCategory AS CASubstituteDocumentCategory,
  CADocBPItem.CADocumentNumberOfOriginItem AS CADocumentNumberOfOriginItem,
  CADocBPItem.CAReferenceDocument AS CAReferenceDocument,
  CADocBPItem.DocumentDate AS DocumentDate,
  CADocBPItem.CAPostingDate AS CAPostingDate,
  CADocBPItem.CANetDueDate AS CANetDueDate,
  CADocBPItem.CADeferralDate AS CADeferralDate,
  CADocBPItem.TransactionCurrency AS TransactionCurrency,
  CADocBPItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  CADocBPItem.CAExchangeRate AS CAExchangeRate,
  CADocBPItem.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
  CADocBPItem.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  CADocBPItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  CADocBPItem.CAAmountInSecondCurrency AS CAAmountInSecondCurrency,
  CADocBPItem.CAAmountInThirdCurrency AS CAAmountInThirdCurrency,
  CADocBPItem.CADocBPItemTotalAmountInTC AS CADocBPItemTotalAmountInTC,
  CADocBPItem.CACashDiscountDueDate AS CACashDiscountDueDate,
  CADocBPItem.CACashDiscountRate AS CACashDiscountRate,
  CADocBPItem.CAEligibleAmountForCshDiscount AS CAEligibleAmountForCshDiscount,
  CADocBPItem.TaxCode AS TaxCode,
  CADocBPItem.CASupplementaryTaxCode AS CASupplementaryTaxCode,
  CADocBPItem.CATaxAmountInLocalCurrency AS CATaxAmountInLocalCurrency,
  CADocBPItem.CATaxAmountInTransCurrency AS CATaxAmountInTransCurrency,
  CADocBPItem.CATaxAmountInSecondCurrency AS CATaxAmountInSecondCurrency,
  CADocBPItem.CATaxAmountInThirdCurrency AS CATaxAmountInThirdCurrency,
  CADocBPItem.CADownPaymentTaxAccount AS CADownPaymentTaxAccount,
  CADocBPItem.CADownPaymentOffsetTaxAccount AS CADownPaymentOffsetTaxAccount,
  CADocBPItem.TaxJurisdiction AS TaxJurisdiction,
  CADocBPItem.CATaxDate AS CATaxDate,
  CADocBPItem.WithholdingTaxCode AS WithholdingTaxCode,
  CADocBPItem.CAWithholdingTaxSupplement AS CAWithholdingTaxSupplement,
  CADocBPItem.CAWithholdingTaxCategory AS CAWithholdingTaxCategory,
  CADocBPItem.CABaseAmountForWithholdingTax AS CABaseAmountForWithholdingTax,
  CADocBPItem.CAWithholdingTaxAmount AS CAWithholdingTaxAmount,
  CADocBPItem.CAWithholdingTaxPercentage AS CAWithholdingTaxPercentage,
  CADocBPItem.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  CADocBPItem.CAOtherTaxCode AS CAOtherTaxCode,
  CADocBPItem.CAGroupingCodeForTaxItems AS CAGroupingCodeForTaxItems,
  CADocBPItem.CATaxPortionInLocalCurrency AS CATaxPortionInLocalCurrency,
  CADocBPItem.CATaxPortionInTransCurrency AS CATaxPortionInTransCurrency,
  CADocBPItem.CATaxIsCalculatedExternally AS CATaxIsCalculatedExternally,
  CADocBPItem.CATaxAmountIsSetFromExternal AS CATaxAmountIsSetFromExternal,
  CADocBPItem.CAPaymentMethod AS CAPaymentMethod,
  CADocBPItem.CAPaymentCompanyCode AS CAPaymentCompanyCode,
  CADocBPItem.CAGroupingForPayment AS CAGroupingForPayment,
  CADocBPItem.CAPaymentSpecificationCategory AS CAPaymentSpecificationCategory,
  CADocBPItem.CAClearingStatus AS CAClearingStatus,
  CADocBPItem.CAClearingDate AS CAClearingDate,
  CADocBPItem.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  CADocBPItem.CAPostingDateOfClearingDoc AS CAPostingDateOfClearingDoc,
  CADocBPItem.CAClearingReason AS CAClearingReason,
  CADocBPItem.CAClearingCurrency AS CAClearingCurrency,
  CADocBPItem.CAClearingAmountInClearingCrcy AS CAClearingAmountInClearingCrcy,
  CADocBPItem.CATaxAmountInClearingCrcy AS CATaxAmountInClearingCrcy,
  CADocBPItem.CACashDiscAmountInClearingCrcy AS CACashDiscAmountInClearingCrcy,
  CADocBPItem.CAValueDateForClearing AS CAValueDateForClearing,
  CADocBPItem.CAClearingRestrictionCode AS CAClearingRestrictionCode,
  CADocBPItem.CAClearingPostingIsReset AS CAClearingPostingIsReset,
  CADocBPItem.CAItemIsWithdrawn AS CAItemIsWithdrawn,
  CADocBPItem.CAItemIsExcludedFromDunning AS CAItemIsExcludedFromDunning,
  CADocBPItem.CADunningProcedure AS CADunningProcedure,
  CADocBPItem.CAGrpgCodeForTransfToCollAgcy AS CAGrpgCodeForTransfToCollAgcy,
  CADocBPItem.CAIsIncludedInCollectionCase AS CAIsIncludedInCollectionCase,
  CADocBPItem.CashPlanningGroup AS CashPlanningGroup,
  CADocBPItem.PlanningLevel AS PlanningLevel,
  CADocBPItem.CAAdditionalDaysForCashMgmt AS CAAdditionalDaysForCashMgmt,
  CADocBPItem.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  CADocBPItem.CAAltvBPForPayment AS CAAltvBPForPayment,
  CADocBPItem.CABankOfAltvBPForPayment AS CABankOfAltvBPForPayment,
  CADocBPItem.CAAddressOfAltvBPForPayment AS CAAddressOfAltvBPForPayment,
  CADocBPItem.CACardOfAltvBPForPayment AS CACardOfAltvBPForPayment,
  CADocBPItem.SEPAMandateCAInternalID AS SEPAMandateCAInternalID,
  CADocBPItem.CAGLPostingCurrency AS CAGLPostingCurrency,
  CADocBPItem.CAGLPostingAmount AS CAGLPostingAmount,
  CADocBPItem.CAGLPostingTaxAmount AS CAGLPostingTaxAmount,
  CADocBPItem.CAIsSeparateLineItemInGL AS CAIsSeparateLineItemInGL,
  CADocBPItem.CAIsCashFlowItem AS CAIsCashFlowItem,
  CADocBPItem.CACashFlowAccount AS CACashFlowAccount,
  CADocBPItem.CACashFlowCompanyCode AS CACashFlowCompanyCode,
  CADocBPItem.CAPaymentPreNotificationCode AS CAPaymentPreNotificationCode,
  CADocBPItem.CASEPAPreNotificationNumber AS CASEPAPreNotificationNumber,
  CADocBPItem.CASEPAPreNotifOriginCode AS CASEPAPreNotifOriginCode,
  CADocBPItem.CASEPAPreNotifExecutionDate AS CASEPAPreNotifExecutionDate,
  CADocBPItem.CASEPAPreNotificationRqmtCode AS CASEPAPreNotificationRqmtCode,
  CADocBPItem.CARevenueDistrFinalRecipient AS CARevenueDistrFinalRecipient,
  CADocBPItem.CARevenueDistrCurrentStatus AS CARevenueDistrCurrentStatus,
  CADocBPItem.CARevenueDistrLastStatus AS CARevenueDistrLastStatus,
  CADocBPItem.CACurrentFactoringStatusOfRbl AS CACurrentFactoringStatusOfRbl,
  CADocBPItem.CAFactoringCheckStsForClrgInfo AS CAFactoringCheckStsForClrgInfo,
  CADocBPItem.CAFactoringItem AS CAFactoringItem,
  CADocBPItem.ControllingArea AS ControllingArea,
  CADocBPItem.ChartOfAccounts AS ChartOfAccounts,
  CADocBPItem.Country AS Country,
  CADocBPItem._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  CADocBPItem._CAAccountAssignmentCategory AS _AcctAssgmtCat,
  CADocBPItem._CAAccountDeterminationCode AS _AcctDetnCode,
  CADocBPItem._PaytAltvBusinessPartner AS _AltvBPForPayment,
  CADocBPItem._CAApplicationArea AS _ApplArea,
  CADocBPItem._BusinessArea AS _BusinessArea,
  CADocBPItem._BusinessPartner AS _BusinessPartner,
  CADocBPItem._ContractAccount AS _CAHeader,
  CADocBPItem._CollvBillsAltvContractAccount AS _CAHeaderCollvBills,
  CADocBPItem._RevnDistrFnlRcpntContrAccount AS _CAHeaderFinalRec,
  CADocBPItem._ContractAccountPartner AS _CAPartner,
  CADocBPItem._CARevenueDistrCurrentStatus AS _CARevnDistrCurSts,
  CADocBPItem._CARevenueDistrLastStatus AS _CARevnDistrLastSts,
  CADocBPItem._CARoundingItemCode AS _CARoundingItemCode,
  CADocBPItem._CASEPAPreNotifOriginCode AS _SEPAPreNotifOrignCd,
  CADocBPItem._CASEPAPreNotificationRqmtCode AS _SEPAPreNotifRqmtCode,
  CADocBPItem._CASubApplication AS _CASubApplication,
  CADocBPItem._ClearingCurrency AS _ClearingCurrency,
  CADocBPItem._CAClearingReason AS _ClearingReason,
  CADocBPItem._CAClearingStatus AS _ClearingStatus,
  CADocBPItem._CAClearingRestrictionCode AS _ClrgRstrcnCode,
  CADocBPItem._TransactionCurrency AS _Currency,
  CADocBPItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  CADocBPItem._CompanyCode AS _CompCode,
  CADocBPItem._CashFlowCompanyCode AS _CompCodeCashFlow,
  CADocBPItem._PaymentCompanyCode AS _CompCodePayt,
  CADocBPItem._ControllingArea AS _ControllingArea,
  CADocBPItem._ChartOfAccounts AS _ChartOfAccounts,
  CADocBPItem._Country AS _Country,
  CADocBPItem._CADbtflOrValueAdjmtCode AS _DbtflOrValAdjmtCode,
  CADocBPItem._Division AS _Division,
  CADocBPItem._CADocumentType AS _DocType,
  CADocBPItem._CADunningProcedure AS _DunningProcedure,
  CADocBPItem._CAFactoringReceivableStatus AS _FactoringRblStatus,
  CADocBPItem._CAFactoringClrgCheckStatus AS _FctrngClrgChkStatus,
  CADocBPItem._GLPostingCurrency AS _GLPostingCurrency,
  CADocBPItem._CAInterestCode AS _InterestCode,
  CADocBPItem._CAInternalPostingReasonCode AS _IntPostingReasonCode,
  CADocBPItem._CAMainTransaction AS _MainTransaction,
  CADocBPItem._CANegativePostingControlCode AS _NgtvPostingCtrlCode,
  CADocBPItem._CAOriglStatisticalItemCode AS _OriglStstclItemCode,
  CADocBPItem._CAOtherTaxCode AS _OtherTaxCode,
  CADocBPItem._PartnerCompany AS _PartnerCompany,
  CADocBPItem._CAPaymentMethod AS _PaytMethod,
  CADocBPItem._CAPaytPreNotificationCode AS _PaytPreNotifCode,
  CADocBPItem._CAPaytSpecificationCategory AS _PaytSpecCategory,
  CADocBPItem._CAPeriodCode AS _PeriodCode,
  CADocBPItem._ProfitCenter AS _ProfitCenter,
  CADocBPItem._CAProviderContract AS _ProviderContract,
  CADocBPItem._CAPartnerSettlementStatus AS _PrtnSettlementStatus,
  CADocBPItem._ReceivingCountry AS _ReceivingCountry,
  CADocBPItem._Segment AS _Segment,
  CADocBPItem._CAStatisticalItemCode AS _StatisticalItemCode,
  CADocBPItem._CASubstituteDocumentCategory AS _SubstitDocCategory,
  CADocBPItem._CASubTransaction AS _SubTransaction,
  CADocBPItem._CAWithholdingTaxSupplement AS _WhldgTaxSuplmnt,
  CADocBPItem._CAWithholdingTaxCategory AS _CAWithholdingTaxCat,
  CADocBPItem._WithholdingTaxCode AS _WithholdingTaxCode,
  CADocBPItem._CAWorkflowCheckProcess AS _WorkflowCheckProcess,
  CADocBPItem._CAWorkflowCheckReason AS _WorkflowCheckReason
FROM I_CADocumentBPItem AS CADocBPItem
LEFT OUTER JOIN I_CADocumentHeader AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CADocumentHeader AS _SubstitDocHeader ON CASubstituteDocumentNumber = _SubstitDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _ClearingDocHeader ON CAClearingDocumentNumber = _ClearingDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _OriginDocHeader ON CADocumentNumberOfOriginItem = _OriginDocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _ReconAccount ON ChartOfAccounts = _ReconAccount.ChartOfAccounts AND CAReconciliationAccount = _ReconAccount.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _TaxAccount ON ChartOfAccounts = _TaxAccount.ChartOfAccounts AND CADownPaymentTaxAccount = _TaxAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsetTaxAccount ON ChartOfAccounts = _OffsetTaxAccount.ChartOfAccounts AND CADownPaymentOffsetTaxAccount = _OffsetTaxAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CashFlowAccount ON ChartOfAccounts = _CashFlowAccount.ChartOfAccounts AND CACashFlowAccount = _CashFlowAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN E_CADocumentBPItemPhysical AS _Extension ON CADocumentNumber = _Extension.CADocumentNumber AND CARepetitionItemNumber = _Extension.CARepetitionItemNumber AND CABPItemNumber = _Extension.CABPItemNumber AND CASubItemNumber = _Extension.CASubItemNumber  -- association [1..1]
;

Depth:

I_CADocumentBPItemPhysical view

I_CADocumentBPItem view_entity