R_SOURCINGPROJECT

CDS View
25 Fields 17 CDS Views

Sourcing Project

R_SOURCINGPROJECT is a CDS View in S/4HANA. Sourcing Project. It contains 25 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_SourcingProjectCompare view_entity from CONSUMPTION Sourcing Project
C_SourcingProjectCompare_2 view_entity from CONSUMPTION Sourcing Project
C_SourcingProjectDEX view_entity from CONSUMPTION Sourcing Project
C_SupCosBrkTmplSrcgProjFacet view_entity from CONSUMPTION Sourcing Project for SupCosBrk Tmpl
I_PPS_PurReqnProcessFlow view_entity inner COMPOSITE Interface for PPS Process Flow
I_SourcingProject view_entity from BASIC Sourcing Project
I_SourcingProjectSitnAnchor view_entity from BASIC Sourcing Project Situation Anchor
I_SPNegttnEndDateSituation view_entity from COMPOSITE Srcg Proj Negotiation End Date Situation
P_SourcingProjectBiddingCount view_entity from COMPOSITE
P_SrcgProjCalctQuotationDate view from COMPOSITE
P_SrcgProjectWithWorkflow view_entity from COMPOSITE Sourcing Project with Workflow
P_SrcgProjSDMV4Root view_entity from COMPOSITE
P_SrcgProjSDMV4StatusOverview view_entity from COMPOSITE
R_SourcingProjectEnvelope view_entity from COMPOSITE Sourcing Project Envelope
R_SourcingProjectTP view_entity from TRANSACTIONAL Sourcing Project - TP
R_SourcingProjectValueHelp view_entity from BASIC Sourcing Project
R_SrcgProjDisplayInformation view from BASIC Sourcing Project

Fields (25)

KeyField CDS FieldsUsed in Views
KEY SourcingProjectUUID ProjectUUID,SourcingProjectUUID 6
_SourcingProjectType _SourcingProjectType 1
_SrcgProjLifecycleStatus _SrcgProjLifecycleStatus 1
_SrcPrjPurgCatReltdMatlGrp _SrcPrjPurgCatReltdMatlGrp 1
CompanyCode CompanyCode 4
CreationDateTime CreationDateTime 1
DocumentCurrency DocumentCurrency 1
MaterialGroup MaterialGroup 4
PurchaserResponsiblePerson PurchaserResponsiblePerson 1
PurchaserRespWorkAgreement PurchaserRespWorkAgreement 1
PurchasingCategory PurchasingCategory 4
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 4
PurContrValidityEndDate PurContrValidityEndDate 1
PurContrValidityStartDate PurContrValidityStartDate 1
SourcingProject SourcingProject 4
SourcingProjectName SourcingProjectName 2
SourcingProjectType SourcingProjectType 4
SourcingProjectVersion SourcingProjectVersion 4
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat 1
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType 1
SrcgProjLifecycleStatus SrcgProjLifecycleStatus 2
SrcgProjPubgDteTme SrcgProjPubgDteTme 1
SrcgProjPurgCategoryIsUsed SrcgProjPurgCategoryIsUsed 2
SrcgProjTotalTargetAmount SrcgProjTotalTargetAmount 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sourcing Project
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SOURCINGPROJECT (
    SOURCINGPROJECTUUID,
    _SOURCINGPROJECTTYPE,
    _SRCGPROJLIFECYCLESTATUS,
    _SRCPRJPURGCATRELTDMATLGRP,
    COMPANYCODE,
    CREATIONDATETIME,
    DOCUMENTCURRENCY,
    MATERIALGROUP,
    PURCHASERRESPONSIBLEPERSON,
    PURCHASERRESPWORKAGREEMENT,
    PURCHASINGCATEGORY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCONTRVALIDITYENDDATE,
    PURCONTRVALIDITYSTARTDATE,
    SOURCINGPROJECT,
    SOURCINGPROJECTNAME,
    SOURCINGPROJECTTYPE,
    SOURCINGPROJECTVERSION,
    SRCGPROJFOLLOWONDOCUMENTCAT,
    SRCGPROJFOLLOWONDOCUMENTTYPE,
    SRCGPROJLIFECYCLESTATUS,
    SRCGPROJPUBGDTETME,
    SRCGPROJPURGCATEGORYISUSED,
    SRCGPROJTOTALTARGETAMOUNT,
    PRIMARY KEY (SOURCINGPROJECTUUID)
);

Learn More