I_NO_SAFTCustomerLog

DDL: I_NO_SAFTCUSTOMERLOG Type: view_entity BASIC
34 Fields 1 Data Sources

SAFT NO Customer Temporary Log

I_NO_SAFTCustomerLog is a Basic CDS View that provides data about "SAFT NO Customer Temporary Log" in SAP S/4HANA. It reads from 1 data source (saft_noa_cutlog) and exposes 34 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, SAFTModuleForProcDetn, Ledger.

Data Sources (1)

SourceAliasJoin Type
saft_noa_cutlog saft_noa_cutlog from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SAFT NO Customer Temporary Log view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY SAFTModuleForProcDetn saftmodule
KEY Ledger ledger Ledger
KEY CompanyCode companycode Receiver Company Code
KEY FiscalYear fiscalyear G/L Fiscal Year
KEY Customer customer Sold-to Party
KEY AccountingDocument accountingdocument Journal Entry
KEY LedgerGLLineItem ledgergllineitem Journal Entry Item
NO_SAFTCustomerID no_saftcustomerid Customer ID
CustomerVATRegistration customervatregistration VAT Registration No.
BPCustomerName bpcustomername Name of Customer
CustomerName customername Name of Customer
BusinessPartner businesspartner Issuing Authority
BusinessPartnerUUID businesspartneruuid UUID
TaxNumber1 taxnumber1 VAT Reg. No.
TaxNumber2 taxnumber2 Tax Number 2
VATRegistration vatregistration VAT Registration No.
ReportingVATRegistration reportingvatregistration Reporting VAT Number
BankNumber banknumber Bank Key
BankAccount bankaccount Bank acct
CityName cityname Name
PostalCode postalcode Postal Code
Region region Venue Region
StreetName streetname Text
AddressTypeDesc addresstypedesc Short Description
RegionName regionname Description
HouseNumber housenumber House Number
Country country Venue: Ctry/Reg
POBox pobox PO Box
POBoxPostalCode poboxpostalcode PO Box Postal Code
IsOneTimeAccount isonetimeaccount One-time acct
ItemIsReportingRelevant itemisreportingrelevant Item Reporting Relv

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_NO_SAFTCustomerLog.
-- 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_NO_SAFTCustomerLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  saftmodule AS SAFTModuleForProcDetn,
  Ledger,
  CompanyCode,
  FiscalYear,
  Customer,
  AccountingDocument,
  LedgerGLLineItem,
  NO_SAFTCustomerID,
  CustomerVATRegistration,
  BPCustomerName,
  CustomerName,
  BusinessPartner,
  BusinessPartnerUUID,
  TaxNumber1,
  TaxNumber2,
  VATRegistration,
  ReportingVATRegistration,
  BankNumber,
  BankAccount,
  CityName,
  PostalCode,
  Region,
  StreetName,
  AddressTypeDesc,
  RegionName,
  HouseNumber,
  Country,
  POBox,
  POBoxPostalCode,
  IsOneTimeAccount,
  ItemIsReportingRelevant
FROM saft_noa_cutlog
;

Learn More