C_NL_SAFTBasicElmntMasterData

DDL: C_NL_SAFTBASICELMNTMASTERDATA SQL: CNLBASICSELMNTMD Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_NL

SAF-T NL Basics Elements Master Data

C_NL_SAFTBasicElmntMasterData is a Consumption CDS View that provides data about "SAF-T NL Basics Elements Master Data" in SAP S/4HANA. It reads from 3 data sources (I_AccountingDocumentTypeText, I_SAFTJournalCode, I_SAFTJournalCode) and exposes 9 fields with key fields CompanyCode, NL_BasicElementMasterDataKey, NL_BasicElementMasterDataType, NL_BasicElementMasterDataKey, NL_BasicElementMasterDataType. Part of development package GLO_FIN_IS_SAFT_NL.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_AccountingDocumentTypeText DocTypeText inner
I_SAFTJournalCode I_SAFTJournalCode from
I_SAFTJournalCode I_SAFTJournalCode union

Parameters (4)

NameTypeDefault
P_CompanyCode bukrs
P_StartDate dats
P_EndDate dats
P_Ledger fins_ledger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CNLBASICSELMNTMD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T NL Basics Elements Master Data view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY NL_BasicElementMasterDataKey CostCenter
KEY NL_BasicElementMasterDataType
P_StartDate
P_EndDate
CompanyCodeasCompanyCode
KEY NL_BasicElementMasterDataKey
KEY NL_BasicElementMasterDataType
NL_BasicElementMasterDataDesc I_AccountingDocumentTypeText AccountingDocumentTypeName 
@AbapCatalog.sqlViewName: 'CNLBASICSELMNTMD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAF-T NL Basics Elements Master Data'
@Consumption.dbHints: [ 'USE_HEX_PLAN', 'NO_SUBPLAN_SHARING' ]
define view C_NL_SAFTBasicElmntMasterData
  with parameters
    P_CompanyCode : bukrs,
    P_StartDate   : dats,
    P_EndDate     : dats,
    P_Ledger      : fins_ledger

  as select distinct from I_SAFTCostCenter
{
  key CompanyCode                        as CompanyCode,
  key CostCenter                         as NL_BasicElementMasterDataKey,
  key '02'                               as NL_BasicElementMasterDataType,

      max( _Text.CostCenterDescription ) as NL_BasicElementMasterDataDesc

}
where
      CompanyCode                                            = $parameters.P_CompanyCode
  and ValidityEndDate                                        >= $parameters.P_EndDate
  and _Text[1: Language = $session.system_language].Language = $session.system_language
group by
  CompanyCode,
  CostCenter

union

select from  I_SAFTJournalCode( P_StartDate:$parameters.P_StartDate ,
                                P_EndDate: $parameters.P_EndDate,
                                P_Ledger:$parameters.P_Ledger) as JournalItem
  inner join I_AccountingDocumentTypeText                      as DocTypeText on  DocTypeText.AccountingDocumentType = JournalItem.AccountingDocumentType
                                                                              and DocTypeText.Language               = $session.system_language

{
  key JournalItem.CompanyCode                                     as CompanyCode,
  key cast( JournalItem.AccountingDocumentType as abap.char(10) ) as NL_BasicElementMasterDataKey,
  key '12'                                                        as NL_BasicElementMasterDataType,

      DocTypeText.AccountingDocumentTypeName                      as NL_BasicElementMasterDataDesc

}
where
  JournalItem.CompanyCode = $parameters.P_CompanyCode

Learn More