P_MFGORDLINKEDSAPOBJKEYRNGE

CDS View

Range for selection of Order Linked SAP Object Key

P_MFGORDLINKEDSAPOBJKEYRNGE is a CDS View in S/4HANA. Range for selection of Order Linked SAP Object Key. It contains 5 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MfgOrderDocInfoRecdObjLink view from COMPOSITE Mfg Order Document Info Record Object Link

Fields (5)

KeyField CDS FieldsUsed in Views
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
ManufacturingOrder ManufacturingOrder 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1 
@AbapCatalog.sqlViewName: 'PMFGORDDOCOBJRNG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view P_MfgOrdLinkedSAPObjKeyRnge
  as select from I_MfgOrderBasic as ord
{
  key ord.ManufacturingOrder                as ManufacturingOrder,
      ord.ManufacturingOrder                as LinkedSAPObjectKeyLow,
      concat( ord.ManufacturingOrder, 'Z' ) as LinkedSAPObjectKeyHigh,
      @ObjectModel.foreignKey.association: '_MfgOrderCategory'
      ord.ManufacturingOrderCategory,
      @ObjectModel.foreignKey.association: '_MfgOrderType'
      ord.ManufacturingOrderType,

      _MfgOrderCategory,
      _MfgOrderType
}

Learn More