C_DFS_AssgmtJobStmntTP

DDL: C_DFS_ASSGMTJOBSTMNTTP SQL: CDFSASSGMTJOBST Type: view CONSUMPTION
18 Fields 1 Data Sources 2 Associations

Capability and Job to Statement Assignment

C_DFS_AssgmtJobStmntTP is a Consumption CDS View that provides data about "Capability and Job to Statement Assignment" in SAP S/4HANA. It reads from 1 data source (I_DFS_UniversalAssignmentSubTP) and exposes 18 fields with key field DfsAssgmtSubUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_UniversalAssignmentSubTP _UniversalAssignmentSubTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_DFS_AssgmtCapbltObjToJobTP _AssgmtCapbltObjToJobTP $projection.DfsAssgmtUUID = _AssgmtCapbltObjToJobTP.DfsAssgmtUUID
[1..1] C_DFS_AssgmtCapbltCodeStmntVH _AssgmtCapbltCodeStmntVH $projection.DfsCapabilityObjectID = _AssgmtCapbltCodeStmntVH.DfsCapabilityObjectID and $projection.DfsCapabilityStatementID = _AssgmtCapbltCodeStmntVH.DfsCapabilityStatementID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CDFSASSGMTJOBST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capability and Job to Statement Assignment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DfsAssgmtSubUUID DfsAssgmtSubUUID Assigment GUID
DfsAssgmtUUID DfsAssgmtUUID Assigment GUID
DfsCapabilityObjectID DfsCapabilityObjectID Capability ID
DfsJobID _AssgmtCapbltObjToJobTP DfsJobID Object ID
DfsJobName _AssgmtCapbltObjToJobTP DfsJobName
DfsCapabilityStatementUUID _AssgmtCapbltCodeStmntVH DfsCapabilityStatementUUID Cap Stmnt UUID
DfsCapabilityStatementID DfsCapabilityStatementID Statement ID
DfsCapbltStmntDesc _AssgmtCapbltCodeStmntVH DfsCapbltStmntDesc Capability Statement
DfsCapbltStmntSqncNmbr _AssgmtCapbltCodeStmntVH DfsCapbltStmntSqncNmbr Sequence Number
DfsCapbltStmntTypeName _AssgmtCapbltCodeStmntVH DfsCapbltStmntTypeName Cap Stat Type Name
DfsCapabilityVarGrpName _AssgmtCapbltCodeStmntVH DfsCapabilityVarGrpName Cap Variant Group
DfsAssgmtSourceType _UniversalAssignmentTP DfsAssgmtSourceType Source Object Type
DfsAssgmtType _UniversalAssignmentTP DfsAssgmtType Assignment Type
DfsAssgmtStatusCode _UniversalAssignmentTP DfsAssgmtStatusCode Status
_AssgmtCapbltObjToJobTP _AssgmtCapbltObjToJobTP
_AssgmtCapbltCodeStmntVH _AssgmtCapbltCodeStmntVH
_AssignmentType _UniversalAssignmentTP _AssignmentType
_JobVH _AssgmtCapbltObjToJobTP _JobVH

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 C_DFS_AssgmtJobStmntTP.
-- 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: CDFSASSGMTJOBST

CREATE VIEW C_DFS_AssgmtJobStmntTP AS
SELECT
  DfsAssgmtSubUUID,
  DfsAssgmtUUID,
  DfsCapabilityObjectID,
  _AssgmtCapbltObjToJobTP.DfsJobID AS DfsJobID,
  _AssgmtCapbltObjToJobTP.DfsJobName AS DfsJobName,
  _AssgmtCapbltCodeStmntVH.DfsCapabilityStatementUUID AS DfsCapabilityStatementUUID,
  DfsCapabilityStatementID,
  _AssgmtCapbltCodeStmntVH.DfsCapbltStmntDesc AS DfsCapbltStmntDesc,
  _AssgmtCapbltCodeStmntVH.DfsCapbltStmntSqncNmbr AS DfsCapbltStmntSqncNmbr,
  _AssgmtCapbltCodeStmntVH.DfsCapbltStmntTypeName AS DfsCapbltStmntTypeName,
  _AssgmtCapbltCodeStmntVH.DfsCapabilityVarGrpName AS DfsCapabilityVarGrpName,
  _UniversalAssignmentTP.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  _UniversalAssignmentTP.DfsAssgmtType AS DfsAssgmtType,
  _UniversalAssignmentTP.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  _UniversalAssignmentTP._AssignmentType AS _AssignmentType,
  _AssgmtCapbltObjToJobTP._JobVH AS _JobVH
FROM I_DFS_UniversalAssignmentSubTP AS _UniversalAssignmentSubTP
LEFT OUTER JOIN C_DFS_AssgmtCapbltObjToJobTP AS _AssgmtCapbltObjToJobTP ON DfsAssgmtUUID = _AssgmtCapbltObjToJobTP.DfsAssgmtUUID  -- association [1..1]
LEFT OUTER JOIN C_DFS_AssgmtCapbltCodeStmntVH AS _AssgmtCapbltCodeStmntVH ON DfsCapabilityObjectID = _AssgmtCapbltCodeStmntVH.DfsCapabilityObjectID AND DfsCapabilityStatementID = _AssgmtCapbltCodeStmntVH.DfsCapabilityStatementID  -- association [1..1]
;

Learn More