RFM_PP_MBOMConstcyChkHdrBsc

DDL: RFM_PP_MBOMCONSTCYCHKHDRDETS Type: view Package: FSH_PP_BD

BOM Header Details

RFM_PP_MBOMConstcyChkHdrBsc is a CDS View that provides data about "BOM Header Details" in SAP S/4HANA. It reads from 1 data source (stko) and exposes 13 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BOMHeaderInternalChangeCount. Part of development package FSH_PP_BD.

Data Sources (1)

SourceAliasJoin Type
stko _MBOMConstcyChkHdrBsc from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName RFMPPMATLBOMHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stko stlty Single-Character Flag
KEY BillOfMaterial stko stlnr BOM
KEY BillOfMaterialVariant stko stlal AlternativeBOM
KEY BOMHeaderInternalChangeCount stko stkoz Counter
HeaderEngineeringChgNmbrDoc stko aennr Change Number
BOMHeaderQuantityInBaseUnit stko bmeng Quantity
BOMHeaderBaseUnit stko bmein Unit 'piece'
HeaderValidityStartDate stko datuv Valid-from date
IsImplicitlyDeleted stko lkenz Deletion Ind.
BOMIsMarkedForDeletion stko loekz Status
BOMHeaderPreviousCounter stko vgkzl Prev hdr countr
BOMAlternativeText stko stktx Alt Text
BillOfMaterialStatus stko stlst Order level

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 RFM_PP_MBOMConstcyChkHdrBsc.
-- 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 RFM_PP_MBOMConstcyChkHdrBsc AS
SELECT
  _MBOMConstcyChkHdrBsc.stlty AS BillOfMaterialCategory,
  _MBOMConstcyChkHdrBsc.stlnr AS BillOfMaterial,
  _MBOMConstcyChkHdrBsc.stlal AS BillOfMaterialVariant,
  _MBOMConstcyChkHdrBsc.stkoz AS BOMHeaderInternalChangeCount,
  _MBOMConstcyChkHdrBsc.aennr AS HeaderEngineeringChgNmbrDoc,
  _MBOMConstcyChkHdrBsc.bmeng AS BOMHeaderQuantityInBaseUnit,
  _MBOMConstcyChkHdrBsc.bmein AS BOMHeaderBaseUnit,
  _MBOMConstcyChkHdrBsc.datuv AS HeaderValidityStartDate,
  _MBOMConstcyChkHdrBsc.lkenz AS IsImplicitlyDeleted,
  _MBOMConstcyChkHdrBsc.loekz AS BOMIsMarkedForDeletion,
  _MBOMConstcyChkHdrBsc.vgkzl AS BOMHeaderPreviousCounter,
  _MBOMConstcyChkHdrBsc.stktx AS BOMAlternativeText,
  _MBOMConstcyChkHdrBsc.stlst AS BillOfMaterialStatus
FROM stko AS _MBOMConstcyChkHdrBsc
;