FUTURESPEND

FUTURESPEND is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition PurchaseRequisition 2
KEY PurchaseRequisitionItem PurchaseRequisitionItem 2
CompanyCode CompanyCode,PurgDocHdrCompanyCode,ReceivingCompanyCode 2
DisplayCurrency DisplayCurrency 2
ExpectedSpend PurRequisitionExpectedSpend 2
Material Material 2
MaterialGroup MaterialGroup 2
Plant Plant 2
PurchaseRequisitionReleaseDate PurchaseOrderDate 2
PurchaseRequisitionType PurchasingDocumentType 2
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurchasingDocumentItemCategory PurchaseOrderItemCategory 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
Supplier Supplier 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FUTURESPEND (
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    COMPANYCODE,
    DISPLAYCURRENCY,
    EXPECTEDSPEND,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PURCHASEREQUISITIONRELEASEDATE,
    PURCHASEREQUISITIONTYPE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);