I_SUPPLIERINVOICEITEMPURORDREF

CDS View
50 Fields 32 CDS Views

Supplier Invoice Item Purchase Order Reference

I_SUPPLIERINVOICEITEMPURORDREF is a CDS View in S/4HANA. Supplier Invoice Item Purchase Order Reference. It contains 50 fields. 32 CDS views read from this table.

CDS Views using this table (32)

ViewTypeJoinVDMDescription
A_SuplrInvcItemPurOrdRef view from CONSUMPTION Item with Purchase Order Reference
C_BSOrdItmProcFlwSuplrInvc view from CONSUMPTION SuplrInvcItmPurgDocRef Attrib BSOrdPrgrs
C_GRIRSupplierInvoiceItem view from CONSUMPTION GR/IR Supplier Invoice Item
C_InvcBfrPurgDocument view from CONSUMPTION Invoices created before PO
C_PurchaserValueHelp view inner CONSUMPTION Purchaser Value Help
C_SuplInvPurOrdRef view inner CONSUMPTION Supplier Invoice
I_CFinSupplierInvoiceItem view union_all COMPOSITE Central Finance Supplier Invoice: Item
I_MpProcHistoryInvoiceStatus view inner BASIC Procurement History Invoice Status
I_PT_SAFTSelfBillgSuplrInvcItm view inner COMPOSITE SAF-T PT Self-Billing SupplierInv Item
I_PT_SelfBillgCustAddrVers view inner COMPOSITE PT Self-Billing CustAddr Version
I_PT_SelfBillgMatlVers view inner COMPOSITE PT Self-Billing Material Version
I_SAFTSuplrInvcTotals view from COMPOSITE SAF-T Supplier Invoice Totals
I_SuplrInvcItemPurOrdRefAPI01 view from COMPOSITE Purchase Order Ref of Supplier Invoice
P_AU_PurchaseHistory view_entity inner COMPOSITE
P_AU_StRpPTRMultiplePOPerInvc view_entity from COMPOSITE
P_HU_MM_AuditReport view left_outer COMPOSITE
P_InvoicesCreatedBeforePO view inner CONSUMPTION
P_InvoicesCreatedBeforePO1 view inner CONSUMPTION
P_MstrProjSupplierInvoice view from BASIC
P_RU_GtdFromPOMM34 view inner COMPOSITE
P_RU_GtdFromPOMM7 view left_outer COMPOSITE
P_RU_GtdFromPOMM7N view left_outer COMPOSITE
P_RU_GtdFromPOMM9N view inner COMPOSITE
P_RU_MaterialReceiptDateMM6 view left_outer COMPOSITE
P_RU_SuplrInvcLogsItem view from CONSUMPTION
P_SuplrInvcBlockedItemReason view from CONSUMPTION
P_SuplrInvcBlockedItemReason view union_all CONSUMPTION
P_SuplrInvcBlockedItemReason1 view from CONSUMPTION
P_SuplrInvcItmAcctgDocBlkdRsn view left_outer CONSUMPTION
P_SuplrInvcItmOvw view from CONSUMPTION Overview of Supplier Invoice Items
P_SupplierInvoiceBlockedItem1 view from CONSUMPTION
P_SupplierInvoiceItemPurOrdRef view from BASIC

