I_SrvcConfReldForCmpltBillg

Service Conf Reld for Complete Billing | view: ISERVCONFRLDCMBL | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMD_BRELVONAE, CRMD_BRELVONAE, CRMC_ITEM_TYPE, CRMC_SALES_ITEM
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
ServiceDocItemGrossAmount Gross Order Value in PO Currency
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity CRM: Order Quantity
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocItemCreationDate Created On
ServiceDocItemChangedDate Changed On
Column Name Description
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemHasError Error Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
ServiceDocItemBillingStatus Billing Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
ServiceDocumentStatus Life Cycle Status Show values
PrdcssrSuccssrDocStatus Life Cycle Status Show values
SuccssrSrvcDocStatus Life Cycle Status Show values
SrvcOrderConfirmationRelevance Relevant for Confirmation Show values
ParentSrvcOrdItmConfRelevance Relevant for Confirmation Show values
Column Name Description Domain name
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemCharUUID 32 Character CRM Object GUID (Converted)
ParentServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
ServiceOrder Transaction ID CRM_OBJECT_ID
ServiceConfirmation Transaction ID CRM_OBJECT_ID
BillingDateTime Billing Date for Billing Index and Printout TZNTSTMPS
BillingDocCreationDateTime Billing Document Creation Date TZNTSTMPS
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
ServiceOrganization Service Organization HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
ServiceDocItemCreationDateTime Created At TZNTSTMPS
ServiceDocItemChangedDateTime Changed At TZNTSTMPS
ServiceDocItemCreatedByUser User that Created the Transaction UNAME
ServiceDocItemChangedByUser Transaction Last Changed By UNAME
OriginallyRequestedProduct Product Name Entered CRM_ORDERED_PROD
RequestedServiceStartDateTime Service Request Start Date TZNTSTMPS
RequestedServiceEndDateTime Service Request Due Date TZNTSTMPS
ServiceContrItemStartDateTime Contract Start date DEC15
ServiceContrItemEndDateTime Contract End Date DEC15
SrvcDocItemIsBundle null
ParentServiceDocumentItem null
ServiceDocPredecessor Transaction ID CRM_OBJECT_ID
ServiceDocSuccessor Transaction ID CRM_OBJECT_ID
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceDocumentCharUUID 32 Character CRM Object GUID (Converted)
Master Data Relations | to Other Relations ↓ Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.BILLABLECONTROL == TBMOT.BEMOT
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TBMOT.MANDT
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.BILLINGBLOCKREASON == TVFS.FAKSP
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TVFS.MANDT
Bill-To Party
  • Bill-To Party
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.BILLTOPARTY == BUT000.PARTNER
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
  • I_SRVCCONFRELDFORCMPLTBILLG.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TVTW.MANDT
  • I_SRVCCONFRELDFORCMPLTBILLG.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TSPA.MANDT
  • I_SRVCCONFRELDFORCMPLTBILLG.DIVISION == TSPA.SPART
Payer
  • Client
  • Payer
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
  • I_SRVCCONFRELDFORCMPLTBILLG.PAYERPARTY == BUT000.PARTNER
Terms of Payment
  • Terms of Payment
  • ?
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.PAYMENTTERMS == T052.ZTERM
  • I_SRVCCONFRELDFORCMPLTBILLG.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == T052.MANDT
Employee Responsible
  • Client
  • Employee Responsible
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
  • I_SRVCCONFRELDFORCMPLTBILLG.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Item Category
  • Item Category
  • Client
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == T006.MANDT
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCSUCCESSORBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCSUCCESSORBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Activity Priority
  • Client
  • Activity Priority
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == SCPRIO.CLIENT
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Business Transaction Type
  • Client
Executing Service Employee
  • Client
  • Executing Service Employee
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCSUCCESSORBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICEDOCPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Service Team
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.SERVICETEAM == BUT000.PARTNER
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == BUT000.CLIENT
  • I_SRVCCONFRELDFORCMPLTBILLG.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == T005.MANDT
  • I_SRVCCONFRELDFORCMPLTBILLG.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • I_SRVCCONFRELDFORCMPLTBILLG.SOLDTOPARTYREGION == T005S.BLAND
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == T005S.MANDT
  • I_SRVCCONFRELDFORCMPLTBILLG.SOLDTOPARTYCOUNTRY == T005S.LAND1
Currency
  • Currency
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Rule for Determining the Next Billing Date
  • Rule for Determining the Next Billing Date
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.BILLINGPLANBILLINGDATERULEUUID == TIMERULEH.RULE_ID
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TIMERULEH.CLIENT
Rule for Determining the Period Date
  • Rule for Determining the Period Date
  • Client
  • I_SRVCCONFRELDFORCMPLTBILLG.SETTLEMENTPERIODRULEUUID == TIMERULEH.RULE_ID
  • I_SRVCCONFRELDFORCMPLTBILLG.MANDT == TIMERULEH.CLIENT