What is C_CustomerSalesAreaTP in SAP S/4HANA?

C_CustomerSalesAreaTP is a consumption CDS view in SAP S/4HANA. Customer Sales Area It contains 101 fields.

Which tables does C_CustomerSalesAreaTP read from?

C_CustomerSalesAreaTP reads data from: I_CustomerSalesAreaTP.

What VDM layer is C_CustomerSalesAreaTP?

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

C_CustomerSalesAreaTP

DDL: C_CUSTOMERSALESAREATP Type: view_entity CONSUMPTION

101 Fields 1 Data Sources 5 Associations

Customer Sales Area

C_CustomerSalesAreaTP is a Consumption CDS View that provides data about "Customer Sales Area" in SAP S/4HANA. It reads from 1 data source (I_CustomerSalesAreaTP) and exposes 101 fields with key fields BusinessPartner, Customer, SalesOrganization, DistributionChannel, Division. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CustomerSalesAreaTP	I_CustomerSalesAreaTP	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	C_SalesOrgVHTemp	_SalesOrgValueHelp	`$projection.SalesOrganizationForEdit = _SalesOrgValueHelp.SalesOrganization and $projection.DistributionChannelForEdit = _SalesOrgValueHelp.DistributionChannel and $projection.DivisionForEdit = _SalesOrgValueHelp.Division`
[0..1]	C_SalesOrgVHTemp	_DistrChnlValueHelp	`$projection.SalesOrganizationForEdit = _DistrChnlValueHelp.SalesOrganization and $projection.DistributionChannelForEdit = _DistrChnlValueHelp.DistributionChannel and $projection.DivisionForEdit = _DistrChnlValueHelp.Division`
[0..1]	C_SalesOrgVHTemp	_DivisionValueHelp	`$projection.DivisionForEdit = _DivisionValueHelp.Division and $projection.SalesOrganizationForEdit = _DivisionValueHelp.SalesOrganization and $projection.DistributionChannelForEdit = _DivisionValueHelp.DistributionChannel`
[0..1]	C_OrderIsBlockedTextVHTemp	_OrderBlockValueHelp	`$projection.OrderIsBlockedForCustomer = _OrderBlockValueHelp.OrderIsBlockedForCustomer`
[0..*]	I_UOMGroup	_ProductUnitGroup	`$projection.ProductUnitGroup = _ProductUnitGroup.ProductUnitGroup`

Annotations (14)

Name	Value	Level
EndUserText.label	Customer Sales Area	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#REQUIRED	view
Metadata.allowExtensions	true	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
UI.headerInfo.typeName	Sales Area	view
UI.headerInfo.typeNamePlural	Sales Areas	view
UI.headerInfo.title.label	Sales Organization Description	view
UI.headerInfo.title.value	SalesOrganizationName	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (101)

