_SALESDOCUMENTHDRNEWVALUE

25 Fields

_SALESDOCUMENTHDRNEWVALUE is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
BillingDocumentDate BillingDocumentDate 1
CompleteDeliveryIsDefined CompleteDeliveryIsDefined 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 1
DeliveryBlockReason DeliveryBlockReason 1
HeaderBillingBlockReason HeaderBillingBlockReason 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
PaymentMethod PaymentMethod 1
PricingDate PricingDate 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
ReceivingPoint ReceivingPoint 1
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDistrict SalesDistrict 1
SalesDocumentDate SalesDocumentDate 1
SalesDocumentRjcnReason SalesDocumentRjcnReason 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SDDocumentReason SDDocumentReason 1
ShippingCondition ShippingCondition 1
ShippingType ShippingType 1
TransactionCurrency TransactionCurrency 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 _SALESDOCUMENTHDRNEWVALUE (
    BILLINGDOCUMENTDATE,
    COMPLETEDELIVERYISDEFINED,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPURCHASEORDERDATE,
    DELIVERYBLOCKREASON,
    HEADERBILLINGBLOCKREASON,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    PAYMENTMETHOD,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    RECEIVINGPOINT,
    REQUESTEDDELIVERYDATE,
    SALESDISTRICT,
    SALESDOCUMENTDATE,
    SALESDOCUMENTRJCNREASON,
    SALESGROUP,
    SALESOFFICE,
    SDDOCUMENTREASON,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    TRANSACTIONCURRENCY
);

Learn More