C_SourcingProjectDocVarbl

DDL: C_SOURCINGPROJECTDOCVARBL SQL: CSRCGPROJVB Type: view CONSUMPTION

Document Variables for Sourcing Project

C_SourcingProjectDocVarbl is a Consumption CDS View that provides data about "Document Variables for Sourcing Project" in SAP S/4HANA. It reads from 1 data source (I_SourcingProject) and exposes 48 fields with key field SourcingProjectUUID. It has 4 associations to related views.

1 data source(s) 48 fields

Data Sources (1)

SourceAliasJoin Type
I_SourcingProject I_SourcingProject from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_IncotermsClassification _IncotermsClassification $projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification
[0..1] I_IncotermsVersion _IncotermsVersion $projection.IncotermsVersion = _IncotermsVersion.IncotermsVersion
[0..1] I_PurchasingDocumentType _PurchasingDocumentType $projection.SrcgProjFollowOnDocumentCat = _PurchasingDocumentType.PurchasingDocumentCategory and $projection.SrcgProjFollowOnDocumentType = _PurchasingDocumentType.PurchasingDocumentType
[0..1] I_WorkAssignment _SrcgProjPurchaserRespVH $projection.PurchaserRespWorkAgreement = _SrcgProjPurchaserRespVH.WorkAssignment

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSRCGPROJVB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey SourcingProjectUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Document Variables for Sourcing Project view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID SourcingProjectUUID
SourcingProject SourcingProject
SourcingProjectType SourcingProjectType
SourcingProjectTypeText
SourcingProjectVersion SourcingProjectVersion
SourcingProjectName SourcingProjectName
SourcingSupplierListUUID SourcingSupplierListUUID
CompanyCode CompanyCode
CompanyCodeName _CompanyCode CompanyCodeName
PurchasingGroup PurchasingGroup
PurchasingGroupName _PurchasingGroup PurchasingGroupName
PurchasingOrganization PurchasingOrganization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName
MaterialGroup MaterialGroup
MaterialGroupText
MaterialGroupName
DocumentCurrency DocumentCurrency
CurrencyName
CurrencyShortName
SrcgProjTotalTargetAmount SrcgProjTotalTargetAmount
PurchaserRespWorkAgreement PurchaserRespWorkAgreement
PurchaserRespFullName _SrcgProjPurchaserRespVH PersonFullName
Person _SrcgProjPurchaserRespVH Person
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime
LastChangeDateTime LastChangeDateTime
CreationDateTime CreationDateTime
IncotermsClassification IncotermsClassification
IncotermsClassificationName
IncotermsTransferLocation IncotermsTransferLocation
IncotermsVersion IncotermsVersion
IncotermsVersionName
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
PaymentTerms PaymentTerms
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
NetPaymentDays NetPaymentDays
SrcgProjPubgDteTme SrcgProjPubgDteTme
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType
PurchasingDocumentTypeName
PurContrValidityStartDate PurContrValidityStartDate
PurContrValidityEndDate PurContrValidityEndDate
ExchangeRateType ExchangeRateType
ExternalSourcingProjectRef ExternalSourcingProjectRef
_DocumentCurrency _DocumentCurrency 
@AbapCatalog.sqlViewName: 'CSRCGPROJVB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel:{ representativeKey: 'SourcingProjectUUID',
               semanticKey: ['SourcingProject'],
               usageType.dataClass: #MIXED,
               usageType.serviceQuality: #C,
               usageType.sizeCategory: #M }

@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Document Variables for Sourcing Project'

define view C_SourcingProjectDocVarbl
  as select from I_SourcingProject
  association [0..1] to I_IncotermsClassification as _IncotermsClassification on  $projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification
  association [0..1] to I_IncotermsVersion        as _IncotermsVersion        on  $projection.IncotermsVersion = _IncotermsVersion.IncotermsVersion
  association [0..1] to I_PurchasingDocumentType  as _PurchasingDocumentType  on  $projection.SrcgProjFollowOnDocumentCat  = _PurchasingDocumentType.PurchasingDocumentCategory
                                                                              and $projection.SrcgProjFollowOnDocumentType = _PurchasingDocumentType.PurchasingDocumentType
  association [0..1] to I_WorkAssignment   as _SrcgProjPurchaserRespVH on  $projection.PurchaserRespWorkAgreement = _SrcgProjPurchaserRespVH.WorkAssignment


{

  key SourcingProjectUUID                                                   as SourcingProjectUUID,
      SourcingProject                                                       as SourcingProject,
      SourcingProjectType,
      _SourcingProjectType._SourcingProjectTypeText[1: Language = $session.system_language ].SourcingProjectTypeText,

      SourcingProjectVersion                                                as SourcingProjectVersion,
      SourcingProjectName                                                   as SourcingProjectName,
      SourcingSupplierListUUID                                              as SourcingSupplierListUUID,

      CompanyCode                                                           as CompanyCode,
      _CompanyCode.CompanyCodeName,

      PurchasingGroup                                                       as PurchasingGroup,
      _PurchasingGroup.PurchasingGroupName,

      PurchasingOrganization                                                as PurchasingOrganization,
      _PurchasingOrganization.PurchasingOrganizationName,

      MaterialGroup                                                         as MaterialGroup,
      _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupText,
      _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName,

      @Semantics.currencyCode: true
      DocumentCurrency                                                      as DocumentCurrency,
      _DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName,
      _DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyShortName,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      SrcgProjTotalTargetAmount                                             as SrcgProjTotalTargetAmount,

      PurchaserRespWorkAgreement                                            as PurchaserRespWorkAgreement,
      _SrcgProjPurchaserRespVH.PersonFullName as PurchaserRespFullName,
      _SrcgProjPurchaserRespVH.Person,

      QtnLatestSubmissionDateTime                                           as QtnLatestSubmissionDateTime,

      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime                                                    as LastChangeDateTime,

      @Semantics.systemDateTime.createdAt: true
      CreationDateTime                                                      as CreationDateTime,

      IncotermsClassification                                               as IncotermsClassification,
      _IncotermsClassification._Text[1: Language = $session.system_language ].IncotermsClassificationName,

      IncotermsTransferLocation                                             as IncotermsTransferLocation,

      IncotermsVersion                                                      as IncotermsVersion,
      _IncotermsVersion._Text[1: Language = $session.system_language ].IncotermsVersionName,

      IncotermsLocation1                                                    as IncotermsLocation1,
      IncotermsLocation2                                                    as IncotermsLocation2,

      PaymentTerms                                                          as PaymentTerms,

      CashDiscount1Days                                                     as CashDiscount1Days,
      CashDiscount2Days                                                     as CashDiscount2Days,
      CashDiscount1Percent                                                  as CashDiscount1Percent,
      CashDiscount2Percent                                                  as CashDiscount2Percent,
      NetPaymentDays                                                        as NetPaymentDays,

      SrcgProjPubgDteTme                                                    as SrcgProjPubgDteTme,

      SrcgProjFollowOnDocumentCat                                           as SrcgProjFollowOnDocumentCat,

      SrcgProjFollowOnDocumentType                                          as SrcgProjFollowOnDocumentType,
      _PurchasingDocumentType._Text[1: Language = $session.system_language ].PurchasingDocumentTypeName,

      PurContrValidityStartDate                                             as PurContrValidityStartDate,
      PurContrValidityEndDate                                               as PurContrValidityEndDate,

      ExchangeRateType                                                      as ExchangeRateType,

      ExternalSourcingProjectRef                                            as ExternalSourcingProjectRef,

      _DocumentCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_CURRENCYTEXT",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSCLASSIFICATIONTEXT",
"I_INCOTERMSVERSION",
"I_INCOTERMSVERSIONTEXT",
"I_MATERIALGROUP",
"I_MATERIALGROUPTEXT",
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SOURCINGPROJECT",
"I_SOURCINGPROJECTTYPE",
"I_SOURCINGPROJECTTYPETEXT",
"I_WORKASSIGNMENT"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_PURCHASINGDOCUMENTTYPE",
"I_WORKASSIGNMENT"
],
"BASE":
[
"I_SOURCINGPROJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More