I_APPROCFLWRSTRCDSUPLRINVC

CDS View

Restricted Invoice

I_APPROCFLWRSTRCDSUPLRINVC is a CDS View in S/4HANA. Restricted Invoice. It contains 10 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 10 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_APProcessFlowSupplierInvoice view union_all CONSUMPTION AP Process Flow Supplier Invoice

Fields (10)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
InvoicingParty Supplier 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
PaymentBlockingReason PaymentBlockingReason 1
PostingDate PostingDate 1
SupplierInvoiceIDByInvcgParty SupplierInvoiceIDByInvcgParty 1
SupplierInvoiceStatus SupplierInvoiceStatus 1 
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IAPRESTRINV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@DataAging.noAgingRestriction: false
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Restricted Invoice'
define view I_APProcFlwRstrcdSuplrInvc
  as select from P_ITEM_ONLINE                 as online
    inner join   I_APProcFlwSuplrInvcAcctMaint as _SupplierInvoice on  online.SupplierInvoice = _SupplierInvoice.SupplierInvoice
                                                                   and online.FiscalYear      = _SupplierInvoice.FiscalYear

  association [1..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.PurchaseOrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure

{
  key online.SupplierInvoice                                         as SupplierInvoice,
  key online.FiscalYear                                              as FiscalYear,
  key online.SupplierInvoiceItem                                     as SupplierInvoiceItem,
      online.PurchaseOrder                                           as PurchaseOrder,
      online.PurchaseOrderItem                                       as PurchaseOrderItem,
      online.Plant                                                   as Plant,
      online.SupplierInvoiceItemText                                 as SupplierInvoiceItemText,
      online.PurchaseOrderItemMaterial                               as PurchaseOrderItemMaterial,
      @Semantics.unitOfMeasure: true
      online.PurchaseOrderQuantityUnit                               as PurchaseOrderQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      @DefaultAggregation: #NONE
      online.QuantityInPurchaseOrderUnit                             as QuantityInPurchaseOrderUnit,
      @Semantics.unitOfMeasure: true
      online.PurchaseOrderPriceUnit                                  as PurchaseOrderPriceUnit,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      @DefaultAggregation: #NONE
      online.QtyInPurchaseOrderPriceUnit                             as QtyInPurchaseOrderPriceUnit,
      online.SuplrInvcDeliveryCostCndnType                           as SuplrInvcDeliveryCostCndnType,
      online.SuplrInvcDeliveryCostCndnStep                           as SuplrInvcDeliveryCostCndnStep,
      online.SuplrInvcDeliveryCostCndnCount                          as SuplrInvcDeliveryCostCndnCount,
      @Semantics.currencyCode: true
      _SupplierInvoice.DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation:#NONE
      online.SupplierInvoiceItemAmount                               as SupplierInvoiceItemAmount,
      online.IsSubsequentDebitCredit                                 as IsSubsequentDebitCredit,
      online.TaxCode                                                 as TaxCode,
      online.TaxJurisdiction                                         as TaxJurisdiction,
      online.ReferenceDocument                                       as ReferenceDocument,
      online.ReferenceDocumentFiscalYear                             as ReferenceDocumentFiscalYear,
      online.ReferenceDocumentItem                                   as ReferenceDocumentItem,
      online.PurchaseContract                                        as PurchaseContract,
      online.PurchaseContractItem                                    as PurchaseContractItem,
      online.DebitCreditCode                                         as DebitCreditCode,
      online.FreightSupplier                                         as FreightSupplier,
      online.IsNotCashDiscountLiable                                 as IsNotCashDiscountLiable,
      online.PurchasingDocumentItemCategory                          as PurchasingDocumentItemCategory,

      //Blocking Reasons

      online.SuplrInvcItemHasPriceVariance                           as SuplrInvcItemHasPriceVariance,
      online.SuplrInvcItemHasQtyVariance                             as SuplrInvcItemHasQtyVariance,
      online.SuplrInvcItemHasDateVariance                            as SuplrInvcItemHasDateVariance,
      online.SuplrInvcItemHasOrdPrcQtyVarc                           as SuplrInvcItemHasOrdPrcQtyVarc,
      online.SuplrInvcItemHasOtherVariance                           as SuplrInvcItemHasOtherVariance,
      online.SuplrInvcItemHasAmountOutsdTol                          as SuplrInvcItemHasAmountOutsdTol,
      online.SuplrInvcItmHasQualityVariance                          as SuplrInvcItmHasQualityVariance,

      _SupplierInvoice.InvoicingParty,
      @Semantics.businessDate.at: true
      _SupplierInvoice.PostingDate,
      @Semantics.businessDate.at: true
      cast( _SupplierInvoice.DocumentDate as invdt  preserving type) as DocumentDate,
      _SupplierInvoice.PaymentBlockingReason,
      _SupplierInvoice.SupplierInvoiceIDByInvcgParty,
      _SupplierInvoice.IsInvoice,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation:#NONE
      _SupplierInvoice.InvoiceGrossAmount,
      @Semantics.user.createdBy: true
      _SupplierInvoice.CreatedByUser,
      _SupplierInvoice.SupplierInvoiceStatus,
      _SupplierInvoice.IsEndOfPurposeBlocked,

      @ObjectModel.foreignKey.association: '_CompanyCode'
      _SupplierInvoice.CompanyCode,

      //Associations

      _Currency,
      _CompanyCode,
      _UnitOfMeasure,
      _Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_APPROCFLWSUPLRINVCACCTMAINT",
"P_ITEM_ONLINE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_SUPPLIER",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_APPROCFLWSUPLRINVCACCTMAINT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More