- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_TranspOrdInvcgBlockStsQ
Transportation Order Invoicing Block Status Query
| view: CINVCGBLOCKSTSQ
| Extraction:
Not supported
| Component: Analytics
Tables used:
SCAL_TT_DATE, /SCMTMS/D_SF_ROT, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORBLK, /SCMTMS/D_TORSTP, ADCP, ADRC, /SCMTMS/C_BLRC, /SCMTMS/C_BLRC_T, BUT000, T005, T005T, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SAPAPO/LOCT, /SAPAPO/TRTYPE, /SAPAPO/TRTYPET, HRP1000, T77S0, T005S, T005U, /SCMTMS/C_SFIR_T, /SCMTMS/C_SFIRTT, /SCMTMS/D_TCHRGI, /SCMTMS/D_TCHRGE, /SCMTMS/D_TCHRGR, /SCMTMS/C_SHTYP, /SCMTMS/C_SHTYPT, /SCMB/HRP5561, T77S0, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
| Column Name | Description | |
|---|---|---|
| TransportationOrderUUID | Transportation Order UUID (Char 32) | |
| SuplrFrtInvcReqUUID | Freight Settlement Document UUID (Char 32) |
| Column Name | Description | |
|---|---|---|
| 💲 Display Currency (DisplayCurrency): | ||
| CreditAmountInDisplayCurrency | Credit Amount in Display Currency (Maximum Length) | |
| InvoicedAmountInDspCurrency | Invoiced Amount In Display Currency (Maximum Length) | |
| CostAmountInDisplayCurrency | Cost Amount in Display Currency (Maximum Length) | |
| Column Name | Description | |
|---|---|---|
| 📏 Display Weight Unit of Measure (DisplayWeightUnit): | ||
| TranspOrdGrossWeightInDspUnit | Transportation Order Gross Weight In Display Unit | |
| 📏 Display Volume Unit of Measure (DisplayVolumeUnit): | ||
| TranspOrdGrossVolumeInDspUnit | Transportation Order Gross Volume in Display Unit | |
| 📏 Display Quantity Unit of Measure (DisplayQuantityUnit): | ||
| TranspOrdQuantityInDisplayUnit | Transportation Order Quantity In Display Unit | |
| 📏 Display Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit): | ||
| TranspOrdNumberOfCtnsInDspUnit | Transportation Order Number of Containers In Display Unit | |
| Column Name | Description | |
|---|---|---|
| TranspOrdLfcycStsChgDte | Transportation Order Lifecycle Status Change Date | |
| InvoiceDate | Posting Date |
| Column Name | Description | |
|---|---|---|
| TransportationOrderCategory | Business Document Category | Show values |
| DangerousGoodsAreContained | Dangerous Goods | Show values |
| TranspOrdPlanningBlock | Planning Block | Show values |
| TranspOrdExecutionIsBlocked | Execution Block | Show values |
| InvoicingIsBlocked | Freight Settlement Document Block | Show values |
| InvoicingBlockCategory | Invoicing Block Category | Show values |
| CarrierOriginOfEntry | Carrier Origin of Entry | Show values |
| TranspOrdTrafficDirection | Traffic Direction | Show values |
| TranspOrdLifeCycleStatus | Life Cycle Status | Show values |
| TranspOrdPlanningStatus | Planning Status | Show values |
| TransportationOrderExecSts | Execution Status | Show values |
| SourceLocationType | Source Location Type | Show values |
| DestinationLocationType | Destination Location Type | Show values |
| TransportationModeCategory | Transportation Mode Category | Show values |
| SuplrFrtInvcReqCategory | Freight Settlement Document Category | Show values |
| SuplrFrtInvcReqLifeCycSts | Life Cycle Status of Freight Settlement Document | Show values |
| SuplrFrtInvcReqBlockStatus | Block Status | Show values |
| SuplrFrtInvcReqConstcySts | Consistency Status | Show values |
| SuplrFrtInvcReqArchStatus | Archiving Status | Show values |
| SuplrFrtInvcReqConfStatus | Confirmation Status | Show values |
| InvoicingStatus | Transportation Charge Invoicing Status | Show values |
| TranspChargeCalcStatus | Charge Calculation Status | Show values |
| CarrierInvoicingStatus | Carrier Invoicing Status | Show values |
| TranspChargeItmInvcgStatus | Transportation Charge Item Invoicing Status | Show values |
| TranspChargeCalcLevel | Calculation Level | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| TransportationOrder | Document | /SCMTMS/TOR_ID | |
| SupplierFreightInvoiceRequest | Freight Settlement Document | /SCMTMS/SFIR_ID | |
| TransportationOrderCatDesc | Short Text for Fixed Values | DDTEXT | |
| TransportationOrderTypeDesc | Transportation Order Type Description | /SCMTMS/TOR_TYPE_DESC | |
| TranspOrdPlanningBlockDesc | Transportation Order Planning Block Description | DDTEXT | |
| TranspOrdExecutionBlockDesc | Transportation Order Execution Block Description | DDTEXT | |
| InvoicingIsBlockedDesc | Short Text for Fixed Values | DDTEXT | |
| InvoicingBlockReasonDesc | Block Reason Description | /SCMTMS/DESCRIPTION_S | |
| InvoicingBlockCategoryDesc | Transportation Order Block Category Description | DDTEXT | |
| Carrier | Carrier | /SCMTMS/BU_PARTNER | |
| CarrierName | null | ||
| CarrierOriginOfEntryDesc | Short Text for Fixed Values | DDTEXT | |
| Shipper | Shipper | BU_PARTNER | |
| ShipperName | null | ||
| Consignee | Ship-to Party | BU_PARTNER | |
| ConsigneeName | null | ||
| TranspOrdShippingType | Shipping Type | /SCMTMS/SHIPPING_TYPE | |
| TranspOrdShippingTypeDesc | Description | /SCMTMS/DESCRIPTION_S | |
| TranspOrdTrafficDirectionDesc | Short Text for Fixed Values | DDTEXT | |
| PlngAndExecOrganization | Planning and Execution Organization | HROBJID | |
| PlngAndExecOrganizationName | Object Name | TEXT40 | |
| PlngAndExecGroup | Planning and Execution Group | HROBJID | |
| PlngAndExecGroupName | Object Name | TEXT40 | |
| PurchasingOrganizationName | Object Name | TEXT40 | |
| PurchasingGroupName | Object Name | TEXT40 | |
| TranspOrdLifeCycleStatusDesc | Short Text for Fixed Values | DDTEXT | |
| TranspOrdPlanningStatusDesc | Short Text for Fixed Values | DDTEXT | |
| TransportationOrderExecStsDesc | Short Text for Fixed Values | DDTEXT | |
| TranspOrdLfcycStsChgDteTime | Created on Timestamp | TZNTSTMPS | |
| TranspOrdLfcycStsChgDteYrWeek | Transp Order Life Cycle Status Change Date Year Week | NUMC6 | |
| TranspOrdLfcycStsChgDteYrMnth | Transportation Order Lifecycle Status Change Date Year Month | NUMC6 | |
| TranspOrdLfcycStsChgDteYearQtr | Transportation Order Lifecycle Status Change Dte Year Qtr | NUMC5 | |
| TranspOrdLfcycStsChgDteYear | Transportation Order Lifecycle Status Change Date Year | NUMC4 | |
| SourceLocationUUID | Source Location Universally Unique Identifier (CHAR 22) | /SAPAPO/LOCID | |
| SourceLocationName | Location Description | /SAPAPO/LOC_CHAR40K | |
| SourceLocationTypeDesc | Short Text for Fixed Values | DDTEXT | |
| SourceLocationCountryName | Country/Region Name | TEXT50 | |
| SourceLocationRegionName | Description | TEXT20 | |
| DestinationLocationUUID | Destination Location UUID (CHAR 22) | /SAPAPO/LOCID | |
| DestinationLocationName | Location Description | /SAPAPO/LOC_CHAR40K | |
| DestinationLocationTypeDesc | Short Text for Fixed Values | DDTEXT | |
| DestinationLocationCountryName | Country/Region Name | TEXT50 | |
| DestinationLocationRegionName | Description | TEXT20 | |
| MeansOfTransport | Means of Transport | /SAPAPO/TR_TRATY | |
| MeansOfTransportDesc | Means of Transport Description | /SAPAPO/TR_TRATYDESCR | |
| TransportationMode | Transportation Mode | VKTRA | |
| TransportationModeDesc | Transportation Mode Description | ||
| TransportationModeCategoryDesc | Transportation Mode Category Description | DDTEXT | |
| NumberOfTransportationOrders | Number of Transportation Orders | /SCMTMS/VDM_NUMBER_OF | |
| NumberOfInvcgBlkdTranspOrds | Number of Transportation Orders with Invoicing Block | /SCMTMS/VDM_NUMBER_OF | |
| SuplrFrtInvcReqTypeDesc | Short Description | /SCMTMS/DESCRIPTION_S | |
| SuplrFrtInvcReqCategoryDesc | Short Text for Fixed Values | DDTEXT | |
| SuplrFrtInvcReqBlockReason | Block Reason | /SCMTMS/BLOCK_REASON_CODE | |
| SuplrFrtInvcReqBlockReasonDesc | Block Reason Description | /SCMTMS/DESCRIPTION_S | |
| SuplrFrtInvcReqLifeCycStsDesc | Short Text for Fixed Values | DDTEXT | |
| SuplrFrtInvcReqBlockStatusDesc | Short Text for Fixed Values | DDTEXT | |
| SuplrFrtInvcReqConstcyStsDesc | Short Text for Fixed Values | DDTEXT | |
| SuplrFrtInvcReqArchStatusDesc | Short Text for Fixed Values | DDTEXT | |
| SuplrFrtInvcReqConfStatusDesc | Short Text for Fixed Values | DDTEXT | |
| InvoiceDateYearWeek | Invoice Year Week | NUM6 | |
| InvoiceDateYearMonth | Invoice Year Month | NUM6 | |
| InvoiceDateYearQuarter | Invoice Year Quarter | NUM5 | |
| InvoiceDateYear | Invoice Year | NUM4 | |
| BillFromParty | Invoicing Party | /SCMTMS/SFIR_INV_BILLFROMPARTY | |
| BillFromPartyName | null | ||
| InvoicingStatusDesc | Short Text for Fixed Values | DDTEXT | |
| TranspChargeCalcStatusDesc | Short Text for Fixed Values | DDTEXT | |
| CarrierInvoicingStatusDesc | Short Text for Fixed Values | DDTEXT | |
| TranspChargeItmInvcgStatusDesc | Short Text for Fixed Values | DDTEXT | |
| TranspChargeCalcLevelDesc | Short Text for Fixed Values | DDTEXT |
| Master Data Relations | Join Conditions |
|---|---|
Country key
| |
Region code
|
|
Reason for Freight Settlement Document Block
|
|
Purchasing Group
| |
Purchasing Organization
| |
Country key
| |
Region code
|
|
Type
|
|
Business Document Type
|
|