P_ARProcessFlowDeliveryDoc

DDL: P_ARPROCESSFLOWDELIVERYDOC SQL: PARPROCFLOWDELIV Type: view CONSUMPTION
28 Fields 1 Data Sources

Delivery Document details for AR process flow

P_ARProcessFlowDeliveryDoc is a Consumption CDS View that provides data about "Delivery Document details for AR process flow" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 28 fields with key field DeliveryDocument.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PARPROCFLOWDELIV view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Document details for AR process flow view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument Outbound Delivery
OverallSDProcessStatus OverallSDProcessStatus Overall Status
OverallSDProcessStatusDesc
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerName _ShipToParty CustomerName Name of Customer
CustomerFullName _ShipToParty CustomerFullName Customer Name
DocumentDate DocumentDate Journal Entry Date
HeaderGrossWeight HeaderGrossWeight Total Weight
HeaderNetWeight HeaderNetWeight Net Weight
HeaderWeightUnit HeaderWeightUnit Weight Unit
TotalNumberOfPackage TotalNumberOfPackage No. of Packages
ShippingPoint ShippingPoint Shipping Point
ShippingPointName
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
BillingBlockReasonDescription
PlannedGoodsIssueDate PlannedGoodsIssueDate Planned Gds Mvmt
ProposedDeliveryRoute ProposedDeliveryRoute Vehicle route
DeliveryBlockReason DeliveryBlockReason Delivery Block
PickingDate PickingDate Pick Date
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
LoadingDate LoadingDate Loading Date
DeliveryDate DeliveryDate Delivery Date
LoadingPoint LoadingPoint Loading Point
OverallPickingStatus OverallPickingStatus Picking Status
OverallWarehouseActivityStatus OverallWarehouseActivityStatus WM Activity Sts
_Item _Item
_ShipToParty _ShipToParty
_HeaderWeightUnit _HeaderWeightUnit

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 P_ARProcessFlowDeliveryDoc.
-- 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: PARPROCFLOWDELIV

CREATE VIEW P_ARProcessFlowDeliveryDoc AS
SELECT
  DeliveryDocument,
  OverallSDProcessStatus,
  _OverallSDProcessStatus._Text[1:Language = $session.system_language].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  ShipToParty,
  _ShipToParty.CustomerName AS CustomerName,
  _ShipToParty.CustomerFullName AS CustomerFullName,
  DocumentDate,
  HeaderGrossWeight,
  HeaderNetWeight,
  HeaderWeightUnit,
  TotalNumberOfPackage,
  ShippingPoint,
  _ShippingPoint._Text[1:Language = $session.system_language].ShippingPointName AS ShippingPointName,
  HeaderBillingBlockReason,
  _HeaderBillingBlockReason._Text[1:Language = $session.system_language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  PlannedGoodsIssueDate,
  ProposedDeliveryRoute,
  DeliveryBlockReason,
  PickingDate,
  TransportationPlanningDate,
  LoadingDate,
  DeliveryDate,
  LoadingPoint,
  OverallPickingStatus,
  OverallWarehouseActivityStatus
FROM I_DeliveryDocument
;

Learn More