What is C_SlOrWtCrItemPartnerManageTP in SAP S/4HANA?

C_SlOrWtCrItemPartnerManageTP is a consumption CDS view in SAP S/4HANA. Sls Ord Without Chrg Item Part - Manage It contains 61 fields.

Which tables does C_SlOrWtCrItemPartnerManageTP read from?

C_SlOrWtCrItemPartnerManageTP reads data from: R_SlsOrdWthoutChrgItmPartnerTP.

What VDM layer is C_SlOrWtCrItemPartnerManageTP?

C_SlOrWtCrItemPartnerManageTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SlOrWtCrItemPartnerManageTP

DDL: C_SLORWTCRITEMPARTNERMANAGETP Type: view_entity CONSUMPTION Package: ODATA_SD_SLSORDWOCHARGE_UI

61 Fields 1 Data Sources 1 Associations 1 OData Services

Sls Ord Without Chrg Item Part - Manage

C_SlOrWtCrItemPartnerManageTP is a Consumption CDS View that provides data about "Sls Ord Without Chrg Item Part - Manage" in SAP S/4HANA. It reads from 1 data source (R_SlsOrdWthoutChrgItmPartnerTP) and exposes 61 fields with key fields SalesOrderWithoutCharge, SalesOrderWithoutChargeItem, PartnerFunction. It has 1 association to related views. It is exposed through 1 OData service (UI_SLSORDERWITHOUTCHARGEMANAGE). Part of development package ODATA_SD_SLSORDWOCHARGE_UI.

Data Sources (1)

Source	Alias	Join Type
R_SlsOrdWthoutChrgItmPartnerTP	R_SlsOrdWthoutChrgItmPartnerTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	C_PartnerFunctionUnconverted	_PartnerFunction	`$projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#TRANSACTIONAL_QUERY	view
ObjectModel.query.implementedBy	ABAP:CL_S4RAP_STICKY_QRY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Sls Ord Without Chrg Item Part - Manage	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_SLSORDERWITHOUTCHARGEMANAGE	UI_SLSORDERWITHOUTCHARGEMANAGE	V4	C1	NOT_RELEASED

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	SalesOrderWithoutCharge	SlsOrdWithoutChargeItemPartner	SalesOrderWithoutCharge
KEY	SalesOrderWithoutChargeItem	SlsOrdWithoutChargeItemPartner	SalesOrderWithoutChargeItem
KEY	PartnerFunction	SlsOrdWithoutChargeItemPartner	PartnerFunction	Partner Functn
	PartnerFunctionForEdit	SlsOrdWithoutChargeItemPartner	PartnerFunctionForEdit	Partner Funct.
	Customer	SlsOrdWithoutChargeItemPartner	Customer	Sold-to Party
	Supplier	SlsOrdWithoutChargeItemPartner	Supplier	Supplier
	Personnel	SlsOrdWithoutChargeItemPartner	Personnel	Personnel No.
	ContactPerson	SlsOrdWithoutChargeItemPartner	ContactPerson	Contact Person Key
	Partner	SlsOrdWithoutChargeItemPartner	Partner	With Partner
	ReferenceBusinessPartner	SlsOrdWithoutChargeItemPartner	ReferenceBusinessPartner	Busn. Partner
	FullName	SlsOrdWithoutChargeItemPartner	FullName	Name
	SDDocumentPartnerType	SlsOrdWithoutChargeItemPartner	SDDocumentPartnerType	Partner Type
	PartnerIsSpecificForSDDocItem	SlsOrdWithoutChargeItemPartner	PartnerIsSpecificForSDDocItem
	UnloadingPointName	SlsOrdWithoutChargeItemPartner	UnloadingPointName	Unloading Point Name
	VATRegistration	SlsOrdWithoutChargeItemPartner	VATRegistration	VAT Registration No.
	virtualSDCustomerAddressIDadrnr
	virtualSDContactPersonAddressIDadrnr
	SDDocPartnerAddrIsDocSpecific	SlsOrdWithoutChargeItemPartner	SDDocPartnerAddrIsDocSpecific
	PartnerIsOneTimeAccount	SlsOrdWithoutChargeItemPartner	PartnerIsOneTimeAccount	One-Time Customer
	AddressID	SlsOrdWithoutChargeItemPartner	AddressID	Ship-to address
	AddressPersonID	SlsOrdWithoutChargeItemPartner	AddressPersonID	Person Number
	AddressObjectType	SlsOrdWithoutChargeItemPartner	AddressObjectType	Address Type
	virtualBusinessPartnerName1ad_name1
	virtualBusinessPartnerName2ad_name2
	virtualBusinessPartnerName3ad_name3
	virtualBusinessPartnerName4ad_name4
	FormOfAddress	SlsOrdWithoutChargeItemPartner	FormOfAddress	Title Key
	PostalCode	SlsOrdWithoutChargeItemPartner	PostalCode	Postal Code
	CityName	SlsOrdWithoutChargeItemPartner	CityName	Name
	Country	SlsOrdWithoutChargeItemPartner	Country	Venue: Ctry/Reg
	Region	SlsOrdWithoutChargeItemPartner	Region	Venue Region
	DistrictName	SlsOrdWithoutChargeItemPartner	DistrictName	District
	StreetName	SlsOrdWithoutChargeItemPartner	StreetName	Text
	StreetPrefixName1	SlsOrdWithoutChargeItemPartner	StreetPrefixName1	Street 2
	StreetPrefixName2	SlsOrdWithoutChargeItemPartner	StreetPrefixName2	Street 3
	StreetSuffixName1	SlsOrdWithoutChargeItemPartner	StreetSuffixName1	Street 4
	StreetSuffixName2	SlsOrdWithoutChargeItemPartner	StreetSuffixName2	Street 5
	HouseNumber	SlsOrdWithoutChargeItemPartner	HouseNumber	House Number
	POBox	SlsOrdWithoutChargeItemPartner	POBox	PO Box
	POBoxPostalCode	SlsOrdWithoutChargeItemPartner	POBoxPostalCode	PO Box Postal Code
	CorrespondenceLanguage	SlsOrdWithoutChargeItemPartner	CorrespondenceLanguage	Correspondence Language
	TaxJurisdiction	SlsOrdWithoutChargeItemPartner	TaxJurisdiction	Tax Jurisdiction
	TransportZone	SlsOrdWithoutChargeItemPartner	TransportZone	Transport Zone
	InternationalPhoneNumber	SlsOrdWithoutChargeItemPartner	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	SlsOrdWithoutChargeItemPartner	InternationalMobilePhoneNumber
	InternationalFaxNumber	SlsOrdWithoutChargeItemPartner	InternationalFaxNumber	Fax Number
	EmailAddress	SlsOrdWithoutChargeItemPartner	EmailAddress	E-Mail Address
	virtualUICT_VATRegistrationboole_d
	virtualUICT_UnloadingPointNameboole_d
	virtualUICT_BusinessPartnerName3boole_d
	virtualUICT_BusinessPartnerName4boole_d
	SalesOrderWithoutChargeType	SlsOrdWithoutChargeItemPartner	SalesOrderWithoutChargeType
	SalesOrganization	SlsOrdWithoutChargeItemPartner	SalesOrganization	Sales Organization
	DistributionChannel	SlsOrdWithoutChargeItemPartner	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	SlsOrdWithoutChargeItemPartner	OrganizationDivision	Org. Division
	_PartnerFunction		_PartnerFunction
	_FormOfAddress	SlsOrdWithoutChargeItemPartner	_FormOfAddress
	_Country	SlsOrdWithoutChargeItemPartner	_Country
	_Region	SlsOrdWithoutChargeItemPartner	_Region
	_CorrespondenceLanguage	SlsOrdWithoutChargeItemPartner	_CorrespondenceLanguage
	_TransportationZone	SlsOrdWithoutChargeItemPartner	_TransportationZone

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 C_SlOrWtCrItemPartnerManageTP.
-- 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 C_SlOrWtCrItemPartnerManageTP AS
SELECT
  SlsOrdWithoutChargeItemPartner.SalesOrderWithoutCharge AS SalesOrderWithoutCharge,
  SlsOrdWithoutChargeItemPartner.SalesOrderWithoutChargeItem AS SalesOrderWithoutChargeItem,
  SlsOrdWithoutChargeItemPartner.PartnerFunction AS PartnerFunction,
  SlsOrdWithoutChargeItemPartner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  SlsOrdWithoutChargeItemPartner.Customer AS Customer,
  SlsOrdWithoutChargeItemPartner.Supplier AS Supplier,
  SlsOrdWithoutChargeItemPartner.Personnel AS Personnel,
  SlsOrdWithoutChargeItemPartner.ContactPerson AS ContactPerson,
  SlsOrdWithoutChargeItemPartner.Partner AS Partner,
  SlsOrdWithoutChargeItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SlsOrdWithoutChargeItemPartner.FullName AS FullName,
  SlsOrdWithoutChargeItemPartner.SDDocumentPartnerType AS SDDocumentPartnerType,
  SlsOrdWithoutChargeItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  SlsOrdWithoutChargeItemPartner.UnloadingPointName AS UnloadingPointName,
  SlsOrdWithoutChargeItemPartner.VATRegistration AS VATRegistration,
  virtual SDCustomerAddressID : adrnr AS virtualSDCustomerAddressIDadrnr,
  virtual SDContactPersonAddressID : adrnr AS virtualSDContactPersonAddressIDadrnr,
  SlsOrdWithoutChargeItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  SlsOrdWithoutChargeItemPartner.PartnerIsOneTimeAccount AS PartnerIsOneTimeAccount,
  SlsOrdWithoutChargeItemPartner.AddressID AS AddressID,
  SlsOrdWithoutChargeItemPartner.AddressPersonID AS AddressPersonID,
  SlsOrdWithoutChargeItemPartner.AddressObjectType AS AddressObjectType,
  virtual BusinessPartnerName1 : ad_name1 AS virtualBusinessPartnerName1ad_name1,
  virtual BusinessPartnerName2 : ad_name2 AS virtualBusinessPartnerName2ad_name2,
  virtual BusinessPartnerName3 : ad_name3 AS virtualBusinessPartnerName3ad_name3,
  virtual BusinessPartnerName4 : ad_name4 AS virtualBusinessPartnerName4ad_name4,
  SlsOrdWithoutChargeItemPartner.FormOfAddress AS FormOfAddress,
  SlsOrdWithoutChargeItemPartner.PostalCode AS PostalCode,
  SlsOrdWithoutChargeItemPartner.CityName AS CityName,
  SlsOrdWithoutChargeItemPartner.Country AS Country,
  SlsOrdWithoutChargeItemPartner.Region AS Region,
  SlsOrdWithoutChargeItemPartner.DistrictName AS DistrictName,
  SlsOrdWithoutChargeItemPartner.StreetName AS StreetName,
  SlsOrdWithoutChargeItemPartner.StreetPrefixName1 AS StreetPrefixName1,
  SlsOrdWithoutChargeItemPartner.StreetPrefixName2 AS StreetPrefixName2,
  SlsOrdWithoutChargeItemPartner.StreetSuffixName1 AS StreetSuffixName1,
  SlsOrdWithoutChargeItemPartner.StreetSuffixName2 AS StreetSuffixName2,
  SlsOrdWithoutChargeItemPartner.HouseNumber AS HouseNumber,
  SlsOrdWithoutChargeItemPartner.POBox AS POBox,
  SlsOrdWithoutChargeItemPartner.POBoxPostalCode AS POBoxPostalCode,
  SlsOrdWithoutChargeItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  SlsOrdWithoutChargeItemPartner.TaxJurisdiction AS TaxJurisdiction,
  SlsOrdWithoutChargeItemPartner.TransportZone AS TransportZone,
  SlsOrdWithoutChargeItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  SlsOrdWithoutChargeItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SlsOrdWithoutChargeItemPartner.InternationalFaxNumber AS InternationalFaxNumber,
  SlsOrdWithoutChargeItemPartner.EmailAddress AS EmailAddress,
  virtual UICT_VATRegistration : boole_d AS virtualUICT_VATRegistrationboole_d,
  virtual UICT_UnloadingPointName : boole_d AS virtualUICT_UnloadingPointNameboole_d,
  virtual UICT_BusinessPartnerName3 : boole_d AS virtualUICT_BusinessPartnerName3boole_d,
  virtual UICT_BusinessPartnerName4 : boole_d AS virtualUICT_BusinessPartnerName4boole_d,
  SlsOrdWithoutChargeItemPartner.SalesOrderWithoutChargeType AS SalesOrderWithoutChargeType,
  SlsOrdWithoutChargeItemPartner.SalesOrganization AS SalesOrganization,
  SlsOrdWithoutChargeItemPartner.DistributionChannel AS DistributionChannel,
  SlsOrdWithoutChargeItemPartner.OrganizationDivision AS OrganizationDivision,
  SlsOrdWithoutChargeItemPartner._FormOfAddress AS _FormOfAddress,
  SlsOrdWithoutChargeItemPartner._Country AS _Country,
  SlsOrdWithoutChargeItemPartner._Region AS _Region,
  SlsOrdWithoutChargeItemPartner._CorrespondenceLanguage AS _CorrespondenceLanguage,
  SlsOrdWithoutChargeItemPartner._TransportationZone AS _TransportationZone
FROM R_SlsOrdWthoutChrgItmPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Depth:

C_SlOrWtCrItemPartnerManageTP view_entity

R_SlsOrdWthoutChrgItmPartnerTP view_entity