A_SourcingProject

DDL: A_SOURCINGPROJECT Type: view_entity CONSUMPTION

Sourcing Project

A_SourcingProject is a Consumption CDS View that provides data about "Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectTP) and exposes 49 fields with key field SourcingProjectUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectTP R_SourcingProjectTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_SrcgProjImprtdSuplrListBP _SrcgProjImprtdSuplrListBP $projection.SourcingSupplierListUUID = _SrcgProjImprtdSuplrListBP.SourcingSupplierListUUID

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey SourcingProjectUUID view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Sourcing Project view
OData.entityType.name SourcingProject_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SPH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID SourcingProjectUUID
SourcingProject SourcingProject
SourcingProjectVersion SourcingProjectVersion
SourcingProjectType SourcingProjectType
SourcingProjectName SourcingProjectName
SrcgProjLifecycleStatus SrcgProjLifecycleStatus
SourcingProjectPhase SourcingProjectPhase
SourcingSupplierListUUID SourcingSupplierListUUID
CompanyCode CompanyCode
PurchasingGroup PurchasingGroup
PurchasingOrganization PurchasingOrganization
MaterialGroup MaterialGroup
DocumentCurrency DocumentCurrency
SrcgProjTotalTargetAmount SrcgProjTotalTargetAmount
PurchaserRespWorkAgreement PurchaserRespWorkAgreement
PurchaserResponsiblePerson _PersonWorkAgreement Person
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime
LastChangeDateTime LastChangeDateTime
CreationDateTime CreationDateTime
SrcgProjPubgDteTme SrcgProjPubgDteTme
SrcgProjCancDteTme SrcgProjCancDteTme
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsVersion IncotermsVersion
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
PaymentTerms PaymentTerms
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
NetPaymentDays NetPaymentDays
ShippingInstruction ShippingInstruction
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType
PurContrValidityStartDate PurContrValidityStartDate
PurContrValidityEndDate PurContrValidityEndDate
SourcingOrigin SourcingOrigin
SourcingScenario SourcingScenario
ExternalSourcingProjectRef ExternalSourcingProjectRef
LogicalSystem LogicalSystem
SourcingProjectUniqueID SourcingProjectUniqueID
SrcgProjAttchsAreForbidden SrcgProjAttchsAreForbidden
SrcgProjNotesAreForbidden SrcgProjNotesAreForbidden
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
ProcurementPlanningBundleUUID ProcurementPlanningBundleUUID
SourcingProjectVersioningRsn SourcingProjectVersioningRsn
_SrcgProjImprtdSuplrListBP _SrcgProjImprtdSuplrListBP
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@Metadata.ignorePropagatedAnnotations:true

@VDM: {
    viewType : #CONSUMPTION,
    lifecycle.contract.type: #PUBLIC_REMOTE_API,
    usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}

@ObjectModel: {
                representativeKey: 'SourcingProjectUUID',
                semanticKey: [ 'SourcingProject' ],

                modelingPattern:        #TRANSACTIONAL_QUERY,
                supportedCapabilities: [#TRANSACTIONAL_PROVIDER],

                usageType.dataClass: #TRANSACTIONAL,
                usageType.serviceQuality:  #C,
                usageType.sizeCategory: #L
                }


@EndUserText.label: 'Sourcing Project'

@AccessControl.privilegedAssociations: [ '_SrcgProjImprtdSuplrListBP',
                                         '_SrcgProjPubdSuplrListBP'  ]
@OData.entityType.name: 'SourcingProject_Type'

@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['SourcingProjectTP'],
  allowNewDatasources: false,
  elementSuffix: 'SPH',
  quota: { maximumFields: 204,
           maximumBytes: 4080 },
  allowNewCompositions: true }

