SCHEDULINGAGREEMENT

19 Fields

SCHEDULINGAGREEMENT is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode,ReceivingCompanyCode 3
KEY PurchaseRequisition PurchaseRequisition 2
KEY PurchaseRequisitionItem PurchaseRequisitionItem 2
KEY ScheduleLine ScheduleLine 2
KEY SchedulingAgreement SchedulingAgreement 4
KEY SchedulingAgreementItem SchedulingAgreementItem 4
DisplayCurrency DisplayCurrency 2
Material Material 2
MaterialGroup MaterialGroup 3
Plant Plant 2
ProductType ProductType 2
PurchaseOrderDate PurchaseOrderDate 2
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurchasingDocumentItemCategory PurchaseOrderItemCategory 2
PurchasingDocumentType PurchasingDocumentType 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
PurgDocHdrCompanyCode CompanyCode,PurgDocHdrCompanyCode 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 SCHEDULINGAGREEMENT (
    COMPANYCODE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    SCHEDULELINE,
    SCHEDULINGAGREEMENT,
    SCHEDULINGAGREEMENTITEM,
    DISPLAYCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PRODUCTTYPE,
    PURCHASEORDERDATE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCHDRCOMPANYCODE,
    SUPPLIER,
    PRIMARY KEY (COMPANYCODE, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, SCHEDULELINE, SCHEDULINGAGREEMENT, SCHEDULINGAGREEMENTITEM)
);

Learn More