_SERVICEDOCITEM
_SERVICEDOCITEM is an SAP database table in S/4HANA. It contains 116 fields.
Fields (116)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ServiceDocumentItem | ServiceDocumentItem | 1 |
| _BillToParty | _BillToParty | 1 | |
| _ContactPerson | _ContactPerson | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _Division | _Division | 1 | |
| _PayerParty | _PayerParty | 1 | |
| _PaymentMethod | _PaymentMethod | 1 | |
| _PaymentTerms | _PaymentTerms | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _RespEmployee | _RespEmployee | 1 | |
| _ResponseProfile | _ResponseProfile | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _ServiceDocItemBillingStatus | _ServiceDocItemBillingStatus | 1 | |
| _ServiceDocItemCategory | _ServiceDocItemCategory | 1 | |
| _ServiceDocItemHasError | _ServiceDocItemHasError | 1 | |
| _ServiceDocItemPriority | _ServiceDocItemPriority | 1 | |
| _ServiceDocItemStatus | _ServiceDocItemStatus | 1 | |
| _ServiceDocItmPrdcssr_2 | _ServiceDocItmPrdcssr_2 | 1 | |
| _ServiceDocOvertimeCat | _ServiceDocOvertimeCat | 1 | |
| _ServiceEmployee | _ServiceEmployee | 1 | |
| _ServiceProfile | _ServiceProfile | 1 | |
| _ServiceTeam | _ServiceTeam | 1 | |
| _ShipToParty | _ShipToParty | 1 | |
| _SoldToParty | _SoldToParty | 1 | |
| _SrvcDocExecutionStatus | _SrvcDocExecutionStatus | 1 | |
| _SrvcDocItemCreditStatus | _SrvcDocItemCreditStatus | 1 | |
| _SrvcDocItemIsRelForBillgSts | _SrvcDocItemIsRelForBillgSts | 1 | |
| _SrvcDocItemTransferStatus | _SrvcDocItemTransferStatus | 1 | |
| _SrvcDocItmBslnCostPostgStat | _SrvcDocItmBslnCostPostgStat | 1 | |
| _SrvcDocItmContinuousCostStat | _SrvcDocItmContinuousCostStat | 1 | |
| _SrvcSEPAMandateRelevance | _SrvcSEPAMandateRelevance | 1 | |
| ActualServiceDuration | ActualServiceDuration | 1 | |
| ActualServiceDurationUnit | ActualServiceDurationUnit | 1 | |
| ActualServiceStartDateTime | ActualServiceStartDateTime | 1 | |
| BillableControl | BillableControl | 1 | |
| BillingDateTime | BillingDateTime | 1 | |
| BillingPlanTimeZone | BillingPlanTimeZone | 1 | |
| BillingPriceSourceName | BillingPriceSourceName | 1 | |
| BillToParty | BillToParty | 1 | |
| ContactPerson | ContactPerson | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CumulativeConfirmedQuantity | SrvcOrdItemReservedQuantity | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Division | Division | 1 | |
| DocumentDescription | DocumentDescription | 1 | |
| OriginallyRequestedProduct | OriginallyRequestedProduct | 1 | |
| ParentServiceDocumentItemUUID | ParentServiceDocumentItemUUID | 1 | |
| PayerParty | PayerParty | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PaymentTerms | PaymentTerms | 1 | |
| PlannedServiceEndDateTime | PlannedServiceEndDateTime | 1 | |
| PlannedServiceStartDateTime | PlannedServiceStartDateTime | 1 | |
| PostingDate | PostingDate | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProfitCenterDeterminationDate | ProfitCenterDeterminationDate | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 1 | |
| RequestedServiceEndDateTime | RequestedServiceEndDateTime | 1 | |
| RequestedServiceStartDateTime | RequestedServiceStartDateTime | 1 | |
| ResponseProfile | ResponseProfile | 1 | |
| ResponsibleEmployee | ResponsibleEmployee | 1 | |
| ResponsibleServiceOrganization | ResponsibleServiceOrganization | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesGroupOrgUnitID | SalesGroupOrgUnitID | 1 | |
| SalesOffice | SalesOffice | 1 | |
| SalesOfficeOrgUnitID | SalesOfficeOrgUnitID | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| SalesOrganizationOrgUnitID | SalesOrganizationOrgUnitID | 1 | |
| SEPAMandate | SEPAMandate | 1 | |
| ServiceDocItemBillingStatus | ServiceDocItemBillingStatus | 1 | |
| ServiceDocItemCategory | ServiceDocItemCategory | 1 | |
| ServiceDocItemChangedByUser | ServiceDocItemChangedByUser | 1 | |
| ServiceDocItemChangedDateTime | ServiceDocItemChangedDateTime | 1 | |
| ServiceDocItemCreatedByUser | ServiceDocItemCreatedByUser | 1 | |
| ServiceDocItemCreationDateTime | ServiceDocItemCreationDateTime | 1 | |
| ServiceDocItemGrossAmount | ServiceDocItemGrossAmount | 1 | |
| ServiceDocItemQuantityUnit | ServiceDocItemQuantityUnit | 1 | |
| ServiceDocItemRejectionReason | ServiceDocItemRejectionReason | 1 | |
| ServiceDocumentItemCharUUID | ServiceDocumentItemCharUUID | 1 | |
| ServiceDocumentItemDescription | ServiceDocumentItemDescription | 1 | |
| ServiceDocumentItemHasError | ServiceDocumentItemHasError | 1 | |
| ServiceDocumentItemIsOpen | ServiceDocumentItemIsOpen | 1 | |
| ServiceDocumentItemIsQuotation | ServiceDocumentItemIsQuotation | 1 | |
| ServiceDocumentItemIsReleased | ServiceDocumentItemIsReleased | 1 | |
| ServiceDocumentItemNetAmount | ServiceDocumentItemNetAmount | 1 | |
| ServiceDocumentItemObjectType | ServiceDocumentItemObjectType | 1 | |
| ServiceDocumentItemPriority | ServiceDocumentItemPriority | 1 | |
| ServiceDocumentItemQuantity | ServiceDocumentItemQuantity | 1 | |
| ServiceDocumentItemStatus | ServiceDocumentItemStatus | 1 | |
| ServiceDocumentItemUUID | ServiceDocumentItemUUID | 1 | |
| ServiceDocumentType | ServiceDocumentType | 4 | |
| ServiceDuration | ServiceDuration | 1 | |
| ServiceDurationUnit | ServiceDurationUnit | 1 | |
| ServiceEmployee | ServiceEmployee | 1 | |
| ServiceFirstResponseByDateTime | ServiceFirstResponseByDateTime | 1 | |
| ServiceOrganization | ServiceOrganization | 1 | |
| ServiceProfile | ServiceProfile | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ServiceTeam | ServiceTeam | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldToParty | SoldToParty | 1 | |
| SoldToPartyCountry | SoldToPartyCountry | 1 | |
| SoldToPartyRegion | SoldToPartyRegion | 1 | |
| SrvcDocItemCreditStatus | SrvcOrdItemCreditStatus | 1 | |
| SrvcDocItemExecutionStatus | SrvcOrdItemExecutionStatus | 1 | |
| SrvcDocItemIsUnplanned | SrvcOrdItemIsUnplanned | 1 | |
| SrvcDocItemSLADueByDateTime | SrvcDocItemSLADueByDateTime | 1 | |
| SrvcDocItemTransferStatus | SrvcDocItemTransferStatus | 1 | |
| SrvcDocItmBslnCostPostgStatus | SrvcDocItmBslnCostPostgStatus | 1 | |
| SrvcDocItmContinuousCostStatus | SrvcDocItmContinuousCostStatus | 1 | |
| SrvcDocItmIsReleasedForBilling | SrvcDocItmIsReleasedForBilling | 1 | |
| SrvcSEPAMandateRelevance | SrvcSEPAMandateRelevance | 1 | |
| TimeSheetOvertimeCategory | TimeSheetOvertimeCategory | 1 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| WBSElementInternalID | WBSElementInternalID | 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 _SERVICEDOCITEM (
SERVICEDOCUMENTITEM,
_BILLTOPARTY,
_CONTACTPERSON,
_DISTRIBUTIONCHANNEL,
_DIVISION,
_PAYERPARTY,
_PAYMENTMETHOD,
_PAYMENTTERMS,
_PROFITCENTER,
_RESPEMPLOYEE,
_RESPONSEPROFILE,
_SALESGROUP,
_SALESOFFICE,
_SALESORGANIZATION,
_SERVICEDOCITEMBILLINGSTATUS,
_SERVICEDOCITEMCATEGORY,
_SERVICEDOCITEMHASERROR,
_SERVICEDOCITEMPRIORITY,
_SERVICEDOCITEMSTATUS,
_SERVICEDOCITMPRDCSSR_2,
_SERVICEDOCOVERTIMECAT,
_SERVICEEMPLOYEE,
_SERVICEPROFILE,
_SERVICETEAM,
_SHIPTOPARTY,
_SOLDTOPARTY,
_SRVCDOCEXECUTIONSTATUS,
_SRVCDOCITEMCREDITSTATUS,
_SRVCDOCITEMISRELFORBILLGSTS,
_SRVCDOCITEMTRANSFERSTATUS,
_SRVCDOCITMBSLNCOSTPOSTGSTAT,
_SRVCDOCITMCONTINUOUSCOSTSTAT,
_SRVCSEPAMANDATERELEVANCE,
ACTUALSERVICEDURATION,
ACTUALSERVICEDURATIONUNIT,
ACTUALSERVICESTARTDATETIME,
BILLABLECONTROL,
BILLINGDATETIME,
BILLINGPLANTIMEZONE,
BILLINGPRICESOURCENAME,
BILLTOPARTY,
CONTACTPERSON,
CONTROLLINGAREA,
CUMULATIVECONFIRMEDQUANTITY,
DISTRIBUTIONCHANNEL,
DIVISION,
DOCUMENTDESCRIPTION,
ORIGINALLYREQUESTEDPRODUCT,
PARENTSERVICEDOCUMENTITEMUUID,
PAYERPARTY,
PAYMENTMETHOD,
PAYMENTTERMS,
PLANNEDSERVICEENDDATETIME,
PLANNEDSERVICESTARTDATETIME,
POSTINGDATE,
PROFITCENTER,
PROFITCENTERDETERMINATIONDATE,
PURCHASEORDERBYCUSTOMER,
REQUESTEDSERVICEENDDATETIME,
REQUESTEDSERVICESTARTDATETIME,
RESPONSEPROFILE,
RESPONSIBLEEMPLOYEE,
RESPONSIBLESERVICEORGANIZATION,
SALESGROUP,
SALESGROUPORGUNITID,
SALESOFFICE,
SALESOFFICEORGUNITID,
SALESORGANIZATION,
SALESORGANIZATIONORGUNITID,
SEPAMANDATE,
SERVICEDOCITEMBILLINGSTATUS,
SERVICEDOCITEMCATEGORY,
SERVICEDOCITEMCHANGEDBYUSER,
SERVICEDOCITEMCHANGEDDATETIME,
SERVICEDOCITEMCREATEDBYUSER,
SERVICEDOCITEMCREATIONDATETIME,
SERVICEDOCITEMGROSSAMOUNT,
SERVICEDOCITEMQUANTITYUNIT,
SERVICEDOCITEMREJECTIONREASON,
SERVICEDOCUMENTITEMCHARUUID,
SERVICEDOCUMENTITEMDESCRIPTION,
SERVICEDOCUMENTITEMHASERROR,
SERVICEDOCUMENTITEMISOPEN,
SERVICEDOCUMENTITEMISQUOTATION,
SERVICEDOCUMENTITEMISRELEASED,
SERVICEDOCUMENTITEMNETAMOUNT,
SERVICEDOCUMENTITEMOBJECTTYPE,
SERVICEDOCUMENTITEMPRIORITY,
SERVICEDOCUMENTITEMQUANTITY,
SERVICEDOCUMENTITEMSTATUS,
SERVICEDOCUMENTITEMUUID,
SERVICEDOCUMENTTYPE,
SERVICEDURATION,
SERVICEDURATIONUNIT,
SERVICEEMPLOYEE,
SERVICEFIRSTRESPONSEBYDATETIME,
SERVICEORGANIZATION,
SERVICEPROFILE,
SERVICESRENDEREDDATE,
SERVICETEAM,
SHIPTOPARTY,
SOLDTOPARTY,
SOLDTOPARTYCOUNTRY,
SOLDTOPARTYREGION,
SRVCDOCITEMCREDITSTATUS,
SRVCDOCITEMEXECUTIONSTATUS,
SRVCDOCITEMISUNPLANNED,
SRVCDOCITEMSLADUEBYDATETIME,
SRVCDOCITEMTRANSFERSTATUS,
SRVCDOCITMBSLNCOSTPOSTGSTATUS,
SRVCDOCITMCONTINUOUSCOSTSTATUS,
SRVCDOCITMISRELEASEDFORBILLING,
SRVCSEPAMANDATERELEVANCE,
TIMESHEETOVERTIMECATEGORY,
TRANSACTIONCURRENCY,
WBSELEMENTINTERNALID,
PRIMARY KEY (SERVICEDOCUMENTITEM)
);Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA