I_CADOCUMENTBPITEMUI
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.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CABusLockForContract | view_entity | from | COMPOSITE | Business Lock for a CA Contract |
Fields (16)
| Key | Field | CDS Fields | Used 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 | _CAPartner | 1 | |
| _ProviderContract | _ProviderContract | 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,
_CAPartner,
_ProviderContract,
_BusinessPartner
}