I_ACMBusPartValues

DDL: I_ACMBUSPARTVALUES SQL: IACMBUSPARTVAL Type: view COMPOSITE

Business Partner Values

I_ACMBusPartValues is a Composite CDS View that provides data about "Business Partner Values" in SAP S/4HANA. It reads from 2 data sources (but000, I_ACMBusinessPartnerInfo) and exposes 15 fields with key field BusinessPartnerNumber. It has 2 associations to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
but000 BusinessPartnerDetails inner
I_ACMBusinessPartnerInfo BusinessPartnerValues from

Associations (2)

CardinalityTargetAliasCondition
[*] I_ACMBusPartCompanyCode _BPCompanyCodeMap
[*] I_ACMBusPartUoMConfign _BPUoMConfig

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMBUSPARTVAL view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Business Partner Values view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber I_ACMBusinessPartnerInfo BusinessPartnerNumber
BusinessPartnerClassification I_ACMBusinessPartnerInfo BusinessPartnerClassification
ACMBusinessPartnerType I_ACMBusinessPartnerInfo ACMBusinessPartnerType
ACMOnboardRelevant I_ACMBusinessPartnerInfo ACMOnboardRelevant
IsBlocked but000 xblck
BPIsCentrallyArchived but000 xdele
CounterpartyFullName CounterpartyName CounterpartyFullName
ContractDataReplicationStatus I_ACMBusinessPartnerInfo ContractDataReplicationStatus
DeliveryDataReplicationStatus I_ACMBusinessPartnerInfo DeliveryDataReplicationStatus
SettlmtDataReplicationStatus I_ACMBusinessPartnerInfo SettlmtDataReplicationStatus
PODataReplicationStatus I_ACMBusinessPartnerInfo PODataReplicationStatus
SlsOrderDataReplicationStatus I_ACMBusinessPartnerInfo SlsOrderDataReplicationStatus
NominationReplicationStatus I_ACMBusinessPartnerInfo NominationReplicationStatus
_BPCompanyCodeMap _BPCompanyCodeMap
_BPUoMConfig _BPUoMConfig 
@AbapCatalog.sqlViewName: 'IACMBUSPARTVAL'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Business Partner Values'

define root view I_ACMBusPartValues 
  as select from           I_ACMBusinessPartnerInfo as BusinessPartnerValues
    inner join             but000                   as BusinessPartnerDetails on BusinessPartnerValues.BusinessPartnerNumber = BusinessPartnerDetails.partner
    left outer to one join P_ACMCounterPartyName    as CounterpartyName       on CounterpartyName.Counterparty = BusinessPartnerValues.BusinessPartnerNumber
  composition [*] of I_ACMBusPartCompanyCode as _BPCompanyCodeMap
  composition [*] of I_ACMBusPartUoMConfign  as _BPUoMConfig
{
  key  BusinessPartnerValues.BusinessPartnerNumber,
       BusinessPartnerValues.BusinessPartnerClassification,
       BusinessPartnerValues.ACMBusinessPartnerType,
       BusinessPartnerValues.ACMOnboardRelevant,
       BusinessPartnerDetails.xblck          as IsBlocked,
       BusinessPartnerDetails.xdele          as BPIsCentrallyArchived,
       CounterpartyName.CounterpartyFullName as CounterpartyFullName,
       BusinessPartnerValues.ContractDataReplicationStatus,
       BusinessPartnerValues.DeliveryDataReplicationStatus,
       BusinessPartnerValues.SettlmtDataReplicationStatus,
       BusinessPartnerValues.PODataReplicationStatus,
       BusinessPartnerValues.SlsOrderDataReplicationStatus,
       BusinessPartnerValues.NominationReplicationStatus,     
       

       
       /* Association to company code */
       _BPCompanyCodeMap,
       _BPUoMConfig
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMBUSINESSPARTNERINFO",
"P_ACMCOUNTERPARTYNAME",
"BUT000"
],
"ASSOCIATED":
[
"I_ACMBUSPARTCOMPANYCODE",
"I_ACMBUSPARTUOMCONFIGN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More