I_ServiceDocReleasedForBilling

Service document released for billing | view: ISRVDOCRELDFRBLN | ATTR | Extraction: Not supported | Component: S4CRM: Reporting

Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMD_BRELVONAI, CRMD_BRELVONAI, CRMD_BRELVONAE, CRMD_BRELVONAE, CRMC_ITEM_TYPE, CRMC_SALES_ITEM

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical (9)
Other (35)
🔗 Relations (24)

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
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	null
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
ServiceDocPredecessor	Transaction ID	CRM_OBJECT_ID
ServiceDocSuccessor	null
ServiceDocSuccessorBusObjType	null
SuccssrSrvcDocStatus	null
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)
ParentServiceDocumentItem	null

Master Data Relations \| to Other Relations ↓	Join Conditions
Accounting Indicator Client Accounting Indicator	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == TBMOT.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.BILLABLECONTROL == TBMOT.BEMOT`
Business Partner: Billing Block Reason Client Business Partner: Billing Block Reason	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == TVFS.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.BILLINGBLOCKREASON == TVFS.FAKSP`
Bill-To Party Client Bill-To Party	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.BILLTOPARTY == BUT000.PARTNER`
Customer Contact Person Client Customer Contact Person	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.CONTACTPERSON == BUT000.PARTNER`
Distribution Channel Client Distribution Channel	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == TVTW.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Client Division	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == TSPA.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.DIVISION == TSPA.SPART`
Payer Client Payer	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.PAYERPARTY == BUT000.PARTNER`
Terms of Payment ? Client Terms of Payment	`I_SERVICEDOCRELEASEDFORBILLING.[column in domain "DZTAGG_052"] == T052.ZTAGG` `I_SERVICEDOCRELEASEDFORBILLING.MANDT == T052.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.PAYMENTTERMS == T052.ZTERM`
Employee Responsible Client Employee Responsible	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.RESPONSIBLEEMPLOYEE == BUT000.PARTNER`
Item Category Client Item Category	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == CRMC_ITEM_TYPE.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCITEMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE`
Unit of Measure in Which the Product Is Sold Client Unit of Measure in Which the Product Is Sold	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == T006.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI`
Business Trans. Cat. Business Trans. Cat. Business Trans. Cat.	`I_SERVICEDOCRELEASEDFORBILLING.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
CRM Item Object Type	`I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY`
Activity Priority Client Activity Priority	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == SCPRIO.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY`
Business Transaction Type Client Business Transaction Type	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == CRMC_PROC_TYPE.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Executing Service Employee Client Executing Service Employee	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEEMPLOYEE == BUT000.PARTNER`
Business Trans. Cat. Business Trans. Cat. Business Trans. Cat.	`I_SERVICEDOCRELEASEDFORBILLING.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY` `I_SERVICEDOCRELEASEDFORBILLING.SERVICEDOCPRDCSSRBUSOBJTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Service Team Client Service Team	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.SERVICETEAM == BUT000.PARTNER`
Sold-To Party Client Sold-To Party	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == BUT000.CLIENT` `I_SERVICEDOCRELEASEDFORBILLING.SOLDTOPARTY == BUT000.PARTNER`
Country/Region Client Country/Region	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == T005.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.SOLDTOPARTYCOUNTRY == T005.LAND1`
Region (State, Province, County) Client Region (State, Province, County) Country/Region	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == T005S.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.SOLDTOPARTYREGION == T005S.BLAND` `I_SERVICEDOCRELEASEDFORBILLING.SOLDTOPARTYCOUNTRY == T005S.LAND1`
Currency Client Currency	`I_SERVICEDOCRELEASEDFORBILLING.MANDT == TCURC.MANDT` `I_SERVICEDOCRELEASEDFORBILLING.TRANSACTIONCURRENCY == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Rule for Determining the Next Billing Date Rule for Determining the Next Billing Date Client	`I_SERVICEDOCRELEASEDFORBILLING.BILLINGPLANBILLINGDATERULEUUID == TIMERULEH.RULE_ID` `I_SERVICEDOCRELEASEDFORBILLING.MANDT == TIMERULEH.CLIENT`
Rule for Determining the Period Date Rule for Determining the Period Date Client	`I_SERVICEDOCRELEASEDFORBILLING.SETTLEMENTPERIODRULEUUID == TIMERULEH.RULE_ID` `I_SERVICEDOCRELEASEDFORBILLING.MANDT == TIMERULEH.CLIENT`