R_SpecCompositionDateIndep

DDL: R_SPECCOMPOSITIONDATEINDEP SQL: RSPCCMPDATEINDEP Type: view COMPOSITE
39 Fields 4 Data Sources 1 Associations

Spec Value Assignment Instance with Comp Date Independent

R_SpecCompositionDateIndep is a Composite CDS View that provides data about "Spec Value Assignment Instance with Comp Date Independent" in SAP S/4HANA. It reads from 4 data sources (I_SpecValAssgmtItem, I_SpecValAssgmtHeader, I_SpecValAssgmtUsage, I_SpecValAssgmt) and exposes 39 fields with key fields SpecValAssgmtHdr, SpecValAssgmt, ComponentSpecificationIntID, SpecificationInternalID, SpecValAssgmtChangeState. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_SpecValAssgmtItem comp inner
I_SpecValAssgmtHeader header from
I_SpecValAssgmtUsage usage inner
I_SpecValAssgmt va inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName RSPCCMPDATEINDEP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Spec Value Assignment Instance with Comp Date Independent view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY SpecValAssgmtHdr I_SpecValAssgmtHeader SpecValAssgmtHdr Unique ID No.
KEY SpecValAssgmt I_SpecValAssgmt SpecValAssgmt Unique ID No.
KEY ComponentSpecificationIntID I_SpecValAssgmtItem ComponentSpecificationIntID Component ID
KEY SpecificationInternalID I_SpecValAssgmtHeader SpecificationInternalID Specification
KEY SpecValAssgmtChangeState I_SpecValAssgmt SpecValAssgmtChangeState GUID number
KEY SpecificationRating I_SpecValAssgmtUsage SpecificationRating Rating
KEY SpecificationValidityArea I_SpecValAssgmtUsage SpecificationValidityArea Validity Area
SpecValAssgmtType I_SpecValAssgmtHeader SpecValAssgmtType Val. Asst Type
SpecValAssgmtHdrIsDeleted I_SpecValAssgmtHeader SpecValAssgmtHdrIsDeleted DID
SpecValAssgmtValidityStartDate I_SpecValAssgmt SpecValAssgmtValidityStartDate Valid From
SpecValAssgmtValidityEndDate I_SpecValAssgmt SpecValAssgmtValidityEndDate Valid To
SpecValAssgmtChangeNumber I_SpecValAssgmt SpecValAssgmtChangeNumber Change Number
SpecValAssgmtCreationDate I_SpecValAssgmt SpecValAssgmtCreationDate Generation Time
SpecValAssgmtCreatedByUser I_SpecValAssgmt SpecValAssgmtCreatedByUser Requester
SpecValAssgmtLastChangeDate I_SpecValAssgmt SpecValAssgmtLastChangeDate Changed On
SpecValAssgmtLastChangedByUser I_SpecValAssgmt SpecValAssgmtLastChangedByUser User Name
SpecValAssgmtSortSequence I_SpecValAssgmt SpecValAssgmtSortSequence Sort Order
SpecValAssgmtUnitRefDimension I_SpecValAssgmt SpecValAssgmtUnitRefDimension Reference Value
SpecValAssgmtIsInhtncSource I_SpecValAssgmt SpecValAssgmtIsInhtncSource Truth Value
InhtdSpecValAssgmtIsTmpChgd I_SpecValAssgmt InhtdSpecValAssgmtIsTmpChgd Truth Value
InhtdSpecValAssgmtIsPermChgd I_SpecValAssgmt InhtdSpecValAssgmtIsPermChgd Truth Value
SpecInheritanceTemplate I_SpecValAssgmt SpecInheritanceTemplate Record number
SpecValAssgmtInheritanceParent I_SpecValAssgmt SpecValAssgmtInheritanceParent Record number
SpecValAssgmtInheritanceRoot I_SpecValAssgmt SpecValAssgmtInheritanceRoot Record number
SpecValAssgmtRootSpecIntID I_SpecValAssgmt SpecValAssgmtRootSpecIntID Record number
SpecValAssgmtIsDeleted I_SpecValAssgmt SpecValAssgmtIsDeleted DID
SpecValAssgmtUsageIsExcluded I_SpecValAssgmtUsage SpecValAssgmtUsageIsExcluded
SpecValAssgmtUsageIsRelevant I_SpecValAssgmtUsage SpecValAssgmtUsageIsRelevant
CompSpecComponentType I_SpecValAssgmtItem CompSpecComponentType Component Type
SpecValAssgmtItem I_SpecValAssgmtItem SpecValAssgmtItem Unique ID No.
SpecValAssgmtItemChangeState I_SpecValAssgmtItem SpecValAssgmtItemChangeState GUID number
CompSpecQuantity I_SpecValAssgmtItem CompSpecQuantity Value
CompSpecUnit I_SpecValAssgmtItem CompSpecUnit Unit of measure
CompSpecExceptionCode I_SpecValAssgmtItem CompSpecExceptionCode Exception value
CompSpecLowerLimitOperator I_SpecValAssgmtItem CompSpecLowerLimitOperator OpLowLimit
CompSpecLowerLimit I_SpecValAssgmtItem CompSpecLowerLimit Lower limit
CompSpecUpperLimitOperator I_SpecValAssgmtItem CompSpecUpperLimitOperator OpUppLimit
CompSpecUpperLimit I_SpecValAssgmtItem CompSpecUpperLimit Upper limit
_SpecificationForKeyDate _SpecificationForKeyDate

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_SpecCompositionDateIndep.
-- 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: RSPCCMPDATEINDEP

