What is C_PT_SAFTCustomer in SAP S/4HANA?

C_PT_SAFTCustomer is a consumption CDS view in SAP S/4HANA. SAF-T PT Customers It contains 157 fields.

What VDM layer is C_PT_SAFTCustomer?

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

C_PT_SAFTCustomer

DDL: C_PT_SAFTCUSTOMER SQL: CPTSAFTCUST Type: view CONSUMPTION

157 Fields

SAF-T PT Customers

C_PT_SAFTCustomer is a Consumption CDS View that provides data about "SAF-T PT Customers" in SAP S/4HANA.

Parameters (2)

Name	Type	Default
P_StartDate	dats
P_EndDate	dats

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CPTSAFTCUST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	SAF-T PT Customers	view

Fields (157)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	a	CompanyCode	Receiver Company Code
KEY	PortugueseCustomerWithVersion	a	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	a	CompanyName	Text
	StreetName	a	StreetName	Text
	CityName	a	CityName	Name
	PostalCode	a	PostalCode	Postal Code
	Country	a	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber			Telephone no.
	FaxNumber			Fax Number
	EmailAddress			E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	a	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	a	CompanyName	Text
	StreetName	a	StreetName	Text
	CityName	a	CityName	Name
	PostalCode	a	PostalCode	Postal Code
	Country	a	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber			Telephone no.
	FaxNumber			Fax Number
	EmailAddress			E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	ac	PortugueseCustomerWithVersion
	CustomerVATRegistration	ac	CustomerVATRegistration	VAT Registration No.
	CompanyName	ac	CompanyName	Text
	StreetName	ac	StreetName	Text
	CityName	ac	CityName	Name
	PostalCode	ac	PostalCode	Postal Code
	Country	ac	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName	ac	CompanyContactPersonFullName	Full Name
	PhoneNumber	ac	PhoneNumber	Telephone no.
	FaxNumber	ac	FaxNumber	Fax Number
	EmailAddress	ac	EmailAddress	E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	bc	PortugueseCustomerWithVersion
	CustomerVATRegistration	bc	CustomerVATRegistration	VAT Registration No.
	CompanyName	bc	CompanyName	Text
	StreetName	bc	StreetName	Text
	CityName	bc	CityName	Name
	PostalCode	bc	PostalCode	Postal Code
	Country	bc	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName	bc	CompanyContactPersonFullName	Full Name
	PhoneNumber	bc	PhoneNumber	Telephone no.
	FaxNumber	bc	FaxNumber	Fax Number
	EmailAddress	bc	EmailAddress	E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	payc	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	payc	CompanyName	Text
	StreetName	payc	StreetName	Text
	CityName	payc	CityName	Name
	PostalCode	payc	PostalCode	Postal Code
	Country	payc	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName	payc	CompanyContactPersonFullName	Full Name
	PhoneNumber	payc	PhoneNumber	Telephone no.
	FaxNumber	payc	FaxNumber	Fax Number
	EmailAddress	payc	EmailAddress	E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	payotc	CustomerNum
	CustomerVATRegistration			VAT Registration No.
	CompanyName	payotc	CompanyName	Text
	StreetName	payotc	StreetName	Text
	CityName	payotc	CityName	Name
	PostalCode	payotc	PostalCode	Postal Code
	Country	payotc	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber			Telephone no.
	FaxNumber			Fax Number
	EmailAddress			E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	mvat	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	mvat	CompanyName	Text
	StreetName	mvat	StreetName	Text
	CityName	mvat	CityName	Name
	PostalCode	mvat	PostalCode	Postal Code
	Country	mvat	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber			Telephone no.
	FaxNumber			Fax Number
	EmailAddress			E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	mvat	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	mvat	CompanyName	Text
	StreetName	mvat	StreetName	Text
	CityName	mvat	CityName	Name
	PostalCode	mvat	PostalCode	Postal Code
	Country	mvat	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber			Telephone no.
	FaxNumber			Fax Number
	EmailAddress			E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	mvat	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	mvat	CompanyName	Text
	StreetName	mvat	StreetName	Text
	CityName	mvat	CityName	Name
	PostalCode	mvat	PostalCode	Postal Code
	Country	mvat	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber			Telephone no.
	FaxNumber			Fax Number
	EmailAddress			E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	m	PortugueseCustomerWithVersion
	CustomerVATRegistration	m	CustomerVATRegistration	VAT Registration No.
	CompanyName	m	CompanyName	Text
	StreetName	m	StreetName	Text
	CityName	m	CityName	Name
	PostalCode	m	PostalCode	Postal Code
	Country	m	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName	m	CompanyContactPersonFullName	Full Name
	PhoneNumber	m	PhoneNumber	Telephone no.
	FaxNumber	m	FaxNumber	Fax Number
	EmailAddress	m	EmailAddress	E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	MoGOneTimeCust	PortugueseCustomerWithVersion
	CustomerVATRegistration	MoGOneTimeCust	CustomerVATRegistration	VAT Registration No.
	CompanyName	MoGOneTimeCust	CompanyName	Text
	StreetName	MoGOneTimeCust	StreetName	Text
	CityName	MoGOneTimeCust	CityName	Name
	PostalCode	MoGOneTimeCust	PostalCode	Postal Code
	Country	MoGOneTimeCust	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName			Full Name
	PhoneNumber	MoGOneTimeCust	PhoneNumber	Telephone no.
	FaxNumber	MoGOneTimeCust	FaxNumber	Fax Number
	EmailAddress	MoGOneTimeCust	EmailAddress	E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	SettlmtMgmtCustomer	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	SettlmtMgmtCustomer	CompanyName	Text
	StreetName	SettlmtMgmtCustomer	StreetName	Text
	CityName	SettlmtMgmtCustomer	CityName	Name
	PostalCode	SettlmtMgmtCustomer	PostalCode	Postal Code
	Country	SettlmtMgmtCustomer	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName	SettlmtMgmtCustomer	CompanyContactPersonFullName	Full Name
	PhoneNumber	SettlmtMgmtCustomer	PhoneNumber	Telephone no.
	FaxNumber	SettlmtMgmtCustomer	FaxNumber	Fax Number
	EmailAddress	SettlmtMgmtCustomer	EmailAddress	E-Mail Address
	CompanyCode			Receiver Company Code
