A_SourcingProject
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)
| Source | Alias | Join Type |
|---|---|---|
| R_SourcingProjectTP | R_SourcingProjectTP | projection |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_SrcgProjImprtdSuplrListBP | _SrcgProjImprtdSuplrListBP | $projection.SourcingSupplierListUUID = _SrcgProjImprtdSuplrListBP.SourcingSupplierListUUID |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA