P_ActyTypesProdnRtgBooOpChgSt

DDL: P_ACTYTYPESPRODNRTGBOOOPCHGST SQL: PACTTYPPRBOCHST Type: view COMPOSITE
37 Fields 1 Data Sources

P_ActyTypesProdnRtgBooOpChgSt is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_BOOOperationChangeState) and exposes 37 fields with key fields BillOfOperationsVariant, BillOfOperationsSequence, BOOSqncOpAssgmtIntVersionCntr, BillOfOperationsType, BillOfOperationsGroup.

Data Sources (1)

SourceAliasJoin Type
I_BOOOperationChangeState I_BOOOperationChangeState from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PACTTYPPRBOCHST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BillOfOperationsSequence BillOfOperationsSequence Sequence
KEY BOOSqncOpAssgmtIntVersionCntr BOOSqncOpAssgmtIntVersionCntr
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
CostCtrActivityType1 CostCtrActivityType1 Activity Type
CostCtrActivityType2 CostCtrActivityType2 Activity Type
CostCtrActivityType3 CostCtrActivityType3 Activity Type
CostCtrActivityType4 CostCtrActivityType4 Activity Type
CostCtrActivityType5 CostCtrActivityType5 Activity Type
CostCtrActivityType6 CostCtrActivityType6 Activity Type
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
Operation Operation Transaction
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
OperationText OperationText Description
OperationControlProfile OperationControlProfile Control Key
OperationStandardTextCode OperationStandardTextCode Std Text Key
BillOfOperationsDesc
_WorkCenter _WorkCenter

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 P_ActyTypesProdnRtgBooOpChgSt.
-- 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: PACTTYPPRBOCHST

CREATE VIEW P_ActyTypesProdnRtgBooOpChgSt AS
SELECT
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOSqncOpAssgmtIntVersionCntr,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  CostCtrActivityType1,
  CostCtrActivityType2,
  CostCtrActivityType3,
  CostCtrActivityType4,
  CostCtrActivityType5,
  CostCtrActivityType6,
  ValidityStartDate,
  ValidityEndDate,
  Operation,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  Plant,
  _Plant.PlantName AS PlantName,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  OperationText,
  OperationControlProfile,
  OperationStandardTextCode,
  _BillOfOperations._BillOfOperationsChangeState.BillOfOperationsDesc AS BillOfOperationsDesc
FROM I_BOOOperationChangeState
;

Learn More