I_DFS_UniversalAssignmentSubTP

DDL: I_DFS_UNIVERSALASSIGNMENTSUBTP SQL: IDFSASSGMTSUBTP Type: view TRANSACTIONAL
14 Fields 1 Data Sources 1 Associations

TP Interface View for Sub Assignment

I_DFS_UniversalAssignmentSubTP is a Transactional CDS View that provides data about "TP Interface View for Sub Assignment" in SAP S/4HANA. It reads from 1 data source (I_DFS_UniversalAssignmentSub) and exposes 14 fields with key field DfsAssgmtSubUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_UniversalAssignmentSub I_DFS_UniversalAssignmentSub from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DFS_UniversalAssignmentTP _UniversalAssignmentTP $projection.DfsAssgmtUUID = _UniversalAssignmentTP.DfsAssgmtUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IDFSASSGMTSUBTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label TP Interface View for Sub Assignment view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.writeDraftPersistence DFS_ASSGMT_SUB_D view
ObjectModel.writeActivePersistence DFS_ASSGMT_SUB view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY DfsAssgmtSubUUID DfsAssgmtSubUUID Assigment GUID
DfsAssgmtUUID DfsAssgmtUUID Assigment GUID
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID Variant UUID
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID FMPO UUID
FlxMtPlObjVarAccogPartAssgmt FlxMtPlObjVarAccogPartAssgmt Assignment Indicator
FlxMtPlObjVarAccogPartItem FlxMtPlObjVarAccogPartItem Accompaniment ID
FlxMtPlObjVariantAccogPrtUUID FlxMtPlObjVariantAccogPrtUUID Accompaniment Guid
FlxMtPlObjVarAccogPrtRefObjID FlxMtPlObjVarAccogPrtRefObjID FMPO ID
FlxMtPlObjVarAccogPrtRefVarID FlxMtPlObjVarAccogPrtRefVarID Variant ID
FlxMtPlObjVarAccogPrtAuthzdVal FlxMtPlObjVarAccogPrtAuthzdVal Quantity
DfsCapabilityObjectID DfsCapabilityObjectID Capability ID
DfsCapabilityStatementID DfsCapabilityStatementID Statement ID
DfsAssgmtCorrectionValue DfsAssgmtCorrectionValue Adjustment Value
_UniversalAssignmentTP _UniversalAssignmentTP

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_DFS_UniversalAssignmentSubTP.
-- 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: IDFSASSGMTSUBTP

CREATE VIEW I_DFS_UniversalAssignmentSubTP AS
SELECT
  DfsAssgmtSubUUID,
  DfsAssgmtUUID,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  FlxMtPlObjVarAccogPartAssgmt,
  FlxMtPlObjVarAccogPartItem,
  FlxMtPlObjVariantAccogPrtUUID,
  FlxMtPlObjVarAccogPrtRefObjID,
  FlxMtPlObjVarAccogPrtRefVarID,
  FlxMtPlObjVarAccogPrtAuthzdVal,
  DfsCapabilityObjectID,
  DfsCapabilityStatementID,
  DfsAssgmtCorrectionValue
FROM I_DFS_UniversalAssignmentSub
LEFT OUTER JOIN I_DFS_UniversalAssignmentTP AS _UniversalAssignmentTP ON DfsAssgmtUUID = _UniversalAssignmentTP.DfsAssgmtUUID  -- association [1..1]
;

Learn More