I_CentralPurContrDistrAddress

DDL: I_CENTRALPURCONTRDISTRADDRESS SQL: ICPCDISTRADDR Type: view COMPOSITE

Basic View for Deliv. Addr. in Central Contract Distribution

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

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
P_CentralPurContrDistrAddress P_CentralPurContrDistrAddress from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CntrlPurContrDistribution _CntrlPurContrDistribution _CntrlPurContrDistribution.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrDistribution.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrDistribution.DistributionKey = $projection.DistributionKey

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICPCDISTRADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View for Deliv. Addr. in Central Contract Distribution view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract
KEY CentralPurchaseContractItem CentralPurchaseContractItem
KEY DistributionKey DistributionKey
CompanyCode CompanyCode
Plant Plant
PurchasingGroup PurchasingGroup
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
CntrlPurContrDistributionLevel CntrlPurContrDistributionLevel
_CentralPurchaseContract _CentralPurchaseContract
_CntrlPurContrDistribution _CntrlPurContrDistribution 
@AbapCatalog.sqlViewName: 'ICPCDISTRADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic View for Deliv. Addr. in Central Contract Distribution'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_CentralPurContrDistrAddress
  as select from P_CentralPurContrDistrAddress

  association [1..1] to I_CentralPurchaseContract   as _CentralPurchaseContract   on  _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurContrDistribution as _CntrlPurContrDistribution on  _CntrlPurContrDistribution.CentralPurchaseContract     = $projection.CentralPurchaseContract
                                                                                  and _CntrlPurContrDistribution.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                  and _CntrlPurContrDistribution.DistributionKey             = $projection.DistributionKey

{
  key CentralPurchaseContract,
  key CentralPurchaseContractItem,
  key DistributionKey,
      CompanyCode,
      Plant,
      PurchasingGroup,
      ManualDeliveryAddressID,
      FullName,
      StreetName,
      HouseNumber,
      CorrespondenceLanguage,
      POBox,
      POBoxPostalCode,
      AddressTimeZone,
      CityName,
      PostalCode,
      CompanyPostalCode,
      Country,
      Region,
      PhoneNumber,
      FaxNumber,
      CntrlPurContrDistributionLevel,
      
      /* Associations */
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _CentralPurchaseContract,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _CntrlPurContrDistribution
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CENTRALPURCONTRDISTRADDRESS"
],
"ASSOCIATED":
[
"I_CENTRALPURCHASECONTRACT",
"I_CNTRLPURCONTRDISTRIBUTION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More