P_BOMComponentsWithKeyDate
P_BOMComponentsWithKeyDate is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_BOMItems) and exposes 95 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialItemNodeNumber, BillOfMaterialVersion.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_BOMItems | valid_items | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PBOMCOMPWITHDATE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (95)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillOfMaterialCategory | P_BOMItems | BillOfMaterialCategory | |
| KEY | BillOfMaterial | P_BOMItems | BillOfMaterial | |
| KEY | BillOfMaterialVariant | P_BOMItems | BillOfMaterialVariant | |
| KEY | BillOfMaterialItemNodeNumber | P_BOMItems | BillOfMaterialItemNodeNumber | |
| KEY | BillOfMaterialVersion | P_BOMItems | BillOfMaterialVersion | |
| KEY | BOMItemInternalChangeCount | P_BOMItems | BOMItemInternalChangeCount | |
| ValidityStartDate | P_BOMItems | ValidityStartDate | ||
| ValidityEndDate | P_BOMItems | ValidityEndDate | ||
| EngineeringChangeDocument | P_BOMItems | ChangeNumberFrom | ||
| ChgToEngineeringChgDocument | P_BOMItems | ChangeNumberTo | ||
| InheritedNodeNumberForBOMItem | P_BOMItems | InheritedNodeNumberForBOMItem | ||
| InheritedNodeNumberVersionBOM | P_BOMItems | InheritedNodeNumberVersionBOM | ||
| BOMItemRecordCreationDate | P_BOMItems | BOMItemRecordCreationDate | ||
| BOMItemCreatedByUser | P_BOMItems | BOMItemCreatedByUser | ||
| BOMItemLastChangeDate | P_BOMItems | BOMItemLastChangeDate | ||
| BOMItemLastChangedByUser | P_BOMItems | BOMItemLastChangedByUser | ||
| BillOfMaterialComponent | P_BOMItems | BillOfMaterialComponent | ||
| BillOfMaterialItemCategory | P_BOMItems | BillOfMaterialItemCategory | ||
| BillOfMaterialItemNumber | P_BOMItems | BillOfMaterialItemNumber | ||
| BillOfMaterialItemUnit | P_BOMItems | BillOfMaterialItemUnit | ||
| BillOfMaterialItemQuantity | P_BOMItems | BillOfMaterialItemQuantity | ||
| IsAssembly | P_BOMItems | IsAssembly | ||
| IsSubItem | P_BOMItems | IsSubItem | ||
| BOMItemSorter | P_BOMItems | BOMItemSorter | ||
| FixedQuantity | P_BOMItems | FixedQuantity | ||
| BOMItemHasFixedQuantity | P_BOMItems | BOMItemHasFixedQuantity | ||
| PurchasingGroup | P_BOMItems | PurchasingGroup | ||
| Currency | P_BOMItems | Currency | ||
| MaterialComponentPrice | P_BOMItems | MaterialComponentPrice | ||
| IdentifierBOMItem | P_BOMItems | IdentifierBOMItem | ||
| MaterialPriceUnitQty | P_BOMItems | MaterialPriceUnitQty | ||
| ComponentScrapInPercent | P_BOMItems | ComponentScrapInPercent | ||
| OperationScrapInPercent | P_BOMItems | OperationScrapInPercent | ||
| IsNetScrap | P_BOMItems | IsNetScrap | ||
| NumberOfVariableSizeItem | P_BOMItems | NumberOfVariableSizeItem | ||
| QuantityVariableSizeItem | P_BOMItems | QuantityVariableSizeItem | ||
| FormulaKey | P_BOMItems | FormulaKey | ||
| BOMItemDescription | P_BOMItems | BOMItemDescription | ||
| BOMItemText2 | P_BOMItems | BOMItemText2 | ||
| MaterialGroup | P_BOMItems | MaterialGroup | ||
| DocumentType | P_BOMItems | DocumentType | ||
| DocNumber | P_BOMItems | DocNumber | ||
| DocumentVersion | P_BOMItems | DocumentVersion | ||
| DocumentPart | P_BOMItems | DocumentPart | ||
| ClassNumber | P_BOMItems | ClassNumber | ||
| ClassType | P_BOMItems | ClassType | ||
| ResultingItemCategory | P_BOMItems | ResultingItemCategory | ||
| DependencyObjectNumber | P_BOMItems | DependencyObjectNumber | ||
| ObjectType | P_BOMItems | ObjectType | ||
| IsClassificationRelevant | P_BOMItems | IsClassificationRelevant | ||
| IsBulkMaterial | P_BOMItems | IsBulkMaterial | ||
| BOMItemIsSparePart | P_BOMItems | BOMItemIsSparePart | ||
| BOMItemIsSalesRelevant | P_BOMItems | BOMItemIsSalesRelevant | ||
| IsProductionRelevant | P_BOMItems | IsProductionRelevant | ||
| BOMItemIsPlantMaintRelevant | P_BOMItems | BOMItemIsPlantMaintRelevant | ||
| BOMItemIsCostingRelevant | P_BOMItems | BOMItemIsCostingRelevant | ||
| IsEngineeringRelevant | P_BOMItems | IsEngineeringRelevant | ||
| SpecialProcurementType | P_BOMItems | SpecialProcurementType | ||
| IsBOMRecursiveAllowed | P_BOMItems | IsBOMRecursiveAllowed | ||
| OperationLeadTimeOffset | P_BOMItems | OperationLeadTimeOffset | ||
| OpsLeadTimeOffsetUnit | P_BOMItems | OpsLeadTimeOffsetUnit | ||
| IsMaterialProvision | P_BOMItems | IsMaterialProvision | ||
| BOMIsRecursive | P_BOMItems | BOMIsRecursive | ||
| DocumentIsCreatedByCAD | P_BOMItems | DocumentIsCreatedByCAD | ||
| DistrKeyCompConsumption | P_BOMItems | DistrKeyCompConsumption | ||
| DeliveryDurationInDays | P_BOMItems | DeliveryDurationInDays | ||
| Creditor | P_BOMItems | Creditor | ||
| CostElement | P_BOMItems | CostElement | ||
| Size1 | P_BOMItems | Size1 | ||
| Size2 | P_BOMItems | Size2 | ||
| Size3 | P_BOMItems | Size3 | ||
| UnitOfMeasureForSize1To3 | P_BOMItems | UnitOfMeasureForSize1To3 | ||
| GoodsReceiptDuration | P_BOMItems | GoodsReceiptDuration | ||
| PurchasingOrganization | P_BOMItems | PurchasingOrganization | ||
| RequiredComponent | P_BOMItems | RequiredComponent | ||
| MultipleSelectionAllowed | P_BOMItems | MultipleSelectionAllowed | ||
| ProdOrderIssueLocation | P_BOMItems | ProdOrderIssueLocation | ||
| MaterialIsCoProduct | P_BOMItems | MaterialIsCoProduct | ||
| ExplosionType | P_BOMItems | ExplosionType | ||
| FollowUpGroup | P_BOMItems | FollowUpGroup | ||
| DiscontinuationGroup | P_BOMItems | DiscontinuationGroup | ||
| IsConfigurableBOM | P_BOMItems | IsConfigurableBOM | ||
| ReferencePoint | P_BOMItems | ReferencePoint | ||
| LeadTimeOffset | P_BOMItems | LeadTimeOffset | ||
| IsSoftwareComponent | P_BOMItems | IsSoftwareComponent | ||
| ProductionSupplyArea | P_BOMItems | ProductionSupplyArea | ||
| IsDeleted | P_BOMItems | IsDeleted | ||
| IsALE | P_BOMItems | IsALE | ||
| UnitOfMeasureForVarSizeItem | P_BOMItems | UnitOfMeasureForVarSizeItem | ||
| AlternativeItemGroup | P_BOMItems | AlternativeItemGroup | ||
| AlternativeItemPriority | P_BOMItems | AlternativeItemPriority | ||
| AlternativeItemStrategy | P_BOMItems | AlternativeItemStrategy | ||
| UsageProbabilityPercent | P_BOMItems | UsageProbabilityPercent | ||
| IsPhantomItem | P_BOMItems | IsPhantomItem | ||
| LastChangeDateTime | P_BOMItems | LastChangeDateTime |
@AbapCatalog.sqlViewName: 'PBOMCOMPWITHDATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
---FOR INTERNAL USE ONLY. NOT FOR CONSUMTION---
define view P_BOMComponentsWithKeyDate
as select from P_BOMItems
as valid_items {
key valid_items.BillOfMaterialCategory,
key valid_items.BillOfMaterial,
key valid_items.BillOfMaterialVariant,
key valid_items.BillOfMaterialItemNodeNumber,
key valid_items.BillOfMaterialVersion,
key valid_items.BOMItemInternalChangeCount,
valid_items.ValidityStartDate,
valid_items.ValidityEndDate,
valid_items.ChangeNumberFrom as EngineeringChangeDocument,
valid_items.ChangeNumberTo as ChgToEngineeringChgDocument,
valid_items.InheritedNodeNumberForBOMItem,
valid_items.InheritedNodeNumberVersionBOM,
valid_items.BOMItemRecordCreationDate,
valid_items.BOMItemCreatedByUser,
valid_items.BOMItemLastChangeDate,
valid_items.BOMItemLastChangedByUser,
valid_items.BillOfMaterialComponent,
valid_items.BillOfMaterialItemCategory,
valid_items.BillOfMaterialItemNumber,
valid_items.BillOfMaterialItemUnit,
valid_items.BillOfMaterialItemQuantity,
valid_items.IsAssembly,
valid_items.IsSubItem,
valid_items.BOMItemSorter,
valid_items.FixedQuantity,
valid_items.BOMItemHasFixedQuantity,
valid_items.PurchasingGroup,
valid_items.Currency,
valid_items.MaterialComponentPrice,
valid_items.IdentifierBOMItem,
valid_items.MaterialPriceUnitQty,
valid_items.ComponentScrapInPercent,
valid_items.OperationScrapInPercent,
valid_items.IsNetScrap,
valid_items.NumberOfVariableSizeItem,
valid_items.QuantityVariableSizeItem,
valid_items.FormulaKey,
valid_items.BOMItemDescription,
valid_items.BOMItemText2,
valid_items.MaterialGroup,
valid_items.DocumentType,
valid_items.DocNumber,
valid_items.DocumentVersion,
valid_items.DocumentPart,
valid_items.ClassNumber,
valid_items.ClassType,
valid_items.ResultingItemCategory,
valid_items.DependencyObjectNumber,
valid_items.ObjectType,
valid_items.IsClassificationRelevant,
valid_items.IsBulkMaterial,
valid_items.BOMItemIsSparePart ,
valid_items.BOMItemIsSalesRelevant,
valid_items.IsProductionRelevant,
valid_items.BOMItemIsPlantMaintRelevant,
valid_items.BOMItemIsCostingRelevant,
valid_items.IsEngineeringRelevant,
valid_items.SpecialProcurementType,
valid_items.IsBOMRecursiveAllowed,
valid_items.OperationLeadTimeOffset,
valid_items.OpsLeadTimeOffsetUnit,
valid_items.IsMaterialProvision,
valid_items.BOMIsRecursive,
valid_items.DocumentIsCreatedByCAD,
valid_items.DistrKeyCompConsumption,
valid_items.DeliveryDurationInDays,
valid_items.Creditor,
valid_items.CostElement,
valid_items.Size1,
valid_items.Size2,
valid_items.Size3,
valid_items.UnitOfMeasureForSize1To3,
valid_items.GoodsReceiptDuration,
valid_items.PurchasingOrganization,
valid_items.RequiredComponent,
valid_items.MultipleSelectionAllowed,
valid_items.ProdOrderIssueLocation,
valid_items.MaterialIsCoProduct,
valid_items.ExplosionType,
valid_items.FollowUpGroup,
valid_items.DiscontinuationGroup,
valid_items.IsConfigurableBOM,
valid_items.ReferencePoint,
valid_items.LeadTimeOffset,
valid_items.IsSoftwareComponent,
valid_items.ProductionSupplyArea,
valid_items.IsDeleted,
valid_items.IsALE,
valid_items.UnitOfMeasureForVarSizeItem,
//Alternative Item Fields
valid_items.AlternativeItemGroup,
valid_items.AlternativeItemPriority,
valid_items.AlternativeItemStrategy,
valid_items.UsageProbabilityPercent,
valid_items.IsPhantomItem,
valid_items.LastChangeDateTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BOMITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA