@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin
@ObjectModel.representativeKey: 'InboundDeliveryItem'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
//Commented by VDM CDS Suite Plugin:@ObjectModel.representativeKey: 'OutboundDeliveryItem'
@EndUserText.label: 'Inbound Delivery Item'
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction: { enabled: true,
delta.changeDataCapture.mapping: [{
role: #MAIN,
table: 'LIPS',
tableElement: ['VBELN','POSNR'],
viewElement: ['InboundDelivery', 'InboundDeliveryItem']
}]
}
@Metadata.allowExtensions: true
@VDM.viewType: #BASIC
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
//@AccessControl.privilegedAssociations: [ '_Extension' ]
@AbapCatalog.sqlViewName: 'ILEINBDELIVITM'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@ObjectModel.sapObjectNodeType.name:'InboundDeliveryItem'
define view I_InboundDeliveryItem
as select from I_DeliveryDocumentItem
//Association
association [1..1] to I_InboundDelivery as _InboundDelivery on $projection.InboundDelivery = _InboundDelivery.InboundDelivery
association [0..1] to I_PutawayStatus as _PutawayStatus on $projection.PutawayStatus = _PutawayStatus.PutawayStatus
//The following shall be removed when the cast bug is fixed.
association [0..*] to I_SDDocumentItemPartner as _Partner on $projection.InboundDelivery = _Partner.SDDocument
and $projection.InboundDeliveryItem = _Partner.SDDocumentItem
association [0..1] to I_FldLogsDelivRefLinkInfo as _FldLogsDelivRefLinkInfo on $projection.InboundDelivery = _FldLogsDelivRefLinkInfo.DeliveryDocument
and $projection.InboundDeliveryItem = _FldLogsDelivRefLinkInfo.DeliveryDocumentItem
//Extensibility
association [0..1] to E_DeliveryDocumentItem as _Extension on $projection.InboundDelivery = _Extension.DeliveryDocument
and $projection.InboundDeliveryItem = _Extension.DeliveryDocumentItem
{
//Key
@ObjectModel.foreignKey.association: '_InboundDelivery'
key DeliveryDocument as InboundDelivery,
key DeliveryDocumentItem as InboundDeliveryItem,
HigherLvlItmOfBatSpltItm,
//Category
@ObjectModel.foreignKey.association: '_ItemCategory'
DeliveryDocumentItemCategory,
@ObjectModel.foreignKey.association: '_SalesDocumentItemType'
SalesDocumentItemType,
//Admin
CreatedByUser,
@Semantics.businessDate.createdAt: true
CreationDate,
CreationTime,
@Semantics.businessDate.lastChangedAt: true
LastChangeDate,
//Organization
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
@ObjectModel.foreignKey.association: '_Division'
Division,
@ObjectModel.foreignKey.association: '_SalesGroup'
SalesGroup,
@ObjectModel.foreignKey.association: '_SalesOffice'
SalesOffice,
DepartmentClassificationByCust,
//Product
@ObjectModel.foreignKey.association: '_Material'
Material,
MaterialByCustomer,
@ObjectModel.foreignKey.association: '_OriginallyRequestedMaterial'
OriginallyRequestedMaterial,
InternationalArticleNumber,
Batch,
BatchClassification,
BatchBySupplier,
MaterialIsIntBatchManaged,
MaterialIsBatchManaged,
@ObjectModel.foreignKey.association: '_MaterialGroup'
MaterialGroup,
@ObjectModel.foreignKey.association: '_MaterialFreightGroup'
MaterialFreightGroup,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup1'
AdditionalMaterialGroup1,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup2'
AdditionalMaterialGroup2,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup3'
AdditionalMaterialGroup3,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup4'
AdditionalMaterialGroup4,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup5'
AdditionalMaterialGroup5,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_Warehouse'
Warehouse,
@ObjectModel.foreignKey.association: '_StorageLocation'
StorageLocation,
StorageBin,
StorageType,
@ObjectModel.foreignKey.association: '_InventorySpecialStockType'
InventorySpecialStockType,
ShelfLifeExpirationDate,
NumberOfSerialNumbers,
ProductConfiguration,
ProductHierarchyNode,
ManufactureDate,
//Delivery
DeliveryDocumentItemText,
HigherLevelItem,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
ActualDeliveryQuantity,
QuantityIsFixed,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
OriginalDeliveryQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_DeliveryQuantityUnit'
DeliveryQuantityUnit,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
ActualDeliveredQtyInBaseUnit,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_BaseUnit'
BaseUnit,
DeliveryToBaseQuantityDnmntr,
DeliveryToBaseQuantityNmrtr,
ProductAvailabilityDate,
ProductAvailabilityTime,
DeliveryGroup,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemGrossWeight,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemNetWeight,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ItemWeightUnit'
ItemWeightUnit,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
ItemVolume,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ItemVolumeUnit'
ItemVolumeUnit,
InspectionLot,
InspectionPartialLot,
PartialDeliveryIsAllowed,
UnlimitedOverdeliveryIsAllowed,
OverdelivTolrtdLmtRatioInPct,
UnderdelivTolrtdLmtRatioInPct,
@ObjectModel.foreignKey.association: '_BOMExplosion'
BOMExplosion,
@ObjectModel.foreignKey.association: '_WarehouseStagingArea'
WarehouseStagingArea,
@ObjectModel.foreignKey.association: '_StockCategory'
WarehouseStockCategory,
@ObjectModel.foreignKey.association: '_StockType_2'
StockType,
GLAccount,
GoodsMovementReasonCode,
SubsequentMovementType,
IsCompletelyDelivered,
IsNotGoodsMovementsRelevant,
//Pick Pack Load
@ObjectModel.foreignKey.association: '_PickingControl'
PickingControl,
@ObjectModel.foreignKey.association: '_LoadingGroup'
LoadingGroup,
@ObjectModel.foreignKey.association: '_GoodsMovementType'
GoodsMovementType,
LoadingPointForDelivery,
//Shipping
@ObjectModel.foreignKey.association: '_TransportationGroup'
TransportationGroup,
ReceivingPoint,
FixedShipgProcgDurationInDays,
VarblShipgProcgDurationInDays,
ProofOfDeliveryRelevanceCode,
//Billing
@ObjectModel.foreignKey.association: '_ItemIsBillingRelevant'
ItemIsBillingRelevant,
@ObjectModel.foreignKey.association: '_ItemBillingBlockReason'
ItemBillingBlockReason,
//Accounting
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@API.element.releaseState: #DECOMMISSIONED
@API.element.successor: 'ProfitabilitySegment_2'
cast( case when ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) as ProfitabilitySegment,
ProfitabilitySegment_2,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
@ObjectModel.foreignKey.association: '_InventoryValuationType'
InventoryValuationType,
IsSeparateValuation,
ConsumptionPosting,
@ObjectModel.foreignKey.association: '_OrderID'
OrderID,
OrderItem,
CostCenter,
//Reference
@ObjectModel.foreignKey.association: '_ReferenceSDDocument'
ReferenceSDDocument,
@ObjectModel.foreignKey.association: '_ReferenceSalesDocumentItem'
ReferenceSDDocumentItem,
@ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
ReferenceSDDocumentCategory,
@ObjectModel.foreignKey.association: '_LogicalSystem'
ReferenceDocumentLogicalSystem,
@ObjectModel.foreignKey.association: '_PurchaseOrder'
PurchaseOrder,
@ObjectModel.foreignKey.association: '_PurchaseOrderItem'
PurchaseOrderItem,
//Sales
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup1'
AdditionalCustomerGroup1,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup2'
AdditionalCustomerGroup2,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup3'
AdditionalCustomerGroup3,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup4'
AdditionalCustomerGroup4,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup5'
AdditionalCustomerGroup5,
RetailPromotion,
//Status
@ObjectModel.foreignKey.association: '_SDProcessStatus'
SDProcessStatus,
@ObjectModel.foreignKey.association: '_PickingConfirmationStatus'
PickingConfirmationStatus,
@ObjectModel.foreignKey.association: '_PickingStatus'
PickingStatus,
@ObjectModel.foreignKey.association: '_PutawayStatus'
PickingStatus as PutawayStatus,
@ObjectModel.foreignKey.association: '_WarehouseActivityStatus'
WarehouseActivityStatus,
@ObjectModel.foreignKey.association: '_PackingStatus'
PackingStatus,
@ObjectModel.foreignKey.association: '_GoodsMovementStatus'
GoodsMovementStatus,
@ObjectModel.foreignKey.association: '_DeliveryRelatedBillingStatus'
DeliveryRelatedBillingStatus,
@ObjectModel.foreignKey.association: '_ProofOfDeliveryStatus'
ProofOfDeliveryStatus,
@ObjectModel.foreignKey.association: '_ItemGeneralIncompletionStatus'
ItemGeneralIncompletionStatus,
@ObjectModel.foreignKey.association: '_ItemDelivIncompletionSts'
ItemDeliveryIncompletionStatus,
@ObjectModel.foreignKey.association: '_ItemPickingIncompletionStatus'
ItemPickingIncompletionStatus,
@ObjectModel.foreignKey.association: '_ItemGdsMvtIncompletionSts'
ItemGdsMvtIncompletionSts,
@ObjectModel.foreignKey.association: '_ItemPackingIncompletionStatus'
ItemPackingIncompletionStatus,
@ObjectModel.foreignKey.association: '_ItemBillingIncompletionStatus'
ItemBillingIncompletionStatus,
IntercompanyBillingStatus,
// Trade Compliance
@ObjectModel.foreignKey.association: '_TrdCmplncEmbargoSts'
TrdCmplncEmbargoSts,
@ObjectModel.foreignKey.association: '_TrdCmplncSnctndListChkSts'
TrdCmplncSnctndListChkSts,
@ObjectModel.foreignKey.association: '_TrdCmplncLegalControlSts'
TrdCmplncLegalControlSts,
//Fashion Management
StockSegment,
ProductSeasonYear,
ProductSeason,
ProductCollection,
ProductTheme,
ProductCharacteristic1,
ProductCharacteristic2,
ProductCharacteristic3,
//Vistex Integration
OriginSDDocument,
SDDocumentItem,
SalesSDDocumentCategory,
MaterialTypePrimary,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CostInDocumentCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal1Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal2Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal3Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal4Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal5Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal6Amount,
OrderDocument,
PlanningMaterial,
PlanningPlant,
ProductGroupBaseUnit,
ConversionFactor,
IsReturnsItem,
ConditionUnit,
@Semantics.amount.currencyCode: 'TransactionCurrency'
NetPriceAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
TotalNetAmount,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
QtyInPurchaseOrderPriceUnit,
@Semantics.amount.currencyCode: 'TransactionCurrency'
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'CreditRelatedPriceAmount'
CreditRelatedPrice,
@Semantics.amount.currencyCode:'TransactionCurrency'
CreditRelatedPriceAmount,
DeliveryToBaseUnitCnvrsnFctr,
FunctionalArea,
@Semantics.currencyCode: true
_InboundDelivery.TransactionCurrency,
FldLogsStatus,
// Associations
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
#TO_COMPOSITION_ROOT]
_InboundDelivery,
_Partner,
_ItemCategory,
_SalesDocumentItemType,
_CreatedByUser,
_DistributionChannel,
_Division,
_SalesGroup,
_SalesOffice,
_Material,
_OriginallyRequestedMaterial,
_ProductHierarchyNode,
_MaterialGroup,
_MaterialFreightGroup,
_AdditionalMaterialGroup1,
_AdditionalMaterialGroup2,
_AdditionalMaterialGroup3,
_AdditionalMaterialGroup4,
_AdditionalMaterialGroup5,
_Plant,
_Warehouse,
_StorageLocation,
_InventorySpecialStockType,
_DeliveryQuantityUnit,
_BaseUnit,
_ItemWeightUnit,
_ItemVolumeUnit,
_BOMExplosion,
_PickingControl,
_LoadingGroup,
_GoodsMovementType,
_TransportationGroup,
_ItemIsBillingRelevant,
_ItemBillingBlockReason,
_BusinessArea,
_ControllingArea,
_ProfitCenter,
_InventoryValuationType,
_OrderID,
_CostCenter,
_ReferenceSDDocument,
_ReferenceSalesDocumentItem,
_ReferenceSDDocumentCategory,
_PurchaseOrder,
_PurchaseOrderItem,
_LogicalSystem,
_AdditionalCustomerGroup1,
_AdditionalCustomerGroup2,
_AdditionalCustomerGroup3,
_AdditionalCustomerGroup4,
_AdditionalCustomerGroup5,
_SDProcessStatus,
_PickingConfirmationStatus,
_PickingStatus,
_PutawayStatus,
_WarehouseActivityStatus,
_WarehouseStagingArea,
_PackingStatus,
_GoodsMovementStatus,
_DeliveryRelatedBillingStatus,
_ProofOfDeliveryStatus,
_ItemGeneralIncompletionStatus,
_ItemDelivIncompletionSts,
_ItemPickingIncompletionStatus,
_ItemGdsMvtIncompletionSts,
_ItemPackingIncompletionStatus,
_ItemBillingIncompletionStatus,
@API.element: {releaseState: #DEPRECATED, successor: '_StockType_2' }
_StockType,
_StockType_2,
_StockCategory,
// Trade Compliance
_TrdCmplncEmbargoSts,
_TrdCmplncSnctndListChkSts,
_TrdCmplncLegalControlSts,
_FieldLogisticsIndicator,
_FldLogsDelivRefLinkInfo
}
where
SDDocumentCategory = '7'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM",
"I_INBOUNDDELIVERY"
],
"ASSOCIATED":
[
"E_DELIVERYDOCUMENTITEM",
"I_ADDITIONALCUSTOMERGROUP1",
"I_ADDITIONALCUSTOMERGROUP2",
"I_ADDITIONALCUSTOMERGROUP3",
"I_ADDITIONALCUSTOMERGROUP4",
"I_ADDITIONALCUSTOMERGROUP5",
"I_ADDITIONALMATERIALGROUP1",
"I_ADDITIONALMATERIALGROUP2",
"I_ADDITIONALMATERIALGROUP3",
"I_ADDITIONALMATERIALGROUP4",
"I_ADDITIONALMATERIALGROUP5",
"I_BILLINGBLOCKREASON",
"I_BILLINGRELEVANCECODE",
"I_BOMEXPLOSIONDATE",
"I_BUSINESSAREA",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_DELIVERYRELATEDBILLGSTATUS",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_FIELDLOGISTICSINDICATOR",
"I_FLDLOGSDELIVREFLINKINFO",
"I_GOODSMOVEMENTSTATUS",
"I_GOODSMOVEMENTTYPE",
"I_INBOUNDDELIVERY",
"I_INVENTORYSPECIALSTOCKTYPE",
"I_INVENTORYVALUATIONTYPE",
"I_ITEMBILLINGINCOMPLETIONSTS",
"I_ITEMDELIVINCOMPLETIONSTS",
"I_ITEMGDSMVTINCOMPLETIONSTS",
"I_ITEMGENINCOMPLETIONSTATUS",
"I_ITEMPACKINGINCOMPLETIONSTS",
"I_ITEMPICKINGINCOMPLETIONSTS",
"I_LOADINGGROUP",
"I_LOGICALSYSTEM",
"I_MATERIAL",
"I_MATERIALFREIGHTGROUP",
"I_MATERIALGROUP",
"I_MFGORDER",
"I_PACKINGSTATUS",
"I_PICKINGCONFIRMATIONSTATUS",
"I_PICKINGCONTROL",
"I_PICKINGSTATUS",
"I_PLANT",
"I_PRODUCTHIERARCHYNODE",
"I_PROFITCENTER",
"I_PROOFOFDELIVERYSTATUS",
"I_PURCHASEORDERAPI01",
"I_PURCHASEORDERITEMAPI01",
"I_PUTAWAYSTATUS",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTITEMTYPE",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTITEMPARTNER",
"I_SDPROCESSSTATUS",
"I_STOCKCATEGORY",
"I_STOCKTYPE",
"I_STOCKTYPE_2",
"I_STORAGELOCATION",
"I_TRANSPORTATIONGROUP",
"I_TRDCMPLNCCHECKSTATUS",
"I_UNITOFMEASURE",
"I_USER",
"I_WAREHOUSE",
"I_WAREHOUSEACTIVITYSTATUS",
"I_WAREHOUSESTAGINGAREA"
],
"BASE":
[
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/