C_SourcingProjQtnDocVarbl
Document Variable for Srcg Proj Qtn
C_SourcingProjQtnDocVarbl is a Consumption CDS View that provides data about "Document Variable for Srcg Proj Qtn" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectQuotation) and exposes 55 fields with key field SourcingProjectQuotationUUID. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SourcingProjectQuotation | Quotation | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | R_SourcingProject | _SrcgProj | $projection.SourcingProjectUUID = _SrcgProj.SourcingProjectUUID |
| [0..1] | C_SourcingProjectDocVarbl | _SourcingProject | $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID |
| [0..1] | I_BusinessPartner | _BusinessPartner | $projection.Bidder = _BusinessPartner.BusinessPartner |
| [0..1] | I_MaterialGroup | _MaterialGroup | $projection.MaterialGroup = _MaterialGroup.MaterialGroup |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | CSRCGPROJQTNDV | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.representativeKey | SourcingProjectQuotationUUID | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| VDM.viewType | #CONSUMPTION | view | |
| EndUserText.label | Document Variable for Srcg Proj Qtn | view |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SourcingProjectQuotationUUID | R_SourcingProjectQuotation | SourcingProjectQuotationUUID | Supplier Quotation UUID |
| SourcingProjectQuotation | R_SourcingProjectQuotation | SourcingProjectQuotation | Supplier Quotation | |
| SrcgProjQuotationVersion | R_SourcingProjectQuotation | SrcgProjQuotationVersion | Version | |
| SourcingProjectQuotationType | R_SourcingProjectQuotation | SourcingProjectQuotationType | Sourcing Project Quotation Type | |
| SourcingProjectQuotationName | R_SourcingProjectQuotation | SourcingProjectQuotationName | Name | |
| SrcgProjQuotationIsSimulated | R_SourcingProjectQuotation | SrcgProjQuotationIsSimulated | Simulated | |
| Bidder | R_SourcingProjectQuotation | Bidder | Business Partner | |
| Supplier | ||||
| CompanyCode | R_SourcingProjectQuotation | CompanyCode | Receiver Company Code | |
| CompanyCodeName | ||||
| PurchasingGroup | R_SourcingProjectQuotation | PurchasingGroup | Purchasing Group | |
| PurchasingGroupName | ||||
| PurchasingOrganization | R_SourcingProjectQuotation | PurchasingOrganization | Purchasing Organization | |
| PurchasingOrganizationName | ||||
| MaterialGroup | R_SourcingProjectQuotation | MaterialGroup | Product Group | |
| MaterialGroupName | ||||
| MaterialGroupText | ||||
| PurchasingCategory | R_SourcingProjectQuotation | PurchasingCategory | Purchasing Category | |
| SrcgProjQtnOfferCurrency | R_SourcingProjectQuotation | SrcgProjQtnOfferCurrency | Quotation Currency | |
| DocumentCurrency | _SrcgProj | DocumentCurrency | Document Currency | |
| CurrencyName | ||||
| CurrencyShortName | ||||
| SrcgProjQtnTotNetAmt | R_SourcingProjectQuotation | SrcgProjQtnTotNetAmt | Total Amount | |
| SrcgProjQtnLifecycleStatus | R_SourcingProjectQuotation | SrcgProjQtnLifecycleStatus | Status | |
| SrcgProjQtnRevisionSts | R_SourcingProjectQuotation | SrcgProjQtnRevisionSts | Revision Status | |
| SrcgProjQtnActvtnSts | R_SourcingProjectQuotation | SrcgProjQtnActvtnSts | Activation Status | |
| SrcgProjQtnSubmsnSts | R_SourcingProjectQuotation | SrcgProjQtnSubmsnSts | Submission Status | |
| SrcgProjQtnAwardingStatus | R_SourcingProjectQuotation | SrcgProjQtnAwardingStatus | Awarding Status | |
| SourcingProjectUUID | R_SourcingProjectQuotation | SourcingProjectUUID | Sourcing Project UUID | |
| SourcingProject | _SrcgProj | SourcingProject | Sourcing Project | |
| SourcingProjectVersion | _SrcgProj | SourcingProjectVersion | Sourcing Project Version | |
| SourcingProjectName | _SrcgProj | SourcingProjectName | Name | |
| SourcingProjectNegotiationUUID | R_SourcingProjectQuotation | SourcingProjectNegotiationUUID | Negotiation UUID | |
| LastChangeDateTime | R_SourcingProjectQuotation | LastChangeDateTime | Timestamp | |
| CreationDateTime | R_SourcingProjectQuotation | CreationDateTime | Timestamp | |
| SrcgProjAttchsAreForbidden | R_SourcingProjectQuotation | SrcgProjAttchsAreForbidden | Forbid Attachments | |
| SrcgProjNotesAreForbidden | R_SourcingProjectQuotation | SrcgProjNotesAreForbidden | Forbid Notes | |
| SourcingOrigin | R_SourcingProjectQuotation | SourcingOrigin | Sourcing Origin | |
| ExternalSourcingProjectQtnRef | R_SourcingProjectQuotation | ExternalSourcingProjectQtnRef | External Reference | |
| QtnLatestSubmissionDateTime | R_SourcingProjectQuotation | QtnLatestSubmissionDateTime | Submission Deadline | |
| LogicalSystem | R_SourcingProjectQuotation | LogicalSystem | Logical System | |
| CashDiscount1Days | R_SourcingProjectQuotation | CashDiscount1Days | Days from Baseline Date for Payment | |
| CashDiscount2Days | R_SourcingProjectQuotation | CashDiscount2Days | Days from Baseline Date for Payment | |
| CashDiscount1Percent | R_SourcingProjectQuotation | CashDiscount1Percent | Disc. Percent 1 | |
| CashDiscount2Percent | R_SourcingProjectQuotation | CashDiscount2Percent | Disc. Percent 2 | |
| NetPaymentDays | R_SourcingProjectQuotation | NetPaymentDays | Net Pmt Terms Period | |
| IsEndOfPurposeBlocked | R_SourcingProjectQuotation | IsEndOfPurposeBlocked | Busin. Purp. Cmpltd. | |
| SourcingEnvelopeOverallStatus | R_SourcingProjectQuotation | SourcingEnvelopeOverallStatus | ||
| _SrcgProjQtnOfferCurrency | R_SourcingProjectQuotation | _SrcgProjQtnOfferCurrency | ||
| _PurchasingGroup | R_SourcingProjectQuotation | _PurchasingGroup | ||
| _PurchasingOrganization | R_SourcingProjectQuotation | _PurchasingOrganization | ||
| _CompanyCode | R_SourcingProjectQuotation | _CompanyCode | ||
| _SourcingProject | _SourcingProject | |||
| _BusinessPartner | _BusinessPartner | |||
| _MaterialGroup | _MaterialGroup |
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_SourcingProjQtnDocVarbl.
-- 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.
CREATE VIEW C_SourcingProjQtnDocVarbl AS
SELECT
Quotation.SourcingProjectQuotationUUID AS SourcingProjectQuotationUUID,
Quotation.SourcingProjectQuotation AS SourcingProjectQuotation,
Quotation.SrcgProjQuotationVersion AS SrcgProjQuotationVersion,
Quotation.SourcingProjectQuotationType AS SourcingProjectQuotationType,
Quotation.SourcingProjectQuotationName AS SourcingProjectQuotationName,
Quotation.SrcgProjQuotationIsSimulated AS SrcgProjQuotationIsSimulated,
Quotation.Bidder AS Bidder,
suppliermapping._Supplier[IsBusinessPurposeCompleted <> 'X'].Supplier AS Supplier,
Quotation.CompanyCode AS CompanyCode,
Quotation._CompanyCode.CompanyCodeName AS CompanyCodeName,
Quotation.PurchasingGroup AS PurchasingGroup,
Quotation._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
Quotation.PurchasingOrganization AS PurchasingOrganization,
Quotation._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
Quotation.MaterialGroup AS MaterialGroup,
Quotation._MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
Quotation._MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupText AS MaterialGroupText,
Quotation.PurchasingCategory AS PurchasingCategory,
Quotation.SrcgProjQtnOfferCurrency AS SrcgProjQtnOfferCurrency,
_SrcgProj.DocumentCurrency AS DocumentCurrency,
_SrcgProj._DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
_SrcgProj._DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyShortName AS CurrencyShortName,
Quotation.SrcgProjQtnTotNetAmt AS SrcgProjQtnTotNetAmt,
Quotation.SrcgProjQtnLifecycleStatus AS SrcgProjQtnLifecycleStatus,
Quotation.SrcgProjQtnRevisionSts AS SrcgProjQtnRevisionSts,
Quotation.SrcgProjQtnActvtnSts AS SrcgProjQtnActvtnSts,
Quotation.SrcgProjQtnSubmsnSts AS SrcgProjQtnSubmsnSts,
Quotation.SrcgProjQtnAwardingStatus AS SrcgProjQtnAwardingStatus,
Quotation.SourcingProjectUUID AS SourcingProjectUUID,
_SrcgProj.SourcingProject AS SourcingProject,
_SrcgProj.SourcingProjectVersion AS SourcingProjectVersion,
_SrcgProj.SourcingProjectName AS SourcingProjectName,
Quotation.SourcingProjectNegotiationUUID AS SourcingProjectNegotiationUUID,
Quotation.LastChangeDateTime AS LastChangeDateTime,
Quotation.CreationDateTime AS CreationDateTime,
Quotation.SrcgProjAttchsAreForbidden AS SrcgProjAttchsAreForbidden,
Quotation.SrcgProjNotesAreForbidden AS SrcgProjNotesAreForbidden,
Quotation.SourcingOrigin AS SourcingOrigin,
Quotation.ExternalSourcingProjectQtnRef AS ExternalSourcingProjectQtnRef,
Quotation.QtnLatestSubmissionDateTime AS QtnLatestSubmissionDateTime,
Quotation.LogicalSystem AS LogicalSystem,
Quotation.CashDiscount1Days AS CashDiscount1Days,
Quotation.CashDiscount2Days AS CashDiscount2Days,
Quotation.CashDiscount1Percent AS CashDiscount1Percent,
Quotation.CashDiscount2Percent AS CashDiscount2Percent,
Quotation.NetPaymentDays AS NetPaymentDays,
Quotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
Quotation.SourcingEnvelopeOverallStatus AS SourcingEnvelopeOverallStatus,
Quotation._SrcgProjQtnOfferCurrency AS _SrcgProjQtnOfferCurrency,
Quotation._PurchasingGroup AS _PurchasingGroup,
Quotation._PurchasingOrganization AS _PurchasingOrganization,
Quotation._CompanyCode AS _CompanyCode
FROM R_SourcingProjectQuotation AS Quotation
LEFT OUTER JOIN R_SourcingProject AS _SrcgProj ON SourcingProjectUUID = _SrcgProj.SourcingProjectUUID -- association [0..1]
LEFT OUTER JOIN C_SourcingProjectDocVarbl AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON Bidder = _BusinessPartner.BusinessPartner -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA