I_SALESORDERBOMLINK
Sales Order Link for BOM
I_SALESORDERBOMLINK is a CDS View in S/4HANA. Sales Order Link for BOM. It contains 5 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AssemblySalesOrderBOM | view | from | COMPOSITE | Assembly Determination Sales Order BOM |
| I_BomHeaderChanges | view | inner | BASIC | BOM Header Changes |
| I_ProjNtwkActyMatBOMAssembly | view | union_all | COMPOSITE | BOM Assembly for Ntwk Activity Comp |
| I_SalesOrderBOMLinkDEX | view | from | BASIC | Data extraction for SO bomlink |
| P_BillOfMaterialHeader | view | left_outer | COMPOSITE | |
| P_BOMHeaderType | view | union_all | BASIC | |
| P_BOMItemChanges | view | inner | BASIC | |
| P_ProjMatBOMAssembly | view | union_all | BASIC | |
| SHSM_KDST | view | from | CDS View for use in CS_KDST search help |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | 2 |
| KEY | Material | Material | 3 |
| KEY | Plant | Plant | 3 |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 |
@AbapCatalog.sqlViewName: 'ISALESORDERBOM'
@AbapCatalog.preserveKey:true
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
@EndUserText.label: 'Sales Order Link for BOM'
@Metadata.ignorePropagatedAnnotations: true
define view I_SalesOrderBOMLink as select from kdst
{
key stlnr as BillOfMaterial,
key stlal as BillOfMaterialVariant,
key matnr as Material,
key werks as Plant,
key stlan as BillOfMaterialVariantUsage,
key vbeln as SalesOrder,
key vbpos as SalesOrderItem,
cast ('K' as stlty preserving type) as BillOfMaterialCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KDST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/