What is C_SlsPricingConditionRecordTP in SAP S/4HANA?

C_SlsPricingConditionRecordTP is a consumption CDS view in SAP S/4HANA. Condition Record for Pricing in Sales It contains 341 fields.

Which tables does C_SlsPricingConditionRecordTP read from?

C_SlsPricingConditionRecordTP reads data from: I_SlsPricingConditionRecordTP.

What VDM layer is C_SlsPricingConditionRecordTP?

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

C_SlsPricingConditionRecordTP

DDL: C_SLSPRICINGCONDITIONRECORDTP SQL: CSLSPRCGCNDNRTP Type: view CONSUMPTION Package: VDM_SD_MD_CM

341 Fields 1 Data Sources 2 Associations

Condition Record for Pricing in Sales

C_SlsPricingConditionRecordTP is a Consumption CDS View that provides data about "Condition Record for Pricing in Sales" in SAP S/4HANA. It reads from 1 data source (I_SlsPricingConditionRecordTP) and exposes 341 fields with key field ConditionRecordUUID. It has 2 associations to related views. Part of development package VDM_SD_MD_CM.

Data Sources (1)

Source	Alias	Join Type
I_SlsPricingConditionRecordTP	RecordTP	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	E_SlsPrcgCndnRecdValidity	_Extension	`$projection.ConditionRecord = _Extension.ConditionRecord and $projection.ConditionValidityEndDate = _Extension.ConditionValidityEndDate`
[0..*]	C_SlsPrcgCndnRecordScaleTP	_SlsPricingCndnRecdScaleTP	`$projection.ConditionRecordUUID = _SlsPricingCndnRecdScaleTP.ConditionRecordUUID`

Annotations (20)

Name	Value	Level
AbapCatalog.sqlViewName	CSLSPRCGCNDNRTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Condition Record for Pricing in Sales	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.compositionRoot	true	view
ObjectModel.representativeKey	ConditionRecordUUID	view
ObjectModel.draftEnabled	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
Metadata.allowExtensions	true	view
Consumption.semanticObject	SalesPrices	view

Fields (341)

