What is A_CABusPartInvoiceItem in SAP S/4HANA?

A_CABusPartInvoiceItem is a composite CDS view in SAP S/4HANA. Business Partner Invoice Item It contains 66 fields.

Which tables does A_CABusPartInvoiceItem read from?

A_CABusPartInvoiceItem reads data from: I_CABPInvcItemEnhcdForDspCrcy.

What VDM layer is A_CABusPartInvoiceItem?

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

A_CABusPartInvoiceItem

DDL: A_CABUSPARTINVOICEITEM Type: view_entity COMPOSITE

66 Fields 1 Data Sources 2 Associations

Business Partner Invoice Item

A_CABusPartInvoiceItem is a Composite CDS View that provides data about "Business Partner Invoice Item" in SAP S/4HANA. It reads from 1 data source (I_CABPInvcItemEnhcdForDspCrcy) and exposes 66 fields with key fields CADocumentContainerUUID, CADocumentContainerSqncNumber. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CABPInvcItemEnhcdForDspCrcy	I_CABPInvcItemEnhcdForDspCrcy	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	waers_curc

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	A_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[1..1]	A_ContractAccountPartner_2	_ContractAccountPartner	`$projection.BusinessPartner = _ContractAccountPartner.BusinessPartner and $projection.ContractAccount = _ContractAccountPartner.ContractAccount`

Annotations (12)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Business Partner Invoice Item	view

Fields (66)

Key	Field	Source Table	Source Field	Description
KEY	CADocumentContainerUUID		CABusPartnerInvoiceUUID
KEY	CADocumentContainerSqncNumber		CABusPartnerInvoiceItem
	CADocContainerInvoiceItmStatus		CABusPartnerInvoiceItemStatus
	CADocContainerInvoiceItmStsTxt
	CADocumentContainerRefType		CADocumentContainerRefType
	CADocumentContainerRefTypeText
	CADocumentContainerReference		CADocumentContainerReference
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	CADocument		CADocument	CA Document No.
	CARepetitionItemNumber		CARepetitionItemNumber	Repetition Item
	CABPItemNumber		CABPItemNumber	Item
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerFullName	_BusinessPartner	BusinessPartnerFullName	Broker Name
	ContractAccount		ContractAccount	Contract Acct
	ContractAccountName	_ContractAccount	ContractAccountName	Cont. acct name
	CAContract		CAContract	Contract
	CASubApplication		CASubApplication	Subapplication
	CASubApplicationText
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompCode	CompanyCodeName	Company Name
	CAReferenceDocument	_DocHeader	CAReferenceDocument	Reference
	CADocumentOriginCode	_DocHeader	CADocumentOriginCode	Document Origin
	CADocumentOriginCodeName
	CADocumentType	_DocHeader	CADocumentType	Document Type
	CADocumentTypeName
	ReferenceDocumentType	_DocHeader	ReferenceDocumentType	Reference Document Type
	OriginalReferenceDocument	_DocHeader	OriginalReferenceDocument	Reference Key
	LogicalSystem	_DocHeader	LogicalSystem	Logical System
	CABPItemText		CABPItemText	Text
	BusinessArea		BusinessArea	Business Area
	BusinessAreaName
	Segment		Segment	Segment number
	SegmentName
	CACashDiscountRate		CACashDiscountRate	Discount rate
	CAGroupingForPayment		CAGroupingForPayment	Pymt Grouping
	CAMainTransaction		CAMainTransaction	Main Trans.
	CAMainTransactionName
	CASubTransaction		CASubTransaction	Subtransaction
	CASubTransactionName
	CashDiscountBaseAmtIsNetAmt	_CompCode	CashDiscountBaseAmtIsNetAmt
	CAClearingReason		CAClearingReason	Clearing Reason
	CAClearingReasonName
	DocumentDate		DocumentDate	Journal Entry Date
	CAPostingDate		CAPostingDate	Posting Date
	CANetDueDate		CANetDueDate	Net Due Date
	CADeferralDate		CADeferralDate	Deferral To
	CACashDiscountDueDate		CACashDiscountDueDate	Disct Due Date
	CAValueDateForClearing		CAValueDateForClearing	Clear.Val.Date
	CAClearingDate		CAClearingDate	Clearing
	ExchangeRateDate		ExchangeRateDate	Translatn Date
	TransactionCurrency		TransactionCurrency	Transaction Currency
	CAAmountInTransactionCurrency		CAAmountInTransactionCurrency	Amount
	CAOpenAmountInTransactionCrcy		CAOpenAmountInTransactionCrcy
	CACashDiscountAmtInTransCrcy		CACashDiscountAmtInTransCrcy
	CAEligibleAmountForCshDiscInTC		CAEligibleAmountForCshDiscInTC
	CAReleasedAmtInTransCurrency		CAReleasedAmtInTransCurrency
	DisplayCurrency
	AmountInDisplayCurrency		AmountInDisplayCurrency
	OpenAmountInDisplayCrcy		OpenAmountInDisplayCrcy
	CashDiscountAmountInDspCrcy		CashDiscountAmountInDspCrcy
	CAEligibleAmountForCshDiscInDC		CAEligibleAmountForCshDiscInDC
	CAReleasedAmtInDisplayCurrency		CAReleasedAmtInDisplayCurrency
	CAClearingAmountInDisplayCrcy		CAClearingAmountInDisplayCrcy
	_BusinessPartner		_BusinessPartner
	_ContractAccountPartner		_ContractAccountPartner

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 A_CABusPartInvoiceItem.
-- 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.
-- Parameters: P_DisplayCurrency : waers_curc

