C_FldLogsEmptyContainerIDVH

DDL: C_FLDLOGSEMPTYCONTAINERIDVH SQL: CFLEMPTYCTNVH Type: view CONSUMPTION Package: ODATA_FLOG_PROCESS_RECEIPTS

Field Logitics for Empty Containers

C_FldLogsEmptyContainerIDVH is a Consumption CDS View that provides data about "Field Logitics for Empty Containers" in SAP S/4HANA. It has 1 association to related views. It is exposed through 2 OData services (UI_PROCESS_RECEIPTS, UI_SHIPMENTCONTAINERPACKG). It is used in 2 Fiori applications: Process Receipt, Pack Container. Part of development package ODATA_FLOG_PROCESS_RECEIPTS.

Associations (1)

CardinalityTargetAliasCondition
[1] I_FldLogsShptCtnCertExpiryDate _CertificateExpiry $projection.FldLogsContainerUUID = _CertificateExpiry.FldLogsContainerUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFLEMPTYCTNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Field Logitics for Empty Containers view
Consumption.ranked true view
Consumption.valueHelpDefault.fetchValues #AUTOMATICALLY_WHEN_DISPLAYED view

OData Services (2)

ServiceBindingVersionContractRelease
UI_PROCESS_RECEIPTS UI_PROCESS_RECEIPTS V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_SHIPMENTCONTAINERPACKG UI_SHIPMENTCONTAINERPACKG V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (2)

App IDApp NameTypeDescription
F5316 Process Receipt Transactional This application is used to Receive Purchase Order Items and Inbound delivery items at Base Plant and Remote Plant. The items can consist of both Stock and Supplier Items.
F5786 Pack Container Transactional An application in Field Logistics to pack the outbound delivery items, handling unit into a container, seal the container and issue the items. Kit is a logical grouping of components required to perform a maintenance operation at a demand plant. A kit could include stock, non-stock, or rental items. Once the delivery for outbound process is fully picked, they can be assigned to a suitable container. The delivery items, handling unit and kit items should be able to assign single or multiple voyage..

Process Receipt

Business Role: Receiving Specialist (Oil & Gas)

This feature enables you to: Create batches with supplier batches using the Create Batch action. View additional fields such as Order Category, Order Number, Recipient, Requisitioner, and Unloading Point details on the list page. Perform a two-step Goods Receipt (GR) process with an alternate unit of measurement. Create a Putaway Warehouse Task for non-stock and supplier items in a single-plant scenario.

Pack Container

Business Role: Warehouse Clerk (Oil & Gas)