Key	Field	Source Table	Source Field	Description
KEY	ConditionRecordUUID	I_SlsPricingConditionRecordTP	ConditionRecordUUID	Key
	ConditionRecord	I_SlsPricingConditionRecordTP	ConditionRecord	Cond.Record No.
	ConditionSequentialNumber	I_SlsPricingConditionRecordTP	ConditionSequentialNumber	SequNo of Cond.
	ConditionValidityEndDate	I_SlsPricingConditionRecordTP	ConditionValidityEndDate	Valid To
	ValidOnDate	I_SlsPricingConditionRecordTP	ValidOnDate
	ConditionValidityStartDate	I_SlsPricingConditionRecordTP	ConditionValidityStartDate	Valid From
	ConditionTable	I_SlsPricingConditionRecordTP	ConditionTable	Condition Table
	ConditionTableDescription	I_SlsPricingConditionRecordTP	ConditionTableDescription
	AccessNumberOfAccessSequence	I_SlsPricingConditionRecordTP	AccessNumberOfAccessSequence	Access
	ConditionApplication	I_SlsPricingConditionRecordTP	ConditionApplication	Application
	ConditionType	I_SlsPricingConditionRecordTP	ConditionType	Condition type
	ConditionTypeName	I_SlsPricingConditionRecordTP	ConditionTypeName	Name
	CreatedByUser	I_SlsPricingConditionRecordTP	CreatedByUser	User Name
	CreationDate	I_SlsPricingConditionRecordTP	CreationDate	Time Stamp
	ConditionSearchTermValue	I_SlsPricingConditionRecordTP	ConditionSearchTermValue
	ConditionTextID	I_SlsPricingConditionRecordTP	ConditionTextID	Text number
	PricingScaleType	I_SlsPricingConditionRecordTP	PricingScaleType	Scale Type
	PricingScaleTypeName	I_SlsPricingConditionRecordTP	PricingScaleTypeName	Scale Type
	PricingScaleBasis	I_SlsPricingConditionRecordTP	PricingScaleBasis	Scale Basis
	PricingScaleBasisName	I_SlsPricingConditionRecordTP	PricingScaleBasisName
	PricingScaleCheckingRule	I_SlsPricingConditionRecordTP	PricingScaleCheckingRule	Check Scale
	PricingScaleCheckingRuleName	I_SlsPricingConditionRecordTP	PricingScaleCheckingRuleName
	ConditionScaleQuantity	I_SlsPricingConditionRecordTP	ConditionScaleQuantity	Scale Quantity
	ConditionScaleQuantityUnit	I_SlsPricingConditionRecordTP	ConditionScaleQuantityUnit	Scale UoM
	ConditionScaleAmount	I_SlsPricingConditionRecordTP	ConditionScaleAmount	Scale Value
	ConditionScaleAmountCurrency	I_SlsPricingConditionRecordTP	ConditionScaleAmountCurrency	Scale Currency
	ConditionCalculationType	I_SlsPricingConditionRecordTP	ConditionCalculationType	Calculat.Type
	ConditionCalculationTypeName	I_SlsPricingConditionRecordTP	ConditionCalculationTypeName
	ConditionRateValue	I_SlsPricingConditionRecordTP	ConditionRateValue	Condition Rate Value
	ConditionRateValueUnit	I_SlsPricingConditionRecordTP	ConditionRateValueUnit	Unit of Condition Rate Value
	ConditionRateRatioUnit	I_SlsPricingConditionRecordTP	ConditionRateRatioUnit	Unit of Measure
	ConditionRateRatio	I_SlsPricingConditionRecordTP	ConditionRateRatio	Ratio
	ConditionCurrency	I_SlsPricingConditionRecordTP	ConditionCurrency	Currency
	ConditionRateAmount	I_SlsPricingConditionRecordTP	ConditionRateAmount	Condition Amount
	ConditionRateValueIsAmount	I_SlsPricingConditionRecordTP	ConditionRateValueIsAmount	TRUE
	ConditionRateValueIsRatio	I_SlsPricingConditionRecordTP	ConditionRateValueIsRatio	TRUE
	ConditionQuantity	I_SlsPricingConditionRecordTP	ConditionQuantity	Pricing Unit
	ConditionQuantityUnit	I_SlsPricingConditionRecordTP	ConditionQuantityUnit	Unit of Measure
	ConditionToBaseQtyNmrtr	I_SlsPricingConditionRecordTP	ConditionToBaseQtyNmrtr	Numerator
	ConditionToBaseQtyDnmntr	I_SlsPricingConditionRecordTP	ConditionToBaseQtyDnmntr	Denominator
	BaseUnit	I_SlsPricingConditionRecordTP	BaseUnit	Unit of Measure
	ConditionUnitConversionText	I_SlsPricingConditionRecordTP	ConditionUnitConversionText
	ConditionLowerLimit	I_SlsPricingConditionRecordTP	ConditionLowerLimit	Lower limit
	ConditionUpperLimit	I_SlsPricingConditionRecordTP	ConditionUpperLimit	Upper limit
	ConditionLowerLimitAmount	I_SlsPricingConditionRecordTP	ConditionLowerLimitAmount	Amount
	ConditionLowerLimitRatio	I_SlsPricingConditionRecordTP	ConditionLowerLimitRatio	Ratio
	ConditionUpperLimitAmount	I_SlsPricingConditionRecordTP	ConditionUpperLimitAmount	Amount
	ConditionUpperLimitRatio	I_SlsPricingConditionRecordTP	ConditionUpperLimitRatio	Ratio
	ConditionAlternativeCurrency	I_SlsPricingConditionRecordTP	ConditionAlternativeCurrency	Cndn Currency
	ConditionExclusion	I_SlsPricingConditionRecordTP	ConditionExclusion	Exclusion
	ConditionIsDeleted	I_SlsPricingConditionRecordTP	ConditionIsDeleted	Deletion Indic.
	ConditionHasScales	I_SlsPricingConditionRecordTP	ConditionHasScales	Scales
	AdditionalValueDays	I_SlsPricingConditionRecordTP	AdditionalValueDays	Add. Value Days
	FixedValueDate	I_SlsPricingConditionRecordTP	FixedValueDate	Fixed Val. Date
	PaymentTerms	I_SlsPricingConditionRecordTP	PaymentTerms	Pyt Terms
	PaymentTermsName	I_SlsPricingConditionRecordTP	PaymentTermsName	Description
	CndnMaxNumberOfSalesOrders	I_SlsPricingConditionRecordTP	CndnMaxNumberOfSalesOrders	NumberOfOrders
	MinimumConditionBasisValue	I_SlsPricingConditionRecordTP	MinimumConditionBasisValue	MinCondBaseVal.
	MaximumConditionBasisValue	I_SlsPricingConditionRecordTP	MaximumConditionBasisValue	MaxCondBaseVal.
	MaximumConditionAmount	I_SlsPricingConditionRecordTP	MaximumConditionAmount	MaxConditValue
	IncrementalScale	I_SlsPricingConditionRecordTP	IncrementalScale	Increment scale
	PricingScaleLine	I_SlsPricingConditionRecordTP	PricingScaleLine	Pricing scale
	ConditionReleaseStatus	I_SlsPricingConditionRecordTP	ConditionReleaseStatus	Release Status
	ConditionReleaseStatusText	I_SlsPricingConditionRecordTP	ConditionReleaseStatusText
	Criticality	I_SlsPricingConditionRecordTP	Criticality	Status Rating
	DepartureCountry	I_SlsPricingConditionRecordTP	DepartureCountry	Departure Country / Region
	DepartureCountryName	I_SlsPricingConditionRecordTP	DepartureCountryName	Name Country / Region
	SalesDocument	I_SlsPricingConditionRecordTP	SalesDocument	SD Document
	SalesDocumentItem	I_SlsPricingConditionRecordTP	SalesDocumentItem	Sales Document Item
	SalesDocumentItemText	I_SlsPricingConditionRecordTP	SalesDocumentItemText	Item Descr.
	BillableControl	I_SlsPricingConditionRecordTP	BillableControl	Billable Control
	BillableControlName	I_SlsPricingConditionRecordTP	BillableControlName
	Industry	I_SlsPricingConditionRecordTP	Industry	Industry Sector
	IndustryKeyText	I_SlsPricingConditionRecordTP	IndustryKeyText
	ProdUnivHierarchyNode	I_SlsPricingConditionRecordTP	ProdUnivHierarchyNode
	ProdUnivHierarchyNodeText	I_SlsPricingConditionRecordTP	ProdUnivHierarchyNodeText
	ProductHierarchyNode	I_SlsPricingConditionRecordTP	ProductHierarchyNode	Prod. Hierarchy
	ProductHierarchyNodeText	I_SlsPricingConditionRecordTP	ProductHierarchyNodeText
	CityCode	I_SlsPricingConditionRecordTP	CityCode	IATA: City
	CityCodeName	I_SlsPricingConditionRecordTP	CityCodeName	City Code
	ConditionContract	I_SlsPricingConditionRecordTP	ConditionContract	Condition Contract
	County	I_SlsPricingConditionRecordTP	County	Wyoming County
	CountyName	I_SlsPricingConditionRecordTP	CountyName
	TechnicalObjectType	I_SlsPricingConditionRecordTP	TechnicalObjectType	Text object
	TechnicalObjectTypeDesc	I_SlsPricingConditionRecordTP	TechnicalObjectTypeDesc
	Equipment	I_SlsPricingConditionRecordTP	Equipment	Equipment check
	EquipmentName	I_SlsPricingConditionRecordTP	EquipmentName	Tech. Obj. Desc
	CustomerHierarchy	I_SlsPricingConditionRecordTP	CustomerHierarchy
	IncotermsClassification	I_SlsPricingConditionRecordTP	IncotermsClassification	Incoterms
	IncotermsClassificationName	I_SlsPricingConditionRecordTP	IncotermsClassificationName	Incoterms Classification Description
	IncotermsTransferLocation	I_SlsPricingConditionRecordTP	IncotermsTransferLocation	Incoterms 2
	CustomerGroup	I_SlsPricingConditionRecordTP	CustomerGroup	Customer Group
	CustomerGroupName	I_SlsPricingConditionRecordTP	CustomerGroupName
	CustomerPriceGroup	I_SlsPricingConditionRecordTP	CustomerPriceGroup	CustPrice Group
	CustomerPriceGroupName	I_SlsPricingConditionRecordTP	CustomerPriceGroupName
	MaterialPricingGroup	I_SlsPricingConditionRecordTP	MaterialPricingGroup
	MaterialPricingGroupName	I_SlsPricingConditionRecordTP	MaterialPricingGroupName
	SoldToParty	I_SlsPricingConditionRecordTP	SoldToParty	Sold-to Party
	SoldToPartyName	I_SlsPricingConditionRecordTP	SoldToPartyName	Sold-to Party Name
	Customer	I_SlsPricingConditionRecordTP	Customer	Sold-to Party
	CustomerName	I_SlsPricingConditionRecordTP	CustomerName	Name of Customer
	PayerParty	I_SlsPricingConditionRecordTP	PayerParty	Payer
	PayerPartyName	I_SlsPricingConditionRecordTP	PayerPartyName
	ShipToParty	I_SlsPricingConditionRecordTP	ShipToParty	Ship-To Party (obsolete)
	ShipToPartyName	I_SlsPricingConditionRecordTP	ShipToPartyName	Ship-To Party Name
	Supplier	I_SlsPricingConditionRecordTP	Supplier	Supplier
	SupplierName	I_SlsPricingConditionRecordTP	SupplierName	Supplier Name
	DestinationCountry	I_SlsPricingConditionRecordTP	DestinationCountry	Dest. Ctry/Reg
	DestinationCountryName	I_SlsPricingConditionRecordTP	DestinationCountryName	Arrival Country / Region
	Country	I_SlsPricingConditionRecordTP	Country	Venue: Ctry/Reg
	CountryName	I_SlsPricingConditionRecordTP	CountryName	Country
	MaterialGroup	I_SlsPricingConditionRecordTP	MaterialGroup	Product Group
	MaterialGroupName	I_SlsPricingConditionRecordTP	MaterialGroupName	prod Grp Desc.
	ReturnsRefundExtent	I_SlsPricingConditionRecordTP	ReturnsRefundExtent
	ReturnsRefundExtentDesc	I_SlsPricingConditionRecordTP	ReturnsRefundExtentDesc
	AdditionalMaterialGroup1	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup1	MaterialGroup 1
	AdditionalMaterialGroup1Name	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup1Name
	AdditionalMaterialGroup2	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup2	MaterialGroup 2
	AdditionalMaterialGroup2Name	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup2Name
	AdditionalMaterialGroup3	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup3	MaterialGroup 3
	AdditionalMaterialGroup3Name	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup3Name
	AdditionalMaterialGroup4	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup4	MaterialGroup 4
	AdditionalMaterialGroup4Name	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup4Name
	AdditionalMaterialGroup5	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup5	MaterialGroup 5
	AdditionalMaterialGroup5Name	I_SlsPricingConditionRecordTP	AdditionalMaterialGroup5Name
	Personnel	I_SlsPricingConditionRecordTP	Personnel	Personnel No.
	PersonFullName	I_SlsPricingConditionRecordTP	PersonFullName	Full Name
	WorkAssignmentExternalID
	Country2DigitISOCode
	WorkAssignmentStartDate
	WorkAssignmentEndDate
	PriceListType	I_SlsPricingConditionRecordTP	PriceListType	Price List Tp.
	PriceListTypeName	I_SlsPricingConditionRecordTP	PriceListTypeName
	PostalCode	I_SlsPricingConditionRecordTP	PostalCode	Postal Code
	Region	I_SlsPricingConditionRecordTP	Region	Venue Region
	RegionName	I_SlsPricingConditionRecordTP	RegionName	Description
	EngagementProjectServiceOrg	I_SlsPricingConditionRecordTP	EngagementProjectServiceOrg	Service Org.
	EngmtProjectServiceOrgName	I_SlsPricingConditionRecordTP	EngmtProjectServiceOrgName
	RequirementSegment	I_SlsPricingConditionRecordTP	RequirementSegment	Req. Segment
	StockSegment	I_SlsPricingConditionRecordTP	StockSegment	Stock Segment
	Division	I_SlsPricingConditionRecordTP	Division	Internal Division ID
	DivisionName	I_SlsPricingConditionRecordTP	DivisionName	Division Description
	CommodityCode	I_SlsPricingConditionRecordTP	CommodityCode	Commodity Code
	CommodityCodeText	I_SlsPricingConditionRecordTP	CommodityCodeText
	TradingContract	I_SlsPricingConditionRecordTP	TradingContract
	TradingContractItem	I_SlsPricingConditionRecordTP	TradingContractItem	Item Number
	MainItemMaterialPricingGroup	I_SlsPricingConditionRecordTP	MainItemMaterialPricingGroup
	MainItmMatlPricingGroupName	I_SlsPricingConditionRecordTP	MainItmMatlPricingGroupName
	MainItemPricingRefMaterial	I_SlsPricingConditionRecordTP	MainItemPricingRefMaterial
	MainItemPricingRefMaterialName	I_SlsPricingConditionRecordTP	MainItemPricingRefMaterialName
	VariantCondition	I_SlsPricingConditionRecordTP	VariantCondition	Variant Key
	VariantConditionName	I_SlsPricingConditionRecordTP	VariantConditionName
	ValueAddedServiceChargeCode	I_SlsPricingConditionRecordTP	ValueAddedServiceChargeCode
	SDDocument	I_SlsPricingConditionRecordTP	SDDocument	SD Document
	ReferenceSDDocument	I_SlsPricingConditionRecordTP	ReferenceSDDocument	Reference Doc.
	ReferenceSDDocumentItem	I_SlsPricingConditionRecordTP	ReferenceSDDocumentItem	Reference Item
	SalesOffice	I_SlsPricingConditionRecordTP	SalesOffice	Sales Office
	SalesOfficeName	I_SlsPricingConditionRecordTP	SalesOfficeName
	SalesGroup	I_SlsPricingConditionRecordTP	SalesGroup	Sales Group
	SalesGroupName	I_SlsPricingConditionRecordTP	SalesGroupName
	SalesOrderSalesOrganization	I_SlsPricingConditionRecordTP	SalesOrderSalesOrganization
	SlsOrderSalesOrganizationName	I_SlsPricingConditionRecordTP	SlsOrderSalesOrganizationName
	OrderQuantityUnit	I_SlsPricingConditionRecordTP	OrderQuantityUnit	Sales Unit
	OrderQuantityUnitName	I_SlsPricingConditionRecordTP	OrderQuantityUnitName
	SalesOrganization	I_SlsPricingConditionRecordTP	SalesOrganization	Sales Organization
	SalesOrganizationName	I_SlsPricingConditionRecordTP	SalesOrganizationName	Sales Organization Description
	DistributionChannel	I_SlsPricingConditionRecordTP	DistributionChannel	RefDistCh-Cust/Mat.
	DistributionChannelName	I_SlsPricingConditionRecordTP	DistributionChannelName
	Material	I_SlsPricingConditionRecordTP	Material	Vehicle Model
	MaterialName	I_SlsPricingConditionRecordTP	MaterialName	Material Description
	TransactionCurrency	I_SlsPricingConditionRecordTP	TransactionCurrency	Transaction Currency
	TransactionCurrencyName	I_SlsPricingConditionRecordTP	TransactionCurrencyName
	WBSElementInternalID	I_SlsPricingConditionRecordTP	WBSElementInternalID	WBS Internal ID
	WBSDescription	I_SlsPricingConditionRecordTP	WBSDescription	WBS Element Name
	WorkPackage	I_SlsPricingConditionRecordTP	WorkPackage	Plan Item
	WorkPackageName	I_SlsPricingConditionRecordTP	WorkPackageName	Plan Item Desc.
	Plant	I_SlsPricingConditionRecordTP	Plant	Valuation Area
	PlantName	I_SlsPricingConditionRecordTP	PlantName	Plant Name
	PlantRegion	I_SlsPricingConditionRecordTP	PlantRegion	Region-Dlv.Plnt
	PlantRegionName	I_SlsPricingConditionRecordTP	PlantRegionName
	WorkItem	I_SlsPricingConditionRecordTP	WorkItem	Work Item ID
	WorkItemName	I_SlsPricingConditionRecordTP	WorkItemName
	ConditionProcessingStatus	I_SlsPricingConditionRecordTP	ConditionProcessingStatus
	ConditionProcessingStatusText	I_SlsPricingConditionRecordTP	ConditionProcessingStatusText
	PricingDate	I_SlsPricingConditionRecordTP	PricingDate	Pricing Date
	ConditionIsExclusive	I_SlsPricingConditionRecordTP	ConditionIsExclusive
	ConditionScaleBasisValue	I_SlsPricingConditionRecordTP	ConditionScaleBasisValue	Scale Base Val.
	EngagementProject	I_SlsPricingConditionRecordTP	EngagementProject	Engmnt Project ID
	EngagementProjectName	I_SlsPricingConditionRecordTP	EngagementProjectName
	ConfigurationNumber	I_SlsPricingConditionRecordTP	ConfigurationNumber	Int. object no.
	InternationalArticleNumber	I_SlsPricingConditionRecordTP	InternationalArticleNumber	EAN/UPC
	ServiceDocument	I_SlsPricingConditionRecordTP	ServiceDocument	Transaction ID
	ServiceDocumentItem	I_SlsPricingConditionRecordTP	ServiceDocumentItem	Service Document
	TimeSheetOvertimeCategory	I_SlsPricingConditionRecordTP	TimeSheetOvertimeCategory
	TimeSheetOvertimeCategoryText	I_SlsPricingConditionRecordTP	TimeSheetOvertimeCategoryText
	SalesSDDocumentCategory	I_SlsPricingConditionRecordTP	SalesSDDocumentCategory	Document Cat.
	SDDocumentCategoryName	I_SlsPricingConditionRecordTP	SDDocumentCategoryName
	OrderType	I_SlsPricingConditionRecordTP	OrderType	Order Type
	OrderTypeName	I_SlsPricingConditionRecordTP	OrderTypeName
	SalesDocumentType	I_SlsPricingConditionRecordTP	SalesDocumentType	Sales Doc. Type
	SalesDocumentTypeName	I_SlsPricingConditionRecordTP	SalesDocumentTypeName
	SDDocumentReason	I_SlsPricingConditionRecordTP	SDDocumentReason	Order Reason
	SDDocumentReasonText	I_SlsPricingConditionRecordTP	SDDocumentReasonText	Description
	VolumeRebateGroup	I_SlsPricingConditionRecordTP	VolumeRebateGroup	Vol. Rebate Grp
	VolumeRebateGroupName	I_SlsPricingConditionRecordTP	VolumeRebateGroupName
	ValuationType	I_SlsPricingConditionRecordTP	ValuationType	Valuation Type
	SalesDistrict	I_SlsPricingConditionRecordTP	SalesDistrict	Sales District
	SalesDistrictName	I_SlsPricingConditionRecordTP	SalesDistrictName
	Batch	I_SlsPricingConditionRecordTP	Batch	Lot No.
	PurgDocSupplyingPlant	I_SlsPricingConditionRecordTP	PurgDocSupplyingPlant
	SupplyingPlantName	I_SlsPricingConditionRecordTP	SupplyingPlantName	Plant Name
	MatUsageIndicator	I_SlsPricingConditionRecordTP	MatUsageIndicator
	MatlUsageIndicatorText	I_SlsPricingConditionRecordTP	MatlUsageIndicatorText
	ShippingCondition	I_SlsPricingConditionRecordTP	ShippingCondition	Shipping Conditions
	ShippingConditionName	I_SlsPricingConditionRecordTP	ShippingConditionName
	PlantCounty	I_SlsPricingConditionRecordTP	PlantCounty	County-Dlv.Plnt
	PlantCountyName	I_SlsPricingConditionRecordTP	PlantCountyName
	PlantCity	I_SlsPricingConditionRecordTP	PlantCity	City-Dlv.Plant
	PlantCityName	I_SlsPricingConditionRecordTP	PlantCityName
	MaterialExternalGroup	I_SlsPricingConditionRecordTP	MaterialExternalGroup	Ext. Matl Group
	ExternalProductGroupName	I_SlsPricingConditionRecordTP	ExternalProductGroupName
	CustomerHierarchyRootNode	I_SlsPricingConditionRecordTP	CustomerHierarchyRootNode
	CustomerUniversalHierarchyText	I_SlsPricingConditionRecordTP	CustomerUniversalHierarchyText
	CustomerHierarchyNodeID	I_SlsPricingConditionRecordTP	CustomerHierarchyNodeID
	CustUnivHierarchyNodeText	I_SlsPricingConditionRecordTP	CustUnivHierarchyNodeText
	CustomerHierarchyNodeType	I_SlsPricingConditionRecordTP	CustomerHierarchyNodeType
	CustomerHierarchyNodeTypeText	I_SlsPricingConditionRecordTP	CustomerHierarchyNodeTypeText
	AdditionalCustomerGroup1	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup1	Customer Grp 1
	AdditionalCustomerGroup1Name	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup1Name
	AdditionalCustomerGroup2	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup2	Customer Grp 2
	AdditionalCustomerGroup2Name	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup2Name
	AdditionalCustomerGroup3	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup3	Customer Grp 3
	AdditionalCustomerGroup3Name	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup3Name
	AdditionalCustomerGroup4	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup4	Customer Grp 4
	AdditionalCustomerGroup4Name	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup4Name
	AdditionalCustomerGroup5	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup5	Customer Grp 5
	AdditionalCustomerGroup5Name	I_SlsPricingConditionRecordTP	AdditionalCustomerGroup5Name
	CustomerPurchaseOrderType	I_SlsPricingConditionRecordTP	CustomerPurchaseOrderType
	CustomerPurchaseOrderTypeDesc	I_SlsPricingConditionRecordTP	CustomerPurchaseOrderTypeDesc
	CountryOfOrigin	I_SlsPricingConditionRecordTP	CountryOfOrigin	Country/Region of Origin
	CountryOfOriginName	I_SlsPricingConditionRecordTP	CountryOfOriginName
	SalesDocumentItemCategory	I_SlsPricingConditionRecordTP	SalesDocumentItemCategory	Item Category
	SalesDocumentItemCategoryName	I_SlsPricingConditionRecordTP	SalesDocumentItemCategoryName
	BillToParty	I_SlsPricingConditionRecordTP	BillToParty	Inv. Recipient
	BillToPartyName	I_SlsPricingConditionRecordTP	BillToPartyName
	BusinessPartnerIndustryCode	I_SlsPricingConditionRecordTP	BusinessPartnerIndustryCode
	CustomerIndustryCodeText	I_SlsPricingConditionRecordTP	CustomerIndustryCodeText
	BillingDocumentType	I_SlsPricingConditionRecordTP	BillingDocumentType	Billing Type
	BillingDocumentTypeName	I_SlsPricingConditionRecordTP	BillingDocumentTypeName
	MatlAccountAssignmentGroup	I_SlsPricingConditionRecordTP	MatlAccountAssignmentGroup
	MatlAccountAssignmentGroupName	I_SlsPricingConditionRecordTP	MatlAccountAssignmentGroupName
	SDDocumentItem	I_SlsPricingConditionRecordTP	SDDocumentItem
	ReturnReason	I_SlsPricingConditionRecordTP	ReturnReason	Return Reason
	ETag	I_SlsPricingConditionRecordTP	ETag	Update Token
	ConditionRecordIsEditable	I_SlsPricingConditionRecordTP	ConditionRecordIsEditable
	ConditionRecordIsDraft	I_SlsPricingConditionRecordTP	ConditionRecordIsDraft
	CustomerConditionGroup	I_SlsPricingConditionRecordTP	CustomerConditionGroup
	ShippingType	I_SlsPricingConditionRecordTP	ShippingType	Shipping Type
	ShippingTypeName	I_SlsPricingConditionRecordTP	ShippingTypeName
	Status	I_SlsPricingConditionRecordTP	Status	Workflow Status
	SalesPriceApprovalRequest	I_SlsPricingConditionRecordTP	SalesPriceApprovalRequest	Sales Price Aprv Req
	ConditionChangeReason	I_SlsPricingConditionRecordTP	ConditionChangeReason	Cndn Change Reason
	ConditionChangeReasonText	I_SlsPricingConditionRecordTP	ConditionChangeReasonText	Description
	ConditionText	I_SlsPricingConditionRecordTP	ConditionText	Node Condition Text
	PrevApprovedConditionRecord	I_SlsPricingConditionRecordTP	PrevApprovedConditionRecord	Cond.Record No.
	ConsumptionTaxCtrlCode	I_SlsPricingConditionRecordTP	ConsumptionTaxCtrlCode	Taxes F.Trade
	ConsumptionTaxCntrlCodeDesc	I_SlsPricingConditionRecordTP	ConsumptionTaxCntrlCodeDesc
	CustomerTaxClassification1	I_SlsPricingConditionRecordTP	CustomerTaxClassification1
	CustomerTaxClassification1Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification1Name
	CustomerTaxClassification2	I_SlsPricingConditionRecordTP	CustomerTaxClassification2
	CustomerTaxClassification2Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification2Name
	CustomerTaxClassification3	I_SlsPricingConditionRecordTP	CustomerTaxClassification3
	CustomerTaxClassification3Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification3Name
	CustomerTaxClassification4	I_SlsPricingConditionRecordTP	CustomerTaxClassification4
	CustomerTaxClassification4Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification4Name
	CustomerTaxClassification5	I_SlsPricingConditionRecordTP	CustomerTaxClassification5
	CustomerTaxClassification5Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification5Name
	CustomerTaxClassification6	I_SlsPricingConditionRecordTP	CustomerTaxClassification6
	CustomerTaxClassification6Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification6Name
	CustomerTaxClassification7	I_SlsPricingConditionRecordTP	CustomerTaxClassification7
	CustomerTaxClassification7Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification7Name
	CustomerTaxClassification8	I_SlsPricingConditionRecordTP	CustomerTaxClassification8
	CustomerTaxClassification8Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification8Name
	CustomerTaxClassification9	I_SlsPricingConditionRecordTP	CustomerTaxClassification9
	CustomerTaxClassification9Name	I_SlsPricingConditionRecordTP	CustomerTaxClassification9Name
	ProductTaxClassification1	I_SlsPricingConditionRecordTP	ProductTaxClassification1
	ProductTaxClassification1Name	I_SlsPricingConditionRecordTP	ProductTaxClassification1Name
	ProductTaxClassification2	I_SlsPricingConditionRecordTP	ProductTaxClassification2
	ProductTaxClassification2Name	I_SlsPricingConditionRecordTP	ProductTaxClassification2Name
	ProductTaxClassification3	I_SlsPricingConditionRecordTP	ProductTaxClassification3
	ProductTaxClassification3Name	I_SlsPricingConditionRecordTP	ProductTaxClassification3Name
	ProductTaxClassification4	I_SlsPricingConditionRecordTP	ProductTaxClassification4
	ProductTaxClassification4Name	I_SlsPricingConditionRecordTP	ProductTaxClassification4Name
	ProductTaxClassification5	I_SlsPricingConditionRecordTP	ProductTaxClassification5
	ProductTaxClassification5Name	I_SlsPricingConditionRecordTP	ProductTaxClassification5Name
	ProductTaxClassification6	I_SlsPricingConditionRecordTP	ProductTaxClassification6
	ProductTaxClassification6Name	I_SlsPricingConditionRecordTP	ProductTaxClassification6Name
	ProductTaxClassification7	I_SlsPricingConditionRecordTP	ProductTaxClassification7
	ProductTaxClassification7Name	I_SlsPricingConditionRecordTP	ProductTaxClassification7Name
	ProductTaxClassification8	I_SlsPricingConditionRecordTP	ProductTaxClassification8
	ProductTaxClassification8Name	I_SlsPricingConditionRecordTP	ProductTaxClassification8Name
	ProductTaxClassification9	I_SlsPricingConditionRecordTP	ProductTaxClassification9
	ProductTaxClassification9Name	I_SlsPricingConditionRecordTP	ProductTaxClassification9Name
	TaxJurisdiction	I_SlsPricingConditionRecordTP	TaxJurisdiction	Tax Jurisdiction
	TaxJurisdictionName	I_SlsPricingConditionRecordTP	TaxJurisdictionName	Description
	CndnBillingDocumentCategory	I_SlsPricingConditionRecordTP	CndnBillingDocumentCategory
	BillingDocumentCategoryName	I_SlsPricingConditionRecordTP	BillingDocumentCategoryName
	LocalSalesTaxApplicabilityCode	I_SlsPricingConditionRecordTP	LocalSalesTaxApplicabilityCode
	ConditionTaxCode	I_SlsPricingConditionRecordTP	ConditionTaxCode	Tax Code
	ConditionTaxCodeName	I_SlsPricingConditionRecordTP	ConditionTaxCodeName
	ConditionWithholdingTaxCode	I_SlsPricingConditionRecordTP	ConditionWithholdingTaxCode	W/Tax Code
	CndnWithholdingTaxCodeName	I_SlsPricingConditionRecordTP	CndnWithholdingTaxCodeName
	TaxExemptionLicense	I_SlsPricingConditionRecordTP	TaxExemptionLicense	License Number
	LicenseGrantDate	I_SlsPricingConditionRecordTP	LicenseGrantDate	License Date
	ConditionIsTaxRate	I_SlsPricingConditionRecordTP	ConditionIsTaxRate	TRUE
	ConditionIsWithholdingTax	I_SlsPricingConditionRecordTP	ConditionIsWithholdingTax	TRUE
	ConditionIsTaxWithExemption	I_SlsPricingConditionRecordTP	ConditionIsTaxWithExemption	TRUE
	ConditionClass	I_SlsPricingConditionRecordTP	ConditionClass	Condition Class
	ConditionClassName	I_SlsPricingConditionRecordTP	ConditionClassName
	ConditionCategory	I_SlsPricingConditionRecordTP	ConditionCategory	Condit.Category
	ConditionCategoryName	I_SlsPricingConditionRecordTP	ConditionCategoryName
	ConditionFioriID	I_SlsPricingConditionRecordTP	ConditionFioriID	SAP Fiori ID
	ConditionJobUUID	I_SlsPricingConditionRecordTP	ConditionJobUUID	Key
	ConditionJobItemNo	I_SlsPricingConditionRecordTP	ConditionJobItemNo
	ExpiringPricesQueryStartDate	I_SlsPricingConditionRecordTP	ExpiringPricesQueryStartDate
	ExpiringPricesQueryEndDate	I_SlsPricingConditionRecordTP	ExpiringPricesQueryEndDate
	ConditionHasSuccessor	I_SlsPricingConditionRecordTP	ConditionHasSuccessor
	AccountTaxType	I_SlsPricingConditionRecordTP	AccountTaxType	Tax Type
	BR_NFDocumentType	I_SlsPricingConditionRecordTP	BR_NFDocumentType
	BR_TaxCode	I_SlsPricingConditionRecordTP	BR_TaxCode
	BRSpcfcFreeDefinedField1	I_SlsPricingConditionRecordTP	BRSpcfcFreeDefinedField1
	BRSpcfcFreeDefinedField2	I_SlsPricingConditionRecordTP	BRSpcfcFreeDefinedField2
	BRSpcfcFreeDefinedField3	I_SlsPricingConditionRecordTP	BRSpcfcFreeDefinedField3
	BRSpcfcTaxBasePercentageCode	I_SlsPricingConditionRecordTP	BRSpcfcTaxBasePercentageCode	Tax Base
	BRSpcfcTaxDepartureRegion	I_SlsPricingConditionRecordTP	BRSpcfcTaxDepartureRegion
	BRSpcfcTaxDestinationRegion	I_SlsPricingConditionRecordTP	BRSpcfcTaxDestinationRegion
	BRSpcfcTxGrpDynTaxExceptions	I_SlsPricingConditionRecordTP	BRSpcfcTxGrpDynTaxExceptions
	TxRlvnceClassfctnForArgentina	I_SlsPricingConditionRecordTP	TxRlvnceClassfctnForArgentina
	Route	I_SlsPricingConditionRecordTP	Route	Vehicle route
	RouteName	I_SlsPricingConditionRecordTP	RouteName
	_SlsPricingCndnRecdScaleTP		_SlsPricingCndnRecdScaleTP

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_SlsPricingConditionRecordTP.
-- 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: CSLSPRCGCNDNRTP

