What is C_CustomerOP in SAP S/4HANA?

C_CustomerOP is a consumption CDS view in SAP S/4HANA. Customer It contains 42 fields.

Which tables does C_CustomerOP read from?

C_CustomerOP reads data from: I_Customer.

What VDM layer is C_CustomerOP?

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

C_CustomerOP

DDL: C_CUSTOMEROP SQL: CCUSTOMEROP Type: view CONSUMPTION Package: VDM_MD_BP

42 Fields 1 Data Sources 7 Associations

Customer

C_CustomerOP is a Consumption CDS View that provides data about "Customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 42 fields with key field Customer. It has 7 associations to related views. Part of development package VDM_MD_BP.

Data Sources (1)

Source	Alias	Join Type
I_Customer	I_Customer	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	I_CustomerContactOP	_CustomerContact	`$projection.Customer = _CustomerContact.Customer`
[0..*]	C_CustomerSalesAreaOP	_CustomerSalesArea	`$projection.Customer = _CustomerSalesArea.Customer`
[0..*]	C_CustomerCompanyCodeOP	_CustomerCompanyCode	`$projection.Customer = _CustomerCompanyCode.Customer`
[0..*]	C_CustomerBankDetailsOP	_CustomerBankDetails	`$projection.Customer = _CustomerBankDetails.Customer`
[0..1]	I_DeliveryBlockReason	_DelivBlkRsnValueHelp	`$projection.DeliveryIsBlocked = _DelivBlkRsnValueHelp.DeliveryBlockReason`
[0..1]	I_BillingBlockReason	_BillingBlockReasonValueHelp	`$projection.BillingIsBlockedForCustomer = _BillingBlockReasonValueHelp.BillingBlockReason`
[0..*]	C_OrderIsBlockedTextVHTemp	_OrderIsBlockedForCustomer	`$projection.OrderIsBlockedForCustomer = _OrderIsBlockedForCustomer.OrderIsBlockedForCustomer`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CCUSTOMEROP	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
EndUserText.label	Customer	view
UI.headerInfo.typeName	Customer	view
UI.headerInfo.typeNamePlural	Customers	view
UI.headerInfo.title.label	Name	view
UI.headerInfo.title.value	BPCustomerName	view
UI.headerInfo.description.value	Customer	view
UI.headerInfo.typeImageUrl	/sap/bc/ui5_ui5/sap/MD_CUSTOMEROPS1/images/customer.jpg	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (42)

Key	Field	Source Table	Source Field	Description
KEY	Customer	I_Customer	Customer	Sold-to Party
	CustomerName		CustomerName	Name of Customer
	BPCustomerName		BPCustomerName	Name of Customer
	CustomerAccountGroup		CustomerAccountGroup	Account group
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	BusinessPartner
	CityName
	Country11asFormattedAddress
	Industry		Industry	Industry Sector
	InternationalLocationNumber1		InternationalLocationNumber1	Location no. 1
	InternationalLocationNumber
	TaxNumber1		TaxNumber1	VAT Reg. No.
	VATRegistration		VATRegistration	VAT Registration No.
	InternationalPhoneNumber
	InternationalMobilePhoneNumber
	InternationalFaxNumber
	EmailAddress
	OrderIsBlockedForCustomer		OrderIsBlockedForCustomer	Order block
	BillingIsBlockedForCustomer		BillingIsBlockedForCustomer	Billing block
	DeliveryIsBlocked		DeliveryIsBlocked	Delivery block
	PostingIsBlocked		PostingIsBlocked	Posting Block
	DataControllerSet	I_Customer	DataControllerSet	Data Ctrlr. Set
	DataController1	I_Customer	DataController1	Data Controller
	DataController2	I_Customer	DataController2	Data Controller
	DataController3	I_Customer	DataController3	Data Controller
	DataController4	I_Customer	DataController4	Data Controller
	DataController5	I_Customer	DataController5	Data Controller
	DataController6	I_Customer	DataController6	Data Controller
	DataController7	I_Customer	DataController7	Data Controller
	DataController8	I_Customer	DataController8	Data Controller
	DataController9	I_Customer	DataController9	Data Controller
	DataController10	I_Customer	DataController10	Data Controller
	IsBusinessPurposeCompleted	I_Customer	IsBusinessPurposeCompleted	Purpose Completed
	URLFieldLengthasURLFieldLength
	WebsiteURL
	_CustomerContact		_CustomerContact
	_CustomerSalesArea		_CustomerSalesArea
	_CustomerCompanyCode		_CustomerCompanyCode
	_CustomerBankDetails		_CustomerBankDetails
	_DelivBlkRsnValueHelp		_DelivBlkRsnValueHelp
	_BillingBlockReasonValueHelp		_BillingBlockReasonValueHelp
	_OrderIsBlockedForCustomer		_OrderIsBlockedForCustomer

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_CustomerOP.
-- 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: CCUSTOMEROP