CREATE VIEW A_CABusPartInvoiceItem AS
SELECT
  CABusPartnerInvoiceUUID AS CADocumentContainerUUID,
  CABusPartnerInvoiceItem AS CADocumentContainerSqncNumber,
  CABusPartnerInvoiceItemStatus AS CADocContainerInvoiceItmStatus,
  _BusPartnerInvoiceItemStatus._Text[1:Language = $session.system_language].CABusPartnerInvoiceItemStsText AS CADocContainerInvoiceItmStsTxt,
  CADocumentContainerRefType,
  _DocCtnRefType._DocCtnRefTypeText[1:Language = $session.system_language].CADocumentContainerRefTypeText AS CADocumentContainerRefTypeText,
  CADocumentContainerReference,
  CreationDate,
  CreationTime,
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  ContractAccount,
  _ContractAccount.ContractAccountName AS ContractAccountName,
  CAContract,
  CASubApplication,
  cast( _SubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText as description_kk ) AS CASubApplicationText,
  CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  _DocHeader.CAReferenceDocument AS CAReferenceDocument,
  _DocHeader.CADocumentOriginCode AS CADocumentOriginCode,
  _DocHeader._DocOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName,
  _DocHeader.CADocumentType AS CADocumentType,
  _DocHeader._DocType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  _DocHeader.ReferenceDocumentType AS ReferenceDocumentType,
  _DocHeader.OriginalReferenceDocument AS OriginalReferenceDocument,
  _DocHeader.LogicalSystem AS LogicalSystem,
  CABPItemText,
  BusinessArea,
  _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  Segment,
  _Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  CACashDiscountRate,
  CAGroupingForPayment,
  CAMainTransaction,
  _MainTransaction._Text[1:Language = $session.system_language].CAMainTransactionName AS CAMainTransactionName,
  CASubTransaction,
  _SubTransaction._Text[1:Language = $session.system_language].CASubTransactionName AS CASubTransactionName,
  _CompCode.CashDiscountBaseAmtIsNetAmt AS CashDiscountBaseAmtIsNetAmt,
  CAClearingReason,
  _ClearingReason._Text[1:Language = $session.system_language].CAClearingReasonName AS CAClearingReasonName,
  DocumentDate,
  CAPostingDate,
  CANetDueDate,
  CADeferralDate,
  CACashDiscountDueDate,
  CAValueDateForClearing,
  CAClearingDate,
  ExchangeRateDate,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAOpenAmountInTransactionCrcy,
  CACashDiscountAmtInTransCrcy,
  CAEligibleAmountForCshDiscInTC,
  CAReleasedAmtInTransCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  AmountInDisplayCurrency,
  OpenAmountInDisplayCrcy,
  CashDiscountAmountInDspCrcy,
  CAEligibleAmountForCshDiscInDC,
  CAReleasedAmtInDisplayCurrency,
  CAClearingAmountInDisplayCrcy
FROM I_CABPInvcItemEnhcdForDspCrcy
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN A_ContractAccountPartner_2 AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [1..1]
;

Depth:

A_CABusPartInvoiceItem view_entity

I_CABPInvcItemEnhcdForDspCrcy view_entity