C_InternalOrderQ0001

DDL: C_INTERNALORDERQ0001 SQL: CFIINTORDERQ0001 Type: view CONSUMPTION

Internal Order

C_InternalOrderQ0001 is a Consumption CDS View that provides data about "Internal Order" in SAP S/4HANA. It reads from 1 data source (I_InternalOrder) and exposes 30 fields with key field InternalOrder.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_InternalOrder I_InternalOrder from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_KeyDate sydatum

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFIINTORDERQ0001 view
EndUserText.label Internal Order view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey InternalOrder view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder InternalOrder
InternalOrderDescription InternalOrderDescription
OrderCategory OrderCategory
BusinessArea BusinessArea
ControllingArea ControllingArea
Plant Plant
Currency Currency
IsStatisticalOrder IsStatisticalOrder
ReferenceOrder ReferenceOrder
IsDeleted IsDeleted
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
LastChangeTime LastChangeTime
ControllingObject ControllingObject
CompanyCode CompanyCode
ProfitCenter ProfitCenter
FunctionalArea FunctionalArea
ControllingObjectClass ControllingObjectClass
OrderType OrderType
ResponsibleCostCenter ResponsibleCostCenter
InternalOrderResponsibleUser InternalOrderResponsibleUser
CompanyCodeName _CompanyCode CompanyCodeName
ProfitCenterName
FunctionalAreaName
ControllingObjectClassName
OrderTypeName
CostCenterDescription
PersonFullName _User UserDescription
StatusName 
@AbapCatalog.sqlViewName: 'CFIINTORDERQ0001'
@EndUserText.label: 'Internal Order'
@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'InternalOrder'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true


define view C_InternalOrderQ0001
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language        : sylangu,
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate         : sydatum

  as select from I_InternalOrder

{
  key InternalOrder,

      InternalOrderDescription,
      OrderCategory,
      BusinessArea,
      ControllingArea,
      Plant,
      Currency,
      IsStatisticalOrder,
      ReferenceOrder,
      //  SalesOrder,

      //  SalesOrderItem,

      //  WBSElement,

      //  RequestingCostCenter,

      //  RequestingCompanyCode,

      //  RequestingOrder,

      //  Location,

      //  LocationPlant,

      //  ExternalOrderNumber,

      //  ActualPostedCostCenter,

      //  PlanningIsIntegrated,

      //  SettlementCostElement,

      //  CostCenter,

      //  GLAccount,

      //  InvestmentMeasureProfile,

      //  InvestmentObjectScale,

      //  InvestmentReason,

      //  EnvironmentalInvestmentReason,

      //  Applicant,

      //  ApplicantTelephoneNumber,

      //  ResponsiblePerson,

      //  EstimatedTotalOrderCost,

      //  ApplicationDate,

      //  WorkStart,

      //  WorkEnd,

      //  ProcessingGroup,

      //  Department,

      IsDeleted,
      CreationDate,
      CreatedByUser,
      LastChangedByUser,
      LastChangeTime,
      ControllingObject,
      CompanyCode,
      ProfitCenter,
      FunctionalArea,
      ControllingObjectClass,
      OrderType,
      ResponsibleCostCenter,
      InternalOrderResponsibleUser,

      _CompanyCode.CompanyCodeName,
      _ProfitCenter[1:ValidityEndDate   >= $parameters.P_KeyDate and
                      ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].ProfitCenterName,
      _FunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName,
      _ControllingObjectClass._Text[1:Language = $parameters.P_Language].ControllingObjectClassName,
      _InternalOrderType._Text[1:Language = $parameters.P_Language].OrderTypeName,
      //  _InternalOrderType.CommitmentManagementIsActive,

      //  _InternalOrderType.RevenuePostingIsAllowed,

      _CostCenter[1:ValidityEndDate   >= $parameters.P_KeyDate and
                    ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostCenterDescription,
      _User.UserDescription as PersonFullName,
      _SystemStatus._Text[1:Language = $parameters.P_Language].StatusName
}
         
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CONTROLLINGOBJECTCLASS",
"I_CONTROLLINGOBJECTCLASST",
"I_COSTCENTER",
"I_COSTCENTERTEXT",
"I_FUNCTIONALAREA",
"I_FUNCTIONALAREATEXT",
"I_INTERNALORDER",
"I_INTERNALORDERSYSTEMSTATUS",
"I_INTERNALORDERSYSTEMSTATUST",
"I_INTERNALORDERTYPE",
"I_INTERNALORDERTYPETEXT",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"I_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More