P_SRCGPROJSUBMSNDDLNTGTAMTBYWK

DDL: P_SRCGPROJSUBMSNDDLNTGTAMTBYWK SQL: PSRCGPROJSDWK Type: view COMPOSITE Package: ODATA_MM_PUR_PROD_SRCG_OVP
12 Fields 1 Data Sources

Sourcing Proj by Submsn deadline and amt

P_SRCGPROJSUBMSNDDLNTGTAMTBYWK is a Composite CDS View that provides data about "Sourcing Proj by Submsn deadline and amt" in SAP S/4HANA. It reads from 1 data source (P_SrcgProjSubmsnDdlnTgtAmt) and exposes 12 fields with key field SourcingProjectUUID. Part of development package ODATA_MM_PUR_PROD_SRCG_OVP.

Data Sources (1)

SourceAliasJoin Type
P_SrcgProjSubmsnDdlnTgtAmt P_SrcgProjSubmsnDdlnTgtAmt from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate vdm_srcgprojcreationdate
P_EndDate vdm_srcgprojcreationdate

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSRCGPROJSDWK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Sourcing Proj by Submsn deadline and amt view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProject SourcingProject Sourcing Project
SourcingProjectVersion SourcingProjectVersion Sourcing Project Version
SourcingProjectName SourcingProjectName Name
DisplayCurrency DisplayCurrency Display Currency
QtanPndgWeeksToSubmsnDdln
SrcgProjTotTgtAmountInDspCrcy
SourcingProjectType SourcingProjectType Sourcing Project Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
MaterialGroup MaterialGroup Product Group

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 P_SRCGPROJSUBMSNDDLNTGTAMTBYWK.
-- 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: PSRCGPROJSDWK
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : vdm_srcgprojcreationdate, P_EndDate : vdm_srcgprojcreationdate

CREATE VIEW P_SRCGPROJSUBMSNDDLNTGTAMTBYWK AS
SELECT
  SourcingProjectUUID,
  SourcingProject,
  SourcingProjectVersion,
  SourcingProjectName,
  DisplayCurrency,
  cast( round( QtanPndgWeeksToSubmsnDdln, 0 ) as mm_a_spqrmngweeksubmsndeadline ) AS QtanPndgWeeksToSubmsnDdln,
  cast( SrcgProjTotTgtAmountInDspCrcy as vdm_srcgprojtotaltargetamount) AS SrcgProjTotTgtAmountInDspCrcy,
  SourcingProjectType,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  MaterialGroup
FROM P_SrcgProjSubmsnDdlnTgtAmt
;

Learn More