C_FlxMtPlObjVarAccogPartProdTP

DDL: C_FLXMTPLOBJVARACCOGPARTPRODTP SQL: CFMPOACCPPRODTP Type: view CONSUMPTION
25 Fields 1 Data Sources 5 Associations

List of Accompanying Parts (Products)

C_FlxMtPlObjVarAccogPartProdTP is a Consumption CDS View that provides data about "List of Accompanying Parts (Products)" in SAP S/4HANA. It reads from 1 data source (I_FlxMtPlObjVarAccogPartProdTP) and exposes 25 fields with key field FlxMtPlObjVariantAccogPrtUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FlxMtPlObjVarAccogPartProdTP _AccPartsProdTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_FlxMtPlObjTP _HeaderTP $projection.FlxblMatlPlngObjectUUID = _HeaderTP.FlxblMatlPlngObjectUUID
[1..1] C_FlxMtPlObjVariantTP _VariantTP $projection.FlxblMatlPlngObjVariantUUID = _VariantTP.FlxblMatlPlngObjVariantUUID
[1..1] I_Product _ProductUnit $projection.Product = _ProductUnit.Product
[0..1] C_FlxMtPlObjVarAccogPrtIndVH _FlxMtPlObjVarAccogPrtIndVH $projection.FlxMtPlObjVarAccogPartAssgmt = _FlxMtPlObjVarAccogPrtIndVH.FlxMtPlObjVarAccogPartAssgmt
[1..1] I_ProductVH _ProductVH $projection.Product = _ProductVH.Product

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFMPOACCPPRODTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label List of Accompanying Parts (Products) view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.semanticKey FlxMtPlObjVarAccogPartItem view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY FlxMtPlObjVariantAccogPrtUUID FlxMtPlObjVariantAccogPrtUUID Accompaniment Guid
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID Variant UUID
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID FMPO UUID
FlxMtPlObjVarAccogPartItem FlxMtPlObjVarAccogPartItem Accompaniment ID
Product Product Product Sold
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
MaintenanceStatus _ProductType MaintenanceStatus Maint. status
FlxMtPlObjVarAccogPrtInitQty FlxMtPlObjVarAccogPrtInitQty Initial Requirement
FlxMtPlObjVarAccogPartAssgmt FlxMtPlObjVarAccogPartAssgmt Assignment Indicator
MaterialName _MaterialText MaterialName Material Description
BaseUnit _ProductUnit BaseUnit Unit of Measure
PurchaseOrderQuantityUnit _ProductUnit PurchaseOrderQuantityUnit Order Unit
ProductGroup _ProductUnit ProductGroup Product Sold Group
ExternalProductGroup _ProductUnit ExternalProductGroup Ext. prod group
_HeaderTP _HeaderTP
_VariantTP _VariantTP
_ProductVH _ProductVH
_MaterialText _MaterialText
_ProductUnit _ProductUnit
_ProductGroup _ProductUnit _ProductGroup
_BaseUnitOfMeasure _ProductUnit _BaseUnitOfMeasure
_ExternalProductGroup _ProductUnit _ExternalProductGroup
_FlxMtPlObjVarAccogPrtIndVH _FlxMtPlObjVarAccogPrtIndVH
MaterialType I_FlxMtPlObjVarAccogPartProdTP MaterialType Material Type
_ProductType I_FlxMtPlObjVarAccogPartProdTP _ProductType

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_FlxMtPlObjVarAccogPartProdTP.
-- 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: CFMPOACCPPRODTP

CREATE VIEW C_FlxMtPlObjVarAccogPartProdTP AS
SELECT
  FlxMtPlObjVariantAccogPrtUUID,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  FlxMtPlObjVarAccogPartItem,
  Product,
  ReorderThresholdQuantity,
  _ProductType.MaintenanceStatus AS MaintenanceStatus,
  FlxMtPlObjVarAccogPrtInitQty,
  FlxMtPlObjVarAccogPartAssgmt,
  _MaterialText.MaterialName AS MaterialName,
  _ProductUnit.BaseUnit AS BaseUnit,
  _ProductUnit.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _ProductUnit.ProductGroup AS ProductGroup,
  _ProductUnit.ExternalProductGroup AS ExternalProductGroup,
  _ProductUnit._ProductGroup AS _ProductGroup,
  _ProductUnit._BaseUnitOfMeasure AS _BaseUnitOfMeasure,
  _ProductUnit._ExternalProductGroup AS _ExternalProductGroup,
  _AccPartsProdTP.MaterialType AS MaterialType,
  _AccPartsProdTP._ProductType AS _ProductType
FROM I_FlxMtPlObjVarAccogPartProdTP AS _AccPartsProdTP
LEFT OUTER JOIN C_FlxMtPlObjTP AS _HeaderTP ON FlxblMatlPlngObjectUUID = _HeaderTP.FlxblMatlPlngObjectUUID  -- association [1..1]
LEFT OUTER JOIN C_FlxMtPlObjVariantTP AS _VariantTP ON FlxblMatlPlngObjVariantUUID = _VariantTP.FlxblMatlPlngObjVariantUUID  -- association [1..1]
LEFT OUTER JOIN I_Product AS _ProductUnit ON Product = _ProductUnit.Product  -- association [1..1]
LEFT OUTER JOIN C_FlxMtPlObjVarAccogPrtIndVH AS _FlxMtPlObjVarAccogPrtIndVH ON FlxMtPlObjVarAccogPartAssgmt = _FlxMtPlObjVarAccogPrtIndVH.FlxMtPlObjVarAccogPartAssgmt  -- association [0..1]
LEFT OUTER JOIN I_ProductVH AS _ProductVH ON Product = _ProductVH.Product  -- association [1..1]
;

Learn More