I_CABusPartInvoiceItem

DDL: I_CABUSPARTINVOICEITEM Type: view_entity BASIC
25 Fields 1 Data Sources

Business Partner Invoice Item

I_CABusPartInvoiceItem is a Basic CDS View that provides data about "Business Partner Invoice Item" in SAP S/4HANA. It reads from 1 data source (I_CADocContainerItem) and exposes 25 fields with key fields CABusPartnerInvoiceUUID, CABusPartnerInvoiceItem.

Data Sources (1)

SourceAliasJoin Type
I_CADocContainerItem DocContainerItem from

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey CABusPartnerInvoiceItem view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partner Invoice Item view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CABusPartnerInvoiceUUID CADocumentContainerUUID Tree Structure
KEY CABusPartnerInvoiceItem CADocumentContainerSqncNumber Tax sequence
CADocContainerDocItemRefType CADocContainerDocItemRefType Reference Category
CADocument CADocument CA Document No.
CARepetitionItemNumber CARepetitionItemNumber Repetition Item
CABPItemNumber CABPItemNumber Item
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CompanyCode CompanyCode Receiver Company Code
CAGroupingForPayment CAGroupingForPayment Pymt Grouping
CADocumentContainerRefType CADocumentContainerRefType
CADocumentContainerReference CADocumentContainerReference
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
_BusPartnerInvoice _BusPartnerInvoice
_BusinessPartner _BusinessPartner
_CompCode _CompCode
_ContractAccount _ContractAccount
_ContractAccountPartner _ContractAccountPartner
_DocCtnDocItemRefType _DocCtnDocItemRefType
_DocCtnRefType _DocCtnRefType
_DocHeader _DocHeader
_SubApplication _SubApplication

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_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.

CREATE VIEW I_CABusPartInvoiceItem AS
SELECT
  CADocumentContainerUUID AS CABusPartnerInvoiceUUID,
  CADocumentContainerSqncNumber AS CABusPartnerInvoiceItem,
  CADocContainerDocItemRefType,
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  BusinessPartner,
  ContractAccount,
  CAContract,
  CASubApplication,
  CompanyCode,
  CAGroupingForPayment,
  CADocumentContainerRefType,
  CADocumentContainerReference,
  CreationDate,
  CreationTime
FROM I_CADocContainerItem AS DocContainerItem
;

Learn More