R_SOURCINGPROJECTTYPE
Sourcing Project Type
R_SOURCINGPROJECTTYPE is a CDS View in S/4HANA. Sourcing Project Type. It contains 9 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProdSrcgTypeCanclnModel | view_entity | from | BASIC | Cancelation Model for Product Srcg Type |
| I_ProdSrcgTypeItemExcludeModel | view_entity | from | BASIC | Item Exclude Model for Product Srcg Type |
| I_ProdSrcgTypeUnconfdRsnModel | view_entity | from | BASIC | Unconfd Reason Model for Prod Srcg Type |
| I_ProdSrcgTypeUnlkSuplrModel | view_entity | from | BASIC | Unlock Supplier Model for Prod Srcg Type |
| I_ProdSrcgTypeVersionModel | view_entity | from | BASIC | Version Model for Product Sourcing Type |
| I_SourcingProjectType | view_entity | from | BASIC | Type of Sourcing Project |
| I_SPQtnTypeContactCatModel | view_entity | from | BASIC | Contact Category Model for SPQtn Type |
| I_SrcgProjCntctCatBySrcgType | view_entity | from | BASIC | Cntct Category Grps for Srcg Proj Types |
| I_SrcgProjFollowOnDocCat | view_entity | from | BASIC | Follow On Document Category in Srcg Proj |
| I_SrcgProjFollowOnDocType | view_entity | from | BASIC | Follow On Document Type in Sourcing Proj |
| I_SrcgProjTypeContactCatModel | view_entity | from | BASIC | Contact Category Model for SrcPrj Type |
| I_SrcgProjTypeMilestoneModel | view_entity | from | BASIC | Milestone Model for Sourcing Proj Type |
| I_SrcgProjTypePhaseModel | view_entity | from | BASIC | Phase Model for Sourcing Project Type |
Fields (9)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SourcingProjectType | SourcingProjectType | 12 |
| KEY | SrcgProjCancellationRsnGroup | SrcgProjCancellationRsnGroup | 1 |
| KEY | SrcgProjContactGroup | SrcgProjContactGroup | 2 |
| KEY | SrcgProjItemUnconfdDmndRsnGrp | SrcgProjItemUnconfdDmndRsnGrp | 1 |
| KEY | SrcgProjMilestoneGroup | SrcgProjMilestoneGroup | 1 |
| KEY | SrcgProjPhaseGroup | SrcgProjPhaseGroup | 1 |
| KEY | SrcgProjQtnItemExcludingRsnGrp | SrcgProjQtnItemExcludingRsnGrp | 1 |
| KEY | SrcgProjSuplrUnlockingRsnGroup | SrcgProjSuplrUnlockingRsnGroup | 1 |
| KEY | SrcgProjVersioningReasonGroup | SrcgProjVersioningReasonGroup | 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 Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SOURCINGPROJECTTYPE (
SOURCINGPROJECTTYPE,
SRCGPROJCANCELLATIONRSNGROUP,
SRCGPROJCONTACTGROUP,
SRCGPROJITEMUNCONFDDMNDRSNGRP,
SRCGPROJMILESTONEGROUP,
SRCGPROJPHASEGROUP,
SRCGPROJQTNITEMEXCLUDINGRSNGRP,
SRCGPROJSUPLRUNLOCKINGRSNGROUP,
SRCGPROJVERSIONINGREASONGROUP,
PRIMARY KEY (SOURCINGPROJECTTYPE, SRCGPROJCANCELLATIONRSNGROUP, SRCGPROJCONTACTGROUP, SRCGPROJITEMUNCONFDDMNDRSNGRP, SRCGPROJMILESTONEGROUP, SRCGPROJPHASEGROUP, SRCGPROJQTNITEMEXCLUDINGRSNGRP, SRCGPROJSUPLRUNLOCKINGRSNGROUP, SRCGPROJVERSIONINGREASONGROUP)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA