I_BR_NFAcctAsgtCrdtCtrlMessage

DDL: I_BR_NFACCTASGTCRDTCTRLMESSAGE SQL: ICRDTCTRLMSG Type: view BASIC Package: GLO_FIN_IS_BR_CRED_CTRL
13 Fields 1 Data Sources

NF Acct Assgt for Cred Ctrl Messages

I_BR_NFAcctAsgtCrdtCtrlMessage is a Basic CDS View that provides data about "NF Acct Assgt for Cred Ctrl Messages" in SAP S/4HANA. It reads from 1 data source (/tmf/d_ccnfmsg) and exposes 13 fields with key fields CompanyCode, Branch, BR_NotaFiscal, BR_NotaFiscalItem, BR_NFAccountAssignment. Part of development package GLO_FIN_IS_BR_CRED_CTRL.

Data Sources (1)

SourceAliasJoin Type
/tmf/d_ccnfmsg /tmf/d_ccnfmsg from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICRDTCTRLMSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label NF Acct Assgt for Cred Ctrl Messages view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode company_code Company Code
KEY Branch branch Repository branch
KEY BR_NotaFiscal nf_id Nota Fiscal
KEY BR_NotaFiscalItem nf_item Item Number
KEY BR_NFAccountAssignment nf_account_assignment_id NF Acct Assignmnt
KEY BR_NFAcctAsgtCreditControlMsg sequencial_messages NF Acct Assgnmnt Msg
SystemMessageType msgty Msg.Type (E,I,W..)
SystemMessageIdentification msgid Message ID
SystemMessageNumber msgno Message Number
SystemMessageVariable1 msgv1 Message variable 1
SystemMessageVariable2 msgv2 Message variable 2
SystemMessageVariable3 msgv3 Message variable 3
SystemMessageVariable4 msgv4 Message variable 4

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_BR_NFAcctAsgtCrdtCtrlMessage.
-- 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: ICRDTCTRLMSG

CREATE VIEW I_BR_NFAcctAsgtCrdtCtrlMessage AS
SELECT
  company_code AS CompanyCode,
  Branch,
  nf_id AS BR_NotaFiscal,
  nf_item AS BR_NotaFiscalItem,
  nf_account_assignment_id AS BR_NFAccountAssignment,
  sequencial_messages AS BR_NFAcctAsgtCreditControlMsg,
  msgty AS SystemMessageType,
  msgid AS SystemMessageIdentification,
  msgno AS SystemMessageNumber,
  msgv1 AS SystemMessageVariable1,
  msgv2 AS SystemMessageVariable2,
  msgv3 AS SystemMessageVariable3,
  msgv4 AS SystemMessageVariable4
FROM /tmf/d_ccnfmsg
;

Learn More