I_SpecAssignedMatlForKeyDate

DDL: I_SPECASSIGNEDMATLFORKEYDATE SQL: ISPECMATASSGMTKD Type: view COMPOSITE
20 Fields 1 Data Sources 1 Associations

Specification Material Assignment for Key Date

I_SpecAssignedMatlForKeyDate is a Composite CDS View that provides data about "Specification Material Assignment for Key Date" in SAP S/4HANA. It reads from 1 data source (I_SpecAssignedMaterial) and exposes 20 fields with key fields SpecMaterialAssgmtInternalID, SpecMaterialAssgmtChangeState. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SpecAssignedMaterial I_SpecAssignedMaterial from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECMATASSGMTKD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Specification Material Assignment for Key Date view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SpecMaterialAssgmtInternalID SpecMaterialAssgmtInternalID Unique ID No.
KEY SpecMaterialAssgmtChangeState SpecMaterialAssgmtChangeState GUID number
SpecificationInternalID SpecificationInternalID Specification
SpecMatlAssgmtValdtyStartDate SpecMatlAssgmtValdtyStartDate Valid From
SpecMatlAssgmtValdtyEndDate SpecMatlAssgmtValdtyEndDate Valid To
SpecMaterialAssgmtChangeNumber SpecMaterialAssgmtChangeNumber Change Number
SpecMaterialAssgmtIsDeleted SpecMaterialAssgmtIsDeleted DID
SpecMaterialAssgmtCreationDate SpecMaterialAssgmtCreationDate Generation Time
SpecMaterialAssgmtCreatedByUsr SpecMaterialAssgmtCreatedByUsr Requester
SpecMaterialAssgmtChangeDate SpecMaterialAssgmtChangeDate Changed On
SpecMatlAssgmtLastChangedByUsr SpecMatlAssgmtLastChangedByUsr User Name
Plant Plant Valuation Area
Material Material Vehicle Model
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Product _Product
_Material _Material
_MaterialPlant _MaterialPlant
_SpecificationForKeyDate _SpecificationForKeyDate
_MaterialText _MaterialText

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 I_SpecAssignedMatlForKeyDate.
-- 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: ISPECMATASSGMTKD
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_SpecAssignedMatlForKeyDate AS
SELECT
  SpecMaterialAssgmtInternalID,
  SpecMaterialAssgmtChangeState,
  SpecificationInternalID,
  SpecMatlAssgmtValdtyStartDate,
  SpecMatlAssgmtValdtyEndDate,
  SpecMaterialAssgmtChangeNumber,
  SpecMaterialAssgmtIsDeleted,
  SpecMaterialAssgmtCreationDate,
  SpecMaterialAssgmtCreatedByUsr,
  SpecMaterialAssgmtChangeDate,
  SpecMatlAssgmtLastChangedByUsr,
  Plant,
  Material
FROM I_SpecAssignedMaterial
LEFT OUTER JOIN I_SpecificationForKeyDate AS _SpecificationForKeyDate ON SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID  -- association [1..1]
;

Learn More