With this feature you can view the outbound deliveries that are picked and ready for loading or packing into a container. The status can be set to allow the packing to assign the deliveries to an existing Field Logistics container . You can also include a step for sealing to record upto to 5 seals for the packed container. Trigger the goods issue for all deliveries in the container.

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerUUID FldLogsContainerUUID
FldLogsContainerID FldLogsContainerID Container ID
EquipmentType EquipmentType Container Type
EquipmentGroup EquipmentGroup Equipment Group
EquipmentTypeDesc _EquipmentTypeText EquipmentTypeDesc Container Type description
FldLogsContainerText FldLogsContainerText Description
FldLogsContainerCategory FldLogsContainerCategory Container Category
FldLogsContainerCategoryText _CtnCategoryText FldLogsContainerCategoryText Container Category description
FldLogsContainerStatus FldLogsContainerStatus Container Status
Plant Plant Base Plant
StorageLocation StorageLocation Base Storage Location
FldLogsCtnCurrentLocation FldLogsCtnCurrentLocation Current Plant
FldLogsCtnCurrentStorageLoc FldLogsCtnCurrentStorageLoc Current Storage Location
FldLogsContainerOwner FldLogsContainerOwner Supplier
FldLogsCertEndDate _CertificateExpiry FldLogsCertEndDate Expiry Date
@AbapCatalog.sqlViewName: 'CFLEMPTYCTNVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM: {
viewType: #CONSUMPTION }
@ObjectModel.usageType: {
serviceQuality: #C,
dataClass: #TRANSACTIONAL,
sizeCategory: #L }
@ObjectModel : {
  dataCategory: #VALUE_HELP,
  semanticKey: ['FldLogsContainerID']
  }
@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Field Logitics for Empty Containers'
@Consumption.ranked: true
@Consumption.valueHelpDefault.fetchValues:#AUTOMATICALLY_WHEN_DISPLAYED
define view C_FldLogsEmptyContainerIDVH
  as select distinct from I_FldLogsShptCtnPackggRecord
  association     to I_FldLogsPlantBasic            as _BasePlant         on $projection.FldLogsCtnCurrentLocation = _BasePlant.SupplyingPlant
  association [1] to I_FldLogsShptCtnCertExpiryDate as _CertificateExpiry on $projection.FldLogsContainerUUID = _CertificateExpiry.FldLogsContainerUUID
{
  key FldLogsContainerUUID,
      @Search: { defaultSearchElement: true,ranking: #HIGH, fuzzinessThreshold: 0.7 }
      @UI.selectionField: [{position: 10 }]
      @EndUserText.label: 'Container ID'
      @UI.lineItem: [{position: 10, label: 'Container ID',importance: #HIGH }]
      @ObjectModel : { text.element: ['FldLogsContainerText'] }
      @UI.textArrangement: #TEXT_FIRST
      FldLogsContainerID,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7,ranking: #LOW }
      @UI.lineItem: [{position: 30,importance: #HIGH }]
      @EndUserText.label: 'Container Type'
      @Consumption.valueHelpDefinition: [{ entity: {name: 'C_FldLogsContainerTypeVH'  ,element: 'EquipmentType'}}]
      @ObjectModel : { text.element: ['EquipmentTypeDesc'] }
      @UI.textArrangement: #TEXT_FIRST
      EquipmentType,

      @EndUserText.label: 'Equipment Group'
      EquipmentGroup,
      @EndUserText.label: 'Container Type description'
      _EquipmentTypeText.EquipmentTypeDesc,
      @EndUserText.label: 'Description'
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7,ranking: #LOW }
      @Semantics.text: true
      FldLogsContainerText,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7,ranking: #LOW }
      @UI.selectionField: [{position: 40 }]
      @EndUserText.label: 'Container Category'
      @UI.lineItem: [{position: 20, label: 'Container Category',importance: #HIGH }]
      @Consumption.valueHelpDefinition: [{ entity: {name: 'I_FldLogsContainerCategoryText', element: 'FldLogsContainerCategory' }}]
      @ObjectModel : { text.element: ['FldLogsContainerCategoryText'] }
      @UI.textArrangement: #TEXT_FIRST
      FldLogsContainerCategory,
      @EndUserText.label: 'Container Category description'
      _CtnCategoryText.FldLogsContainerCategoryText,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7,ranking: #LOW }
      @EndUserText.label: 'Container Status'
      @Consumption.valueHelpDefinition: [{ entity: {name: 'C_FldLogsShptCtnStatusVH', element: 'FldLogsContainerStatus' } }]
      FldLogsContainerStatus,


      @EndUserText.label: 'Base Plant'
      Plant,

      @EndUserText.label: 'Base Storage Location'
      StorageLocation,

      @UI.selectionField: [{position: 50 }]
      @UI.lineItem: [{position: 50,importance: #HIGH }]
      @EndUserText.label: 'Current Plant'
      @Consumption.valueHelpDefinition: [{entity:{ name: 'C_FldLogsPlantsVH', element: 'Plant' }}]
      FldLogsCtnCurrentLocation,
      @EndUserText.label: 'Current Storage Location'
      FldLogsCtnCurrentStorageLoc,
      @UI.lineItem: [{position: 60,importance: #HIGH }]
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7,ranking: #LOW }
      @EndUserText.label: 'Supplier'
      FldLogsContainerOwner,

      @EndUserText.label: 'Expiry Date'
      @UI.lineItem: [{position: 40, label: 'Certificate Expiry Date',importance: #HIGH }]
      _CertificateExpiry.FldLogsCertEndDate

}
where
       FldLogsContainerStatus    = '10' //available container

  and(
       FldLogsCtnCurrentLocation is initial
    or _BasePlant.SupplyingPlant = FldLogsCtnCurrentLocation
  )