R_CntrlPurContrHdrDistrTP

DDL: R_CNTRLPURCONTRHDRDISTRTP Type: view_entity TRANSACTIONAL

Cntrl PC Header Distribution

R_CntrlPurContrHdrDistrTP is a Transactional CDS View that provides data about "Cntrl PC Header Distribution" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrDistribution) and exposes 48 fields with key fields CentralPurchaseContract, DistributionKey. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrDistribution I_CntrlPurContrDistribution from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_CntrlPurContrDistribution _CntrlPurContrDistriExtension $projection.CentralPurchaseContract = _CntrlPurContrDistriExtension.PurchasingDocument and $projection.DistributionKey = _CntrlPurContrDistriExtension.DistributionKey
[0..1] I_UnitOfMeasure _OrderQuantityUnit $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
[0..*] R_CntrlPurContrHdrDistrPartTP _CentralPurchaseContHdrPart

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Cntrl PC Header Distribution view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract
KEY DistributionKey DistributionKey
CentralPurchaseContractItem CentralPurchaseContractItem
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
PurchasingOrganization PurchasingOrganization
CompanyCode CompanyCode
Plant Plant
DocumentCurrency DocumentCurrency
PurchasingGroup PurchasingGroup
StorageLocation StorageLocation
PaymentTerms PaymentTerms
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
NetPaymentDays NetPaymentDays
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
CntrlPurContrDistributionPct CntrlPurContrDistributionPct
IsDeleted
OrderQuantityUnit OrderQuantityUnit
OrderQuantityUnitISOCode _OrderQuantityUnit UnitOfMeasureISOCode
ManualDeliveryAddressID ManualDeliveryAddressID
ProcmtHubDelivAddressTypeCode ProcmtHubDelivAddressTypeCode
ProcurementHubSourceSystem ProcurementHubSourceSystem
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode
SourceListIsUpdated SourceListIsUpdated
SourceListRestriction SourceListRestriction
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID
IncotermsClassification IncotermsClassification
IncotermsLocation1 IncotermsLocation1
ShippingInstruction ShippingInstruction
ProcmtHubSubcontractor ProcmtHubSubcontractor
ProcmtHubSuplrIsSubcontractor ProcmtHubSuplrIsSubcontractor
ReferenceDeliveryAddressID ReferenceDeliveryAddressID
FormOfAddress FormOfAddress
ProcmtHubBusinessPartnerName1 ProcmtHubBusinessPartnerName1
ProcmtHubBusinessPartnerName2 ProcmtHubBusinessPartnerName2
ProcmtHubBusinessPartnerName3 ProcmtHubBusinessPartnerName3
ProcmtHubBusinessPartnerName4 ProcmtHubBusinessPartnerName4
ProcmtHubStreetName ProcmtHubStreetName
ProcmtHubHouseNumber ProcmtHubHouseNumber
ProcmtHubPostalCode ProcmtHubPostalCode
ProcmtHubCityName ProcmtHubCityName
ProcmtHubCountry ProcmtHubCountry
ProcmtHubRegion ProcmtHubRegion
LastChangeDateTime _CentralPurchaseContract LastChangeDateTime
_CentralPurchaseContHdrPart _CentralPurchaseContHdrPart
_CntrlPurchaseContract _CntrlPurchaseContract
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Cntrl PC Header Distribution'
@VDM.viewType : #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey:  [ 'CentralPurchaseContract','DistributionKey']


@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED


@Metadata.ignorePropagatedAnnotations: true



define view entity R_CntrlPurContrHdrDistrTP
  as select from I_CntrlPurContrDistribution

  composition [0..*] of R_CntrlPurContrHdrDistrPartTP as _CentralPurchaseContHdrPart
  association        to parent R_CntrlPurchaseContractTP     as _CntrlPurchaseContract on  $projection.CentralPurchaseContract = _CntrlPurchaseContract.CentralPurchaseContract

  ----Extension Association
  association [1..1] to E_CntrlPurContrDistribution   as _CntrlPurContrDistriExtension on  $projection.CentralPurchaseContract = _CntrlPurContrDistriExtension.PurchasingDocument
                                                                                       and $projection.DistributionKey         = _CntrlPurContrDistriExtension.DistributionKey

  association [0..1] to I_UnitOfMeasure               as _OrderQuantityUnit            on  $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
{

  key CentralPurchaseContract,
  key DistributionKey,
      CentralPurchaseContractItem,
      PurchasingDocumentCategory,
      PurchasingDocumentType,
      PurchasingOrganization,
      CompanyCode,
      Plant,
      DocumentCurrency,
      PurchasingGroup,
      StorageLocation,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      CntrlPurContrDistributionPct,
      cast ( IsDeleted as xfeld )                      as IsDeleted,
      OrderQuantityUnit,
      _OrderQuantityUnit.UnitOfMeasureISOCode          as OrderQuantityUnitISOCode,
      ManualDeliveryAddressID,
      ProcmtHubDelivAddressTypeCode,
      ProcurementHubSourceSystem,
      PurchasingInfoRecordUpdateCode,
      @Semantics.booleanIndicator: true
      SourceListIsUpdated,
      SourceListRestriction,
      ProcmtHubCompanyCodeGroupingID,
      IncotermsClassification,
      IncotermsLocation1,
      ShippingInstruction,
      ProcmtHubSubcontractor,
      ProcmtHubSuplrIsSubcontractor,
      ReferenceDeliveryAddressID,
      FormOfAddress,
      ProcmtHubBusinessPartnerName1,
      ProcmtHubBusinessPartnerName2,
      ProcmtHubBusinessPartnerName3,
      ProcmtHubBusinessPartnerName4,
      ProcmtHubStreetName,
      ProcmtHubHouseNumber,
      ProcmtHubPostalCode,
      ProcmtHubCityName,
      ProcmtHubCountry,
      ProcmtHubRegion,
      @Semantics.systemDateTime.lastChangedAt: true
      _CentralPurchaseContract.LastChangeDateTime      as LastChangeDateTime,

      //Association

      _CentralPurchaseContHdrPart,

      _CntrlPurchaseContract
}


where
      CentralPurchaseContractItem                    = '00000'
  and CntrlPurContrDistributionLevel                 = 'H'
  and _CntrlPurchaseContract.CentralPurchaseContract is not null;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CENTRALPURCHASECONTRACT",
"I_CNTRLPURCONTRDISTRIBUTION",
"I_UNITOFMEASURE",
"R_CNTRLPURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_CNTRLPURCHASECONTRACTTP",
"R_CNTRLPURCONTRHDRDISTRPARTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/