A_ProdCmplncLogisticsDocItem_2

DDL: A_PRODCMPLNCLOGISTICSDOCITEM_2 Type: view_entity CONSUMPTION Package: EHFND_API_ODATA_LOGISTICS_DOC
30 Fields 1 Data Sources 2 OData Services

Prod Compliance Logs Document Item

A_ProdCmplncLogisticsDocItem_2 is a Consumption CDS View that provides data about "Prod Compliance Logs Document Item" in SAP S/4HANA. It reads from 1 data source (R_ProdCmplncLogsDocumentItemTP) and exposes 30 fields with key fields ProdCmplncLogsDocumentUUID, ProdCmplncLogsDocumentItem. It is exposed through 2 OData services (API_PRODCMPLNCLOGSDOCUMENT_2, ASQL_F8503). Part of development package EHFND_API_ODATA_LOGISTICS_DOC.

Data Sources (1)

SourceAliasJoin Type
R_ProdCmplncLogsDocumentItemTP R_ProdCmplncLogsDocumentItemTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Prod Compliance Logs Document Item view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name ProdCmplncLogisticsDocItem_Type view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
API_PRODCMPLNCLOGSDOCUMENT_2
ASQL_F8503 ASQL_F8503 C2 NOT_RELEASED

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncLogsDocumentUUID ProdCmplncLogsDocumentUUID Logistics Doc. UUID
KEY ProdCmplncLogsDocumentItem ProdCmplncLogsDocumentItem Item
LastChangeDateTime LastChangeDateTime Timestamp
Product Product Product Sold
DepartureCountry DepartureCountry Departure Country / Region
DestinationCountry DestinationCountry Dest. Ctry/Reg
DestinationRegion DestinationRegion Region
GoodsIssueDate GoodsIssueDate Goods Issue Date CCD
SalesOrganization SalesOrganization Sales Organization
Plant Plant Valuation Area
Supplier Supplier Supplier
Customer Customer Sold-to Party
ProdCmplncShipToPartyBusPrtn ProdCmplncShipToPartyBusPrtn
ProdCmplncShipToPartyAddressID ProdCmplncShipToPartyAddressID Ship-to Party Address
ProdCmplncSftyDataShtRcpntPty ProdCmplncSftyDataShtRcpntPty Recipient
PCSftyDataShtRcpntAddrID PCSftyDataShtRcpntAddrID SDS Recipient Address
DngrsGoodsMainModeOfTransport DngrsGoodsMainModeOfTransport Mode of Transport
ShippedQuantityInOrderQtyUnit ShippedQuantityInOrderQtyUnit Delivery Qty
OrderQuantitySAPUnit OrderQuantityUnit Sales Unit
OrderQuantityISOUnit
ProdCmplncLogsDocCntctPersnUsr ProdCmplncLogsDocCntctPersnUsr
ProdCmplncMarketabilityStatus ProdCmplncMarketabilityStatus Product Marketability Status
ProdCmplncMktbltyStatusReason ProdCmplncMktbltyStatusReason Check Result Reason
ProdCmplncDngrsGoodsStatus ProdCmplncDngrsGoodsStatus Transport Status
DangerousGoodsStatusReason DangerousGoodsStatusReason Reason
ProdCmplncSftyDataSheetStatus ProdCmplncSftyDataSheetStatus Safety Data Sheet Status
ProdCmplncSDSStatusReason ProdCmplncSDSStatusReason SDS Result Reason
ChmlSuplrChkStatus ChmlSuplrChkStatus Product Compliance Supplier Status
ChmlSuplrChkStatusReason ChmlSuplrChkStatusReason PCS Result Reason
SftyDtaShtRcpntPtyDetnType SftyDtaShtRcpntPtyDetnType Determination

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 A_ProdCmplncLogisticsDocItem_2.
-- 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.

CREATE VIEW A_ProdCmplncLogisticsDocItem_2 AS
SELECT
  ProdCmplncLogsDocumentUUID,
  ProdCmplncLogsDocumentItem,
  LastChangeDateTime,
  Product,
  DepartureCountry,
  DestinationCountry,
  DestinationRegion,
  GoodsIssueDate,
  SalesOrganization,
  Plant,
  Supplier,
  Customer,
  ProdCmplncShipToPartyBusPrtn,
  ProdCmplncShipToPartyAddressID,
  ProdCmplncSftyDataShtRcpntPty,
  PCSftyDataShtRcpntAddrID,
  DngrsGoodsMainModeOfTransport,
  ShippedQuantityInOrderQtyUnit,
  OrderQuantityUnit AS OrderQuantitySAPUnit,
  cast(_OrderQuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) AS OrderQuantityISOUnit,
  ProdCmplncLogsDocCntctPersnUsr,
  ProdCmplncMarketabilityStatus,
  ProdCmplncMktbltyStatusReason,
  ProdCmplncDngrsGoodsStatus,
  DangerousGoodsStatusReason,
  ProdCmplncSftyDataSheetStatus,
  ProdCmplncSDSStatusReason,
  ChmlSuplrChkStatus,
  ChmlSuplrChkStatusReason,
  SftyDtaShtRcpntPtyDetnType
FROM R_ProdCmplncLogsDocumentItemTP
;

Learn More