What is P_ARCustomer in SAP S/4HANA?

P_ARCustomer is a consumption CDS view in SAP S/4HANA. It contains 115 fields.

Which tables does P_ARCustomer read from?

P_ARCustomer reads data from: P_ARCustomerUnion.

What VDM layer is P_ARCustomer?

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

P_ARCustomer

DDL: P_ARCUSTOMER SQL: PARCUSTOMER Type: view CONSUMPTION

115 Fields 1 Data Sources 8 Associations

P_ARCustomer is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_ARCustomerUnion) and exposes 115 fields with key fields Customer, CompanyCode, SalesOrganization, DistributionChannel, Division. It has 8 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_ARCustomerUnion	_Customer	from

Associations (8)

Cardinality	Target	Alias	Condition
[0..*]	I_Paymentcard	_PaymentCard	`$projection.BusinessPartner = _PaymentCard.BusinessPartner`
[0..*]	I_BusinessPartnerBank	_BusinessPartnerBank	`$projection.BusinessPartner = _BusinessPartnerBank.BusinessPartner`
[0..1]	P_BusinessPartnerFSAttr	_ARBusinessPartnerFSAttr	`$projection.BusinessPartner = _ARBusinessPartnerFSAttr.BusinessPartner`
[0..1]	I_StatusObjectUUIDStatus	_StatusObject	`$projection.BusinessPartnerUUID = _StatusObject.StatusObjectUUID and _StatusObject.StatusIsInactive != 'X'`
[0..1]	P_ADDRESSTEXT	_AddressText	`$projection.addressid = _AddressText.AddressID and _AddressText.Language = $session.system_language`
[0..*]	P_ARCustSalesPartnerFunc	_CustSalesPartnerFunc	`$projection.Customer = _CustSalesPartnerFunc.Customer and $projection.SalesOrganization = _CustSalesPartnerFunc.SalesOrganization and $projection.DistributionChannel = _CustSalesPartnerFunc.DistributionChannel and $projection.Division = _CustSalesPartnerFunc.Division`
[0..1]	I_AccountingClerk	_AccountingClerk	`$projection.AccountingClerk = _AccountingClerk.AccountingClerk and $projection.CompanyCode = _AccountingClerk.CompanyCode`
[0..1]	I_TH_CustomerBranchCodeVH	_BranchCode	`$projection.Customer = _BranchCode.Customer and _BranchCode.IsDefaultValue = 'X'`

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	PARCUSTOMER	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view

Fields (115)

