I_CADocumentBPItemUI

DDL: I_CADOCUMENTBPITEMUI Type: view_entity COMPOSITE
18 Fields 1 Data Sources 1 Associations

Business Partner Item

I_CADocumentBPItemUI is a Composite CDS View that provides data about "Business Partner Item" in SAP S/4HANA. It reads from 1 data source (R_CADocumentBPItemTP) and exposes 18 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CADocumentBPItemTP R_CADocumentBPItemTP from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAProviderContractItem _ProviderContractItem _ProviderContractItem.CAProviderContract = $projection.CAContract and _ProviderContractItem.CAProviderContractItemNumber = $projection.CAProviderContractItemNumber

Annotations (7)

NameValueLevelField
EndUserText.label Business Partner Item view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
BusinessPartner BusinessPartner Issuing Authority
CAContract CAContract Contract
CAProviderContractItemNumber CAProviderContractItemNumber Contract Item
CAProviderContractItemUUID _ProviderContractItem CAProviderContractItemUUID Contr.Item ID
CAProviderContractItemCharUUID
CompanyCode CompanyCode Receiver Company Code
CADocumentOriginCode CADocumentOriginCode Document Origin
BusinessArea BusinessArea Business Area
Segment Segment Segment number
ContractAccount ContractAccount Contract Acct
CASubApplication CASubApplication Subapplication
_CAPartner _CAPartner
_ProviderContract _ProviderContract
_BusinessPartner _BusinessPartner

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_CADocumentBPItemUI.
-- 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_CADocumentBPItemUI AS
SELECT
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  BusinessPartner,
  CAContract,
  CAProviderContractItemNumber,
  _ProviderContractItem.CAProviderContractItemUUID AS CAProviderContractItemUUID,
  cast(bintohex(_ProviderContractItem.CAProviderContractItemUUID) as vtpid_c_kk) AS CAProviderContractItemCharUUID,
  CompanyCode,
  CADocumentOriginCode,
  BusinessArea,
  Segment,
  ContractAccount,
  CASubApplication
FROM R_CADocumentBPItemTP
LEFT OUTER JOIN I_CAProviderContractItem AS _ProviderContractItem ON _ProviderContractItem.CAProviderContract = CAContract AND _ProviderContractItem.CAProviderContractItemNumber = CAProviderContractItemNumber  -- association [0..1]
;

Learn More