I_PT_SAFTBillAcctgOneTimeCust

DDL: I_PT_SAFTBILLACCTGONETIMECUST Type: view_entity COMPOSITE
12 Fields 6 Data Sources

One Time Customer from Accounting Doc

I_PT_SAFTBillAcctgOneTimeCust is a Composite CDS View that provides data about "One Time Customer from Accounting Doc" in SAP S/4HANA. It reads from 6 data sources and exposes 12 fields with key fields CompanyCode, PortugueseInvoiceNumber, FiscalYear, PostingDate.

Data Sources (6)

SourceAliasJoin Type
I_PT_SAFTIsAlternateAccount AltAccount inner
I_JournalEntryItemOneTimeData Cust inner
I_CustomerCompany CustCompany inner
I_GLAccountInCompanyCode GLAcct inner
I_OperationalAcctgDocItem Item inner
I_PT_AcctgDocDgtlSgntr Sig from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label One Time Customer from Accounting Doc view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PT_AcctgDocDgtlSgntr CompanyCode Receiver Company Code
KEY PortugueseInvoiceNumber I_PT_AcctgDocDgtlSgntr PortugueseInvoiceNumber
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
Customer I_OperationalAcctgDocItem Customer Sold-to Party
AddressID
ReconciliationAccount
char20asCustomerVATRegistration
char3asCountry
IsOneTimeAccount I_JournalEntryItemOneTimeData IsOneTimeAccount One-time acct
_Customer I_OperationalAcctgDocItem _Customer

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_PT_SAFTBillAcctgOneTimeCust.
-- 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 I_PT_SAFTBillAcctgOneTimeCust AS
SELECT
  Sig.CompanyCode AS CompanyCode,
  Sig.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  Item.FiscalYear AS FiscalYear,
  Item.PostingDate AS PostingDate,
  Item.AccountingDocument AS AccountingDocument,
  Item.Customer AS Customer,
  Item._Customer.AddressID AS AddressID,
  cast(case when Item.VATRegistration is not initial then substring(Item.VATRegistration ,1,2) else Cust.Country end as abap.char(3) ) as Country AS char3asCountry,
  Cust.IsOneTimeAccount AS IsOneTimeAccount,
  Item._Customer AS _Customer
FROM I_PT_AcctgDocDgtlSgntr AS Sig
INNER JOIN I_OperationalAcctgDocItem AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS Cust ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTIsAlternateAccount AS AltAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerCompany AS CustCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInCompanyCode AS GLAcct ON /* join condition not captured in parsed metadata */
;

Learn More