P_SalesDocumentItemFulfillmnt1

DDL: P_SALESDOCUMENTITEMFULFILLMNT1 SQL: PSDSLSDOCITMFLF1 Type: view COMPOSITE
22 Fields 1 Data Sources

P_SalesDocumentItemFulfillmnt1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SalesDocumentItemFulfillmnt2) and exposes 22 fields with key fields SalesDocument, SalesDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_SalesDocumentItemFulfillmnt2 P_SalesDocumentItemFulfillmnt2 from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDSLSDOCITMFLF1 view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
Material Material Vehicle Model
Product Product Product Sold
SalesDocumentItemText SalesDocumentItemText Item Descr.
OrderQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
TargetQuantity TargetQuantity Target Quantity
TargetQuantityUnit TargetQuantityUnit Target Qty UoM
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ShippedQuantityInOrderQtyUnit ShippedQuantityInOrderQtyUnit Delivery Qty
BillingDocumentDate BillingDocumentDate Billing Date
InvoicedQuantityInOrderQtyUnit InvoicedQuantityInOrderQtyUnit
SDDocumentRejectionStatus SDDocumentRejectionStatus
DeliveryStatus DeliveryStatus Delivery Status
SDProcessStatus SDProcessStatus
_OrderQuantityUnit _OrderQuantityUnit
_SalesDocumentType _SalesDocumentType

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_SalesDocumentItemFulfillmnt1.
-- 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: PSDSLSDOCITMFLF1

CREATE VIEW P_SalesDocumentItemFulfillmnt1 AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  SalesDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Material,
  Product,
  SalesDocumentItemText,
  OrderQuantity,
  OrderQuantityUnit,
  TargetQuantity,
  TargetQuantityUnit,
  RequestedDeliveryDate,
  ShippedQuantityInOrderQtyUnit,
  BillingDocumentDate,
  InvoicedQuantityInOrderQtyUnit,
  SDDocumentRejectionStatus,
  DeliveryStatus,
  SDProcessStatus
FROM P_SalesDocumentItemFulfillmnt2
;

Learn More