C_NO_SAFTSupplierMasterData

DDL: C_NO_SAFTSUPPLIERMASTERDATA Type: view_entity CONSUMPTION Package: GLO_FIN_IS_SAFT_NO
27 Fields

SAFT Norway Supplier Master Data

C_NO_SAFTSupplierMasterData is a Consumption CDS View that provides data about "SAFT Norway Supplier Master Data" in SAP S/4HANA. Part of development package GLO_FIN_IS_SAFT_NO.

Parameters (4)

NameTypeDefault
P_FromPostingDate budat
P_ToPostingDate budat
P_Ledger fins_ledger
P_FiscalYear gjahr

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label SAFT Norway Supplier Master Data view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Supplier CompanyCode Receiver Company Code
KEY Supplier Supplier Supplier Supplier
KEY AccountingDocument Supplier AccountingDocument Journal Entry
KEY LedgerGLLineItem Supplier LedgerGLLineItem Journal Entry Item
BusinessPartner Supplier BusinessPartner Issuing Authority
BusinessPartnerUUID Supplier BusinessPartnerUUID UUID
NO_SAFTSupplierID Supplier NO_SAFTSupplierID Supplier ID
TaxNumber1 Supplier TaxNumber1 VAT Reg. No.
TaxNumber2 Supplier TaxNumber2 Tax Number 2
VATRegistration Supplier VATRegistration VAT Registration No.
OrganizationBPName21endasBPSupplierName
SupplierName SupplierName Supplier Name
CityName135endasCityName
StreetNameendasStreetName
POBoxPostalCodeelseNAendendasPostalCode
Region Supplier Region Venue Region
RegionName Supplier RegionName Description
HouseNumber Supplier HouseNumber House Number
Country Supplier Country Venue: Ctry/Reg
POBox Supplier POBox PO Box
POBoxPostalCode Supplier POBoxPostalCode PO Box Postal Code
IsOneTimeAccount Supplier IsOneTimeAccount One-time acct
BankAccount Supplier BankAccount Bank acct
BankNumber Supplier BankNumber Bank Key
ItemIsReportingRelevant
_CompanyCode Supplier _CompanyCode
_Supplier Supplier _Supplier

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_NO_SAFTSupplierMasterData.
-- 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.
-- Parameters: P_FromPostingDate : budat, P_ToPostingDate : budat, P_Ledger : fins_ledger, P_FiscalYear : gjahr

CREATE VIEW C_NO_SAFTSupplierMasterData AS
SELECT
  Supplier.CompanyCode AS CompanyCode,
  Supplier.Supplier AS Supplier,
  Supplier.AccountingDocument AS AccountingDocument,
  Supplier.LedgerGLLineItem AS LedgerGLLineItem,
  Supplier.BusinessPartner AS BusinessPartner,
  Supplier.BusinessPartnerUUID AS BusinessPartnerUUID,
  Supplier.NO_SAFTSupplierID AS NO_SAFTSupplierID,
  Supplier.TaxNumber1 AS TaxNumber1,
  Supplier.TaxNumber2 AS TaxNumber2,
  Supplier.VATRegistration AS VATRegistration,
  case when Supplier.OrganizationBPName1 is initial and Supplier.OrganizationBPName2 is initial then 'NA' else concat_with_space(Supplier.OrganizationBPName1, Supplier.OrganizationBPName2, 1) end as BPSupplierName AS OrganizationBPName21endasBPSupplierName,
  SupplierName,
  case when Supplier.CityName is initial then 'NA' else substring(Supplier.CityName,1,35) end as CityName AS CityName135endasCityName,
  case when Supplier.StreetName is initial then Supplier.POBox else Supplier.StreetName end as StreetName AS StreetNameendasStreetName,
  case when Supplier.PostalCode is not initial and Supplier.StreetName is not initial then Supplier.PostalCode else case when Supplier.POBoxPostalCode is not initial and Supplier.POBox is not initial then Supplier.POBoxPostalCode else 'NA' end end as PostalCode AS POBoxPostalCodeelseNAendendasPostalCode,
  Supplier.Region AS Region,
  Supplier.RegionName AS RegionName,
  Supplier.HouseNumber AS HouseNumber,
  Supplier.Country AS Country,
  Supplier.POBox AS POBox,
  Supplier.POBoxPostalCode AS POBoxPostalCode,
  Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  Supplier.BankAccount AS BankAccount,
  Supplier.BankNumber AS BankNumber,
  'X' AS ItemIsReportingRelevant,
  Supplier._CompanyCode AS _CompanyCode,
  Supplier._Supplier AS _Supplier
;

Learn More