I_CntrlPurContrItmDistrAddrTP

DDL: I_CNTRLPURCONTRITMDISTRADDRTP SQL: ICPCIDISTRADDRTP Type: view TRANSACTIONAL

BO View for Deliv. Addr. in Central Contract Item Distrib.

I_CntrlPurContrItmDistrAddrTP is a Transactional CDS View that provides data about "BO View for Deliv. Addr. in Central Contract Item Distrib." in SAP S/4HANA. It reads from 1 data source (I_CentralPurContrDistrAddress) and exposes 22 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey. It has 2 associations to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_CentralPurContrDistrAddress I_CentralPurContrDistrAddress from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CntrlPurContrDistributionTP _CntrlPurContrDistributionTP _CntrlPurContrDistributionTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrDistributionTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrDistributionTP.DistributionKey = $projection.DistributionKey

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICPCIDISTRADDRTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO View for Deliv. Addr. in Central Contract Item Distrib. view
ObjectModel.writeDraftPersistence CNTRLPCITMADDR_D view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract
KEY CentralPurchaseContractItem CentralPurchaseContractItem
KEY DistributionKey DistributionKey
CompanyCode CompanyCode
Plant Plant
ManualDeliveryAddressID ManualDeliveryAddressID
FullName FullName
StreetName StreetName
HouseNumber HouseNumber
CorrespondenceLanguage CorrespondenceLanguage
POBox POBox
POBoxPostalCode POBoxPostalCode
AddressTimeZone AddressTimeZone
CityName CityName
PostalCode PostalCode
CompanyPostalCode CompanyPostalCode
Country Country
Region Region
PhoneNumber PhoneNumber
FaxNumber FaxNumber
_CentralPurchaseContractTP _CentralPurchaseContractTP
_CntrlPurContrDistributionTP _CntrlPurContrDistributionTP 
@AbapCatalog.sqlViewName: 'ICPCIDISTRADDRTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BO View for Deliv. Addr. in Central Contract Item Distrib.'

@ObjectModel.writeDraftPersistence: 'CNTRLPCITMADDR_D'
@VDM.viewType:#TRANSACTIONAL
@ObjectModel: {
  createEnabled,
  updateEnabled,
  deleteEnabled,
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #MIXED
  }
}

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_CntrlPurContrItmDistrAddrTP
  as select from I_CentralPurContrDistrAddress

  association [1..1] to I_CentralPurchaseContractTP   as _CentralPurchaseContractTP   on  _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurContrDistributionTP as _CntrlPurContrDistributionTP on  _CntrlPurContrDistributionTP.CentralPurchaseContract     = $projection.CentralPurchaseContract
                                                                                      and _CntrlPurContrDistributionTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                      and _CntrlPurContrDistributionTP.DistributionKey             = $projection.DistributionKey

{

  key CentralPurchaseContract,
  key CentralPurchaseContractItem,
  key DistributionKey,
      CompanyCode,
      Plant,
      ManualDeliveryAddressID,
      FullName,
      StreetName,
      HouseNumber,
      CorrespondenceLanguage,
      POBox,
      POBoxPostalCode,
      AddressTimeZone,
      CityName,
      PostalCode,
      CompanyPostalCode,
      Country,
      Region,
      PhoneNumber,
      FaxNumber,

      /* Associations */
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _CentralPurchaseContractTP,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _CntrlPurContrDistributionTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CENTRALPURCONTRDISTRADDRESS"
],
"ASSOCIATED":
[
"I_CENTRALPURCHASECONTRACTTP",
"I_CNTRLPURCONTRDISTRIBUTIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More