P_SupInvToAccDoc

DDL: P_SUPINVTOACCDOC SQL: PSUPINVACCDOC Type: view CONSUMPTION

Supplier Invoice to Accounting Document

P_SupInvToAccDoc is a Consumption CDS View that provides data about "Supplier Invoice to Accounting Document" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoice) and exposes 3 fields with key fields SupplierInvoice, FiscalYear.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoice I_SupplierInvoice from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSUPINVACCDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Supplier Invoice to Accounting Document view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice
KEY FiscalYear FiscalYear
SupplierInvoiceWthnFiscalYear 
@AbapCatalog.sqlViewName: 'PSUPINVACCDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Supplier Invoice to Accounting Document'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #S,
   usageType.dataClass: #MIXED
}
define view P_SupInvToAccDoc as 
select from I_SupplierInvoice 
{
    key SupplierInvoice,
    key FiscalYear,
        cast( concat(I_SupplierInvoice.SupplierInvoice , I_SupplierInvoice.FiscalYear) as fxu_sit_belnr_gjahr )       
          as SupplierInvoiceWthnFiscalYear,
        case
          when ( I_SupplierInvoice.CashDiscount1Days > 0 and I_SupplierInvoice.CashDiscount1Percent > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.CashDiscount1Days), 'NULL')
          when ( I_SupplierInvoice.CashDiscount1Days > 0 and I_SupplierInvoice.CashDiscount1Percent > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.CashDiscount1Percent), 'NULL')
          else cast( '00000000' as dats)
        end as EarliestCashDiscountDate,
        cast(case
          when ( I_SupplierInvoice.CashDiscount1Days > 0 and I_SupplierInvoice.CashDiscount1Percent > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.CashDiscount1Days), 'NULL')          
          else cast( '00000000' as dats)
        end as sk1dt) as CashDiscount1DueDate,
        cast(case          
          when ( I_SupplierInvoice.CashDiscount2Days > 0 and I_SupplierInvoice.CashDiscount1Percent > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.CashDiscount2Days), 'NULL')
          else cast( '00000000' as dats)
        end as sk2dt) as CashDiscount2DueDate,
        cast(case
          when ( I_SupplierInvoice.NetPaymentDays > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.NetPaymentDays), 'NULL')
          when ( I_SupplierInvoice.CashDiscount2Days > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.CashDiscount2Days), 'NULL')
          when ( I_SupplierInvoice.CashDiscount1Days > 0 and I_SupplierInvoice.DueCalculationBaseDate is not null and I_SupplierInvoice.DueCalculationBaseDate <> '00000000' and I_SupplierInvoice.DueCalculationBaseDate <> '' )
            then DATS_ADD_DAYS(I_SupplierInvoice.DueCalculationBaseDate, ceil(I_SupplierInvoice.CashDiscount1Days), 'NULL')            
          else DueCalculationBaseDate
        end as faedt_fpos) as NetDueDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIERINVOICE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More