P_SalesDocumentItemFulfillmnt4

DDL: P_SALESDOCUMENTITEMFULFILLMNT4 SQL: PSDSLSDOCITMFLF4 Type: view COMPOSITE
15 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItemBasic SalesDocItem 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 PSDSLSDOCITMFLF4 view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItemBasic SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
SalesDocumentType _SalesDocumentBasic SalesDocumentType Sales Doc. Type
SalesOrganization
DistributionChannel _SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesDocumentBasic OrganizationDivision Org. Division
Material I_SalesDocumentItemBasic Material Vehicle Model
SalesDocumentItemText I_SalesDocumentItemBasic SalesDocumentItemText Item Descr.
OrderQuantity I_SalesDocumentItemBasic OrderQuantity Quantity
OrderQuantityUnit I_SalesDocumentItemBasic OrderQuantityUnit Sales Unit
OrderToBaseQuantityDnmntr I_SalesDocumentItemBasic OrderToBaseQuantityDnmntr Denominator
OrderToBaseQuantityNmrtr I_SalesDocumentItemBasic OrderToBaseQuantityNmrtr Numerator
UnderdelivTolrtdLmtRatioInPct I_SalesDocumentItemBasic UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
ItemIsBillingRelevant I_SalesDocumentItemBasic ItemIsBillingRelevant
SDDocumentRejectionStatus I_SalesDocumentItemBasic SDDocumentRejectionStatus

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_SalesDocumentItemFulfillmnt4.
-- 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: PSDSLSDOCITMFLF4

CREATE VIEW P_SalesDocumentItemFulfillmnt4 AS
SELECT
  SalesDocItem.SalesDocument AS SalesDocument,
  SalesDocItem.SalesDocumentItem AS SalesDocumentItem,
  _SalesDocumentBasic.SalesDocumentType AS SalesDocumentType,
  _SalesDocumentBasic.DistributionChannel AS DistributionChannel,
  _SalesDocumentBasic.OrganizationDivision AS OrganizationDivision,
  SalesDocItem.Material AS Material,
  SalesDocItem.SalesDocumentItemText AS SalesDocumentItemText,
  SalesDocItem.OrderQuantity AS OrderQuantity,
  SalesDocItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesDocItem.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  SalesDocItem.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  SalesDocItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  SalesDocItem.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  SalesDocItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus
FROM I_SalesDocumentItemBasic AS SalesDocItem
;

Learn More