Key	Field	Source Table	Source Field	Description
KEY	Customer		Customer	Sold-to Party
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	SalesOrganization		SalesOrganization	Sales Organization
KEY	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
KEY	Division		Division	Internal Division ID
KEY	CustomerIsWithCompanyCode		CustomerIsWithCompanyCode
	CustomerAccountGroup			Account group
	AccountGroupName
	Supplier		Supplier	Supplier
	PostingIsBlocked		PostingIsBlocked	Posting Block
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	CreatedByUser			User Name
	VATRegistration		VATRegistration	VAT Registration No.
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	TaxNumber3		TaxNumber3
	TaxNumber4		TaxNumber4
	TaxNumber5		TaxNumber5
	VATLiability		VATLiability	Liable for VAT
	ResponsibleType			Tax Type
	TaxNumberType			Tax number type
	CustomerName		CustomerName	Name of Customer
	CustomerFullName		CustomerFullName	Customer Name
	SalesOffice		SalesOffice	Sales Office
	SalesGroup		SalesGroup	Sales Group
	CustomerPaymentTerms		CustomerPaymentTerms	Pyt Terms
	BusinessPartner
	BusinessPartnerUUID
	BusinessPartnerName
	FirstName
	LastName
	OrganizationBPName1
	OrganizationBPName2
	GroupBusinessPartnerName1
	GroupBusinessPartnerName2
	BusinessPartnerType
	LegalForm
	LegalEntityOfOrganization
	BusinessPartnerIDByExtSystem
	IsMarkedForArchiving
	BusinessPartnerIsBlocked
	ContactPermission
	AddressID	_StandardAddress	AddressID	Ship-to address
	CityName	_StandardAddress	CityName	Name
	PhoneNumber	_StandardAddress	PhoneNumber	Telephone no.
	EmailAddress
	StreetName	_StandardAddress	StreetName	Text
	PostalCode	_StandardAddress	PostalCode	Postal Code
	Country	_StandardAddress	Country	Venue: Ctry/Reg
	Region	_StandardAddress	Region	Venue Region
	AddressTimeZone	_StandardAddress	AddressTimeZone	Time Zone
	POBox	_StandardAddress	POBox	PO Box
	POBoxPostalCode	_StandardAddress	POBoxPostalCode	PO Box Postal Code
	CompanyPostalCode	_StandardAddress	CompanyPostalCode	Company Post Cd
	CorrespondenceLanguage	_StandardAddress	CorrespondenceLanguage	Language
	MobilePhoneNumber
	FaxNumber	_StandardAddress	FaxNumber	Fax Number
	PrfrdCommMediumType	_StandardAddress	PrfrdCommMediumType	Comm. Method
	SearchTerm1	_StandardAddress	SearchTerm1	Search Term 1
	SearchTerm2	_StandardAddress	SearchTerm2	Search Term 2
	StreetPrefixName	_StandardAddress	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	_StandardAddress	AdditionalStreetPrefixName	Street 3
	StreetSuffixName	_StandardAddress	StreetSuffixName	Street 4
	AdditionalStreetSuffixName	_StandardAddress	AdditionalStreetSuffixName	Street 5
	District	_StandardAddress	District	District Court
	HouseNumber	_StandardAddress	HouseNumber	House Number
	BusinessPartnerName2	_StandardAddress	BusinessPartnerName2	Name 2
	BusinessPartnerName3	_StandardAddress	BusinessPartnerName3	Name 3
	BusinessPartnerName4	_StandardAddress	BusinessPartnerName4	Name 4
	AccountingClerk		AccountingClerk	Clerk Abbrev.
	PaymentTerms		PaymentTerms	Pyt Terms
	DunningProcedure
	DunningBlock
	LastDunnedOn
	LegDunningProcedureOn
	DunningLevel
	PhysicalInventoryBlockInd		PhysicalInventoryBlockInd	Phys. Inv. Blk
	CreditMemoPaymentTerms		CreditMemoPaymentTerms	Cr Memo Terms
	PaymentMethodsList		PaymentMethodsList	Payment Methods
	HouseBank		HouseBank	House Bank
	PaymentBlockingReason		PaymentBlockingReason	Pmnt block
	DunningNoticeGroup		DunningNoticeGroup	Grouping Key
	AccountByCustomer		AccountByCustomer	Acct at cust.
	UserAtCustomer		UserAtCustomer	Customer user
	AccountingClerkPhoneNumber		AccountingClerkPhoneNumber	Act.clk tel.no.
	AccountingClerkInternetAddress		AccountingClerkInternetAddress	Clrk's internet
	ReconciliationAccount		ReconciliationAccount	Recon. account
	InterestCalculationCode		InterestCalculationCode	Interest Indic.
	DunningRecipient
	DunningClerk
	IntrstCalcFrequencyInMonths		IntrstCalcFrequencyInMonths	Int.Calc.Freq.
	InterestCalculationDate		InterestCalculationDate	Last Key Date
	LastInterestCalcRunDate		LastInterestCalcRunDate	Last Int. Calc.
	CustPreviousMasterRecordNumber		CustPreviousMasterRecordNumber	Prev.Acct No.
	CashPlanningGroup		CashPlanningGroup	Planning Group
	BranchCode	_BranchCode	BranchCode	Branch Code
	TH_BranchCodeDescription
	_PaymentCard		_PaymentCard
	_BusinessPartnerBank		_BusinessPartnerBank
	_ARBusinessPartnerFSAttr		_ARBusinessPartnerFSAttr
	_StatusObject		_StatusObject
	_AddressText		_AddressText
	_CustSalesPartnerFunc		_CustSalesPartnerFunc
	_AccountingClerk		_AccountingClerk
	DataControllerSet		DataControllerSet	Data Ctrlr. Set
	DataController1		DataController1	Data Controller
	DataController2		DataController2	Data Controller
	DataController3		DataController3	Data Controller
	DataController4		DataController4	Data Controller
	DataController5		DataController5	Data Controller
	DataController6		DataController6	Data Controller
	DataController7		DataController7	Data Controller
	DataController8		DataController8	Data Controller
	DataController9		DataController9	Data Controller
	DataController10		DataController10	Data Controller

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_ARCustomer.
-- 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: PARCUSTOMER