Key	Field	Source Field	Description
KEY	BusinessPartner	BusinessPartner	Issuing Authority
KEY	Customer	Customer	Sold-to Party
KEY	SalesOrganization	SalesOrganization	Sales Organization
KEY	DistributionChannel	DistributionChannel	RefDistCh-Cust/Mat.
KEY	Division	Division	Internal Division ID
	BusinessPartnerForEdit	BusinessPartnerForEdit	Busn. Partner
	BusinessPartnerUUID	BusinessPartnerUUID	UUID
	SalesOrganizationForEdit	SalesOrganizationForEdit	Sales Org.
	SalesOrganizationName	SalesOrganizationName	Sales Organization Description
	DistributionChannelForEdit	DistributionChannelForEdit	RefDistCh-Cust/Mat.
	DivisionForEdit	DivisionForEdit	Division
	SalesDistrict	SalesDistrict	Sales District
	CustomerGroup	CustomerGroup	Customer Group
	SalesOffice	SalesOffice	Sales Office
	SalesGroup	SalesGroup	Sales Group
	AccountByCustomer	AccountByCustomer	Acct at cust.
	CustomerABCClassification	CustomerABCClassification	ABC class
	Currency	Currency	Valuation Crcy
	CustomerPriceGroup	CustomerPriceGroup	CustPrice Group
	BPCustomerPricingProcedure	BPCustomerPricingProcedure	Cust.Pric.Proc.
	PriceListType	PriceListType	Price List Tp.
	DeliveryPriority	DeliveryPriority	Delivery Prior.
	OrderCombinationIsAllowed	OrderCombinationIsAllowed	Order Combinat.
	ShippingCondition	ShippingCondition	Shipping Conditions
	SupplyingPlant	SupplyingPlant	Supplying Plant
	PlantName	PlantName	Plant Name
	OrderIsBlockedForCustomer	OrderIsBlockedForCustomer	Order block
	DelivBlkdForCustSlsArea	DelivBlkdForCustSlsArea	DelBlckSalesAr.
	BillingIsBlockedForCustomer	BillingIsBlockedForCustomer	Billing block
	CompleteDeliveryIsDefined	CompleteDeliveryIsDefined	Complete Dlv.
	PartialDeliveryIsAllowed	PartialDeliveryIsAllowed	Partial Deliv.
	BPFactoryCalendarID	BPFactoryCalendarID	Invoicing Dates
	IncotermsVersion	IncotermsVersion	Inco. Version
	IncotermsClassification	IncotermsClassification	Incoterms
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms 2
	CustomerPaymentTerms	CustomerPaymentTerms	Pyt Terms
	CustomerAccountAssignmentGroup	CustomerAccountAssignmentGroup	AccAssmtGrpCust
	IncotermsLocation1	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	IncotermsLocation2	Inco. Location2
	AuthorizationGroup	AuthorizationGroup	AuthorizGroup
	CustomerPaytGuarProced	CustomerPaytGuarProced	Paym.guar.proc.
	IsBusinessPurposeCompleted	IsBusinessPurposeCompleted	Purpose Completed
	InvoiceListSchedule	InvoiceListSchedule	Inv.List Sched.
	ExchangeRateType	ExchangeRateType	Exch. Rate Type
	ItemOrderProbabilityInPercent	ItemOrderProbabilityInPercent	Order Probab.
	AdditionalCustomerGroup1	AdditionalCustomerGroup1	Customer Grp 1
	AdditionalCustomerGroup2	AdditionalCustomerGroup2	Customer Grp 2
	AdditionalCustomerGroup3	AdditionalCustomerGroup3	Customer Grp 3
	AdditionalCustomerGroup4	AdditionalCustomerGroup4	Customer Grp 4
	AdditionalCustomerGroup5	AdditionalCustomerGroup5	Customer Grp 5
	UnderdelivTolrtdLmtRatioInPct	UnderdelivTolrtdLmtRatioInPct	Underdel. Tol.
	OverdelivTolrtdLmtRatioInPct	OverdelivTolrtdLmtRatioInPct	Overdeliv. Tol.
	MaxNmbrOfPartialDelivery	MaxNmbrOfPartialDelivery	Max.Part.Deliv.
	SuplrIsRlvtForSettlmtMgmt	SuplrIsRlvtForSettlmtMgmt	Settlem. Mgmt.
	ProductUnitGroup	ProductUnitGroup	UoM Group
	SlsDocIsRlvtForProofOfDeliv	SlsDocIsRlvtForProofOfDeliv	POD-relevant
	SlsUnlmtdOvrdelivIsAllwd	SlsUnlmtdOvrdelivIsAllwd	Unlimited Tol.
	CreditControlArea	CreditControlArea	Credit Control Area
	CustomerIsRebateRelevant	CustomerIsRebateRelevant	Rebate
	InspSbstHasNoTimeOrQuantity	InspSbstHasNoTimeOrQuantity	Price determin.
	ManualInvoiceMaintIsRelevant	ManualInvoiceMaintIsRelevant	Man.Inv.Maint.
	SalesItemProposal	SalesItemProposal	Item proposal
	CustProdProposalProcedure	CustProdProposalProcedure	PP cust. proc.
	IncotermsLocation1Identifier	IncotermsLocation1Identifier	Location
	IncotermsLocation2Identifier	IncotermsLocation2Identifier	Location
	IncotermsDvtgLocDescription	IncotermsDvtgLocDescription	Loc. Description
	IncotermsDvtgLocIdentifier	IncotermsDvtgLocIdentifier	Location
	IncotermsSupChnDvtgLocAddlUUID	IncotermsSupChnDvtgLocAddlUUID	Location UUID
	IncotermsSupChnLoc2AddlUUID	IncotermsSupChnLoc2AddlUUID	Location UUID
	IncotermsSupChnLoc1AddlUUID	IncotermsSupChnLoc1AddlUUID	Location UUID
	SalesBlockForCustomer	SalesBlockForCustomer	Sales Block
	BPHasActiveEntity	BPHasActiveEntity	Is active
	_BusinessPartner	_BusinessPartner
	_CustomerGroupValueHelp	_CustomerGroupValueHelp
	_CustomerPriceGroupValueHelp	_CustomerPriceGroupValueHelp
	_OrderBlockValueHelp	_OrderBlockValueHelp
	_BillingBlockReasonValueHelp	_BillingBlockReasonValueHelp
	_AccountAssgmtGroupValueHelp	_AccountAssgmtGroupValueHelp
	_SalesDistrictValueHelp	_SalesDistrictValueHelp
	_SalesOrgValueHelp	_SalesOrgValueHelp
	_DistrChnlValueHelp	_DistrChnlValueHelp
	_DivisionValueHelp	_DivisionValueHelp
	_SalesOrgText	_SalesOrgText
	_SalesOfficeText	_SalesOfficeText
	_SalesGroupText	_SalesGroupText
	_PaymentGuaranteeProcedureText	_PaymentGuaranteeProcedureText
	_PriceListType	_PriceListType
	_PriceListTypeText	_PriceListTypeText
	_DeliveryPlantText	_DeliveryPlantText
	_FactoryCalendar	_FactoryCalendar
	_ExchangeRateType	_ExchangeRateType
	_DeliveryPriorityText	_DeliveryPriorityText
	_ProductUnitGroup	_ProductUnitGroup
	_CreditControlAreaText	_CreditControlAreaText
	_AdditionalCustGroupOneText	_AdditionalCustGroupOneText
	_AdditionalCustGroupTwoText	_AdditionalCustGroupTwoText
	_AdditionalCustGroupThreeText	_AdditionalCustGroupThreeText
	_AdditionalCustGroupFourText	_AdditionalCustGroupFourText
	_AdditionalCustGroupFiveText	_AdditionalCustGroupFiveText
	_AuthorizationGrpText	_AuthorizationGrpText
	_TransportLocationText	_TransportLocationText

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_CustomerSalesAreaTP.
-- 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_CustomerSalesAreaTP AS
SELECT
  BusinessPartner,
  Customer,
  SalesOrganization,
  DistributionChannel,
  Division,
  BusinessPartnerForEdit,
  BusinessPartnerUUID,
  SalesOrganizationForEdit,
  SalesOrganizationName,
  DistributionChannelForEdit,
  DivisionForEdit,
  SalesDistrict,
  CustomerGroup,
  SalesOffice,
  SalesGroup,
  AccountByCustomer,
  CustomerABCClassification,
  Currency,
  CustomerPriceGroup,
  BPCustomerPricingProcedure,
  PriceListType,
  DeliveryPriority,
  OrderCombinationIsAllowed,
  ShippingCondition,
  SupplyingPlant,
  PlantName,
  OrderIsBlockedForCustomer,
  DelivBlkdForCustSlsArea,
  BillingIsBlockedForCustomer,
  CompleteDeliveryIsDefined,
  PartialDeliveryIsAllowed,
  BPFactoryCalendarID,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  CustomerPaymentTerms,
  CustomerAccountAssignmentGroup,
  IncotermsLocation1,
  IncotermsLocation2,
  AuthorizationGroup,
  CustomerPaytGuarProced,
  IsBusinessPurposeCompleted,
  InvoiceListSchedule,
  ExchangeRateType,
  ItemOrderProbabilityInPercent,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  MaxNmbrOfPartialDelivery,
  SuplrIsRlvtForSettlmtMgmt,
  ProductUnitGroup,
  SlsDocIsRlvtForProofOfDeliv,
  SlsUnlmtdOvrdelivIsAllwd,
  CreditControlArea,
  CustomerIsRebateRelevant,
  InspSbstHasNoTimeOrQuantity,
  ManualInvoiceMaintIsRelevant,
  SalesItemProposal,
  CustProdProposalProcedure,
  IncotermsLocation1Identifier,
  IncotermsLocation2Identifier,
  IncotermsDvtgLocDescription,
  IncotermsDvtgLocIdentifier,
  IncotermsSupChnDvtgLocAddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnLoc1AddlUUID,
  SalesBlockForCustomer,
  BPHasActiveEntity
