I_SUPDMNDALLDOCGDSISSDDELIV
View for Goods Issued Deliveries
I_SUPDMNDALLDOCGDSISSDDELIV is a CDS View in S/4HANA. View for Goods Issued Deliveries. It contains 16 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SupDmndAllDocGdsIssdDelivC | view | from | COMPOSITE | Cube View for Goods Issued Deliveries |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProductAvailabilityDate | ProductAvailabilityDate | 1 |
| KEY | RequestedDate | RequestedDate | 1 |
| KEY | RequirementDocumentItem | RequirementDocumentItem | 1 |
| KEY | RequirementDocumentNumber | RequirementDocumentNumber | 1 |
| KEY | RequirementType | RequirementType | 1 |
| BaseUnit | BaseUnit | 1 | |
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | 1 | |
| DocumentCurrency | DocumentCurrency | 1 | |
| HigherLvlItmOfBatSpltItm | HigherLvlItmOfBatSpltItm | 1 | |
| Material | Material | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| NetPriceAmount | NetPriceAmount | 1 | |
| Plant | Plant | 1 | |
| RequestedDeliveryDate | RequestedDeliveryDate | 1 | |
| ShippingType | ShippingType | 1 | |
| StorageLocation | StorageLocation | 1 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'ISUPDMNDADGIDLV',
compiler.compareFilter: true
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #X,
sizeCategory: #XXL
}
}
@EndUserText.label: 'View for Goods Issued Deliveries'
define view I_SupDmndAllDocGdsIssdDeliv
as select from lips as lips
inner join likp as likp on lips.vbeln = likp.vbeln
inner join kna1 as kna1 on likp.kunnr = kna1.kunnr
inner join I_SupDmndMaterialPlant as marc on lips.matnr = marc.Material
and lips.werks = marc.Plant
{
lips.vbeln as RequirementDocumentNumber,
lips.posnr as RequirementDocumentItem,
lips.uecha as HigherLvlItmOfBatSpltItm,
'VJ' as RequirementType,
lips.mbdat as RequestedDate,
lips.mbdat as ProductAvailabilityDate,
lips.mbdat as RequestedDeliveryDate,
lips.ormng as DeliveredQuantity,
lips.meins as BaseUnit,
likp.wadat as PlannedGoodsIssueDate,
likp.wadat_ist as ActualGoodsMovementDate,
// Planned GI Date - Actual GI Date
dats_days_between( likp.wadat, likp.wadat_ist ) as GIToPlndGIDelayInDays,
likp.vsart as ShippingType,
lips.matnr as Material,
lips.werks as Plant,
lips.matkl as MaterialGroup,
marc.MaterialType,
marc.CrossPlantConfigurableProduct,
lips.sgt_rcat as RequirementSegment,
likp.vbtyp as SDDocumentCategory,
likp.lfart as DeliveryDocumentType,
likp.vkorg as SalesOrganization,
lips.vtweg as DistributionChannel,
lips.spart as Division,
likp.bzirk as SalesDistrict,
likp.kunag as SoldToParty,
lips.lgort as StorageLocation,
kna1.cvp_xblck as IsBusinessPurposeCompleted,
lips.netpr as NetPriceAmount,
likp.waerk as DocumentCurrency
}
where
lips.wbsta = 'C' --> Good Movement completed ( PGI Done )
and lips.lfimg > 0
and likp.vbtyp = 'J'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDMATERIALPLANT",
"KNA1",
"LIKP",
"LIPS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/