CREATE VIEW P_ARCustomer AS
SELECT
  Customer,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustomerIsWithCompanyCode,
  cast(CustomerAccountGroup as farp_customer_account_group preserving type) AS CustomerAccountGroup,
  _CustomerAccountGroupText[1:Language = $session.system_language].AccountGroupName AS AccountGroupName,
  Supplier,
  PostingIsBlocked,
  AuthorizationGroup,
  cast(CreatedByUser as farp_ernam_rf) AS CreatedByUser,
  VATRegistration,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATLiability,
  cast(ResponsibleType as supplist_j_1atoid) AS ResponsibleType,
  cast(TaxNumberType as farp_supplist_j_1atoid) AS TaxNumberType,
  CustomerName,
  CustomerFullName,
  SalesOffice,
  SalesGroup,
  CustomerPaymentTerms,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CustomerToBusinessPartner._BusinessPartner.FirstName AS FirstName,
  _CustomerToBusinessPartner._BusinessPartner.LastName AS LastName,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _CustomerToBusinessPartner._BusinessPartner.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  _CustomerToBusinessPartner._BusinessPartner.LegalForm AS LegalForm,
  _CustomerToBusinessPartner._BusinessPartner.LegalEntityOfOrganization AS LegalEntityOfOrganization,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerIDByExtSystem AS BusinessPartnerIDByExtSystem,
  _CustomerToBusinessPartner._BusinessPartner.IsMarkedForArchiving AS IsMarkedForArchiving,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _CustomerToBusinessPartner._BusinessPartner.ContactPermission AS ContactPermission,
  _StandardAddress.AddressID AS AddressID,
  _StandardAddress.CityName AS CityName,
  _StandardAddress.PhoneNumber AS PhoneNumber,
  _StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _StandardAddress.StreetName AS StreetName,
  _StandardAddress.PostalCode AS PostalCode,
  _StandardAddress.Country AS Country,
  _StandardAddress.Region AS Region,
  _StandardAddress.AddressTimeZone AS AddressTimeZone,
  _StandardAddress.POBox AS POBox,
  _StandardAddress.POBoxPostalCode AS POBoxPostalCode,
  _StandardAddress.CompanyPostalCode AS CompanyPostalCode,
  _StandardAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  _StandardAddress._DefaultMobilePhoneNumber.InternationalPhoneNumber AS MobilePhoneNumber,
  _StandardAddress.FaxNumber AS FaxNumber,
  _StandardAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  _StandardAddress.SearchTerm1 AS SearchTerm1,
  _StandardAddress.SearchTerm2 AS SearchTerm2,
  _StandardAddress.StreetPrefixName AS StreetPrefixName,
  _StandardAddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _StandardAddress.StreetSuffixName AS StreetSuffixName,
  _StandardAddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _StandardAddress.District AS District,
  _StandardAddress.HouseNumber AS HouseNumber,
  _StandardAddress.BusinessPartnerName2 AS BusinessPartnerName2,
  _StandardAddress.BusinessPartnerName3 AS BusinessPartnerName3,
  _StandardAddress.BusinessPartnerName4 AS BusinessPartnerName4,
  AccountingClerk,
  PaymentTerms,
  _CustomerCompany._CustomerDefaultDunning.DunningProcedure AS DunningProcedure,
  _CustomerCompany._CustomerDefaultDunning.DunningBlock AS DunningBlock,
  _CustomerCompany._CustomerDefaultDunning.LastDunnedOn AS LastDunnedOn,
  _CustomerCompany._CustomerDefaultDunning.LegDunningProcedureOn AS LegDunningProcedureOn,
  _CustomerCompany._CustomerDefaultDunning.DunningLevel AS DunningLevel,
  PhysicalInventoryBlockInd,
  CreditMemoPaymentTerms,
  PaymentMethodsList,
  HouseBank,
  PaymentBlockingReason,
  DunningNoticeGroup,
  AccountByCustomer,
  UserAtCustomer,
  AccountingClerkPhoneNumber,
  AccountingClerkInternetAddress,
  ReconciliationAccount,
  InterestCalculationCode,
  _CustomerCompany._CustomerDefaultDunning.DunningRecipient AS DunningRecipient,
  _CustomerCompany._CustomerDefaultDunning.DunningClerk AS DunningClerk,
  IntrstCalcFrequencyInMonths,
  InterestCalculationDate,
  LastInterestCalcRunDate,
  CustPreviousMasterRecordNumber,
  CashPlanningGroup,
  _BranchCode.BranchCode AS BranchCode,
  cast(_BranchCode.TH_BranchCodeDescription as farp_supplist_branch_descr preserving type) AS TH_BranchCodeDescription,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM P_ARCustomerUnion AS _Customer
LEFT OUTER JOIN I_Paymentcard AS _PaymentCard ON BusinessPartner = _PaymentCard.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerBank AS _BusinessPartnerBank ON BusinessPartner = _BusinessPartnerBank.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN P_BusinessPartnerFSAttr AS _ARBusinessPartnerFSAttr ON BusinessPartner = _ARBusinessPartnerFSAttr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _StatusObject ON BusinessPartnerUUID = _StatusObject.StatusObjectUUID AND _StatusObject.StatusIsInactive != 'X'  -- association [0..1]
LEFT OUTER JOIN P_ADDRESSTEXT AS _AddressText ON addressid = _AddressText.AddressID AND _AddressText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_ARCustSalesPartnerFunc AS _CustSalesPartnerFunc ON Customer = _CustSalesPartnerFunc.Customer AND SalesOrganization = _CustSalesPartnerFunc.SalesOrganization AND DistributionChannel = _CustSalesPartnerFunc.DistributionChannel AND Division = _CustSalesPartnerFunc.Division  -- association [0..*]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON AccountingClerk = _AccountingClerk.AccountingClerk AND CompanyCode = _AccountingClerk.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TH_CustomerBranchCodeVH AS _BranchCode ON Customer = _BranchCode.Customer AND _BranchCode.IsDefaultValue = 'X'  -- association [0..1]
;

Depth:

P_ARCustomer view

P_ARCustomerUnion view

C_ARCustomer view