R_CNTRLPURCONTRHDRDISTRTP

CDS View

Cntrl PC Header Distribution

R_CNTRLPURCONTRHDRDISTRTP is a CDS View in S/4HANA. Cntrl PC Header Distribution. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CntrlPurContrHeaderDistr_2 view_entity projection CONSUMPTION CCTR Header Distribution
I_CntrlPurContrHdrDistrTP_2 view_entity projection TRANSACTIONAL CCTR Header Distribution - TP 
@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":""
}
}*/

Learn More