C_NO_SAFTCustomerMasterData

DDL: C_NO_SAFTCUSTOMERMASTERDATA Type: view_entity CONSUMPTION
23 Fields

SAFT Norway Customer Master Data

C_NO_SAFTCustomerMasterData is a Consumption CDS View that provides data about "SAFT Norway Customer Master Data" in SAP S/4HANA.

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 Customer Master Data view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY Customer Customer Sold-to Party
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerUUID BusinessPartnerUUID UUID
NO_SAFTCustomerID NO_SAFTCustomerID Customer ID
VATRegistration VATRegistration VAT Registration No.
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
CustomerName CustomerName Name of Customer
Region Region Venue Region
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
BankAccount BankAccount Bank acct
BankNumber BankNumber Bank Key
ItemIsReportingRelevant
_CompanyCode _CompanyCode
_Customer _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 C_NO_SAFTCustomerMasterData.
-- 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_SAFTCustomerMasterData AS
SELECT
  CompanyCode,
  Customer,
  AccountingDocument,
  LedgerGLLineItem,
  BusinessPartner,
  BusinessPartnerUUID,
  NO_SAFTCustomerID,
  VATRegistration,
  TaxNumber1,
  TaxNumber2,
  CustomerName,
  Region,
  RegionName,
  HouseNumber,
  Country,
  POBox,
  POBoxPostalCode,
  IsOneTimeAccount,
  BankAccount,
  BankNumber,
  'X' AS ItemIsReportingRelevant
;

Learn More