Description | Query Customer Invoices |
Name | QueryCustomerInvoiceIn |
Namespace | http://sap.com/xi/A1S/Global |
Process Component Description | Customer Invoice Processing |
Process Component Name | CustomerInvoiceProcessing |
Process Component Namespace | http://sap.com/xi/AP/CustomerInvoicing/Global |
Deployment Unit Description | Customer Invoicing |
Endpoint Activation | By Scoping of Process Component | Operations |
Release Status | Released |
An interface to query customer invoice data.
This web service is used to query customer invoices. It has one operation called FindByElements.
Query example
{code : soap}
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
<soapenv:Header />
<soapenv:Body>
<glob:CustomerInvoiceByElementsQuery_sync>
<CustomerInvoiceSelectionByElements>
<SelectionByID>
<InclusionExclusionCode>I</InclusionExclusionCode>
<IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
<LowerBoundaryIdentifier>MCCI-110</LowerBoundaryIdentifier>
</SelectionByID>
</CustomerInvoiceSelectionByElements>
</glob:CustomerInvoiceByElementsQuery_sync>
</soapenv:Body>
</soapenv:Envelope>
Response example
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"> <soap-env:Header/> <soap-env:Body> <n0:CustomerInvoiceByElementsResponse_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global" xmlns:prx="urn:sap.com:proxy:QCH:/1SAI/TASC467E917EC5C40C66969:804"> <CustomerInvoice> <ID>MCCI-110</ID> <UUID>00163e94-8bb2-1eea-91e5-c211be1b50cf</UUID> <SystemAdministrativeData> <CreationDateTime>2020-02-04T09:09:49Z</CreationDateTime> <CreationIdentityUUID>00145ef5-88e6-02db-bcae-74ea799f1856</CreationIdentityUUID> <LastChangeDateTime>2020-02-04T09:09:49Z</LastChangeDateTime> <LastChangeIdentityUUID>00145ef5-88e6-02db-bcae-74ea799f1856</LastChangeIdentityUUID> </SystemAdministrativeData> <ProcessingTypeCode>CI</ProcessingTypeCode> <ProcessingTypeName languageCode="EN">Invoice</ProcessingTypeName> <Date>2020-02-04</Date> <ReferenceBusinessTransactionDocumentID>MCCI-110</ReferenceBusinessTransactionDocumentID> <Status> <ReleaseStatusCode>1</ReleaseStatusCode> <ReleaseStatusName languageCode="EN">Not Released</ReleaseStatusName> <ClearingStatusCode>4</ClearingStatusCode> <ClearingStatusName languageCode="EN">Not Relevant</ClearingStatusName> <ConsistencyStatusCode>3</ConsistencyStatusCode> <ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName> <ItemConsistencyStatusCode>3</ItemConsistencyStatusCode> <ItemConsistencyStatusName languageCode="EN">Consistent</ItemConsistencyStatusName> <ApprovalStatusCode>1</ApprovalStatusCode> </Status> <SellerParty> <PartyID>MC10000</PartyID> <StandardID schemeAgencyID="16">100000999</StandardID> <AddressHostUUID>00145ef5-88e6-02db-b8b3-ac7afa9cd618</AddressHostUUID> <Address> <FirstLineName>Akron Heating Technologies INC.</FirstLineName> <DisplayName languageCode="EN">Akron Heating Technologies INC.</DisplayName> <PostalAddress> <CountryCode>US</CountryCode> <RegionCode listID="US">OH</RegionCode> <CityName>Akron</CityName> <StreetPostalCode>44308</StreetPostalCode> <StreetName>North Streeet</StreetName> <HouseID>1128</HouseID> <TaxJurisdictionCode listID="US">OH 77</TaxJurisdictionCode> <TimeZoneCode>EST</TimeZoneCode> </PostalAddress> <ConventionalPhoneFormattedNumberDescription>+1 (330) 733-1</ConventionalPhoneFormattedNumberDescription> <FacsimileFormattedNumberDescription>+1 (330) 734-1</FacsimileFormattedNumberDescription> <EmailURI>info@akron.com</EmailURI> </Address> </SellerParty> <BuyerParty> <PartyID>MC6049</PartyID> <AddressHostUUID>00300571-ce9b-1ddd-89de-7c56531eda3e</AddressHostUUID> <Address> <FirstLineName>Luxury Heating & Cooling Co</FirstLineName> <DisplayName languageCode="EN">Luxury Heating & Cooling Co</DisplayName> <PostalAddress> <CountryCode>US</CountryCode> <RegionCode listID="US">MA</RegionCode> <CityName>Boston</CityName> <StreetPostalCode>02134</StreetPostalCode> <StreetName>Commonwealth Ave</StreetName> <HouseID>1249</HouseID> <TaxJurisdictionCode listID="US">MA</TaxJurisdictionCode> <TimeZoneCode>EST</TimeZoneCode> </PostalAddress> <ConventionalPhoneFormattedNumberDescription>+1 (617) 782-9508</ConventionalPhoneFormattedNumberDescription> <FacsimileFormattedNumberDescription>+1 (617) 782-9522</FacsimileFormattedNumberDescription> <EmailURI>info@lhc.us</EmailURI> </Address> </BuyerParty> <BillToParty> <PartyID>MC6049</PartyID> <AddressHostUUID>00300571-ce9b-1ddd-89de-7c56531eda3e</AddressHostUUID> <Address> <FirstLineName>Luxury Heating & Cooling Co</FirstLineName> <DisplayName languageCode="EN">Luxury Heating & Cooling Co</DisplayName> <PostalAddress> <CountryCode>US</CountryCode> <RegionCode listID="US">MA</RegionCode> <CityName>Boston</CityName> <StreetPostalCode>02134</StreetPostalCode> <StreetName>Commonwealth Ave</StreetName> <HouseID>1249</HouseID> <TaxJurisdictionCode listID="US">MA</TaxJurisdictionCode> <TimeZoneCode>EST</TimeZoneCode> </PostalAddress> <ConventionalPhoneFormattedNumberDescription>+1 (617) 782-9508</ConventionalPhoneFormattedNumberDescription> <FacsimileFormattedNumberDescription>+1 (617) 782-9522</FacsimileFormattedNumberDescription> <EmailURI>info@lhc.us</EmailURI> </Address> </BillToParty> <PayerParty> <PartyID>MC6049</PartyID> <AddressHostUUID>00300571-ce9b-1ddd-89de-7c56531eda3e</AddressHostUUID> <Address> <FirstLineName>Luxury Heating & Cooling Co</FirstLineName> <DisplayName languageCode="EN">Luxury Heating & Cooling Co</DisplayName> <PostalAddress> <CountryCode>US</CountryCode> <RegionCode listID="US">MA</RegionCode> <CityName>Boston</CityName> <StreetPostalCode>02134</StreetPostalCode> <StreetName>Commonwealth Ave</StreetName> <HouseID>1249</HouseID> <TaxJurisdictionCode listID="US">MA</TaxJurisdictionCode> <TimeZoneCode>EST</TimeZoneCode> </PostalAddress> <ConventionalPhoneFormattedNumberDescription>+1 (617) 782-9508</ConventionalPhoneFormattedNumberDescription> <FacsimileFormattedNumberDescription>+1 (617) 782-9522</FacsimileFormattedNumberDescription> <EmailURI>info@lhc.us</EmailURI> </Address> </PayerParty> <BillFromParty> <PartyID>MC40000</PartyID> <AddressHostUUID>00163e01-2015-1ed0-93ff-60af1679a874</AddressHostUUID> <Address> <DisplayName languageCode="EN">Sales, Service & Marketing</DisplayName> </Address> </BillFromParty> <InvoicingUnitParty> <PartyID>MC40000</PartyID> <AddressHostUUID>00163e01-2015-1ed0-93ff-60af1679a874</AddressHostUUID> <Address> <DisplayName languageCode="EN">Sales, Service & Marketing</DisplayName> </Address> </InvoicingUnitParty> <PricingTerms> <CurrencyCode>USD</CurrencyCode> <PricingProcedureCode listID="2">PPSTD1</PricingProcedureCode> </PricingTerms> <PriceAndTax> <NetAmount currencyCode="USD">450.0</NetAmount> <TaxAmount currencyCode="USD">22.5</TaxAmount> <GrossAmount currencyCode="USD">472.5</GrossAmount> <PriceComponent> <Description languageCode="EN">List Price</Description> <MajorLevelOrdinalNumberValue>10</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <TypeCode listID="2">7PR1</TypeCode> <TypeName languageCode="EN">List Price</TypeName> <CategoryCode>1</CategoryCode> <CategoryName languageCode="EN">Price</CategoryName> <PurposeCode>1000</PurposeCode> <PurposeName languageCode="EN">General</PurposeName> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <RateBaseQuantityTypeName languageCode="EN">working day</RateBaseQuantityTypeName> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculationBasisQuantityTypeName languageCode="EN">working day</CalculationBasisQuantityTypeName> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Total Item Net Value</Description> <MajorLevelOrdinalNumberValue>50</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>2</MinorLevelOrdinalNumberValue> <CalculationBasis> <BaseCode>3</BaseCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Total Item Net Value</Description> <MajorLevelOrdinalNumberValue>78</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>3</MinorLevelOrdinalNumberValue> <CalculationBasis> <BaseCode>3</BaseCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Total Net Value</Description> <MajorLevelOrdinalNumberValue>80</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>4</MinorLevelOrdinalNumberValue> <CalculationBasis> <BaseCode>3</BaseCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Cost Estimate</Description> <MajorLevelOrdinalNumberValue>82</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>5</MinorLevelOrdinalNumberValue> <TypeCode listID="2">0009</TypeCode> <TypeName languageCode="EN">Cost Estimate</TypeName> <CategoryCode>1</CategoryCode> <CategoryName languageCode="EN">Price</CategoryName> <PurposeCode>4120</PurposeCode> <PurposeName languageCode="EN">Preliminary Order Cost Estimate</PurposeName> <Rate> <DecimalValue>0.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <RateBaseQuantityTypeName languageCode="EN">working day</RateBaseQuantityTypeName> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculationBasisQuantityTypeName languageCode="EN">working day</CalculationBasisQuantityTypeName> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Tax Values</Description> <MajorLevelOrdinalNumberValue>90</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>6</MinorLevelOrdinalNumberValue> <TypeCode listID="2">0TTE</TypeCode> <TypeName languageCode="EN">Tax</TypeName> <CategoryCode>4</CategoryCode> <CategoryName languageCode="EN">Tax</CategoryName> <PurposeCode>5100</PurposeCode> <PurposeName languageCode="EN">Tax</PurposeName> <Rate> <DecimalValue>0.0</DecimalValue> <MeasureUnitCode>P1</MeasureUnitCode> </Rate> <CalculationBasis> <BaseCode>1</BaseCode> <Amount currencyCode="USD">450.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Percentage (of one hundred)</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">State sales tax (%)</Description> <MajorLevelOrdinalNumberValue>90</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>7</MinorLevelOrdinalNumberValue> <TypeCode listID="2">US11</TypeCode> <TypeName languageCode="EN">State sales tax (%)</TypeName> <CategoryCode>4</CategoryCode> <CategoryName languageCode="EN">Tax</CategoryName> <PurposeCode>5100</PurposeCode> <PurposeName languageCode="EN">Tax</PurposeName> <Rate> <DecimalValue>5.0</DecimalValue> <MeasureUnitCode>P1</MeasureUnitCode> </Rate> <CalculationBasis> <BaseCode>1</BaseCode> <Amount currencyCode="USD">450.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Percentage (of one hundred)</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">22.5</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Total</Description> <MajorLevelOrdinalNumberValue>100</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>8</MinorLevelOrdinalNumberValue> <CalculationBasis> <BaseCode>3</BaseCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">472.5</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Item Discounts</Description> <MajorLevelOrdinalNumberValue>110</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>9</MinorLevelOrdinalNumberValue> <CalculationBasis> <BaseCode>3</BaseCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Header Discounts</Description> <MajorLevelOrdinalNumberValue>111</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>10</MinorLevelOrdinalNumberValue> <CalculationBasis> <BaseCode>3</BaseCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">Total Given Discounts (%)</Description> <MajorLevelOrdinalNumberValue>112</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>11</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>0.0</DecimalValue> <MeasureUnitCode>P1</MeasureUnitCode> </Rate> <CalculationBasis> <BaseCode>1</BaseCode> <Amount currencyCode="USD">450.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Percentage (of one hundred)</CalculationBasisBaseName> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponent> <PriceComponent> <Description languageCode="EN">List Price</Description> <MajorLevelOrdinalNumberValue>940</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>12</MinorLevelOrdinalNumberValue> <TypeCode listID="2">7PR1</TypeCode> <TypeName languageCode="EN">List Price</TypeName> <CategoryCode>1</CategoryCode> <CategoryName languageCode="EN">Price</CategoryName> <PurposeCode>1000</PurposeCode> <PurposeName languageCode="EN">General</PurposeName> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <RateBaseQuantityTypeName languageCode="EN">working day</RateBaseQuantityTypeName> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculationBasisBaseName languageCode="EN">Quantity</CalculationBasisBaseName> <CalculationBasisQuantityTypeName languageCode="EN">working day</CalculationBasisQuantityTypeName> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponent> <SellerTaxCountryCode>US</SellerTaxCountryCode> <SellerTaxID schemeID=" ">US6277</SellerTaxID> <SellerTaxIdentificationNumberTypeCode listID="US">4</SellerTaxIdentificationNumberTypeCode> </PriceAndTax> <CashDiscountTerms> <Code>1002</Code> <PaymentBaselineDate>2020-02-04</PaymentBaselineDate> <FullPaymentDueDaysValue>20</FullPaymentDueDaysValue> <FullPaymentEndDate>2020-02-24</FullPaymentEndDate> </CashDiscountTerms> <TextCollection> <Text> <TypeCode>10024</TypeCode> <CreationDateTime timeZoneCode=" " daylightSavingTimeIndicator="false">2011-01-13T12:39:16</CreationDateTime> <ContentText>Account MC6049 External Sales Note tEST cOMMENTS</ContentText> </Text> <Text> <TypeCode>10011</TypeCode> <CreationDateTime timeZoneCode=" " daylightSavingTimeIndicator="false">2011-01-13T12:39:16</CreationDateTime> <ContentText>Account MC6049 Internal Sales Note</ContentText> </Text> </TextCollection> <Item> <ID>10</ID> <Description languageCode="EN">Training - Installation of Gas Boilers</Description> <ItemProcessTypeCode>CII</ItemProcessTypeCode> <Quantity> <Quantity unitCode="E49">1.0</Quantity> <TypeCode>E49</TypeCode> <TypeName languageCode="EN">working day</TypeName> <MeasureUnitName languageCode="EN">Working day(s)</MeasureUnitName> <MeasureUnitCommercialName languageCode="EN">wday</MeasureUnitCommercialName> </Quantity> <Product> <InternalID>MCD-0442</InternalID> <TypeCode>2</TypeCode> </Product> <Status> <ConsistencyStatusCode>3</ConsistencyStatusCode> <ConsistencyStatusName languageCode="EN">Consistent</ConsistencyStatusName> </Status> <EmployeeResponsible> <PartyID>MC2471</PartyID> <AddressHostUUID>00163e03-390f-1ed2-81c4-cbdd1481e64a</AddressHostUUID> <Address> <FirstLineName>Ms. Kate Jacob</FirstLineName> <SecondLineName>Akron Heating Technologies INC.</SecondLineName> <DisplayName languageCode="EN">Kate Jacob</DisplayName> <PostalAddress> <CountryCode>US</CountryCode> <RegionCode listID="US">NY</RegionCode> <CityName>New York</CityName> <StreetPostalCode>10021</StreetPostalCode> <StreetName>3rd Ave</StreetName> <HouseID>1303</HouseID> <BuildingID>NY01</BuildingID> <RoomID>E3.01-02</RoomID> <TimeZoneCode>EST</TimeZoneCode> </PostalAddress> <ConventionalPhoneFormattedNumberDescription>+1 (646) 731-0309</ConventionalPhoneFormattedNumberDescription> <MobilePhoneFormattedNumberDescription>+1 (646) 731-0309</MobilePhoneFormattedNumberDescription> <FacsimileFormattedNumberDescription>+1 (212) 716-2471</FacsimileFormattedNumberDescription> <EmailURI>kate.jacob@akron.com</EmailURI> </Address> </EmployeeResponsible> <SalesAndServiceBusinessArea> <SalesOrganisationID>MC42100</SalesOrganisationID> <DistributionChannelCode>02</DistributionChannelCode> <DistributionChannelName languageCode="EN">Indirect sales</DistributionChannelName> </SalesAndServiceBusinessArea> <PriceAndTax> <NetAmount currencyCode="USD">450.0</NetAmount> <TaxAmount currencyCode="USD">22.5</TaxAmount> <GrossAmount currencyCode="USD">472.5</GrossAmount> <TaxCountryCode>US</TaxCountryCode> <PriceComponents> <Description languageCode="EN">Price List Akron Products</Description> <MajorLevelOrdinalNumberValue>10</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <TypeCode listID="2">7PR1</TypeCode> <CategoryCode>1</CategoryCode> <PurposeCode>1000</PurposeCode> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Total Item Net Value</Description> <MajorLevelOrdinalNumberValue>50</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Total Item Net Value</Description> <MajorLevelOrdinalNumberValue>78</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Total Net Value</Description> <MajorLevelOrdinalNumberValue>80</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Cost Estimate</Description> <MajorLevelOrdinalNumberValue>82</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <TypeCode listID="2">0009</TypeCode> <CategoryCode>1</CategoryCode> <PurposeCode>4120</PurposeCode> <Rate> <DecimalValue>0.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Tax Values</Description> <MajorLevelOrdinalNumberValue>90</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <TypeCode listID="2">0TTE</TypeCode> <CategoryCode>4</CategoryCode> <PurposeCode>5100</PurposeCode> <Rate> <DecimalValue>0.0</DecimalValue> <MeasureUnitCode>P1</MeasureUnitCode> </Rate> <CalculationBasis> <BaseCode>1</BaseCode> <Amount currencyCode="USD">450.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">State sales tax (%)</Description> <MajorLevelOrdinalNumberValue>90</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>2</MinorLevelOrdinalNumberValue> <TypeCode listID="2">US11</TypeCode> <CategoryCode>4</CategoryCode> <PurposeCode>5100</PurposeCode> <Rate> <DecimalValue>5.0</DecimalValue> <MeasureUnitCode>P1</MeasureUnitCode> </Rate> <CalculationBasis> <BaseCode>1</BaseCode> <Amount currencyCode="USD">450.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">22.5</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Total</Description> <MajorLevelOrdinalNumberValue>100</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>472.5</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">472.5</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Item Discounts</Description> <MajorLevelOrdinalNumberValue>110</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>0.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Header Discounts</Description> <MajorLevelOrdinalNumberValue>111</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>0.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Total Given Discounts (%)</Description> <MajorLevelOrdinalNumberValue>112</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>0.0</DecimalValue> <MeasureUnitCode>P1</MeasureUnitCode> </Rate> <CalculationBasis> <BaseCode>1</BaseCode> <Amount currencyCode="USD">450.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">0.0</CalculatedAmount> </PriceComponents> <PriceComponents> <Description languageCode="EN">Price List Akron Products</Description> <MajorLevelOrdinalNumberValue>940</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <TypeCode listID="2">7PR1</TypeCode> <CategoryCode>1</CategoryCode> <PurposeCode>1000</PurposeCode> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </PriceComponents> <MainPrice> <Description languageCode="EN">Price List Akron Products</Description> <MajorLevelOrdinalNumberValue>10</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <TypeCode listID="2">7PR1</TypeCode> <CategoryCode>1</CategoryCode> <PurposeCode>1000</PurposeCode> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </MainPrice> <MainTotal> <Description languageCode="EN">Total Item Net Value</Description> <MajorLevelOrdinalNumberValue>78</MajorLevelOrdinalNumberValue> <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue> <Rate> <DecimalValue>450.0</DecimalValue> <CurrencyCode>USD</CurrencyCode> <BaseDecimalValue>1.0</BaseDecimalValue> <BaseMeasureUnitCode>E49</BaseMeasureUnitCode> </Rate> <RateBaseQuantityTypeCode>E49</RateBaseQuantityTypeCode> <CalculationBasis> <BaseCode>3</BaseCode> <Quantity unitCode="E49">1.0</Quantity> <QuantityTypeCode>E49</QuantityTypeCode> <Amount currencyCode="USD">0.0</Amount> </CalculationBasis> <CalculatedAmount currencyCode="USD">450.0</CalculatedAmount> </MainTotal> <TaxDate>2020-02-04</TaxDate> <TaxCharacteristicsCode listID="US">501</TaxCharacteristicsCode> </PriceAndTax> <PricingTerms> <PriceDateTime timeZoneCode="EST">2020-02-04T08:40:13Z</PriceDateTime> </PricingTerms> <ProductRecipientParty> <PartyID>MC6049</PartyID> <AddressHostUUID>00300571-ce9b-1ddd-89de-7c56531eda3e</AddressHostUUID> <Address> <FirstLineName>Luxury Heating & Cooling Co</FirstLineName> <DisplayName languageCode="EN">Luxury Heating & Cooling Co</DisplayName> <PostalAddress> <CountryCode>US</CountryCode> <RegionCode listID="US">MA</RegionCode> <CityName>Boston</CityName> <StreetPostalCode>02134</StreetPostalCode> <StreetName>Commonwealth Ave</StreetName> <HouseID>1249</HouseID> <TaxJurisdictionCode listID="US">MA</TaxJurisdictionCode> <TimeZoneCode>EST</TimeZoneCode> </PostalAddress> <ConventionalPhoneFormattedNumberDescription>+1 (617) 782-9508</ConventionalPhoneFormattedNumberDescription> <FacsimileFormattedNumberDescription>+1 (617) 782-9522</FacsimileFormattedNumberDescription> <EmailURI>info@lhc.us</EmailURI> </Address> </ProductRecipientParty> <TextCollection> <Text> <TypeCode>10024</TypeCode> <CreationDateTime timeZoneCode=" " daylightSavingTimeIndicator="false">2009-02-13T13:16:30</CreationDateTime> <ContentText>Training - Installation of Gas Boilers</ContentText> </Text> </TextCollection> <CustomerContractReference> <ID>221</ID> <ItemID>30</ItemID> <ItemTypeCode>88</ItemTypeCode> <ItemTypeName languageCode="EN">Customer Contract Service Item</ItemTypeName> </CustomerContractReference> <CustomerInvoiceRequestReference> <ID>1347</ID> <ItemID>30</ItemID> <ItemTypeCode>002</ItemTypeCode> <ItemTypeName languageCode="EN">Invoice Item</ItemTypeName> </CustomerInvoiceRequestReference> <ContractItemDates> <StartDate timeZoneCode="EST">2020-02-04T05:00:00Z</StartDate> <EndDate timeZoneCode="EST">2021-02-04T05:00:00Z</EndDate> </ContractItemDates> </Item> </CustomerInvoice> <ProcessingConditions> <ReturnedQueryHitsNumberValue>1</ReturnedQueryHitsNumberValue> <MoreHitsAvailableIndicator>false</MoreHitsAvailableIndicator> <LastReturnedObjectID>00163E948BB21EEA91E5C211BE1B50CF</LastReturnedObjectID> </ProcessingConditions> </n0:CustomerInvoiceByElementsResponse_sync> </soap-env:Body> </soap-env:Envelope>
<?xml version="1.0" encoding="UTF-8"?> <RequestedElements> <CustomerInvoice> <!-- Don't show price components --> <PriceComponentTransmissionRequestCode>4</PriceComponentTransmissionRequestCode> <!-- Don't show cash discount terms --> <CashDiscountTermsTransmissionRequestCode>4</CashDiscountTermsTransmissionRequestCode> <!-- Don't show text collections --> <TextCollectionTransmissionRequestCode>4</TextCollectionTransmissionRequestCode> <!-- Show items (same as this would have been not specified) --> <ItemTransmissionRequestCode>1</ItemTransmissionRequestCode> </CustomerInvoice> </RequestedElements>
You can find general information about Web services, their structure and consumption in the Web Services documentation.
This is an example request XML, that combines parameter structures for ID and date for selection and requests only a subset of the message elements and a limited number of documents.
<?xml version="1.0" encoding="UTF-8"?> <n0:CustomerInvoiceByElementsQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <CustomerInvoiceSelectionByElements> <!-- Select all Customer Invoices which start with ID "DECI" --> <SelectionByID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>DECI*</LowerBoundaryIdentifier> </SelectionByID> <!-- Select all Invoices between first of August and first of September --> <SelectionByDate> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>3</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceDate>2012-08-01</LowerBoundaryCustomerInvoiceDate> <UpperBoundaryCustomerInvoiceDate>2012-09-01</UpperBoundaryCustomerInvoiceDate> </SelectionByDate> </CustomerInvoiceSelectionByElements> <!-- Limit the hits to maximum 3000 --> <ProcessingConditions> <QueryHitsMaximumNumberValue>3000</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator> </ProcessingConditions> </n0:CustomerInvoiceByElementsQuery_sync>
Release | Change Description | Details | |
2005 | Documentation change | Added Employee Responsible and Contract Dates to ITEM | Authorization Fields to response message of QueryCustomerInvoice |
Description | Find customer invoices |
Name | FindByElements |
Synchronous | yes |
Release Status | Released |
To query customer invoice data by elements.
This is the sole operation of the web service and used to query customer invoices.
You can query with the following parameters:
Parameter | Description | Data Type |
---|---|---|
SelectionByID | Selection by customer invoice ID | Identifier |
SelectionByBaseBTDReferenceID | Selection by customer invoice request ID | Identifier |
SelectionByExternalReferenceID | Selection by external reference ID | Identifier |
SelectionByBuyerPartyID | Selection by buyer ID | Identifier |
SelectionBySellerPartyID | Selection by seller ID | Identifier |
SelectionByBillToPartyID | Selection by bill-to ID | Identifier |
SelectionByBillFromPartyID | Selection by bill-from ID | Identifier |
SelectionByPayerPartyID | Selection by payer ID | Identifier |
SelectionBySellerPartyID | Selection by seller ID | Identifier |
SelectionByProductRecipientPartyID | Selection by product recipient ID | Identifier |
SelectionByDate | Selection by date | Date |
SelectionByLastChangeDateTime | Selection by last changed date time | DateTime |
SelectionByReleaseStatusCode | Selection by release status code | Code |
SelectionByClearingStatusCode | Selection by clearing status code | Code |
SelectionByApprovalStatusCode | Selection by approval status code | Code |
SelectionByProcessingTypeCode | Selection by processing type code | Code |
SelectionBySearchText | Selection by search text | Text |
SelectionByID
With this query parameter you can query customer invoices with a specific customer invoice ID. The value depends on the number range that you have defined for the customer invoice business object in your system.
SelectionByBaseBTDReferenceID
With this query parameter you can query customer invoices with a specific customer invoice request ID.
SelectionByExternalReferenceID
With this query parameter you can query customer invoices with a specific external reference ID used in the creation of customer invoice request.
SelectionByBuyerPartyID
With this parameter you can search for customer invoices with a specific customer by ID.
SelectionBySellerPartyID
With this parameter you can search for customer invoices with a specific seller party ID.
SelectionByBillToPartyID
With this parameter you can search for customer invoices with a specific bill-to party ID.
SelectionByBillFromPartyID
With this parameter you can search for customer invoices with a specific bill-from party ID.
SelectionByPayerPartyID
With this parameter you can search for customer invoices with a specific payer party ID.
SelectionByProductRecipientPartyID
With this parameter you can search for customer invoices with a specific product recipient party ID.
SelectionByDate
With this parameter you can search for customer invoices with a specific date.
format: YYYY-MM-DD, sample value: 2016-01-05
SelectionByLastChangeDateTime
With this parameter you can search for customer invoices with a specific last changed date time.
format: YYYY-MM-DDTHH:MM:SS.0000000Z, sample value: 2016-01-05T07:47:09.0000000Z
SelectionByReleaseStatusCode
With this parameter you can search for customer invoices with a specific release status.
ReleaseStatusCode | Description |
---|---|
1 | Not Released |
3 | Released |
4 | Release Discarded |
5 | Release Canceled |
SelectionByClearingStatusCode
With this parameter you can search for customer invoices that have a specific clearing status.
ClearingCode | Description |
---|---|
1 | Open |
2 | Cleared |
SelectionByApprovalStatusCode
With this parameter you can search for customer invoices that have a specific approval status.
ApprovalCode | Description |
---|---|
1 | Not Started |
2 | Approval Not Necessary |
3 | In Approval |
4 | Approved |
5 | Rejected |
6 | In Revision |
7 | Withdrawn |
SelectionByProcessingTypeCode
With this parameter you can search for customer invoices using the Processing Type Code.
ProcessingTypeCode | Description |
---|---|
CI | Invoice |
CCM | Credit Memo |
CDP | Down Payment Request |
CCI | Correction Invoice |
SelectionBySearchText
With this parameter you can search for customer invoices that contain a specific text.
Consistency Status Codes
Customer invoice consistency and item consistency status codes.
ConsistencyStatusCode | Description |
---|---|
2 | Inconsistent |
3 | Consistent |
ID - The customer invoice ID.
UUID - The unique identifier of the customer invoice.
SystemAdministrativeData - Structure node with the following elements:
CreationDateTime - The creation timepoint of the customer invoice.
CreationIdentityUUID - The unique ID of the person who created the customer invoice.
LastChangeDateTime - The last change timepoint of the customer invoice.
LastChangeIdentityUUID - The unique ID of the last person who changed the customer invoice.
ProcessingTypeCode - The processing type code of the customer invoice. The code list is described above.
ProcessingTypeName - The language-specific name of the processing type.
Date - The invoice date.
DeviatingPostingDate - Deviating posting date, if specified.
CancellationInvoiceIndicator - Indicator whether or not the invoice is a cancellation invoice.
ReferenceBusinessTransactionDocumentID - External reference ID as configured in the Business Configuration Activity "External Reference for Customer Invoice"
Status - Structure node with the following elements:
ReleaseStatusCode - The release status code of the customer invoice. The code list is described above.
ReleaseStatusName - The release status name of the customer invoice
ClearingStatusCode - The clearing status code of the cutomer invoice. The code list is described above.
ClearingStatusName - The clearing status name of the cutomer invoice.
ConsistencyStatusCode - The consistency status code of the cutomer invoice. The code list is described above.
ConsistencyStatusName - The consistency status name of the cutomer invoice.
ItemConsistencyStatusCode - The items consistency status code of the cutomer invoice. The code list is described above.
ItemConsistencyStatusName - The items consistency status name of the cutomer invoice.
ApprovalStatusCode - The approval status code of the customer invoice.
SellerParty - Structure node
Company for which the receivables or liabilities described in the invoice arose or which is responsible for the invoicing process. Like for all parties there are the following elements, giving IDs, address and name of the party:
PartyID - ID of Party
Address - Address structure node
AddressHostUUID - address UUID information
BuyerParty - Structure node
Party that has caused the customer invoice, e.g by consuming goods or services.
BillToParty - Structure node
Party to which the customer invoice is addressed.
PayerParty - Structure node
Party obliged to pay the customer invoice.
BillFromParty - Structure node
Organisational unit responsible for the customer invoice.
TaxReportingUnitParty - Structure node
The permanent establishment of the buying company, which is responsible for tax reporting to the respective tax authority.
SplitRuleDescription - Description of the split rule used ( configured in the Business Confirguration Activity "Customer Invoice Split rule")
PriceAndTax - Structure node with the following elements:
NetAmount - The net currency amount of the customer invoice.
TaxAmount - The tax currency amount of the customer invoice.
GrossAmount - The gross currency amount of the customer invoice.
PriceComponent - Structure node
SellerTaxCountryCode - The tax country code of the seller party.
SellerTaxID - The tax ID of the seller party.
SellerTaxIdentificationNumberTypeCode - The tax type of the seller party.
CustomerTaxCountryCode - The tax country code of the buyer party.
CustomerTaxID - The tax ID of the buyer party.
CustomerTaxIdentificationNumberTypeCode - The tax type of the buyer party.
TaxDueDate - The tax due date of the customer invoice.
AutomaticTaxDetermination (Item) - indicator to deteremine if tax automatically deteremined.
CashDiscountTerms - Structure node with the following elements:
Code - Cash Discount Type code
PaymentBaselineDate
MaximumCashDiscount
NormalCashDiscount
FullPaymentDueDaysValue
FullPaymentDayOfMonthValue
FullPaymentMonthOffsetValue
FullPaymentEndDate - Date of payment in full
Description - description of cash discount
PaymentControl - structure node for Payments
PaymentFormCode - Payment code for the Invoice (see below)
PettyCashID - Petty Cash ID used in the Invoice
BankAccountID - Bank Account ID used in the Invoice
ExternalBankAccountID - Bank Account ID used for and External Payment used in the Invoice
PricingTerms - Pricing Terms structure node with the following elements:
CurrencyCode - Pricing Currency used in invoice.
PriceDateTime - Pricing date used in invoice.
ProvisionDate - Invoice provision date.
PricingProcedureCode - Pricing (Net / Gross) procedure used in invoice.
Product
TypeCode - type code of the product
itemProductSerialNumber - serial number information.
TextCollection - Structure node for texts.
AttachmentFolder - Structure node for attachments.
Item - Structure node for items with the following elements:
ID - ID of item in the invoice.
Description - Desciption of the item
Quantity - Quantity of the items
Status - Structure node
SalesKitParentLine - Parent line item ID of sales kit item and description
SalesOrderReference - Sales Order reference ID
PurchaseOrderReference - Purchase Order Reference ID
ServiceOrderReference - Service Order Reference ID
ServiceConfirmationReference - Service Confirmation Reference ID
CustomerReturnReference - Customer Return Reference ID
CustomerProjectInvoiceRequisitionReference - Customer Project Invoice Requisition reference ID
OutboundDeliveryReference - Outbound Delivery Reference ID
OriginInvoiceReference - Original Invoice Reference ID
IntercompanyContractReference - Intercompany Contract Reference ID
CustomerContractReference - Customer Contract Reference ID
CustomerInvoiceRequestReference - Customer Invoice Request Reference ID
Product - Product Structure node
TextCollection - Structure node for texts
ItemAttachmentFolder - Structure node for attachments for items
ItemProcessTypeCode - type of invoice item
CashDiscountDeductibleIndicator - CashDiscountDeductibleIndicator - Indicator that cash discount may be deducted.
PriceAndTax - Price and Tax Structure node for the items
ProductRecipientParty - Party Structure node
AccountingCodingBlockAssignment - Structure node for account coding block. Also contains the partner coding block(This can be activated with business option Partner Profit Center Segment)
Sample request payload :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global"> <soapenv:Header /> <soapenv:Body> <glob:CustomerInvoiceByElementsQuery_sync> <CustomerInvoiceSelectionByElements> <SelectionByID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>MCDP-172</LowerBoundaryIdentifier> </SelectionByID> <SelectionByBaseBTDReferenceID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>4788</LowerBoundaryIdentifier> </SelectionByBaseBTDReferenceID> <SelectionByExternalReferenceID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>External_ID</LowerBoundaryIdentifier> </SelectionByExternalReferenceID> <SelectionByBuyerPartyID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>MC9785</LowerBoundaryIdentifier> </SelectionByBuyerPartyID> <SelectionBySellerPartyID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>MC10000</LowerBoundaryIdentifier> </SelectionBySellerPartyID> <SelectionByBillToPartyID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>MC9785</LowerBoundaryIdentifier> </SelectionByBillToPartyID> <SelectionByBillFromPartyID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>MC42110</LowerBoundaryIdentifier> </SelectionByBillFromPartyID> <SelectionByPayerPartyID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>MC9785</LowerBoundaryIdentifier> </SelectionByPayerPartyID> <SelectionByDate> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceDate>2016-01-05</LowerBoundaryCustomerInvoiceDate> </SelectionByDate> <SelectionByLastChangeDateTime> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceLastChangeDateTime>2016-01-05T07:47:09.0000000Z</LowerBoundaryCustomerInvoiceLastChangeDateTime> </SelectionByLastChangeDateTime> <SelectionByClearingStatusCode> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceClearingStatusCode>2</LowerBoundaryCustomerInvoiceClearingStatusCode> </SelectionByClearingStatusCode> <SelectionByApprovalStatusCode> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceApprovalStatusCode>4</LowerBoundaryCustomerInvoiceApprovalStatusCode> </SelectionByClearingStatusCode> <SelectionByReleaseStatusCode> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceReleaseStatusCode>3</LowerBoundaryCustomerInvoiceReleaseStatusCode> </SelectionByReleaseStatusCode> <SelectionByProcessingTypeCode> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryCustomerInvoiceProcessingTypeCode>CDP</LowerBoundaryCustomerInvoiceProcessingTypeCode> </SelectionByProcessingTypeCode> <SelectionBySearchText>MCDP-172</SelectionBySearchText> </CustomerInvoiceSelectionByElements> </glob:CustomerInvoiceRequestBundleMaintainRequest_sync> </soapenv:Body> </soapenv:Envelope>
h3. %NOTE% h3. %USAGE% h3. %CONSTRAINT%