I_BillOfMaterialTP_2

DDL: I_BILLOFMATERIALTP_2 Type: view_entity TRANSACTIONAL
44 Fields 1 Data Sources

Bill of Material - TP

I_BillOfMaterialTP_2 is a Transactional CDS View that provides data about "Bill of Material - TP" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialTP) and exposes 44 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument.

Data Sources (1)

SourceAliasJoin Type
R_BillOfMaterialTP R_BillOfMaterialTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of Material - TP view
ObjectModel.sapObjectNodeType.name BillOfMaterial view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial bom_header BillOfMaterial BOM
KEY BillOfMaterialCategory bom_header BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant bom_header BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion bom_header BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument bom_header EngineeringChangeDocument Change Number
KEY Material bom_header Material Vehicle Model
KEY Plant bom_header Plant Valuation Area
BillOfMaterialHeaderUUID bom_header BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage bom_header BillOfMaterialVariantUsage Usage
EngineeringChangeDocForEdit bom_header EngineeringChangeDocForEdit Change Number
IsMultipleBOMAlt bom_header IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount bom_header BOMHeaderInternalChangeCount Counter
BOMUsagePriority bom_header BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp bom_header BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus bom_header BOMVersionStatus BOM Version Status
IsVersionBillOfMaterial bom_header IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion bom_header IsLatestBOMVersion Latest Rel Version
IsConfiguredMaterial bom_header IsConfiguredMaterial Configured matl
BOMTechnicalType bom_header BOMTechnicalType Tech type
BOMGroup bom_header BOMGroup BOM group
BOMHeaderText bom_header BOMHeaderText BOM Description
BOMAlternativeText bom_header BOMAlternativeText Alt Text
BillOfMaterialStatus bom_header BillOfMaterialStatus BOM Status
HeaderValidityStartDate bom_header HeaderValidityStartDate Valid From
HeaderValidityEndDate bom_header HeaderValidityEndDate to
ChgToEngineeringChgDocument bom_header ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion bom_header IsMarkedForDeletion Purch.org. data
IsALE bom_header IsALE ALE indicator
MatFromLotSizeQuantity bom_header MatFromLotSizeQuantity From Lot Size
MaterialToLotSizeQuantity bom_header MaterialToLotSizeQuantity To Lot Size
BOMHeaderBaseUnit bom_header BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit bom_header BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate bom_header RecordCreationDate Created On
LastChangeDate bom_header LastChangeDate Time Stamp
CreatedByUser bom_header CreatedByUser User Name
LastChangedByUser bom_header LastChangedByUser User Name
BOMIsToBeDeleted bom_header BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD bom_header DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice bom_header LaboratoryOrDesignOffice Lab/Office
LastChangeDateTime bom_header LastChangeDateTime Timestamp
ProductDescription bom_header ProductDescription Description
PlantName bom_header PlantName Plant Name
BillOfMaterialHdrDetailsText bom_header BillOfMaterialHdrDetailsText
SelectedBillOfMaterialVersion SelectedBillOfMaterialVersion

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 I_BillOfMaterialTP_2.
-- 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 I_BillOfMaterialTP_2 AS
SELECT
  bom_header.BillOfMaterial AS BillOfMaterial,
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.Material AS Material,
  bom_header.Plant AS Plant,
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.EngineeringChangeDocForEdit AS EngineeringChangeDocForEdit,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.IsLatestBOMVersion AS IsLatestBOMVersion,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  bom_header.BOMTechnicalType AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.IsALE AS IsALE,
  bom_header.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  bom_header.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bom_header.LastChangeDateTime AS LastChangeDateTime,
  bom_header.ProductDescription AS ProductDescription,
  bom_header.PlantName AS PlantName,
  bom_header.BillOfMaterialHdrDetailsText AS BillOfMaterialHdrDetailsText,
  SelectedBillOfMaterialVersion
FROM R_BillOfMaterialTP
;

Learn More