R_SupCosBrkTmplCndnTypeDraft

DDL: R_SUPCOSBRKTMPLCNDNTYPEDRAFT Type: view_entity BASIC Package: VDM_MM_PUR_SUPLRCOSTBRKDWNTMPL
12 Fields 1 Data Sources 3 Associations

Condition type for Suplr CBDT - Draft

R_SupCosBrkTmplCndnTypeDraft is a Basic CDS View that provides data about "Condition type for Suplr CBDT - Draft" in SAP S/4HANA. It reads from 1 data source (mmsuplrcbtcndn_d) and exposes 12 fields with key field SuplrCostBrkdwnTmplCndnUUID. It has 3 associations to related views. Part of development package VDM_MM_PUR_SUPLRCOSTBRKDWNTMPL.

Data Sources (1)

SourceAliasJoin Type
mmsuplrcbtcndn_d mmsuplrcbtcndn_d from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_SuplrCostBreakdownTemplate _SuplrCostBreakdownTemplate $projection.SuplrCostBreakdownTemplateUUID = _SuplrCostBreakdownTemplate.SuplrCostBreakdownTemplateUUID
[0..1] I_SupCosBrkTmplCndnTypeVH _SupCosBrkTmplCndnTypeText $projection.SuplrCostBrkdwnTmplCndnType = _SupCosBrkTmplCndnTypeText.ConditionType
[1..1] E_SupCosBrkTmplCndnTypeDraft _Extension $projection.SuplrCostBrkdwnTmplCndnUUID = _Extension.SuplrCostBrkdwnTmplCndnUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Condition type for Suplr CBDT - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SuplrCostBrkdwnTmplCndnUUID suplrcostbrkdwntmplcndnuuid Sourcing Project UUID
SuplrCostBrkdwnTmplCndnType suplrcostbrkdwntmplcndntype Condition Type
SuplrCostBreakdownTemplateUUID suplrcostbreakdowntemplateuuid SUPLRCBDTUUID
IsDeleted isdeleted TRUE
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_SuplrCostBreakdownTemplate _SuplrCostBreakdownTemplate
_SupCosBrkTmplCndnTypeText _SupCosBrkTmplCndnTypeText

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 R_SupCosBrkTmplCndnTypeDraft.
-- 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 R_SupCosBrkTmplCndnTypeDraft AS
SELECT
  SuplrCostBrkdwnTmplCndnUUID,
  SuplrCostBrkdwnTmplCndnType,
  SuplrCostBreakdownTemplateUUID,
  IsDeleted,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM mmsuplrcbtcndn_d
LEFT OUTER JOIN R_SuplrCostBreakdownTemplate AS _SuplrCostBreakdownTemplate ON SuplrCostBreakdownTemplateUUID = _SuplrCostBreakdownTemplate.SuplrCostBreakdownTemplateUUID  -- association [1..1]
LEFT OUTER JOIN I_SupCosBrkTmplCndnTypeVH AS _SupCosBrkTmplCndnTypeText ON SuplrCostBrkdwnTmplCndnType = _SupCosBrkTmplCndnTypeText.ConditionType  -- association [0..1]
LEFT OUTER JOIN E_SupCosBrkTmplCndnTypeDraft AS _Extension ON SuplrCostBrkdwnTmplCndnUUID = _Extension.SuplrCostBrkdwnTmplCndnUUID  -- association [1..1]
;

Learn More