C_AdvncdSchedgPlngLog

DDL: C_ADVNCDSCHEDGPLNGLOG Type: view_entity CONSUMPTION

Planning Logs

C_AdvncdSchedgPlngLog is a Consumption CDS View that provides data about "Planning Logs" in SAP S/4HANA. It reads from 1 data source (I_AdvancedPlanningPlanningLog) and exposes 32 fields with key field AdvancedPlanningLogNumber.

Data Sources (1)

SourceAliasJoin Type
I_AdvancedPlanningPlanningLog I_AdvancedPlanningPlanningLog from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Planning Logs view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ObjectModel.query.implementedBy ABAP:CL_ASB_LOGS_QUERY view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY AdvancedPlanningLogNumber AdvancedPlanningLogNumber
SimulationSessionUUID SimulationSessionUUID Sim. Session
AdvncdPlngMsgTypeIcon AdvncdPlngMsgTypeIcon
AdvancedPlanningLogSearchText AdvancedPlanningLogSearchText
AdvncdPlngLgMsgVal AdvncdPlngLgMsgVal
AdvncdPlngLgCreationDateTime AdvncdPlngLgCreationDateTime Time Stamp
AdvncdPlngLgCrtedByName AdvncdPlngLgCrtedByName
PlanningVersionExternal PlanningVersionExternal
AdvncdPlngLogMsgType AdvncdPlngLogMsgType
AdvncdPlngLogMsgNumber AdvncdPlngLogMsgNumber
AdvncdPlngLogMsgClass AdvncdPlngLogMsgClass
AdvncdPlngLgMsgText AdvncdPlngLgMsgText
AdvncdPlngOrderInternalNumber AdvncdPlngOrderInternalNumber
AdvncdPlngLgLvlDet AdvncdPlngLgLvlDet
AdvncdPlngLgProbClTxt AdvncdPlngLgProbClTxt Problem Class
AdvncdPlngLgSortCritrnStr AdvncdPlngLgSortCritrnStr
AdvncdPlngLgMsgSrlNo AdvncdPlngLgMsgSrlNo
AdvncdPlngTransCodeText AdvncdPlngTransCodeText
AdvncdPlngHeuristicsID AdvncdPlngHeuristicsID
AdvancedPlanningProductName AdvancedPlanningProductName
AdvancedPlanningFilterLocation AdvancedPlanningFilterLocation
ProductionPlanner ProductionPlanner
AdvncdPlngRsceIsFinite AdvncdPlngRsceIsFinite
ResourcePlanner ResourcePlanner
AdvncdPlngStrgyPrflTxt AdvncdPlngStrgyPrflTxt Strategy Profile
AdvncdPlngResourceName AdvncdPlngResourceName Resource
AdvncdPlngPlngSgmtType AdvncdPlngPlngSgmtType Planning Segment Type
AdvncdPlngAccountAssgmtObj AdvncdPlngAccountAssgmtObj Account Assignment Object
ProductPlanningGroup ProductPlanningGroup Planning Group
AdvncdPlngUIHierParNde AdvncdPlngUIHierParNde
AdvncdPlngHierDstncFrmRootVal AdvncdPlngHierDstncFrmRootVal
AdvncdPlngUIHierDrillState AdvncdPlngUIHierDrillState

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_AdvncdSchedgPlngLog.
-- 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.

CREATE VIEW C_AdvncdSchedgPlngLog AS
SELECT
  AdvancedPlanningLogNumber,
  SimulationSessionUUID,
  AdvncdPlngMsgTypeIcon,
  AdvancedPlanningLogSearchText,
  AdvncdPlngLgMsgVal,
  AdvncdPlngLgCreationDateTime,
  AdvncdPlngLgCrtedByName,
  PlanningVersionExternal,
  AdvncdPlngLogMsgType,
  AdvncdPlngLogMsgNumber,
  AdvncdPlngLogMsgClass,
  AdvncdPlngLgMsgText,
  AdvncdPlngOrderInternalNumber,
  AdvncdPlngLgLvlDet,
  AdvncdPlngLgProbClTxt,
  AdvncdPlngLgSortCritrnStr,
  AdvncdPlngLgMsgSrlNo,
  AdvncdPlngTransCodeText,
  AdvncdPlngHeuristicsID,
  AdvancedPlanningProductName,
  AdvancedPlanningFilterLocation,
  ProductionPlanner,
  AdvncdPlngRsceIsFinite,
  ResourcePlanner,
  AdvncdPlngStrgyPrflTxt,
  AdvncdPlngResourceName,
  AdvncdPlngPlngSgmtType,
  AdvncdPlngAccountAssgmtObj,
  ProductPlanningGroup,
  AdvncdPlngUIHierParNde,
  AdvncdPlngHierDstncFrmRootVal,
  AdvncdPlngUIHierDrillState
FROM I_AdvancedPlanningPlanningLog
;