FROM I_CustomerSalesAreaTP
LEFT OUTER JOIN C_SalesOrgVHTemp AS _SalesOrgValueHelp ON SalesOrganizationForEdit = _SalesOrgValueHelp.SalesOrganization AND DistributionChannelForEdit = _SalesOrgValueHelp.DistributionChannel AND DivisionForEdit = _SalesOrgValueHelp.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _DistrChnlValueHelp ON SalesOrganizationForEdit = _DistrChnlValueHelp.SalesOrganization AND DistributionChannelForEdit = _DistrChnlValueHelp.DistributionChannel AND DivisionForEdit = _DistrChnlValueHelp.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _DivisionValueHelp ON DivisionForEdit = _DivisionValueHelp.Division AND SalesOrganizationForEdit = _DivisionValueHelp.SalesOrganization AND DistributionChannelForEdit = _DivisionValueHelp.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrderIsBlockedTextVHTemp AS _OrderBlockValueHelp ON OrderIsBlockedForCustomer = _OrderBlockValueHelp.OrderIsBlockedForCustomer  -- association [0..1]
LEFT OUTER JOIN I_UOMGroup AS _ProductUnitGroup ON ProductUnitGroup = _ProductUnitGroup.ProductUnitGroup  -- association [0..*]
;

Depth:

C_CustomerSalesAreaTP view_entity

I_CustomerSalesAreaTP view_entity