P_RU_OneTimeAcctData1

DDL: P_RU_ONETIMEACCTDATA1 SQL: PRUONETIMEACCT1 Type: view CONSUMPTION

P_RU_OneTimeAcctData1 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_OneTimeAccountBP) and exposes 12 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_OneTimeAccountBP I_OneTimeAccountBP from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUONETIMEACCT1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
BusinessPartnerName1 BusinessPartnerName1
BusinessPartnerName2 BusinessPartnerName2
BusinessPartnerName3 BusinessPartnerName3
BusinessPartnerName4 BusinessPartnerName4
AddressID AddressID
TaxID1 TaxID1
TaxID3 TaxID3
IsNaturalPerson IsNaturalPerson 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUONETIMEACCT1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_OneTimeAcctData1
  as select from I_OneTimeAccountBP

{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key AccountingDocumentItem,
      BusinessPartnerName1,
      BusinessPartnerName2,
      BusinessPartnerName3,
      BusinessPartnerName4,
      concat_with_space(concat_with_space(BusinessPartnerName1, BusinessPartnerName2, 1),
                        concat_with_space(BusinessPartnerName3, BusinessPartnerName4, 1),
                        1)                                                                     as BusinessPartnerFullName,
      AddressID,
      TaxID1,
      TaxID3,
      cast( case length( TaxID1 )
                when 12 then ''
                else         'X'
      end                                                           as firu_is_bp_org )        as BPIsOrganization,

      cast( case length( TaxID1 )
                when 12 then ''
                else         TaxID1
            end                                                     as firu_partner_inn )      as RU_PartnerOrganizationINN,
      cast( case length( TaxID1 )
                when 12 then ''
                else         TaxID3
            end                                                     as firu_partner_inn )      as RU_PartnerOrganizationKPP,
      cast( case length( TaxID1 )
                when 12 then TaxID1
                else         ''
            end                                                     as firu_partner_pers_inn ) as RU_PartnerPersonINN,

      IsNaturalPerson
}

Learn More