I_SUPPLIERINVOICEAPI01
Supplier Invoice
I_SUPPLIERINVOICEAPI01 is a CDS View in S/4HANA. Supplier Invoice. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_SupplierInvoiceDEX | view | from | CONSUMPTION | Data Extraction for Supplier Invoice |
| I_SuplrInvcHeaderWhldgTaxAPI01 | view | inner | BASIC | Withholding Tax for Supplier Invoice |
| I_SuplrInvcItemPurOrdRefAPI01 | view | inner | BASIC | Purchase Order Ref of Supplier Invoice |
| I_SuplrInvcItmAcctAssgmtAPI01 | view | inner | BASIC | Account Assignment for Supplier Invoice |
| I_SuplrInvcStsAndOrignAPI01 | view | inner | COMPOSITE | Supplier Invoice Status and Origin |
| I_SuplrInvoiceItemGLAcctAPI01 | view | inner | BASIC | G/L Account Item of Supplier Invoice |
| I_SupplierInvoiceTaxAPI01 | view | inner | BASIC | Tax for Supplier Invoice |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISUPLRINVCAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Supplier Invoice'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE ]
@ObjectModel.modelingPattern: #NONE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
define view I_SupplierInvoiceAPI01
as select from I_SupplierInvoice
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_Currency as _Currency on $projection.DocumentCurrency = _Currency.Currency
association [1..*] to I_SuplrInvcItemPurOrdRefAPI01 as _SuplrInvcItemPurOrdRefAPI01 on $projection.SupplierInvoice = _SuplrInvcItemPurOrdRefAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvcItemPurOrdRefAPI01.FiscalYear
association [1..*] to I_SuplrInvoiceItemGLAcctAPI01 as _SuplrInvoiceItemGLAcctAPI01 on $projection.SupplierInvoice = _SuplrInvoiceItemGLAcctAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvoiceItemGLAcctAPI01.FiscalYear
association [1..*] to I_SupplierInvoiceTaxAPI01 as _SupplierInvoiceTaxAPI01 on $projection.SupplierInvoice = _SupplierInvoiceTaxAPI01.SupplierInvoice
and $projection.FiscalYear = _SupplierInvoiceTaxAPI01.FiscalYear
association [1..*] to I_SuplrInvcHeaderWhldgTaxAPI01 as _SuplrInvcHeaderWhldgTaxAPI01 on $projection.SupplierInvoice = _SuplrInvcHeaderWhldgTaxAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvcHeaderWhldgTaxAPI01.FiscalYear
association [1..*] to I_SuplrInvcSeldPurgDocAPI01 as _SuplrInvcSeldPurgDocAPI01 on $projection.SupplierInvoice = _SuplrInvcSeldPurgDocAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvcSeldPurgDocAPI01.FiscalYear
association [1..*] to I_SuplrInvcSeldDelivNoteAPI01 as _SuplrInvcSeldDelivNoteAPI01 on $projection.SupplierInvoice = _SuplrInvcSeldDelivNoteAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvcSeldDelivNoteAPI01.FiscalYear
association [1..*] to I_SuplrInvcSeldInbBOLAPI01 as _SuplrInvcSeldInbBOLAPI01 on $projection.SupplierInvoice = _SuplrInvcSeldInbBOLAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvcSeldInbBOLAPI01.FiscalYear
association [1..*] to I_SuplrInvcSeldSESLeanAPI01 as _SuplrInvcSeldSESLeanAPI01 on $projection.SupplierInvoice = _SuplrInvcSeldSESLeanAPI01.SupplierInvoice
and $projection.FiscalYear = _SuplrInvcSeldSESLeanAPI01.FiscalYear
association [0..*] to I_SupplierInvoiceBlockAPI01 as _SupplierInvoiceBlockAPI01 on $projection.SupplierInvoice = _SupplierInvoiceBlockAPI01.SupplierInvoice
and $projection.FiscalYear = _SupplierInvoiceBlockAPI01.FiscalYear
association [1..1] to E_SupplierInvoice as _HeaderExtension on $projection.SupplierInvoice = _HeaderExtension.SupplierInvoice
and $projection.FiscalYear = _HeaderExtension.FiscalYear
and I_SupplierInvoice.SupplierInvoiceUUID = _HeaderExtension.SupplierInvoiceUUID
{
//Key
key SupplierInvoice,
key FiscalYear,
//-------------------------------------------------------------------------------------------------
// General header data
//-------------------------------------------------------------------------------------------------
//For easier joins against BKPF-AWKEY
concat(SupplierInvoice , FiscalYear) as SupplierInvoiceWthnFiscalYear,
CompanyCode,
DocumentDate,
PostingDate,
SupplierInvoiceIDByInvcgParty,
InvoicingParty,
IsInvoice,
@Semantics.currencyCode: true
DocumentCurrency,
@Semantics.amount.currencyCode: 'DocumentCurrency'
InvoiceGrossAmount,
ExchangeRate,
AccountingDocumentType,
SupplierInvoiceStatus,
SupplierInvoiceOrigin,
CreatedByUser,
LastChangedByUser,
InvoiceReference,
InvoiceReferenceFiscalYear,
AssignmentReference,
TaxIsCalculatedAutomatically,
BusinessPlace,
CreationDate,
//-------------------------------------------------------------------------------------------------
//Unplanned delivery costs
//-------------------------------------------------------------------------------------------------
@Semantics.amount.currencyCode: 'DocumentCurrency'
UnplannedDeliveryCost,
UnplannedDeliveryCostTaxCode,
UnplndDelivCostTaxJurisdiction,
//-------------------------------------------------------------------------------------------------
//Texts
//-------------------------------------------------------------------------------------------------
DocumentHeaderText,
SupplierPostingLineItemText,
//-------------------------------------------------------------------------------------------------
//Payment
//-------------------------------------------------------------------------------------------------
PaymentTerms,
DueCalculationBaseDate,
CashDiscount1Percent,
CashDiscount1Days,
CashDiscount2Percent,
CashDiscount2Days,
NetPaymentDays,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ManualCashDiscount,
FixedCashDiscount,
StateCentralBankPaymentReason,
SupplyingCountry,
BPBankAccountInternalID,
PaymentMethod,
PaymentReference,
PaytSlipWthRefSubscriber,
PaytSlipWthRefCheckDigit,
PaytSlipWthRefReference,
PaymentReason,
//-------------------------------------------------------------------------------------------------
//Cancellation
//-------------------------------------------------------------------------------------------------
ReverseDocument,
ReverseDocumentFiscalYear,
//-------------------------------------------------------------------------------------------------
//Invoice reduction
//-------------------------------------------------------------------------------------------------
@Semantics.amount.currencyCode: 'DocumentCurrency'
SuplrInvcManuallyReducedAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
SuplrInvcAutomReducedAmount,
//-------------------------------------------------------------------------------------------------
// Taxes
//-------------------------------------------------------------------------------------------------
TaxDeterminationDate,
TaxReportingDate,
TaxFulfillmentDate,
TaxCountry,
UnplndDeliveryCostTaxCountry,
//-------------------------------------------------------------------------------------------------
//Tax reporting
//-------------------------------------------------------------------------------------------------
DeliveryOfGoodsReportingCntry,
SupplierVATRegistration,
IsEUTriangularDeal,
//-------------------------------------------------------------------------------------------------
// Preliminary fields (parked, held, batch)
//-------------------------------------------------------------------------------------------------
SuplrInvcDebitCrdtCodeDelivery,
SuplrInvcDebitCrdtCodeReturns,
//-------------------------------------------------------------------------------------------------
// Localization
//-------------------------------------------------------------------------------------------------
ElectronicInvoiceUUID, //Mexico
JrnlEntryCntrySpecificRef1,
JrnlEntryCntrySpecificDate1,
JrnlEntryCntrySpecificRef2,
JrnlEntryCntrySpecificDate2,
JrnlEntryCntrySpecificRef3,
JrnlEntryCntrySpecificDate3,
JrnlEntryCntrySpecificRef4,
JrnlEntryCntrySpecificDate4,
JrnlEntryCntrySpecificRef5,
JrnlEntryCntrySpecificDate5,
JrnlEntryCntrySpecificBP1,
JrnlEntryCntrySpecificBP2,
_CompanyCode,
_Currency,
_SuplrInvcItemPurOrdRefAPI01,
_SuplrInvoiceItemGLAcctAPI01,
_SupplierInvoiceTaxAPI01,
_SuplrInvcHeaderWhldgTaxAPI01,
_SuplrInvcSeldPurgDocAPI01,
_SuplrInvcSeldDelivNoteAPI01,
_SuplrInvcSeldInbBOLAPI01,
_SuplrInvcSeldSESLeanAPI01,
_SupplierInvoiceBlockAPI01
}
where
IsEndOfPurposeBlocked = ''
or IsEndOfPurposeBlocked is null