R_PURGDOCHISTORYDELIVERYCOST

CDS View
35 Fields 1 CDS Views

Purchasing History Delivery Cost

R_PURGDOCHISTORYDELIVERYCOST is a CDS View in S/4HANA. Purchasing History Delivery Cost. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PurOrdHistoryDeliveryCost view from COMPOSITE Purchase Order History Delivery Cost

Fields (35)

KeyField CDS FieldsUsed in Views
KEY PricingProcedureCounter PricingProcedureCounter 1
KEY PricingProcedureStep PricingProcedureStep 1
KEY PurchasingDocument PurchaseOrder 1
KEY PurchasingDocumentItem PurchaseOrderItem 1
KEY PurchasingHistoryDocument PurchasingHistoryDocument 1
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem 1
KEY PurchasingHistoryDocumentType PurchasingHistoryDocumentType 1
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear 1
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionType ConditionType 1
CreatedByUser CreatedByUser 1
Currency Currency 1
DebitCreditCode DebitCreditCode 1
DocumentCurrency DocumentCurrency 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
ExchangeRateDifferenceAmount ExchangeRateDifferenceAmount 1
GRIRAcctClrgAmtInCoCodeCrcy GRIRAcctClrgAmtInCoCodeCrcy 1
GRIRAcctClrgAmtInOrdTrnsacCrcy GRIRAcctClrgAmtInOrdTrnsacCrcy 1
GRIRAcctClrgAmtInTransacCrcy GRIRAcctClrgAmtInTransacCrcy 1
InventoryValuationType InventoryValuationType 1
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency 1
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy 1
InvoiceAmtInPurOrdTransacCrcy InvoiceAmtInPurOrdTransacCrcy 1
OrderPriceUnit OrderPriceUnit 1
OrderQuantityUnit OrderQuantityUnit 1
PostingDate PostingDate 1
PurchaseOrderAmount PurchaseOrderAmount 1
PurchasingHistoryCategory PurchasingHistoryCategory 1
PurgHistDocumentCreationDate PurgHistDocumentCreationDate 1
PurgHistDocumentCreationTime PurgHistDocumentCreationTime 1
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy 1
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 1
Quantity Quantity 1
Supplier Supplier 1

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.

-- Purchasing History Delivery Cost
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURGDOCHISTORYDELIVERYCOST (
    PRICINGPROCEDURECOUNTER,
    PRICINGPROCEDURESTEP,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENTTYPE,
    PURCHASINGHISTORYDOCUMENTYEAR,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    CREATEDBYUSER,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTCURRENCY,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDIFFERENCEAMOUNT,
    GRIRACCTCLRGAMTINCOCODECRCY,
    GRIRACCTCLRGAMTINORDTRNSACCRCY,
    GRIRACCTCLRGAMTINTRANSACCRCY,
    INVENTORYVALUATIONTYPE,
    INVOICEAMOUNTINFRGNCURRENCY,
    INVOICEAMTINCOCODECRCY,
    INVOICEAMTINPURORDTRANSACCRCY,
    ORDERPRICEUNIT,
    ORDERQUANTITYUNIT,
    POSTINGDATE,
    PURCHASEORDERAMOUNT,
    PURCHASINGHISTORYCATEGORY,
    PURGHISTDOCUMENTCREATIONDATE,
    PURGHISTDOCUMENTCREATIONTIME,
    PURORDAMOUNTINCOMPANYCODECRCY,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITY,
    SUPPLIER,
    PRIMARY KEY (PRICINGPROCEDURECOUNTER, PRICINGPROCEDURESTEP, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTITEM, PURCHASINGHISTORYDOCUMENTTYPE, PURCHASINGHISTORYDOCUMENTYEAR)
);

Learn More