C_SourcingProjectDocVarbl

DDL: C_SOURCINGPROJECTDOCVARBL SQL: CSRCGPROJVB Type: view CONSUMPTION
48 Fields 1 Data Sources 4 Associations

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.

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 Sourcing Project UUID
SourcingProject SourcingProject Sourcing Project
SourcingProjectType SourcingProjectType Sourcing Project Type
SourcingProjectTypeText
SourcingProjectVersion SourcingProjectVersion Sourcing Project Version
SourcingProjectName SourcingProjectName Name
SourcingSupplierListUUID SourcingSupplierListUUID UUID of Sourcing Supplier List
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
MaterialGroup MaterialGroup Product Group
MaterialGroupText
MaterialGroupName
DocumentCurrency DocumentCurrency Document Currency
CurrencyName
CurrencyShortName
SrcgProjTotalTargetAmount SrcgProjTotalTargetAmount Total Target Amount
PurchaserRespWorkAgreement PurchaserRespWorkAgreement Purchaser Responsible
PurchaserRespFullName _SrcgProjPurchaserRespVH PersonFullName Full Name
Person _SrcgProjPurchaserRespVH Person Person/ Farm/ Field
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime Submission Deadline
LastChangeDateTime LastChangeDateTime Timestamp
CreationDateTime CreationDateTime Timestamp
IncotermsClassification IncotermsClassification Incoterms
IncotermsClassificationName
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsVersion IncotermsVersion Inco. Version
IncotermsVersionName
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
NetPaymentDays NetPaymentDays Net Pmt Terms Period
SrcgProjPubgDteTme SrcgProjPubgDteTme Published On
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat Follow-On Document Category
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType Follow-On Document Type
PurchasingDocumentTypeName
PurContrValidityStartDate PurContrValidityStartDate Validity Start
PurContrValidityEndDate PurContrValidityEndDate Validity End
ExchangeRateType ExchangeRateType Exch. Rate Type
ExternalSourcingProjectRef ExternalSourcingProjectRef External Reference
_DocumentCurrency _DocumentCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SourcingProjectDocVarbl.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSRCGPROJVB

CREATE VIEW C_SourcingProjectDocVarbl AS
SELECT
  SourcingProjectUUID,
  SourcingProject,
  SourcingProjectType,
  _SourcingProjectType._SourcingProjectTypeText[1: Language = $session.system_language ].SourcingProjectTypeText AS SourcingProjectTypeText,
  SourcingProjectVersion,
  SourcingProjectName,
  SourcingSupplierListUUID,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  MaterialGroup,
  _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupText AS MaterialGroupText,
  _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
  DocumentCurrency,
  _DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  _DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyShortName AS CurrencyShortName,
  SrcgProjTotalTargetAmount,
  PurchaserRespWorkAgreement,
  _SrcgProjPurchaserRespVH.PersonFullName AS PurchaserRespFullName,
  _SrcgProjPurchaserRespVH.Person AS Person,
  QtnLatestSubmissionDateTime,
  LastChangeDateTime,
  CreationDateTime,
  IncotermsClassification,
  _IncotermsClassification._Text[1: Language = $session.system_language ].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsTransferLocation,
  IncotermsVersion,
  _IncotermsVersion._Text[1: Language = $session.system_language ].IncotermsVersionName AS IncotermsVersionName,
  IncotermsLocation1,
  IncotermsLocation2,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  SrcgProjPubgDteTme,
  SrcgProjFollowOnDocumentCat,
  SrcgProjFollowOnDocumentType,
  _PurchasingDocumentType._Text[1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurContrValidityStartDate,
  PurContrValidityEndDate,
  ExchangeRateType,
  ExternalSourcingProjectRef
FROM I_SourcingProject
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON SrcgProjFollowOnDocumentCat = _PurchasingDocumentType.PurchasingDocumentCategory AND SrcgProjFollowOnDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _SrcgProjPurchaserRespVH ON PurchaserRespWorkAgreement = _SrcgProjPurchaserRespVH.WorkAssignment  -- association [0..1]
;

Learn More