C_ProdnPlngOutbDelivQuickView

DDL: C_PRODNPLNGOUTBDELIVQUICKVIEW SQL: COUTBDQV Type: view CONSUMPTION Package: ODATA_PP_DD_ORD_DET
44 Fields 1 Data Sources

Outbound Delivery Details

C_ProdnPlngOutbDelivQuickView is a Consumption CDS View that provides data about "Outbound Delivery Details" in SAP S/4HANA. It reads from 1 data source (I_OutboundDeliveryQuickView) and exposes 44 fields with key fields Delivery, DeliveryItem. Part of development package ODATA_PP_DD_ORD_DET.

Data Sources (1)

SourceAliasJoin Type
I_OutboundDeliveryQuickView I_OutboundDeliveryQuickView from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName COUTBDQV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Outbound Delivery Details view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY Delivery Delivery Delivery Status
KEY DeliveryItem DeliveryItem Logistics Execution Delivery Item
DeliveryType DeliveryType intern./extern.
DocumentDate DocumentDate Journal Entry Date
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
SalesDocumentType SalesDocumentType Sales Doc. Type
Material Material Vehicle Model
MRPPlant MRPPlant Plant
MRPPlantName MRPPlantName Plant Name
MaterialGroup MaterialGroup Product Group
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
InventorySpecialStockType InventorySpecialStockType Special Stock Type
MaterialByCustomer MaterialByCustomer Customer Mat.
CustomerMaterialBaseUnit CustomerMaterialBaseUnit Unit of Measure
MinDeliveryQtyInBaseUnit MinDeliveryQtyInBaseUnit Min. Dely Qty
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CustomerGroup CustomerGroup Customer Group
Customer Customer Sold-to Party
BPCustomerName BPCustomerName Name of Customer
ContactPersonName ContactPersonName Full Name
ContactPersonPhoneNumber ContactPersonPhoneNumber Telephone No.
ContactPersonEmailAddress ContactPersonEmailAddress Email
DeliveryBlockReason DeliveryBlockReason Delivery Block
DeliveryBlockReasonText DeliveryBlockReasonText
DeliveryIsBlocked DeliveryIsBlocked Delivery block
DeliveryPriority DeliveryPriority Delivery Prior.
DeliveryPriorityDesc DeliveryPriorityDesc
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
DeliveryIsPostedGoodsIssue DeliveryIsPostedGoodsIssue
MaxNumberOfPartialDelivery
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedLoadingDate RequestedLoadingDate Loading Date
RequestedGoodsIssueDate RequestedGoodsIssueDate Goods Issue
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
BaseUnit BaseUnit Unit of Measure
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit
SalesUnit SalesUnit Unit
DeliveredQuantityInSalesUnit DeliveredQuantityInSalesUnit Base quantity
_OutboundDelivery _OutboundDelivery

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProdnPlngOutbDelivQuickView.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: COUTBDQV

CREATE VIEW C_ProdnPlngOutbDelivQuickView AS
SELECT
  Delivery,
  DeliveryItem,
  DeliveryType,
  DocumentDate,
  ReferenceDocument,
  ReferenceDocumentItem,
  SalesDocumentType,
  Material,
  MRPPlant,
  MRPPlantName,
  MaterialGroup,
  StorageLocation,
  Batch,
  InventorySpecialStockType,
  MaterialByCustomer,
  CustomerMaterialBaseUnit,
  MinDeliveryQtyInBaseUnit,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustomerGroup,
  Customer,
  BPCustomerName,
  ContactPersonName,
  ContactPersonPhoneNumber,
  ContactPersonEmailAddress,
  DeliveryBlockReason,
  DeliveryBlockReasonText,
  DeliveryIsBlocked,
  DeliveryPriority,
  DeliveryPriorityDesc,
  CompleteDeliveryIsDefined,
  PartialDeliveryIsAllowed,
  DeliveryIsPostedGoodsIssue,
  RequestedDeliveryDate,
  RequestedLoadingDate,
  RequestedGoodsIssueDate,
  ProductAvailabilityDate,
  BaseUnit,
  DeliveredQuantityInBaseUnit,
  SalesUnit,
  DeliveredQuantityInSalesUnit
FROM I_OutboundDeliveryQuickView
;

Learn More