LEVEL0

26 Fields

LEVEL0 is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 4
KEY PrecedingDocument PrecedingDocument 1
KEY PrecedingDocumentCategory PrecedingDocumentCategory 1
KEY PrecedingDocumentItem PrecedingDocumentItem 1
KEY SalesContract SalesContract 1
KEY SalesOrder SalesOrder 1
BillingDocumentIsCancelled BillingDocumentIsCancelled 1
BillingDocumentType BillingDocumentType 4
BusinessSolutionOrder BusinessSolutionOrder 1
CustomerReturnType CustomerReturnType 1
DistributionChannel DistributionChannel 2
OrganizationDivision OrganizationDivision 1
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 1
OverallSDProcessStatus OverallSDProcessStatus 1
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDocumentDate SalesDocumentDate 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrderCategory SalesOrderCategory 1
SalesOrderType SalesOrderType 1
SalesOrganization SalesOrganization 5
SDDocumentCategory SDDocumentCategory 5
ServiceObjectType ServiceObjectType 1
SoldToParty SoldToParty 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 LEVEL0 (
    BILLINGDOCUMENT,
    PRECEDINGDOCUMENT,
    PRECEDINGDOCUMENTCATEGORY,
    PRECEDINGDOCUMENTITEM,
    SALESCONTRACT,
    SALESORDER,
    BILLINGDOCUMENTISCANCELLED,
    BILLINGDOCUMENTTYPE,
    BUSINESSSOLUTIONORDER,
    CUSTOMERRETURNTYPE,
    DISTRIBUTIONCHANNEL,
    ORGANIZATIONDIVISION,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDDELIVERYDATE,
    SALESDOCUMENTDATE,
    SALESGROUP,
    SALESOFFICE,
    SALESORDERCATEGORY,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SERVICEOBJECTTYPE,
    SOLDTOPARTY,
    PRIMARY KEY (BILLINGDOCUMENT, PRECEDINGDOCUMENT, PRECEDINGDOCUMENTCATEGORY, PRECEDINGDOCUMENTITEM, SALESCONTRACT, SALESORDER)
);

Learn More