C_NO_SAFTGenLedgerCustContacts

DDL: C_NO_SAFTGENLEDGERCUSTCONTACTS SQL: CNOSAFTGLCUSTCS Type: view CONSUMPTION
19 Fields 1 Data Sources

SAF-T Norway Customer Contacts

C_NO_SAFTGenLedgerCustContacts is a Consumption CDS View that provides data about "SAF-T Norway Customer Contacts" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerContact) and exposes 19 fields with key fields RelationshipNumber, BusinessPartner, BusinessPartnerPerson, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerContact Contact from

Parameters (2)

NameTypeDefault
P_StartDate dats
P_EndDate dats

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CNOSAFTGLCUSTCS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label SAF-T Norway Customer Contacts view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber I_BusinessPartnerContact RelationshipNumber BP Rel. Number
KEY BusinessPartner I_BusinessPartnerContact BusinessPartnerCompany Busn. Partner
KEY BusinessPartnerPerson I_BusinessPartnerContact BusinessPartnerPerson Busn. Partner
KEY ValidityEndDate I_BusinessPartnerContact ValidityEndDate ValidTo
BusinessPartnerUUID I_BusinessPartnerContact PartnerUUID
PersonUUID I_BusinessPartnerContact PersonUUID BP GUID
FormOfAddress I_BusinessPartnerContact FormOfAddress Title Key
FirstName I_BusinessPartnerContact FirstName First Name
LastName I_BusinessPartnerContact LastName Last Name
PhoneNumber I_BusinessPartnerContact PhoneNumber Telephone no.
MobilePhoneNumber I_BusinessPartnerContact MobilePhoneNumber Telephone
FaxNumber I_BusinessPartnerContact FaxNumber Fax Number
EmailAddress I_BusinessPartnerContact EmailAddress E-Mail Address
AddressID I_BusinessPartnerContact AddressID Ship-to address
ContactPersonDepartment I_BusinessPartnerContact ContactPersonDepartment Department
_CntctPersnDeptValueHelp I_BusinessPartnerContact _CntctPersnDeptValueHelp
_StandardAddress I_BusinessPartnerContact _StandardAddress
_BusinessPartnerCompany I_BusinessPartnerContact _BusinessPartnerCompany
_BusinessPartnerPerson I_BusinessPartnerContact _BusinessPartnerPerson

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_SAFTGenLedgerCustContacts.
-- 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.
-- SQL view name: CNOSAFTGLCUSTCS
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW C_NO_SAFTGenLedgerCustContacts AS
SELECT
  Contact.RelationshipNumber AS RelationshipNumber,
  Contact.BusinessPartnerCompany AS BusinessPartner,
  Contact.BusinessPartnerPerson AS BusinessPartnerPerson,
  Contact.ValidityEndDate AS ValidityEndDate,
  Contact.PartnerUUID AS BusinessPartnerUUID,
  Contact.PersonUUID AS PersonUUID,
  Contact.FormOfAddress AS FormOfAddress,
  Contact.FirstName AS FirstName,
  Contact.LastName AS LastName,
  Contact.PhoneNumber AS PhoneNumber,
  Contact.MobilePhoneNumber AS MobilePhoneNumber,
  Contact.FaxNumber AS FaxNumber,
  Contact.EmailAddress AS EmailAddress,
  Contact.AddressID AS AddressID,
  Contact.ContactPersonDepartment AS ContactPersonDepartment,
  Contact._CntctPersnDeptValueHelp AS _CntctPersnDeptValueHelp,
  Contact._StandardAddress AS _StandardAddress,
  Contact._BusinessPartnerCompany AS _BusinessPartnerCompany,
  Contact._BusinessPartnerPerson AS _BusinessPartnerPerson
FROM I_BusinessPartnerContact AS Contact
;

Learn More