SERVICEDOCUMENTITEM

SERVICEDOCUMENTITEM is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY ServiceDocument ServiceDocument 2
KEY ServiceDocumentItem ServiceDocumentItem 2
KEY ServiceDocumentItemCharUUID ServiceDocumentItemCharUUID 2
KEY ServiceObjectType ServiceObjectType 1
BillableControl BillableControl 1
DistributionChannel DistributionChannel 1
Division Division 1
OriginallyRequestedProduct OriginallyRequestedProduct 2
PostingDate PostingDate 2
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
ResponsibleEmployee ResponsibleEmployee 1
ResponsibleServiceOrganization ResponsibleServiceOrganization 2
SalesGroup SalesGroup 1
SalesGroupOrgUnitID SalesGroupOrgUnitID 1
SalesOffice SalesOffice 1
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 1
SalesOrganization SalesOrganization 1
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 1
ServiceDocItemBillingStatus ServiceDocItemBillingStatus 2
ServiceDocItemCreationDate ServiceConfItemCreationDate 1
ServiceDocItemGrossAmount ServiceDocItemGrossAmount 1
ServiceDocumentCharUUID ServiceDocumentCharUUID 1
ServiceDocumentItemDescription ServiceConfItemDescription 1
ServiceDocumentItemObjectType ServiceDocumentItemObjectType 2
ServiceDocumentItemStatus ServiceDocumentItemStatus 2
ServiceDocumentItemUUID ServiceDocumentItemUUID 1
ServiceDocumentType ServiceDocumentType 2
ServiceDocumentUUID ServiceDocumentUUID 1
ServiceOrganization ServiceOrganization 1
ServiceTeam ServiceTeam 2
SoldToParty SoldToParty 2
SrvcDocItmIsReleasedForBilling SrvcDocItmIsReleasedForBilling 2
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 SERVICEDOCUMENTITEM (
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTITEMCHARUUID,
    SERVICEOBJECTTYPE,
    BILLABLECONTROL,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ORIGINALLYREQUESTEDPRODUCT,
    POSTINGDATE,
    PURCHASEORDERBYCUSTOMER,
    RESPONSIBLEEMPLOYEE,
    RESPONSIBLESERVICEORGANIZATION,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICEDOCITEMBILLINGSTATUS,
    SERVICEDOCITEMCREATIONDATE,
    SERVICEDOCITEMGROSSAMOUNT,
    SERVICEDOCUMENTCHARUUID,
    SERVICEDOCUMENTITEMDESCRIPTION,
    SERVICEDOCUMENTITEMOBJECTTYPE,
    SERVICEDOCUMENTITEMSTATUS,
    SERVICEDOCUMENTITEMUUID,
    SERVICEDOCUMENTTYPE,
    SERVICEDOCUMENTUUID,
    SERVICEORGANIZATION,
    SERVICETEAM,
    SOLDTOPARTY,
    SRVCDOCITMISRELEASEDFORBILLING,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEDOCUMENTITEMCHARUUID, SERVICEOBJECTTYPE)
);