CREATE VIEW C_CustomerOP AS
SELECT
  I_Customer.Customer AS Customer,
  CustomerName,
  BPCustomerName,
  CustomerAccountGroup,
  AuthorizationGroup,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS CityName,
  concat(concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.RoomNumber, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Floor, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Building, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetPrefixName1, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetPrefixName2, concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetSuffixName1, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetSuffixName2, 1),1),1),1),1),1),1),1), concat_with_space(',',concat(concat_with_space(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName,1), concat_with_space(',',_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country,1)),1)) as FormattedAddress AS Country11asFormattedAddress,
  Industry,
  InternationalLocationNumber1,
  cast(concat_with_space(concat_with_space(I_Customer.InternationalLocationNumber1, I_Customer.InternationalLocationNumber2, 1), I_Customer.InternationalLocationNumber3, 1) as mm_pur_supplier_iln) AS InternationalLocationNumber,
  TaxNumber1,
  VATRegistration,
  _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS InternationalPhoneNumber,
  _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber AS InternationalMobilePhoneNumber,
  _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.InternationalFaxNumber AS InternationalFaxNumber,
  _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  OrderIsBlockedForCustomer,
  BillingIsBlockedForCustomer,
  DeliveryIsBlocked,
  PostingIsBlocked,
  I_Customer.DataControllerSet AS DataControllerSet,
  I_Customer.DataController1 AS DataController1,
  I_Customer.DataController2 AS DataController2,
  I_Customer.DataController3 AS DataController3,
  I_Customer.DataController4 AS DataController4,
  I_Customer.DataController5 AS DataController5,
  I_Customer.DataController6 AS DataController6,
  I_Customer.DataController7 AS DataController7,
  I_Customer.DataController8 AS DataController8,
  I_Customer.DataController9 AS DataController9,
  I_Customer.DataController10 AS DataController10,
  I_Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  coalesce(_CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultCorpURLAddress.URLFieldLength, _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address._DefaultPvtURLAddress.URLFieldLength) as URLFieldLength AS URLFieldLengthasURLFieldLength,
  _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._MainWebsiteURL.UniformResourceIdentifier AS WebsiteURL
FROM I_Customer
LEFT OUTER JOIN I_CustomerContactOP AS _CustomerContact ON Customer = _CustomerContact.Customer  -- association [0..*]
LEFT OUTER JOIN C_CustomerSalesAreaOP AS _CustomerSalesArea ON Customer = _CustomerSalesArea.Customer  -- association [0..*]
LEFT OUTER JOIN C_CustomerCompanyCodeOP AS _CustomerCompanyCode ON Customer = _CustomerCompanyCode.Customer  -- association [0..*]
LEFT OUTER JOIN C_CustomerBankDetailsOP AS _CustomerBankDetails ON Customer = _CustomerBankDetails.Customer  -- association [0..*]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DelivBlkRsnValueHelp ON DeliveryIsBlocked = _DelivBlkRsnValueHelp.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReasonValueHelp ON BillingIsBlockedForCustomer = _BillingBlockReasonValueHelp.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN C_OrderIsBlockedTextVHTemp AS _OrderIsBlockedForCustomer ON OrderIsBlockedForCustomer = _OrderIsBlockedForCustomer.OrderIsBlockedForCustomer  -- association [0..*]
;

Depth:

C_CustomerOP view

I_Customer view