CREATE VIEW C_SlsPricingConditionRecordTP AS
SELECT
  RecordTP.ConditionRecordUUID AS ConditionRecordUUID,
  RecordTP.ConditionRecord AS ConditionRecord,
  RecordTP.ConditionSequentialNumber AS ConditionSequentialNumber,
  RecordTP.ConditionValidityEndDate AS ConditionValidityEndDate,
  RecordTP.ValidOnDate AS ValidOnDate,
  RecordTP.ConditionValidityStartDate AS ConditionValidityStartDate,
  RecordTP.ConditionTable AS ConditionTable,
  RecordTP.ConditionTableDescription AS ConditionTableDescription,
  RecordTP.AccessNumberOfAccessSequence AS AccessNumberOfAccessSequence,
  RecordTP.ConditionApplication AS ConditionApplication,
  RecordTP.ConditionType AS ConditionType,
  RecordTP.ConditionTypeName AS ConditionTypeName,
  RecordTP.CreatedByUser AS CreatedByUser,
  RecordTP.CreationDate AS CreationDate,
  RecordTP.ConditionSearchTermValue AS ConditionSearchTermValue,
  RecordTP.ConditionTextID AS ConditionTextID,
  RecordTP.PricingScaleType AS PricingScaleType,
  RecordTP.PricingScaleTypeName AS PricingScaleTypeName,
  RecordTP.PricingScaleBasis AS PricingScaleBasis,
  RecordTP.PricingScaleBasisName AS PricingScaleBasisName,
  RecordTP.PricingScaleCheckingRule AS PricingScaleCheckingRule,
  RecordTP.PricingScaleCheckingRuleName AS PricingScaleCheckingRuleName,
  RecordTP.ConditionScaleQuantity AS ConditionScaleQuantity,
  RecordTP.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  RecordTP.ConditionScaleAmount AS ConditionScaleAmount,
  RecordTP.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  RecordTP.ConditionCalculationType AS ConditionCalculationType,
  RecordTP.ConditionCalculationTypeName AS ConditionCalculationTypeName,
  RecordTP.ConditionRateValue AS ConditionRateValue,
  RecordTP.ConditionRateValueUnit AS ConditionRateValueUnit,
  RecordTP.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  RecordTP.ConditionRateRatio AS ConditionRateRatio,
  RecordTP.ConditionCurrency AS ConditionCurrency,
  RecordTP.ConditionRateAmount AS ConditionRateAmount,
  RecordTP.ConditionRateValueIsAmount AS ConditionRateValueIsAmount,
  RecordTP.ConditionRateValueIsRatio AS ConditionRateValueIsRatio,
  RecordTP.ConditionQuantity AS ConditionQuantity,
  RecordTP.ConditionQuantityUnit AS ConditionQuantityUnit,
  RecordTP.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  RecordTP.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  RecordTP.BaseUnit AS BaseUnit,
  RecordTP.ConditionUnitConversionText AS ConditionUnitConversionText,
  RecordTP.ConditionLowerLimit AS ConditionLowerLimit,
  RecordTP.ConditionUpperLimit AS ConditionUpperLimit,
  RecordTP.ConditionLowerLimitAmount AS ConditionLowerLimitAmount,
  RecordTP.ConditionLowerLimitRatio AS ConditionLowerLimitRatio,
  RecordTP.ConditionUpperLimitAmount AS ConditionUpperLimitAmount,
  RecordTP.ConditionUpperLimitRatio AS ConditionUpperLimitRatio,
  RecordTP.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  RecordTP.ConditionExclusion AS ConditionExclusion,
  RecordTP.ConditionIsDeleted AS ConditionIsDeleted,
  RecordTP.ConditionHasScales AS ConditionHasScales,
  RecordTP.AdditionalValueDays AS AdditionalValueDays,
  RecordTP.FixedValueDate AS FixedValueDate,
  RecordTP.PaymentTerms AS PaymentTerms,
  RecordTP.PaymentTermsName AS PaymentTermsName,
  RecordTP.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  RecordTP.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  RecordTP.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  RecordTP.MaximumConditionAmount AS MaximumConditionAmount,
  RecordTP.IncrementalScale AS IncrementalScale,
  RecordTP.PricingScaleLine AS PricingScaleLine,
  RecordTP.ConditionReleaseStatus AS ConditionReleaseStatus,
  RecordTP.ConditionReleaseStatusText AS ConditionReleaseStatusText,
  RecordTP.Criticality AS Criticality,
  RecordTP.DepartureCountry AS DepartureCountry,
  RecordTP.DepartureCountryName AS DepartureCountryName,
  RecordTP.SalesDocument AS SalesDocument,
  RecordTP.SalesDocumentItem AS SalesDocumentItem,
  RecordTP.SalesDocumentItemText AS SalesDocumentItemText,
  RecordTP.BillableControl AS BillableControl,
  RecordTP.BillableControlName AS BillableControlName,
  RecordTP.Industry AS Industry,
  RecordTP.IndustryKeyText AS IndustryKeyText,
  RecordTP.ProdUnivHierarchyNode AS ProdUnivHierarchyNode,
  RecordTP.ProdUnivHierarchyNodeText AS ProdUnivHierarchyNodeText,
  RecordTP.ProductHierarchyNode AS ProductHierarchyNode,
  RecordTP.ProductHierarchyNodeText AS ProductHierarchyNodeText,
  RecordTP.CityCode AS CityCode,
  RecordTP.CityCodeName AS CityCodeName,
  RecordTP.ConditionContract AS ConditionContract,
  RecordTP.County AS County,
  RecordTP.CountyName AS CountyName,
  RecordTP.TechnicalObjectType AS TechnicalObjectType,
  RecordTP.TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  RecordTP.Equipment AS Equipment,
  RecordTP.EquipmentName AS EquipmentName,
  RecordTP.CustomerHierarchy AS CustomerHierarchy,
  RecordTP.IncotermsClassification AS IncotermsClassification,
  RecordTP.IncotermsClassificationName AS IncotermsClassificationName,
  RecordTP.IncotermsTransferLocation AS IncotermsTransferLocation,
  RecordTP.CustomerGroup AS CustomerGroup,
  RecordTP.CustomerGroupName AS CustomerGroupName,
  RecordTP.CustomerPriceGroup AS CustomerPriceGroup,
  RecordTP.CustomerPriceGroupName AS CustomerPriceGroupName,
  RecordTP.MaterialPricingGroup AS MaterialPricingGroup,
  RecordTP.MaterialPricingGroupName AS MaterialPricingGroupName,
  RecordTP.SoldToParty AS SoldToParty,
  RecordTP.SoldToPartyName AS SoldToPartyName,
  RecordTP.Customer AS Customer,
  RecordTP.CustomerName AS CustomerName,
  RecordTP.PayerParty AS PayerParty,
  RecordTP.PayerPartyName AS PayerPartyName,
  RecordTP.ShipToParty AS ShipToParty,
  RecordTP.ShipToPartyName AS ShipToPartyName,
  RecordTP.Supplier AS Supplier,
  RecordTP.SupplierName AS SupplierName,
  RecordTP.DestinationCountry AS DestinationCountry,
  RecordTP.DestinationCountryName AS DestinationCountryName,
  RecordTP.Country AS Country,
  RecordTP.CountryName AS CountryName,
  RecordTP.MaterialGroup AS MaterialGroup,
  RecordTP.MaterialGroupName AS MaterialGroupName,
  RecordTP.ReturnsRefundExtent AS ReturnsRefundExtent,
  RecordTP.ReturnsRefundExtentDesc AS ReturnsRefundExtentDesc,
  RecordTP.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  RecordTP.AdditionalMaterialGroup1Name AS AdditionalMaterialGroup1Name,
  RecordTP.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  RecordTP.AdditionalMaterialGroup2Name AS AdditionalMaterialGroup2Name,
  RecordTP.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  RecordTP.AdditionalMaterialGroup3Name AS AdditionalMaterialGroup3Name,
  RecordTP.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  RecordTP.AdditionalMaterialGroup4Name AS AdditionalMaterialGroup4Name,
  RecordTP.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  RecordTP.AdditionalMaterialGroup5Name AS AdditionalMaterialGroup5Name,
  RecordTP.Personnel AS Personnel,
  RecordTP.PersonFullName AS PersonFullName,
  cast('' as wfd_agreement_id ) AS WorkAssignmentExternalID,
  cast('' as wfd_country ) AS Country2DigitISOCode,
  cast('' as wfd_start_date ) AS WorkAssignmentStartDate,
  cast('' as wfd_end_date ) AS WorkAssignmentEndDate,
  RecordTP.PriceListType AS PriceListType,
  RecordTP.PriceListTypeName AS PriceListTypeName,
  RecordTP.PostalCode AS PostalCode,
  RecordTP.Region AS Region,
  RecordTP.RegionName AS RegionName,
  RecordTP.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  RecordTP.EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  RecordTP.RequirementSegment AS RequirementSegment,
  RecordTP.StockSegment AS StockSegment,
  RecordTP.Division AS Division,
  RecordTP.DivisionName AS DivisionName,
  RecordTP.CommodityCode AS CommodityCode,
  RecordTP.CommodityCodeText AS CommodityCodeText,
  RecordTP.TradingContract AS TradingContract,
  RecordTP.TradingContractItem AS TradingContractItem,
  RecordTP.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
  RecordTP.MainItmMatlPricingGroupName AS MainItmMatlPricingGroupName,
  RecordTP.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  RecordTP.MainItemPricingRefMaterialName AS MainItemPricingRefMaterialName,
  RecordTP.VariantCondition AS VariantCondition,
  RecordTP.VariantConditionName AS VariantConditionName,
  RecordTP.ValueAddedServiceChargeCode AS ValueAddedServiceChargeCode,
  RecordTP.SDDocument AS SDDocument,
  RecordTP.ReferenceSDDocument AS ReferenceSDDocument,
  RecordTP.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  RecordTP.SalesOffice AS SalesOffice,
  RecordTP.SalesOfficeName AS SalesOfficeName,
  RecordTP.SalesGroup AS SalesGroup,
  RecordTP.SalesGroupName AS SalesGroupName,
  RecordTP.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
  RecordTP.SlsOrderSalesOrganizationName AS SlsOrderSalesOrganizationName,
  RecordTP.OrderQuantityUnit AS OrderQuantityUnit,
  RecordTP.OrderQuantityUnitName AS OrderQuantityUnitName,
  RecordTP.SalesOrganization AS SalesOrganization,
  RecordTP.SalesOrganizationName AS SalesOrganizationName,
  RecordTP.DistributionChannel AS DistributionChannel,
  RecordTP.DistributionChannelName AS DistributionChannelName,
  RecordTP.Material AS Material,
  RecordTP.MaterialName AS MaterialName,
  RecordTP.TransactionCurrency AS TransactionCurrency,
  RecordTP.TransactionCurrencyName AS TransactionCurrencyName,
  RecordTP.WBSElementInternalID AS WBSElementInternalID,
  RecordTP.WBSDescription AS WBSDescription,
  RecordTP.WorkPackage AS WorkPackage,
  RecordTP.WorkPackageName AS WorkPackageName,
  RecordTP.Plant AS Plant,
  RecordTP.PlantName AS PlantName,
  RecordTP.PlantRegion AS PlantRegion,
  RecordTP.PlantRegionName AS PlantRegionName,
  RecordTP.WorkItem AS WorkItem,
  RecordTP.WorkItemName AS WorkItemName,
  RecordTP.ConditionProcessingStatus AS ConditionProcessingStatus,
  RecordTP.ConditionProcessingStatusText AS ConditionProcessingStatusText,
  RecordTP.PricingDate AS PricingDate,
  RecordTP.ConditionIsExclusive AS ConditionIsExclusive,
  RecordTP.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  RecordTP.EngagementProject AS EngagementProject,
  RecordTP.EngagementProjectName AS EngagementProjectName,
  RecordTP.ConfigurationNumber AS ConfigurationNumber,
  RecordTP.InternationalArticleNumber AS InternationalArticleNumber,
  RecordTP.ServiceDocument AS ServiceDocument,
  RecordTP.ServiceDocumentItem AS ServiceDocumentItem,
  RecordTP.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  RecordTP.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  RecordTP.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  RecordTP.SDDocumentCategoryName AS SDDocumentCategoryName,
  RecordTP.OrderType AS OrderType,
  RecordTP.OrderTypeName AS OrderTypeName,
  RecordTP.SalesDocumentType AS SalesDocumentType,
  RecordTP.SalesDocumentTypeName AS SalesDocumentTypeName,
  RecordTP.SDDocumentReason AS SDDocumentReason,
  RecordTP.SDDocumentReasonText AS SDDocumentReasonText,
  RecordTP.VolumeRebateGroup AS VolumeRebateGroup,
  RecordTP.VolumeRebateGroupName AS VolumeRebateGroupName,
  RecordTP.ValuationType AS ValuationType,
  RecordTP.SalesDistrict AS SalesDistrict,
  RecordTP.SalesDistrictName AS SalesDistrictName,
  RecordTP.Batch AS Batch,
  RecordTP.PurgDocSupplyingPlant AS PurgDocSupplyingPlant,
  RecordTP.SupplyingPlantName AS SupplyingPlantName,
  RecordTP.MatUsageIndicator AS MatUsageIndicator,
  RecordTP.MatlUsageIndicatorText AS MatlUsageIndicatorText,
  RecordTP.ShippingCondition AS ShippingCondition,
  RecordTP.ShippingConditionName AS ShippingConditionName,
  RecordTP.PlantCounty AS PlantCounty,
  RecordTP.PlantCountyName AS PlantCountyName,
  RecordTP.PlantCity AS PlantCity,
  RecordTP.PlantCityName AS PlantCityName,
  RecordTP.MaterialExternalGroup AS MaterialExternalGroup,
  RecordTP.ExternalProductGroupName AS ExternalProductGroupName,
  RecordTP.CustomerHierarchyRootNode AS CustomerHierarchyRootNode,
  RecordTP.CustomerUniversalHierarchyText AS CustomerUniversalHierarchyText,
  RecordTP.CustomerHierarchyNodeID AS CustomerHierarchyNodeID,
  RecordTP.CustUnivHierarchyNodeText AS CustUnivHierarchyNodeText,
  RecordTP.CustomerHierarchyNodeType AS CustomerHierarchyNodeType,
  RecordTP.CustomerHierarchyNodeTypeText AS CustomerHierarchyNodeTypeText,
  RecordTP.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  RecordTP.AdditionalCustomerGroup1Name AS AdditionalCustomerGroup1Name,
  RecordTP.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  RecordTP.AdditionalCustomerGroup2Name AS AdditionalCustomerGroup2Name,
  RecordTP.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  RecordTP.AdditionalCustomerGroup3Name AS AdditionalCustomerGroup3Name,
  RecordTP.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  RecordTP.AdditionalCustomerGroup4Name AS AdditionalCustomerGroup4Name,
  RecordTP.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  RecordTP.AdditionalCustomerGroup5Name AS AdditionalCustomerGroup5Name,
  RecordTP.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  RecordTP.CustomerPurchaseOrderTypeDesc AS CustomerPurchaseOrderTypeDesc,
  RecordTP.CountryOfOrigin AS CountryOfOrigin,
  RecordTP.CountryOfOriginName AS CountryOfOriginName,
  RecordTP.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  RecordTP.SalesDocumentItemCategoryName AS SalesDocumentItemCategoryName,
  RecordTP.BillToParty AS BillToParty,
  RecordTP.BillToPartyName AS BillToPartyName,
  RecordTP.BusinessPartnerIndustryCode AS BusinessPartnerIndustryCode,
  RecordTP.CustomerIndustryCodeText AS CustomerIndustryCodeText,
  RecordTP.BillingDocumentType AS BillingDocumentType,
  RecordTP.BillingDocumentTypeName AS BillingDocumentTypeName,
  RecordTP.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  RecordTP.MatlAccountAssignmentGroupName AS MatlAccountAssignmentGroupName,
  RecordTP.SDDocumentItem AS SDDocumentItem,
  RecordTP.ReturnReason AS ReturnReason,
  RecordTP.ETag AS ETag,
  RecordTP.ConditionRecordIsEditable AS ConditionRecordIsEditable,
  RecordTP.ConditionRecordIsDraft AS ConditionRecordIsDraft,
  RecordTP.CustomerConditionGroup AS CustomerConditionGroup,
  RecordTP.ShippingType AS ShippingType,
  RecordTP.ShippingTypeName AS ShippingTypeName,
  RecordTP.Status AS Status,
  RecordTP.SalesPriceApprovalRequest AS SalesPriceApprovalRequest,
  RecordTP.ConditionChangeReason AS ConditionChangeReason,
  RecordTP.ConditionChangeReasonText AS ConditionChangeReasonText,
  RecordTP.ConditionText AS ConditionText,
  RecordTP.PrevApprovedConditionRecord AS PrevApprovedConditionRecord,
  RecordTP.ConsumptionTaxCtrlCode AS ConsumptionTaxCtrlCode,
  RecordTP.ConsumptionTaxCntrlCodeDesc AS ConsumptionTaxCntrlCodeDesc,
  RecordTP.CustomerTaxClassification1 AS CustomerTaxClassification1,
  RecordTP.CustomerTaxClassification1Name AS CustomerTaxClassification1Name,
  RecordTP.CustomerTaxClassification2 AS CustomerTaxClassification2,
  RecordTP.CustomerTaxClassification2Name AS CustomerTaxClassification2Name,
  RecordTP.CustomerTaxClassification3 AS CustomerTaxClassification3,
  RecordTP.CustomerTaxClassification3Name AS CustomerTaxClassification3Name,
  RecordTP.CustomerTaxClassification4 AS CustomerTaxClassification4,
  RecordTP.CustomerTaxClassification4Name AS CustomerTaxClassification4Name,
  RecordTP.CustomerTaxClassification5 AS CustomerTaxClassification5,
  RecordTP.CustomerTaxClassification5Name AS CustomerTaxClassification5Name,
  RecordTP.CustomerTaxClassification6 AS CustomerTaxClassification6,
  RecordTP.CustomerTaxClassification6Name AS CustomerTaxClassification6Name,
  RecordTP.CustomerTaxClassification7 AS CustomerTaxClassification7,
  RecordTP.CustomerTaxClassification7Name AS CustomerTaxClassification7Name,
  RecordTP.CustomerTaxClassification8 AS CustomerTaxClassification8,
  RecordTP.CustomerTaxClassification8Name AS CustomerTaxClassification8Name,
  RecordTP.CustomerTaxClassification9 AS CustomerTaxClassification9,
  RecordTP.CustomerTaxClassification9Name AS CustomerTaxClassification9Name,
  RecordTP.ProductTaxClassification1 AS ProductTaxClassification1,
  RecordTP.ProductTaxClassification1Name AS ProductTaxClassification1Name,
  RecordTP.ProductTaxClassification2 AS ProductTaxClassification2,
  RecordTP.ProductTaxClassification2Name AS ProductTaxClassification2Name,
  RecordTP.ProductTaxClassification3 AS ProductTaxClassification3,
  RecordTP.ProductTaxClassification3Name AS ProductTaxClassification3Name,
  RecordTP.ProductTaxClassification4 AS ProductTaxClassification4,
  RecordTP.ProductTaxClassification4Name AS ProductTaxClassification4Name,
  RecordTP.ProductTaxClassification5 AS ProductTaxClassification5,
  RecordTP.ProductTaxClassification5Name AS ProductTaxClassification5Name,
  RecordTP.ProductTaxClassification6 AS ProductTaxClassification6,
  RecordTP.ProductTaxClassification6Name AS ProductTaxClassification6Name,
  RecordTP.ProductTaxClassification7 AS ProductTaxClassification7,
  RecordTP.ProductTaxClassification7Name AS ProductTaxClassification7Name,
  RecordTP.ProductTaxClassification8 AS ProductTaxClassification8,
  RecordTP.ProductTaxClassification8Name AS ProductTaxClassification8Name,
  RecordTP.ProductTaxClassification9 AS ProductTaxClassification9,
  RecordTP.ProductTaxClassification9Name AS ProductTaxClassification9Name,
  RecordTP.TaxJurisdiction AS TaxJurisdiction,
  RecordTP.TaxJurisdictionName AS TaxJurisdictionName,
  RecordTP.CndnBillingDocumentCategory AS CndnBillingDocumentCategory,
  RecordTP.BillingDocumentCategoryName AS BillingDocumentCategoryName,
  RecordTP.LocalSalesTaxApplicabilityCode AS LocalSalesTaxApplicabilityCode,
  RecordTP.ConditionTaxCode AS ConditionTaxCode,
  RecordTP.ConditionTaxCodeName AS ConditionTaxCodeName,
  RecordTP.ConditionWithholdingTaxCode AS ConditionWithholdingTaxCode,
  RecordTP.CndnWithholdingTaxCodeName AS CndnWithholdingTaxCodeName,
  RecordTP.TaxExemptionLicense AS TaxExemptionLicense,
  RecordTP.LicenseGrantDate AS LicenseGrantDate,
  RecordTP.ConditionIsTaxRate AS ConditionIsTaxRate,
  RecordTP.ConditionIsWithholdingTax AS ConditionIsWithholdingTax,
  RecordTP.ConditionIsTaxWithExemption AS ConditionIsTaxWithExemption,
  RecordTP.ConditionClass AS ConditionClass,
  RecordTP.ConditionClassName AS ConditionClassName,
  RecordTP.ConditionCategory AS ConditionCategory,
  RecordTP.ConditionCategoryName AS ConditionCategoryName,
  RecordTP.ConditionFioriID AS ConditionFioriID,
  RecordTP.ConditionJobUUID AS ConditionJobUUID,
  RecordTP.ConditionJobItemNo AS ConditionJobItemNo,
  RecordTP.ExpiringPricesQueryStartDate AS ExpiringPricesQueryStartDate,
  RecordTP.ExpiringPricesQueryEndDate AS ExpiringPricesQueryEndDate,
  RecordTP.ConditionHasSuccessor AS ConditionHasSuccessor,
  RecordTP.AccountTaxType AS AccountTaxType,
  RecordTP.BR_NFDocumentType AS BR_NFDocumentType,
  RecordTP.BR_TaxCode AS BR_TaxCode,
  RecordTP.BRSpcfcFreeDefinedField1 AS BRSpcfcFreeDefinedField1,
  RecordTP.BRSpcfcFreeDefinedField2 AS BRSpcfcFreeDefinedField2,
  RecordTP.BRSpcfcFreeDefinedField3 AS BRSpcfcFreeDefinedField3,
  RecordTP.BRSpcfcTaxBasePercentageCode AS BRSpcfcTaxBasePercentageCode,
  RecordTP.BRSpcfcTaxDepartureRegion AS BRSpcfcTaxDepartureRegion,
  RecordTP.BRSpcfcTaxDestinationRegion AS BRSpcfcTaxDestinationRegion,
  RecordTP.BRSpcfcTxGrpDynTaxExceptions AS BRSpcfcTxGrpDynTaxExceptions,
  RecordTP.TxRlvnceClassfctnForArgentina AS TxRlvnceClassfctnForArgentina,
  RecordTP.Route AS Route,
  RecordTP.RouteName AS RouteName
FROM I_SlsPricingConditionRecordTP AS RecordTP
LEFT OUTER JOIN E_SlsPrcgCndnRecdValidity AS _Extension ON ConditionRecord = _Extension.ConditionRecord AND ConditionValidityEndDate = _Extension.ConditionValidityEndDate  -- association [0..1]
LEFT OUTER JOIN C_SlsPrcgCndnRecordScaleTP AS _SlsPricingCndnRecdScaleTP ON ConditionRecordUUID = _SlsPricingCndnRecdScaleTP.ConditionRecordUUID  -- association [0..*]
;

Depth:

C_SlsPricingConditionRecordTP view

I_SlsPricingConditionRecordTP view