P_SpecValAssgmtWithHeader

DDL: P_SPECVALASSGMTWITHHEADER SQL: PSPECVAHDR Type: view COMPOSITE
24 Fields 2 Data Sources

P_SpecValAssgmtWithHeader is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SpecValAssgmtHeader, I_SpecValAssgmt) and exposes 24 fields with key fields SpecValAssgmtHdr, SpecValAssgmt.

Data Sources (2)

SourceAliasJoin Type
I_SpecValAssgmtHeader header from
I_SpecValAssgmt va inner

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSPECVAHDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SpecValAssgmtHdr I_SpecValAssgmtHeader SpecValAssgmtHdr Unique ID No.
KEY SpecValAssgmt I_SpecValAssgmt SpecValAssgmt Unique ID No.
SpecificationInternalID I_SpecValAssgmtHeader SpecificationInternalID Specification
SpecValAssgmtType I_SpecValAssgmtHeader SpecValAssgmtType Val. Asst Type
SpecValAssgmtHdrIsDeleted I_SpecValAssgmtHeader SpecValAssgmtHdrIsDeleted DID
SpecValAssgmtChangeState I_SpecValAssgmt SpecValAssgmtChangeState GUID number
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
_ValueAssignmentType _ValueAssignmentType

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 P_SpecValAssgmtWithHeader.
-- 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: PSPECVAHDR
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_SpecValAssgmtWithHeader AS
SELECT
  header.SpecValAssgmtHdr AS SpecValAssgmtHdr,
  va.SpecValAssgmt AS SpecValAssgmt,
  header.SpecificationInternalID AS SpecificationInternalID,
  header.SpecValAssgmtType AS SpecValAssgmtType,
  header.SpecValAssgmtHdrIsDeleted AS SpecValAssgmtHdrIsDeleted,
  va.SpecValAssgmtChangeState AS SpecValAssgmtChangeState,
  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
FROM I_SpecValAssgmtHeader AS header
INNER JOIN I_SpecValAssgmt AS va ON /* join condition not captured in parsed metadata */
;

Learn More