P_SlsDocItmCntdNonStdPartner

DDL: P_SLSDOCITMCNTDNONSTDPARTNER Type: view CONSUMPTION Package: SD_CHANGE_COCKPIT_ODATA
16 Fields 1 Data Sources

Sls Doc Item with Count of non Std Partners

P_SlsDocItmCntdNonStdPartner is a Consumption CDS View that provides data about "Sls Doc Item with Count of non Std Partners" in SAP S/4HANA. It reads from 1 data source (I_SlsDocItmNonStdPartner) and exposes 16 fields with key fields SalesDocument, SalesDocumentItem, PartnerFunction. Part of development package SD_CHANGE_COCKPIT_ODATA.

Data Sources (1)

SourceAliasJoin Type
I_SlsDocItmNonStdPartner _NonStdPartners from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Sls Doc Item with Count of non Std Partners view
AbapCatalog.sqlViewName PSDCNTDITMNSTDPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SlsDocItmNonStdPartner SalesDocument SD Document
KEY SalesDocumentItem I_SlsDocItmNonStdPartner SalesDocumentItem Sales Document Item
KEY PartnerFunction I_SlsDocItmNonStdPartner PartnerFunction Partner Functn
PartnerFunctionName I_SlsDocItmNonStdPartner PartnerFunctionName Name
Customer I_SlsDocItmNonStdPartner Customer Sold-to Party
Supplier I_SlsDocItmNonStdPartner Supplier Supplier
Partner I_SlsDocItmNonStdPartner Partner With Partner
NumberOfAdditionalPartners _AdditionalPartnerCount NumberOfAdditionalPartners
Personnel I_SlsDocItmNonStdPartner Personnel Personnel No.
AddressID I_SlsDocItmNonStdPartner AddressID Ship-to address
AddressPersonID I_SlsDocItmNonStdPartner AddressPersonID Person Number
ContactPerson I_SlsDocItmNonStdPartner ContactPerson Contact Person Key
_PartnerFunction I_SlsDocItmNonStdPartner _PartnerFunction
_SalesDocument I_SlsDocItmNonStdPartner _SalesDocument
_SalesDocumentItem I_SlsDocItmNonStdPartner _SalesDocumentItem
_DfltAddrRprstn I_SlsDocItmNonStdPartner _DfltAddrRprstn

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_SlsDocItmCntdNonStdPartner.
-- 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 P_SlsDocItmCntdNonStdPartner AS
SELECT
  _NonStdPartners.SalesDocument AS SalesDocument,
  _NonStdPartners.SalesDocumentItem AS SalesDocumentItem,
  _NonStdPartners.PartnerFunction AS PartnerFunction,
  _NonStdPartners.PartnerFunctionName AS PartnerFunctionName,
  _NonStdPartners.Customer AS Customer,
  _NonStdPartners.Supplier AS Supplier,
  _NonStdPartners.Partner AS Partner,
  _AdditionalPartnerCount.NumberOfAdditionalPartners AS NumberOfAdditionalPartners,
  _NonStdPartners.Personnel AS Personnel,
  _NonStdPartners.AddressID AS AddressID,
  _NonStdPartners.AddressPersonID AS AddressPersonID,
  _NonStdPartners.ContactPerson AS ContactPerson,
  _NonStdPartners._PartnerFunction AS _PartnerFunction,
  _NonStdPartners._SalesDocument AS _SalesDocument,
  _NonStdPartners._SalesDocumentItem AS _SalesDocumentItem,
  _NonStdPartners._DfltAddrRprstn AS _DfltAddrRprstn
FROM I_SlsDocItmNonStdPartner AS _NonStdPartners
;

Learn More