P_SlsDocCntdNonStdPartner

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

SD Document with Count of non Std Partners

P_SlsDocCntdNonStdPartner is a Consumption CDS View that provides data about "SD Document with Count of non Std Partners" in SAP S/4HANA. It reads from 1 data source (I_SlsDocNonStdPartner) and exposes 16 fields with key fields SDDocument, SDDocumentItem, PartnerFunction. Part of development package SD_CHANGE_COCKPIT_ODATA.

Data Sources (1)

SourceAliasJoin Type
I_SlsDocNonStdPartner _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 SD Document with Count of non Std Partners view
AbapCatalog.sqlViewName PSLSDOCCNTNSTDPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SDDocument I_SlsDocNonStdPartner SDDocument SD Document
KEY SDDocumentItem I_SlsDocNonStdPartner SDDocumentItem
KEY PartnerFunction I_SlsDocNonStdPartner PartnerFunction Partner Functn
PartnerFunctionName I_SlsDocNonStdPartner PartnerFunctionName Name
Customer I_SlsDocNonStdPartner Customer Sold-to Party
Supplier I_SlsDocNonStdPartner Supplier Supplier
BusinessPartner I_SlsDocNonStdPartner BusinessPartner Issuing Authority
BusinessPartnerFullName I_SlsDocNonStdPartner BusinessPartnerFullName Broker Name
NumberOfAdditionalPartners _AdditionalPartnerCount NumberOfAdditionalPartners
Personnel I_SlsDocNonStdPartner Personnel Personnel No.
AddressID I_SlsDocNonStdPartner AddressID Ship-to address
AddressPersonID I_SlsDocNonStdPartner AddressPersonID Person Number
ContactPerson I_SlsDocNonStdPartner ContactPerson Contact Person Key
_PartnerFunction I_SlsDocNonStdPartner _PartnerFunction
_DfltAddrRprstn I_SlsDocNonStdPartner _DfltAddrRprstn
_ContactPerson I_SlsDocNonStdPartner _ContactPerson

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_SlsDocCntdNonStdPartner.
-- 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_SlsDocCntdNonStdPartner AS
SELECT
  _NonStdPartners.SDDocument AS SDDocument,
  _NonStdPartners.SDDocumentItem AS SDDocumentItem,
  _NonStdPartners.PartnerFunction AS PartnerFunction,
  _NonStdPartners.PartnerFunctionName AS PartnerFunctionName,
  _NonStdPartners.Customer AS Customer,
  _NonStdPartners.Supplier AS Supplier,
  _NonStdPartners.BusinessPartner AS BusinessPartner,
  _NonStdPartners.BusinessPartnerFullName AS BusinessPartnerFullName,
  _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._DfltAddrRprstn AS _DfltAddrRprstn,
  _NonStdPartners._ContactPerson AS _ContactPerson
FROM I_SlsDocNonStdPartner AS _NonStdPartners
;

Learn More