C_Cust360RecentDeliveryDoc

DDL: C_CUST360RECENTDELIVERYDOC SQL: CUST360BDRDEL Type: view_entity CONSUMPTION
18 Fields 2 Data Sources 1 OData Services

Customer 360 Recent Delivery

C_Cust360RecentDeliveryDoc is a Consumption CDS View that provides data about "Customer 360 Recent Delivery" in SAP S/4HANA. It reads from 2 data sources (I_Customer360BusDocSetting, I_DeliveryDocument) and exposes 18 fields with key fields SoldToParty, OutboundDelivery, SDDocumentCategory. It is exposed through 1 OData service (SD_ADVNCD_CUSTOMER360).

Data Sources (2)

SourceAliasJoin Type
I_Customer360BusDocSetting Customer360BusDocSetting inner
I_DeliveryDocument DeliveryDocument from

Annotations (6)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Customer 360 Recent Delivery view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
SD_ADVNCD_CUSTOMER360 SD_ADVNCD_CUSTOMER360 V4 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SoldToParty I_DeliveryDocument SoldToParty Sold-to Party
KEY OutboundDelivery I_DeliveryDocument DeliveryDocument Outbound Delivery
KEY SDDocumentCategory I_DeliveryDocument SDDocumentCategory Document Cat.
CustomerName
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType Delivery Type
DeliveryDocumentTypeName
OverallSDProcessStatus I_DeliveryDocument OverallSDProcessStatus Overall Status
OverallSDProcessStatusDesc
TotalNetAmount I_DeliveryDocument TotalNetAmount Total Net Amount
TransactionCurrency I_DeliveryDocument TransactionCurrency Transaction Currency
CreationDate I_DeliveryDocument CreationDate Time Stamp
_DeliveryDocumentType I_DeliveryDocument _DeliveryDocumentType
_OverallSDProcessStatus I_DeliveryDocument _OverallSDProcessStatus
SalesOrganization I_DeliveryDocument SalesOrganization Sales Organization
ShippingPoint I_DeliveryDocument ShippingPoint Shipping Point
ShippingPointName
_ShippingPoint I_DeliveryDocument _ShippingPoint
_SoldToParty I_DeliveryDocument _SoldToParty

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_Cust360RecentDeliveryDoc.
-- 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: CUST360BDRDEL

CREATE VIEW C_Cust360RecentDeliveryDoc AS
SELECT
  DeliveryDocument.SoldToParty AS SoldToParty,
  DeliveryDocument.DeliveryDocument AS OutboundDelivery,
  DeliveryDocument.SDDocumentCategory AS SDDocumentCategory,
  DeliveryDocument._SoldToParty.CustomerName AS CustomerName,
  DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  DeliveryDocument._DeliveryDocumentType._Text[1:Language = $session.system_language].DeliveryDocumentTypeName AS DeliveryDocumentTypeName,
  DeliveryDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  DeliveryDocument._OverallSDProcessStatus._Text[1:Language = $session.system_language].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  DeliveryDocument.TotalNetAmount AS TotalNetAmount,
  DeliveryDocument.TransactionCurrency AS TransactionCurrency,
  DeliveryDocument.CreationDate AS CreationDate,
  DeliveryDocument._DeliveryDocumentType AS _DeliveryDocumentType,
  DeliveryDocument._OverallSDProcessStatus AS _OverallSDProcessStatus,
  DeliveryDocument.SalesOrganization AS SalesOrganization,
  DeliveryDocument.ShippingPoint AS ShippingPoint,
  DeliveryDocument._ShippingPoint._Text[1:Language = $session.system_language].ShippingPointName AS ShippingPointName,
  DeliveryDocument._ShippingPoint AS _ShippingPoint,
  DeliveryDocument._SoldToParty AS _SoldToParty
FROM I_DeliveryDocument AS DeliveryDocument
INNER JOIN I_Customer360BusDocSetting AS Customer360BusDocSetting ON /* join condition not captured in parsed metadata */
;

Learn More