Which CDS Views use P_SFONONTRCBLCOMPONENTASSEMBLY?

P_SFONONTRCBLCOMPONENTASSEMBLY is used by 3 CDS view(s), including: C_SFOAssldNonTrcblComponent, C_SFODsassldNonTrcblComponent, C_SFORetdNonTraceableMaterial.

How many fields does P_SFONONTRCBLCOMPONENTASSEMBLY have?

P_SFONONTRCBLCOMPONENTASSEMBLY has 38 fields. Key fields: OpActyNtwkElement, OpActyNtwkInstance, RecordType, Reservation, ReservationItem.

P_SFONONTRCBLCOMPONENTASSEMBLY

CDS View

P_SFONONTRCBLCOMPONENTASSEMBLY is a CDS View in S/4HANA. It contains 38 fields. 3 CDS views read from this table.

CDS Views using this table (3)

View	Type	Join	VDM	Description
C_SFOAssldNonTrcblComponent	view_entity	from	CONSUMPTION	SFO assembled non traceable component
C_SFODsassldNonTrcblComponent	view_entity	from	CONSUMPTION	SFO disassembled non traceable component
C_SFORetdNonTraceableMaterial	view_entity	from	CONSUMPTION	SFO returned non traceable material

Fields (38)

Key	Field	CDS Fields	Used in Views
KEY	OpActyNtwkElement	OpActyNtwkElement	3
KEY	OpActyNtwkInstance	OpActyNtwkInstance	3
KEY	RecordType	RecordType	3
KEY	Reservation	Reservation	3
KEY	ReservationItem	ReservationItem	3
	_Batch	_Batch	3
	_Material	_Material	3
	_StorageLocation	_StorageLocation	1
	Assembly	Assembly	3
	BillOfMaterialCategory	BillOfMaterialCategory	3
	BillOfMaterialInternalID	BillOfMaterialInternalID	3
	BillOfMaterialItemNumber	BillOfMaterialItemNumber	3
	BillOfMaterialVariant	BillOfMaterialVariant	3
	BillOfMaterialVersion	BillOfMaterialVersion	3
	BOMItem	BOMItem	3
	BOMItemCategory	BOMItemCategory	3
	BOMItemInternalChangeCount	BOMItemInternalChangeCount	3
	EffectivityParameterVariant	EffectivityParameterVariant	3
	EntryUnit	EntryUnit	3
	FormulaKey	FormulaKey	3
	InheritedNodeNumberForBOMItem	InheritedNodeNumberForBOMItem	3
	InheritedNodeNumberVersionBOM	InheritedNodeNumberVersionBOM	3
	MaterialBaseUnit	MaterialBaseUnit	3
	MaterialComponentQuantity	MaterialComponentQuantity	1
	MatlCompAssembleControl	MatlCompAssembleControl	3
	MfgOrderOperationText	MfgOrderOperationText	3
	OrderInternalID	OrderInternalID	3
	OrderOperationInternalID	OrderOperationInternalID	3
	Plant	Plant	3
	RequiredQuantityInBaseUnit	RequiredQuantityInBaseUnit	2
	ResvnItmWithdrawnQtyInBaseUnit	ResvnItmWithdrawnQtyInBaseUnit	1
	StorageLocation	StorageLocation	1
	VariableSizeComponentQuantity	VariableSizeComponentQuantity	3
	VariableSizeComponentUnit	VariableSizeComponentUnit	3
	VariableSizeDimension1	VariableSizeDimension1	3
	VariableSizeDimension2	VariableSizeDimension2	3
	VariableSizeDimension3	VariableSizeDimension3	3
	VariableSizeDimensionUnit	VariableSizeDimensionUnit	3

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_SFONonTrcblComponentAssembly

  as select from      P_SFONonTrcblCompByLdngResv   as SFONonTrcblCompByLdngResv
    inner to one join I_OpActyInstceComponentDetail as OpActyInstceComponentDetail on  OpActyInstceComponentDetail.OpActyNtwkInstance = SFONonTrcblCompByLdngResv.OpActyNtwkInstance
                                                                                   and OpActyInstceComponentDetail.OpActyNtwkElement  = SFONonTrcblCompByLdngResv.OpActyNtwkElement
                                                                                   and OpActyInstceComponentDetail.Reservation        = SFONonTrcblCompByLdngResv.Reservation
                                                                                   and OpActyInstceComponentDetail.ReservationItem    = SFONonTrcblCompByLdngResv.ReservationItem
                                                                                   and OpActyInstceComponentDetail.RecordType         = SFONonTrcblCompByLdngResv.RecordType

  association [0..1] to I_ReservationDocumentHeader as _Reservation               on  $projection.Reservation = _Reservation.Reservation
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance        on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OperationActivityInstance as _OperationActivityInstance on  $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OperationActivityInstance.OpActyNtwkElement
  association [0..1] to I_ProductPlantBasic         as _ProductPlantBasic         on  $projection.Material = _ProductPlantBasic.Product
                                                                                  and $projection.Plant    = _ProductPlantBasic.Plant
  association [1..1] to I_MatlCompAssembleControl   as _MatlCompAssembleControl   on  $projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl
  association [0..1] to I_BillOfMaterialItemBasic   as _BillOfMaterialItemBasic   on  $projection.BillOfMaterialCategory     = _BillOfMaterialItemBasic.BillOfMaterialCategory
                                                                                  and $projection.BillOfMaterialInternalID   = _BillOfMaterialItemBasic.BillOfMaterial
                                                                                  and $projection.BOMItem                    = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber
                                                                                  and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount
  association [0..1] to I_MfgBOMItemWithPhantomHier as _MfgBOMItemWithPhantomHier on  $projection.BillOfMaterialCategory   = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory
                                                                                  and $projection.BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial
                                                                                  and $projection.BillOfMaterialVariant    = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant
                                                                                  and $projection.BillOfMaterialVersion    = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion
                                                                                  and $projection.InheritedBOMItemNode     = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr
{
  key SFONonTrcblCompByLdngResv.Reservation                                                           as Reservation,
  key SFONonTrcblCompByLdngResv.ReservationItem                                                       as ReservationItem,
  key SFONonTrcblCompByLdngResv.RecordType                                                            as RecordType,
  key SFONonTrcblCompByLdngResv.OpActyNtwkInstance                                                    as OpActyNtwkInstance,
  key SFONonTrcblCompByLdngResv.OpActyNtwkElement                                                     as OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_Batch'
      OpActyInstceComponentDetail.Batch                                                               as Batch,
      OpActyInstceComponentDetail.Material                                                            as Material,
      @ObjectModel.foreignKey.association: '_Plant'
      OpActyInstceComponentDetail.Plant                                                               as Plant,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      OpActyInstceComponentDetail.StorageLocation                                                     as StorageLocation,
      OpActyInstceComponentDetail.MatlCompIsMarkedForBackflush                                        as MatlCompIsMarkedForBackflush,
      OpActyInstceComponentDetail.IsBulkMaterialComponent                                             as IsBulkMaterialComponent,
      cast(case
        when OpActyInstceComponentDetail.MatlCompIsMarkedForBackflush = 'X' then 4
        when OpActyInstceComponentDetail.IsBulkMaterialComponent = 'X' then 5
        end as mpe_comp_assemble_control preserving type)                                             as MatlCompAssembleControl,
      OpActyInstceComponentDetail.DebitCreditCode                                                     as DebitCreditCode,

      --Quantities
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      cast(OpActyInstceComponentDetail.RequiredQuantity as mpe_planned_qty preserving type )          as RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      OpActyInstceComponentDetail.RequiredQuantityInBaseUnit                                          as RequiredQuantityInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      SFONonTrcblCompByLdngResv.MaterialComponentQuantity                                             as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      SFONonTrcblCompByLdngResv.ResvnItmWithdrawnQtyInBaseUnit                                        as ResvnItmWithdrawnQtyInBaseUnit,
      OpActyInstceComponentDetail.BaseUnit                                                            as MaterialBaseUnit,
      OpActyInstceComponentDetail.EntryUnit                                                           as EntryUnit,

      -- Operation Activity Information
      @ObjectModel.foreignKey.association: '_ManufacturingOrder'
      OpActyInstceComponentDetail.ManufacturingOrder                                                  as ManufacturingOrder,
      cast(OpActyInstceComponentDetail.ManufacturingOrderOperation as mpe_vornr_char preserving type) as ManufacturingOrderOperation,
      OpActyInstceComponentDetail.MfgOrderOperationText                                               as MfgOrderOperationText,
      OpActyInstceComponentDetail.OrderInternalBillOfOperations                                       as OrderInternalID,
      OpActyInstceComponentDetail.OrderIntBillOfOperationsItem                                        as OrderOperationInternalID,
      SFONonTrcblCompByLdngResv._OpActyInstceNtwkElmntBasic.OpActyNtwkElementExternalID               as OpActyNtwkElementExternalID,
      SFONonTrcblCompByLdngResv._OpActyInstceNtwkElmntBasic.OpActyNtwkElementElement                  as OpActyNtwkElementElement,
      SFONonTrcblCompByLdngResv._OpActyInstceNtwkElmntBasic.OpActyNtwkElementElmntVersCntr            as OpActyNtwkElementElmntVersCntr,

      -- BOM Information
      OpActyInstceComponentDetail.BillOfMaterialItemNumber                                            as BillOfMaterialItemNumber,
      OpActyInstceComponentDetail.BillOfMaterialCategory                                              as BillOfMaterialCategory,
      cast( OpActyInstceComponentDetail.BillOfMaterialInternalID as mpe_exec_stnum preserving type )  as BillOfMaterialInternalID,
      OpActyInstceComponentDetail.BOMItem                                                             as BOMItem,
      OpActyInstceComponentDetail.BOMItemInternalChangeCount                                          as BOMItemInternalChangeCount,
      OpActyInstceComponentDetail.BillOfMaterialVariant                                               as BillOfMaterialVariant,
      OpActyInstceComponentDetail.BillOfMaterialVersion                                               as BillOfMaterialVersion,
      OpActyInstceComponentDetail.BOMItemCategory                                                     as BOMItemCategory,
      OpActyInstceComponentDetail.InheritedBOMItemNode                                                as InheritedBOMItemNode,
      OpActyInstceComponentDetail.EffectivityParameterVariant                                         as EffectivityParameterVariant,
      _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem                                          as InheritedNodeNumberForBOMItem,
      _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM                                          as InheritedNodeNumberVersionBOM,
      OpActyInstceComponentDetail.Assembly                                                            as Assembly,

      -- Variable-Size Item Fields
      OpActyInstceComponentDetail.MaterialCompIsVariableSized                                         as MaterialCompIsVariableSized,
      OpActyInstceComponentDetail.FormulaKey                                                          as FormulaKey,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension1                                              as VariableSizeDimension1,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension2                                              as VariableSizeDimension2,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension3                                              as VariableSizeDimension3,
      OpActyInstceComponentDetail.VariableSizeDimensionUnit                                           as VariableSizeDimensionUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      OpActyInstceComponentDetail.VariableSizeComponentQuantity                                       as VariableSizeComponentQuantity,
      OpActyInstceComponentDetail.VariableSizeComponentUnit                                           as VariableSizeComponentUnit,

      _Reservation,
      _OpActyNtwkInstance,
      _OperationActivityInstance,
      OpActyInstceComponentDetail._ManufacturingOrder,
      OpActyInstceComponentDetail._Batch,
      OpActyInstceComponentDetail._Material,
      OpActyInstceComponentDetail._Plant,
      OpActyInstceComponentDetail._StorageLocation,
      _ProductPlantBasic,
      _MatlCompAssembleControl,
      OpActyInstceComponentDetail._BOMItemCategory,
      SFONonTrcblCompByLdngResv._OpActyInstceNtwkElmntBasic._OperationActivityText,
      _MfgBOMItemWithPhantomHier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIALITEMBASIC",
"I_OPACTYINSTCECOMPONENTDETAIL",
"I_OPACTYINSTCENTWKELMNTBASIC",
"P_SFONONTRCBLCOMPBYLDNGRESV"
],
"ASSOCIATED":
[
"I_BATCH",
"I_BILLOFMATERIALITEMCATEGORY",
"I_MANUFACTURINGORDER",
"I_MATERIAL",
"I_MATLCOMPASSEMBLECONTROL",
"I_MFGBOMITEMWITHPHANTOMHIER",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_OPERATIONACTIVITYTEXT",
"I_PLANT",
"I_PRODUCTPLANTBASIC",
"I_RESERVATIONDOCUMENTHEADER",
"I_STORAGELOCATION"
],
"BASE":
[
"I_OPACTYINSTCECOMPONENTDETAIL",
"I_OPACTYINSTCENTWKELMNTBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_SFONONTRCBLCOMPONENTASSEMBLY

CDS Views using this table (3)

Fields (38)

Learn More