SCHEDULINGAGREEMENTITEM

27 Fields

SCHEDULINGAGREEMENTITEM is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
KEY ScheduleLine ScheduleLine 1
KEY SchedulingAgreement SchedulingAgreement 2
KEY SchedulingAgreementItem SchedulingAgreementItem 2
AccountAssignmentCategory AccountAssignmentCategory 1
CompanyCode CompanyCode 1
DocumentCurrency DocumentCurrency 1
Material Material 1
MaterialGroup MaterialGroup 1
MaterialType MaterialType 1
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 1
NetPriceAmount NetPriceAmount 1
NetPriceQuantity NetPriceQuantity 1
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 1
OrderQuantityUnit OrderQuantityUnit 1
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 1
PartialInvoiceDistribution PartialInvoiceDistribution 1
Plant Plant 1
ProductType ProductType 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 1
StorageLocation StorageLocation 1
Supplier Supplier 1
TargetQuantity TargetQuantity 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCHEDULINGAGREEMENTITEM (
    SCHEDULELINE,
    SCHEDULINGAGREEMENT,
    SCHEDULINGAGREEMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    MATERIALTYPE,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    PARTIALINVOICEDISTRIBUTION,
    PLANT,
    PRODUCTTYPE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SCHEDULELINEDELIVERYDATE,
    STORAGELOCATION,
    SUPPLIER,
    TARGETQUANTITY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (SCHEDULELINE, SCHEDULINGAGREEMENT, SCHEDULINGAGREEMENTITEM)
);

Learn More