What is I_SAFTBillingOneTimeCustomer in SAP S/4HANA?

I_SAFTBillingOneTimeCustomer is a composite CDS view in SAP S/4HANA. SAF-T Billing OneTimeCustomers It contains 47 fields.

Which tables does I_SAFTBillingOneTimeCustomer read from?

I_SAFTBillingOneTimeCustomer reads data from: I_SDDocumentCompletePartners, I_SDDocumentCompletePartners, I_BillingDocument, I_InvoiceList, I_OneTimeCustomerTaxNumber and more.

What VDM layer is I_SAFTBillingOneTimeCustomer?

I_SAFTBillingOneTimeCustomer is classified as a Composite view that combines data from multiple basic views.

I_SAFTBillingOneTimeCustomer

DDL: I_SAFTBILLINGONETIMECUSTOMER SQL: ISAFTOTBILCUST Type: view COMPOSITE Package: ID-FI-SAFT_DEPREC

47 Fields 6 Data Sources 1 Associations

SAF-T Billing OneTimeCustomers

I_SAFTBillingOneTimeCustomer is a Composite CDS View that provides data about "SAF-T Billing OneTimeCustomers" in SAP S/4HANA. It reads from 6 data sources and exposes 47 fields with key fields BillingDocument, FiscalYear, CompanyCode, PartnerFunction, FiscalYear. It has 1 association to related views. Part of development package ID-FI-SAFT_DEPREC.

Data Sources (6)

Source	Alias	Join Type
I_SDDocumentCompletePartners	Cust	inner
I_SDDocumentCompletePartners	Cust	inner
I_BillingDocument	SDDoc	from
I_InvoiceList	SDDoc	union
I_OneTimeCustomerTaxNumber	Tax	left_outer
I_OneTimeCustomerTaxNumber	Tax	left_outer

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_CustomerCompany	_CustCompany	`Cust.Customer = _CustCompany.Customer and SDDoc.CompanyCode = _CustCompany.CompanyCode`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	ISAFTOTBILCUST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
EndUserText.label	SAF-T Billing OneTimeCustomers	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	NoSuccessor	view

Fields (47)

Key	Field	Source Table	Source Field	Description
KEY	BillingDocument	I_InvoiceList	BillingDocument	SD Document
KEY	FiscalYear	I_InvoiceList	FiscalYear	G/L Fiscal Year
KEY	CompanyCode	I_InvoiceList	CompanyCode	Receiver Company Code
KEY	PartnerFunction	I_SDDocumentCompletePartners	PartnerFunction	Partner Functn
	InvoiceDate	I_InvoiceList	BillingDocumentDate	Billing Date
	Customer	I_SDDocumentCompletePartners	Customer	Sold-to Party
	IsOneTimeAccount	I_SDDocumentCompletePartners	PartnerIsOneTimeAccount	One-time acct
	ReconciliationAccount	_CustCompany	ReconciliationAccount	Recon. account
	AddressNumber	I_SDDocumentCompletePartners	AddressID	Ship-to address
	AddressID	I_SDDocumentCompletePartners	AddressID	Ship-to address
	AddressPersonID	I_SDDocumentCompletePartners	AddressPersonID	Person Number
	FullName
	StreetName
	StreetPrefixName
	AdditionalStreetPrefixName
	StreetSuffixName
	AdditionalStreetSuffixName
	HouseNumber
	Region
	_DfltAddrRprstn	I_SDDocumentCompletePartners	_DfltAddrRprstn
	PhoneNumber
	FaxNumber
	EmailAddress
	InvoiceListasBillingDocument
KEY	FiscalYear	I_InvoiceList	FiscalYear	G/L Fiscal Year
KEY	CompanyCode	I_InvoiceList	CompanyCode	Receiver Company Code
KEY	PartnerFunction	I_SDDocumentCompletePartners	PartnerFunction	Partner Functn
	InvoiceDate	I_InvoiceList	InvoiceListBillingDate	Billing Date
	Customer	I_SDDocumentCompletePartners	Customer	Sold-to Party
	IsOneTimeAccount	I_SDDocumentCompletePartners	PartnerIsOneTimeAccount	One-time acct
	ReconciliationAccount	_CustCompany	ReconciliationAccount	Recon. account
	AddressNumber	I_SDDocumentCompletePartners	AddressID	Ship-to address
	AddressID	I_SDDocumentCompletePartners	AddressID	Ship-to address
	AddressPersonID	I_SDDocumentCompletePartners	AddressPersonID	Person Number
	FullName
	StreetName
	StreetPrefixName
	AdditionalStreetPrefixName
	StreetSuffixName
	AdditionalStreetSuffixName
	HouseNumber
	Region
	_DfltAddrRprstn	I_SDDocumentCompletePartners	_DfltAddrRprstn
	PhoneNumber
	FaxNumber
	EmailAddress
	WebsiteURL

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 I_SAFTBillingOneTimeCustomer.
-- 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: ISAFTOTBILCUST

CREATE VIEW I_SAFTBillingOneTimeCustomer AS
SELECT
  SDDoc.BillingDocument AS BillingDocument,
  SDDoc.FiscalYear AS FiscalYear,
  SDDoc.CompanyCode AS CompanyCode,
  Cust.PartnerFunction AS PartnerFunction,
  SDDoc.BillingDocumentDate AS InvoiceDate,
  Cust.Customer AS Customer,
  Cust.PartnerIsOneTimeAccount AS IsOneTimeAccount,
  _CustCompany.ReconciliationAccount AS ReconciliationAccount,
  Cust.AddressID AS AddressNumber,
  Cust.AddressID AS AddressID,
  Cust.AddressPersonID AS AddressPersonID,
  concat_with_space(Cust._DfltAddrRprstn.OrganizationName1, Cust._DfltAddrRprstn.OrganizationName2, 1) AS FullName,
  Cust._DfltAddrRprstn.StreetName AS StreetName,
  Cust._DfltAddrRprstn.StreetPrefixName1 AS StreetPrefixName,
  Cust._DfltAddrRprstn.StreetPrefixName1 AS AdditionalStreetPrefixName,
  Cust._DfltAddrRprstn.StreetSuffixName1 AS StreetSuffixName,
  Cust._DfltAddrRprstn.StreetSuffixName2 AS AdditionalStreetSuffixName,
  Cust._DfltAddrRprstn.HouseNumber AS HouseNumber,
  Cust._DfltAddrRprstn.Region AS Region,
  Cust._DfltAddrRprstn AS _DfltAddrRprstn,
  Cust._DfltAddrRprstn._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS PhoneNumber,
  Cust._DfltAddrRprstn._CurrentDfltFaxNumber.InternationalFaxNumber AS FaxNumber,
  Cust._DfltAddrRprstn._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  ' ' as WebsiteURL AS InvoiceListasBillingDocument,
  ' ' AS WebsiteURL
FROM I_BillingDocument AS SDDoc
INNER JOIN I_SDDocumentCompletePartners AS Cust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OneTimeCustomerTaxNumber AS Tax ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerCompany AS _CustCompany ON Cust.Customer = _CustCompany.Customer AND SDDoc.CompanyCode = _CustCompany.CompanyCode  -- association [0..1]
-- UNION with additional select branch(es): I_InvoiceList
;

Depth:

I_SAFTBillingOneTimeCustomer view

P_PT_SAFTCUSTADDR view