define root view entity A_SourcingProject
  provider contract transactional_query
  as projection on R_SourcingProjectTP as SourcingProjectTP

  association [0..*] to A_SrcgProjImprtdSuplrListBP as _SrcgProjImprtdSuplrListBP on $projection.SourcingSupplierListUUID = _SrcgProjImprtdSuplrListBP.SourcingSupplierListUUID
{
  key SourcingProjectUUID,
      SourcingProject,
      SourcingProjectVersion,
      @ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectType'
      SourcingProjectType,
      SourcingProjectName,
      @ObjectModel.sapObjectNodeTypeReference: 'SrcgProjLifecycleStatus'
      SrcgProjLifecycleStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectPhase'
      SourcingProjectPhase,
      SourcingSupplierListUUID,
      @ObjectModel.sapObjectNodeTypeReference: 'CompanyCode'
      CompanyCode,
      @ObjectModel.sapObjectNodeTypeReference: 'PurchasingGroup'
      PurchasingGroup,
      @ObjectModel.sapObjectNodeTypeReference: 'PurchasingOrganization'
      PurchasingOrganization,
      MaterialGroup,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      SrcgProjTotalTargetAmount,
      PurchaserRespWorkAgreement,
      _PersonWorkAgreement.Person as PurchaserResponsiblePerson,
      QtnLatestSubmissionDateTime,
      LastChangeDateTime,
      CreationDateTime,
      SrcgProjPubgDteTme,
      SrcgProjCancDteTme,
      @ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'
      IncotermsClassification,
      IncotermsTransferLocation,
      @ObjectModel.sapObjectNodeTypeReference: 'IncotermsVersion'
      IncotermsVersion,
      IncotermsLocation1,
      IncotermsLocation2,
      @ObjectModel.sapObjectNodeTypeReference: 'PaymentTerms'
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      CashDiscount1Percent,
      CashDiscount2Percent,
      NetPaymentDays,
      @ObjectModel.sapObjectNodeTypeReference: 'PurchasingShippingInstruction'
      ShippingInstruction,
      SrcgProjFollowOnDocumentCat,
      @ObjectModel.sapObjectNodeTypeReference: 'PurchasingDocumentType'
      SrcgProjFollowOnDocumentType,
      PurContrValidityStartDate,
      PurContrValidityEndDate,
      // TargetAmount,

      @ObjectModel.sapObjectNodeTypeReference: 'SourcingOrigin'
      SourcingOrigin,
      @ObjectModel.sapObjectNodeTypeReference: 'SourcingScenario'
      SourcingScenario,
      ExternalSourcingProjectRef,
      LogicalSystem,
      SourcingProjectUniqueID,
      SrcgProjAttchsAreForbidden,
      SrcgProjNotesAreForbidden,
      LastChangedByUser,
      CreatedByUser,
      ProcurementPlanningBundleUUID,
      @ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectVersioningRsn'
      SourcingProjectVersioningRsn,
      // SourceLogicalSystem,


      /* Associations */
      _SourcingProjectItem        : redirected to composition child A_SourcingProjectItem,
      _SrcgProjAllowedCurrency    : redirected to composition child A_SrcgProjAllowedCurrency,
      _SrcgProjPubdSuplrListBP    : redirected to composition child A_SrcgProjPubdSuplrListBP,
      _SrcgProjImprtdSuplrListBP,
      _SrcgProjAllwdSuplrContact  : redirected to composition child A_SrcgProjAllwdSuplrContact,
      _SourcingProjectContact     : redirected to composition child A_SourcingProjectContact,
      _SrcgProjProcurementProject : redirected to composition child A_SrcgProjProcurementProject,
      _SourcingProjectMilestone   : redirected to composition child A_SourcingProjectMilestone,
      _SourcingProjectNote        : redirected to composition child A_SourcingProjectNote
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKASSIGNMENT",
"R_SOURCINGPROJECTTP"
],
"ASSOCIATED":
[
"A_SOURCINGPROJECTCONTACT",
"A_SOURCINGPROJECTITEM",
"A_SOURCINGPROJECTMILESTONE",
"A_SOURCINGPROJECTNOTE",
"A_SRCGPROJALLOWEDCURRENCY",
"A_SRCGPROJALLWDSUPLRCONTACT",
"A_SRCGPROJIMPRTDSUPLRLISTBP",
"A_SRCGPROJPROCUREMENTPROJECT",
"A_SRCGPROJPUBDSUPLRLISTBP",
"R_SOURCINGPROJECTCONTACTTP",
"R_SOURCINGPROJECTITEMTP",
"R_SOURCINGPROJECTMILESTONETP",
"R_SOURCINGPROJECTNOTETP",
"R_SRCGPROJALLOWEDCURRENCYTP",
"R_SRCGPROJALLWDSUPLRCONTACTTP",
"R_SRCGPROJPROCUREMENTPROJECTTP",
"R_SRCGPROJPUBDSUPLRLISTBPTP"
],
"BASE":
[
"R_SOURCINGPROJECTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/