Fields (50)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear,SupplierInvoiceFiscalYear 10
KEY PurchaseOrder PurchaseOrder 8
KEY PurchaseOrderItem PurchaseOrderItem 6
KEY PurchaseOrderItemMaterial Material,PurchaseOrderItemMaterial 4
KEY SuplrInvcPurgDocItmCompanyCode SuplrInvcPurgDocItmCompanyCode 2
KEY SupplierInvoice SupplierInvoice 11
KEY SupplierInvoiceItem SupplierInvoiceItem 6
_Currency _Currency 1
DebitCreditCode DebitCreditCode 2
DocumentCurrency DocumentCurrency,TransactionCurrency 3
FreightSupplier FreightSupplier 2
IsFinallyInvoiced IsFinallyInvoiced 1
IsNotCashDiscountLiable IsNotCashDiscountLiable 2
IsSubsequentDebitCredit IsSubsequentDebitCredit 2
NL_ChainLbltyCnstrctnSiteDesc NL_ChainLbltyCnstrctnSiteDesc 1
NL_ChainLiabilityDescription NL_ChainLiabilityDescription 1
NL_ChainLiabilityDuration NL_ChainLiabilityDuration 1
NL_ChainLiabilityEndDate NL_ChainLiabilityEndDate 1
NL_ChainLiabilityPercent NL_ChainLiabilityPercent 1
NL_ChainLiabilityStartDate NL_ChainLiabilityStartDate 1
Plant Plant,ProductionPlant 5
ProductType ProductType 1
PurchaseOrderPriceUnit PurchaseOrderPriceUnit,PurchaseOrderPriceUnitSAPCode 2
PurchaseOrderQuantityUnit PurchaseOrderQtyUnitSAPCode,PurchaseOrderQuantityUnit 5
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 3
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 2
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit 5
ReferenceDocument ReferenceDocument 6
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 6
ReferenceDocumentItem ReferenceDocumentItem 4
RetentionAmountInDocCurrency RetentionAmountInDocCurrency 1
RetentionDueDate RetentionDueDate 1
RetentionPercentage RetentionPercentage 1
StockUnit StockUnit 1
SuplrInvcDeliveryCostCndnCount SuplrInvcDeliveryCostCndnCount 2
SuplrInvcDeliveryCostCndnStep SuplrInvcDeliveryCostCndnStep 2
SuplrInvcDeliveryCostCndnType SuplrInvcDeliveryCostCndnType 2
SuplrInvcItemHasAmountOutsdTol SuplrInvcItemHasAmountOutsdTol 2
SuplrInvcItemHasDateVariance SuplrInvcItemHasDateVariance 2
SuplrInvcItemHasOrdPrcQtyVarc SuplrInvcItemHasOrdPrcQtyVarc 2
SuplrInvcItemHasOtherVariance SuplrInvcItemHasOtherVariance 2
SuplrInvcItemHasPriceVariance SuplrInvcItemHasPriceVariance 2
SuplrInvcItemHasQtyVariance SuplrInvcItemHasQtyVariance 2
SuplrInvcItmHasQualityVariance SuplrInvcItmHasQualityVariance 2
SuplrInvcItmUnplndDelivCost SuplrInvcItmUnplndDelivCost 1
SupplierInvoiceItemAmount AmountInTransactionCurrency,NetAmount,SupplierInvoiceItemAmount 4
SupplierInvoiceItemText SupplierInvoiceItemText 3
TaxCode TaxCode 4
TaxCountry TaxCountry 1
TaxJurisdiction TaxJurisdiction 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Supplier Invoice Item Purchase Order Reference
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPPLIERINVOICEITEMPURORDREF (
    FISCALYEAR,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERITEMMATERIAL,
    SUPLRINVCPURGDOCITMCOMPANYCODE,
    SUPPLIERINVOICE,
    SUPPLIERINVOICEITEM,
    _CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTCURRENCY,
    FREIGHTSUPPLIER,
    ISFINALLYINVOICED,
    ISNOTCASHDISCOUNTLIABLE,
    ISSUBSEQUENTDEBITCREDIT,
    NL_CHAINLBLTYCNSTRCTNSITEDESC,
    NL_CHAINLIABILITYDESCRIPTION,
    NL_CHAINLIABILITYDURATION,
    NL_CHAINLIABILITYENDDATE,
    NL_CHAINLIABILITYPERCENT,
    NL_CHAINLIABILITYSTARTDATE,
    PLANT,
    PRODUCTTYPE,
    PURCHASEORDERPRICEUNIT,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENTITEMCATEGORY,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITYINPURCHASEORDERUNIT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    RETENTIONAMOUNTINDOCCURRENCY,
    RETENTIONDUEDATE,
    RETENTIONPERCENTAGE,
    STOCKUNIT,
    SUPLRINVCDELIVERYCOSTCNDNCOUNT,
    SUPLRINVCDELIVERYCOSTCNDNSTEP,
    SUPLRINVCDELIVERYCOSTCNDNTYPE,
    SUPLRINVCITEMHASAMOUNTOUTSDTOL,
    SUPLRINVCITEMHASDATEVARIANCE,
    SUPLRINVCITEMHASORDPRCQTYVARC,
    SUPLRINVCITEMHASOTHERVARIANCE,
    SUPLRINVCITEMHASPRICEVARIANCE,
    SUPLRINVCITEMHASQTYVARIANCE,
    SUPLRINVCITMHASQUALITYVARIANCE,
    SUPLRINVCITMUNPLNDDELIVCOST,
    SUPPLIERINVOICEITEMAMOUNT,
    SUPPLIERINVOICEITEMTEXT,
    TAXCODE,
    TAXCOUNTRY,
    TAXJURISDICTION,
    PRIMARY KEY (FISCALYEAR, PURCHASEORDER, PURCHASEORDERITEM, PURCHASEORDERITEMMATERIAL, SUPLRINVCPURGDOCITMCOMPANYCODE, SUPPLIERINVOICE, SUPPLIERINVOICEITEM)
);

Learn More