I_CADOCUMENTBPITEMUI

CDS View

Business Partner Item

I_CADOCUMENTBPITEMUI is a CDS View in S/4HANA. Business Partner Item. It contains 16 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 16 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CABusLockForContract view_entity from COMPOSITE Business Lock for a CA Contract

Fields (16)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CABPItemNumber CABPItemNumber 1
KEY CAContract CAContract 1
KEY CADocumentNumber CADocumentNumber 1
KEY CAProviderContractItemCharUUID CAProviderContractItemCharUUID 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
KEY ContractAccount ContractAccount 1
_BusinessPartner _BusinessPartner 1
_CAPartner _ContractAccountPartner 1
_ProviderContract _CAProviderContract 1
BusinessArea BusinessArea 1
CADocumentOriginCode CADocumentOriginCode 1
CASubApplication CASubApplication 1
CompanyCode CompanyCode 1
Segment Segment 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Business Partner Item'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #COMPOSITE
define view entity I_CADocumentBPItemUI
  as select from R_CADocumentBPItemTP
  association [0..1] to I_CAProviderContractItem as _ProviderContractItem on  _ProviderContractItem.CAProviderContract           = $projection.CAContract
                                                                          and _ProviderContractItem.CAProviderContractItemNumber = $projection.CAProviderContractItemNumber

{
  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,
      BusinessPartner,
      CAContract,
      CAProviderContractItemNumber,
      _ProviderContractItem.CAProviderContractItemUUID,
      cast(bintohex(_ProviderContractItem.CAProviderContractItemUUID) as vtpid_c_kk) as CAProviderContractItemCharUUID,

      case
        when CAAmountInTransactionCurrency >= 0 then cast('X' as bpitem_is_receivable_kk)
        else cast('' as bpitem_is_receivable_kk)
        end                                                      as CADocumentBPItemIsReceivable,

      //for Authorization Check

      CompanyCode,
      CADocumentOriginCode,
      BusinessArea,
      Segment,
      ContractAccount,
      CASubApplication,
      
      _BusinessPartner,
      _CAPartner,
      _ProviderContract,
      _CASubApplication
}

Learn More