KEY	PortugueseCustomerWithVersion	SettlmtMgmtTaxRegNmbr	PortugueseCustomerWithVersion
	CustomerVATRegistration			VAT Registration No.
	CompanyName	SettlmtMgmtTaxRegNmbr	CompanyName	Text
	StreetName	SettlmtMgmtTaxRegNmbr	StreetName	Text
	CityName	SettlmtMgmtTaxRegNmbr	CityName	Name
	PostalCode	SettlmtMgmtTaxRegNmbr	PostalCode	Postal Code
	Country	SettlmtMgmtTaxRegNmbr	Country	Venue: Ctry/Reg
	CompanyContactPersonFullName	SettlmtMgmtTaxRegNmbr	CompanyContactPersonFullName	Full Name
	PhoneNumber	SettlmtMgmtTaxRegNmbr	PhoneNumber	Telephone no.
	FaxNumber	SettlmtMgmtTaxRegNmbr	FaxNumber	Fax Number
	EmailAddress	SettlmtMgmtTaxRegNmbr	EmailAddress	E-Mail Address
	WebsiteURL	SettlmtMgmtTaxRegNmbr	WebsiteURL	URI

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_PT_SAFTCustomer.
-- 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: CPTSAFTCUST
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW C_PT_SAFTCustomer AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.PortugueseCustomerWithVersion AS PortugueseCustomerWithVersion,
  cast(a.CustomerVATRegistration as stceg) AS CustomerVATRegistration,
  a.CompanyName AS CompanyName,
  a.StreetName AS StreetName,
  a.CityName AS CityName,
  a.PostalCode AS PostalCode,
  a.Country AS Country,
  cast(' ' as saft_pt_contact_name) AS CompanyContactPersonFullName,
  coalesce( a.PhoneNumber , '') AS PhoneNumber,
  coalesce( a.FaxNumber , '') AS FaxNumber,
  coalesce( a.EmailAddress , '') AS EmailAddress,
  SettlmtMgmtTaxRegNmbr.WebsiteURL AS WebsiteURL
;

Depth:

C_PT_SAFTCustomer view

C_PT_SAFTIntegratedCustomer view