R_PURGDOCHISTDELIVERYCOSTBSC

CDS View
31 Fields 1 CDS Views

History per Purchasing Delivery Cost

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PurgDocHistoryDeliveryCost view from COMPOSITE Purchasing History Delivery Cost

Fields (31)

KeyField CDS FieldsUsed in Views
KEY PricingProcedureCounter PricingProcedureCounter 1
KEY PricingProcedureStep PricingProcedureStep 1
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
KEY PurchasingHistoryDocument PurchasingHistoryDocument 1
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem 1
KEY PurchasingHistoryDocumentType PurchasingHistoryDocumentType 1
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear 1
ConditionType ConditionType 1
CreatedByUser CreatedByUser 1
Currency Currency 1
DebitCreditCode DebitCreditCode 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
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.

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

Learn More