I_AU_PTRBusinessIdentification

DDL: I_AU_PTRBUSINESSIDENTIFICATION Type: view_entity BASIC Package: GLO_FIN_IS_AU
8 Fields 1 Data Sources

AU PTR Business Identification

I_AU_PTRBusinessIdentification is a Basic CDS View that provides data about "AU PTR Business Identification" in SAP S/4HANA. It reads from 1 data source (fiau_ptr_sbi) and exposes 8 fields with key fields Supplier, CompanyCode, FromReportingDate, VATRegistration. Part of development package GLO_FIN_IS_AU.

Data Sources (1)

SourceAliasJoin Type
fiau_ptr_sbi fiau_ptr_sbi from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
EndUserText.label AU PTR Business Identification view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Supplier lifnr Vendor no.
KEY CompanyCode bukrs Value
KEY FromReportingDate frmdate Reporting Date From
KEY VATRegistration stceg VAT Reg. No.
ToReportingDate todate ValToDate
ChangedBy usname User Name
ChangeLogUTCDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
AU_ABNIsNotSmallBusiness notsmallbusiness

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_AU_PTRBusinessIdentification.
-- 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_AU_PTRBusinessIdentification AS
SELECT
  lifnr AS Supplier,
  bukrs AS CompanyCode,
  frmdate AS FromReportingDate,
  stceg AS VATRegistration,
  todate AS ToReportingDate,
  usname AS ChangedBy,
  timestamp AS ChangeLogUTCDateTime,
  notsmallbusiness AS AU_ABNIsNotSmallBusiness
FROM fiau_ptr_sbi
;

Learn More