CREATE VIEW R_SpecCompositionDateIndep AS
SELECT
  header.SpecValAssgmtHdr AS SpecValAssgmtHdr,
  va.SpecValAssgmt AS SpecValAssgmt,
  comp.ComponentSpecificationIntID AS ComponentSpecificationIntID,
  header.SpecificationInternalID AS SpecificationInternalID,
  va.SpecValAssgmtChangeState AS SpecValAssgmtChangeState,
  usage.SpecificationRating AS SpecificationRating,
  usage.SpecificationValidityArea AS SpecificationValidityArea,
  header.SpecValAssgmtType AS SpecValAssgmtType,
  header.SpecValAssgmtHdrIsDeleted AS SpecValAssgmtHdrIsDeleted,
  va.SpecValAssgmtValidityStartDate AS SpecValAssgmtValidityStartDate,
  va.SpecValAssgmtValidityEndDate AS SpecValAssgmtValidityEndDate,
  va.SpecValAssgmtChangeNumber AS SpecValAssgmtChangeNumber,
  va.SpecValAssgmtCreationDate AS SpecValAssgmtCreationDate,
  va.SpecValAssgmtCreatedByUser AS SpecValAssgmtCreatedByUser,
  va.SpecValAssgmtLastChangeDate AS SpecValAssgmtLastChangeDate,
  va.SpecValAssgmtLastChangedByUser AS SpecValAssgmtLastChangedByUser,
  va.SpecValAssgmtSortSequence AS SpecValAssgmtSortSequence,
  va.SpecValAssgmtUnitRefDimension AS SpecValAssgmtUnitRefDimension,
  va.SpecValAssgmtIsInhtncSource AS SpecValAssgmtIsInhtncSource,
  va.InhtdSpecValAssgmtIsTmpChgd AS InhtdSpecValAssgmtIsTmpChgd,
  va.InhtdSpecValAssgmtIsPermChgd AS InhtdSpecValAssgmtIsPermChgd,
  va.SpecInheritanceTemplate AS SpecInheritanceTemplate,
  va.SpecValAssgmtInheritanceParent AS SpecValAssgmtInheritanceParent,
  va.SpecValAssgmtInheritanceRoot AS SpecValAssgmtInheritanceRoot,
  va.SpecValAssgmtRootSpecIntID AS SpecValAssgmtRootSpecIntID,
  va.SpecValAssgmtIsDeleted AS SpecValAssgmtIsDeleted,
  usage.SpecValAssgmtUsageIsExcluded AS SpecValAssgmtUsageIsExcluded,
  usage.SpecValAssgmtUsageIsRelevant AS SpecValAssgmtUsageIsRelevant,
  comp.CompSpecComponentType AS CompSpecComponentType,
  comp.SpecValAssgmtItem AS SpecValAssgmtItem,
  comp.SpecValAssgmtItemChangeState AS SpecValAssgmtItemChangeState,
  comp.CompSpecQuantity AS CompSpecQuantity,
  comp.CompSpecUnit AS CompSpecUnit,
  comp.CompSpecExceptionCode AS CompSpecExceptionCode,
  comp.CompSpecLowerLimitOperator AS CompSpecLowerLimitOperator,
  comp.CompSpecLowerLimit AS CompSpecLowerLimit,
  comp.CompSpecUpperLimitOperator AS CompSpecUpperLimitOperator,
  comp.CompSpecUpperLimit AS CompSpecUpperLimit
FROM I_SpecValAssgmtHeader AS header
INNER JOIN I_SpecValAssgmt AS va ON /* join condition not captured in parsed metadata */
INNER JOIN I_SpecValAssgmtUsage AS usage ON /* join condition not captured in parsed metadata */
INNER JOIN I_SpecValAssgmtItem AS comp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SpecificationForKeyDate AS _SpecificationForKeyDate ON SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID  -- association [0..1]
;

Learn More