_SALESDOCUMENTBASIC

_SALESDOCUMENTBASIC is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
_SoldToParty _SoldToParty 1
CreationDate CreationDate 1
DistributionChannel DistributionChannel 6
FashionCancelDate FashionCancelDate 1
OrganizationDivision Division,OrganizationDivision 9
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDocument SalesDocument 2
SalesDocumentDate SalesDocumentDate 2
SalesDocumentType CustomerReturnType,OrderType,SalesDocumentType,SalesOrderWithoutChargeType 11
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 7
SDDocumentCategory SDDocumentCategory 2
SDDocumentReason SDDocumentReason 1
SoldToParty EDocCockpitSalesSoldToParty,SoldToParty 5

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 _SALESDOCUMENTBASIC (
    _SOLDTOPARTY,
    CREATIONDATE,
    DISTRIBUTIONCHANNEL,
    FASHIONCANCELDATE,
    ORGANIZATIONDIVISION,
    REQUESTEDDELIVERYDATE,
    SALESDOCUMENT,
    SALESDOCUMENTDATE,
    SALESDOCUMENTTYPE,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTREASON,
    SOLDTOPARTY
);