I_SCHEDGAGRMTHDRWITHDRAFT

CDS View
60 Fields 1 CDS Views

Scheduling Agreement Header with Draft

I_SCHEDGAGRMTHDRWITHDRAFT is a CDS View in S/4HANA. Scheduling Agreement Header with Draft. It contains 60 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_Schedgagrmthdr view from CONSUMPTION Purchase Scheduling Agreement Header

Fields (60)

KeyField CDS FieldsUsed in Views
KEY SchedulingAgreement SchedulingAgreement 1
_DocumentCurrency _DocumentCurrency 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 1
CorrespncExternalReference CorrespncExternalReference 1
CorrespncInternalReference CorrespncInternalReference 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
DocumentCurrency DocumentCurrency 1
ExchangeRateForEdit ExchangeRateForEdit 1
ExchangeRateIsFixed ExchangeRateIsFixed 1
IncotermsClassification IncotermsClassification 1
IncotermsDvtgLocDescription IncotermsDvtgLocDescription 1
IncotermsDvtgLocIdentifier IncotermsDvtgLocIdentifier 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation1Identifier IncotermsLocation1Identifier 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsLocation2Identifier IncotermsLocation2Identifier 1
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 1
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InvoicingParty InvoicingParty 1
Language Language 1
LastChangeDateTime LastChangeDateTime 1
NetPaymentDays NetPaymentDays 1
OvrlTrdCmplncLegalCtrlChkSts OvrlTrdCmplncLegalCtrlChkSts 1
OvrlTrdCmplncSnctndListChkSts OvrlTrdCmplncSnctndListChkSts 1
PaymentTerms PaymentTerms 1
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentOrderDate PurchasingDocumentOrderDate 1
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingDocumentTypeName PurchasingDocumentTypeName 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurchasingProcessingStatus PurchasingProcessingStatus 1
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 1
QuotationSubmissionDate QuotationSubmissionDate 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
SchedgAgrmtIsInPreparation SchedgAgrmtIsInPreparation 1
SchedgAgrmtOutpCtrlStatus SchedgAgrmtOutpCtrlStatus 1
SchedgAgrmtOutpCtrlStatusText SchedgAgrmtOutpCtrlStatusText 1
SchedgAgrmtOutpCtrlTime SchedgAgrmtOutpCtrlTime 1
SchedgAgrmtOutpCtrlType SchedgAgrmtOutpCtrlType 1
ScheduleAgreementHasReleaseDoc ScheduleAgreementHasReleaseDoc 1
SchedulingAgreementForEdit SchedulingAgreementForEdit 1
Supplier Supplier 1
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotationExternalID SupplierQuotationExternalID 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingSupplier SupplyingSupplier 1
TargetAmount TargetAmount 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.

-- Scheduling Agreement Header with Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SCHEDGAGRMTHDRWITHDRAFT (
    SCHEDULINGAGREEMENT,
    _DOCUMENTCURRENCY,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    EXCHANGERATEFOREDIT,
    EXCHANGERATEISFIXED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSDVTGLOCDESCRIPTION,
    INCOTERMSDVTGLOCIDENTIFIER,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION1IDENTIFIER,
    INCOTERMSLOCATION2,
    INCOTERMSLOCATION2IDENTIFIER,
    INCOTERMSSUPCHNDVTGLOCADDLUUID,
    INCOTERMSSUPCHNLOC1ADDLUUID,
    INCOTERMSSUPCHNLOC2ADDLUUID,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    LANGUAGE,
    LASTCHANGEDATETIME,
    NETPAYMENTDAYS,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    OVRLTRDCMPLNCSNCTNDLISTCHKSTS,
    PAYMENTTERMS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGDOCUMENTTYPENAME,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURGAGGRGDPRODCMPLNCSUPLRSTS,
    QUOTATIONSUBMISSIONDATE,
    RELEASEISNOTCOMPLETED,
    SCHEDGAGRMTISINPREPARATION,
    SCHEDGAGRMTOUTPCTRLSTATUS,
    SCHEDGAGRMTOUTPCTRLSTATUSTEXT,
    SCHEDGAGRMTOUTPCTRLTIME,
    SCHEDGAGRMTOUTPCTRLTYPE,
    SCHEDULEAGREEMENTHASRELEASEDOC,
    SCHEDULINGAGREEMENTFOREDIT,
    SUPPLIER,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATIONEXTERNALID,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGSUPPLIER,
    TARGETAMOUNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (SCHEDULINGAGREEMENT)
);

Learn More