P_CO_DIANOneTimeAccountBP

DDL: P_CO_DIANONETIMEACCOUNTBP Type: view CONSUMPTION Package: GLO_FIN_IS_CO_GL
30 Fields

G/L Formats - BP Logic for Journal Entry

P_CO_DIANOneTimeAccountBP is a Consumption CDS View that provides data about "G/L Formats - BP Logic for Journal Entry" in SAP S/4HANA. Part of development package GLO_FIN_IS_CO_GL.

Annotations (12)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PCOONETIMEBP view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode OneTimeAccountBP CompanyCode Receiver Company Code
KEY AccountingDocument OneTimeAccountBP AccountingDocument Journal Entry
KEY FiscalYear
BusinessPartnerName1 OneTimeAccountBP BusinessPartnerName1 Name
BusinessPartnerName2 OneTimeAccountBP BusinessPartnerName2 Name 2
BusinessPartnerName3 OneTimeAccountBP BusinessPartnerName3 Name 3
BusinessPartnerName4 OneTimeAccountBP BusinessPartnerName4 Name 4
Country OneTimeAccountBP Country Venue: Ctry/Reg
CityName OneTimeAccountBP CityName Name
POBox OneTimeAccountBP POBox PO Box
POBoxPostalCode OneTimeAccountBP POBoxPostalCode PO Box Postal Code
PostalCode OneTimeAccountBP PostalCode Postal Code
Region OneTimeAccountBP Region Venue Region
TaxID1 OneTimeAccountBP TaxID1 Tax Number 1
TaxID2 OneTimeAccountBP TaxID2 Tax Number 2
TaxID3 OneTimeAccountBP TaxID3 Tax Number 3
TaxID4 OneTimeAccountBP TaxID4 Tax Number 4
TaxID5 OneTimeAccountBP TaxID5 Tax Number 5
StreetAddressName OneTimeAccountBP StreetAddressName Street
ResponsibleType OneTimeAccountBP ResponsibleType Tax Type
TaxNumberType OneTimeAccountBP TaxNumberType Tax number type
BusinessType OneTimeAccountBP BusinessType Type of Business
IndustryType OneTimeAccountBP IndustryType Type of Industry
OneTimeAccountBPSalutationText OneTimeAccountBP OneTimeAccountBPSalutationText Title
AddressID OneTimeAccountBP AddressID Ship-to address
IsNaturalPerson OneTimeAccountBP IsNaturalPerson Natural person
_CompanyCode OneTimeAccountBP _CompanyCode
_AccountingDocument OneTimeAccountBP _AccountingDocument
_FiscalYear OneTimeAccountBP _FiscalYear
_Address OneTimeAccountBP _Address

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CO_DIANOneTimeAccountBP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_CO_DIANOneTimeAccountBP AS
SELECT
  OneTimeAccountBP.CompanyCode AS CompanyCode,
  OneTimeAccountBP.AccountingDocument AS AccountingDocument,
  cast( OneTimeAccountBP.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  OneTimeAccountBP.BusinessPartnerName1 AS BusinessPartnerName1,
  OneTimeAccountBP.BusinessPartnerName2 AS BusinessPartnerName2,
  OneTimeAccountBP.BusinessPartnerName3 AS BusinessPartnerName3,
  OneTimeAccountBP.BusinessPartnerName4 AS BusinessPartnerName4,
  OneTimeAccountBP.Country AS Country,
  OneTimeAccountBP.CityName AS CityName,
  OneTimeAccountBP.POBox AS POBox,
  OneTimeAccountBP.POBoxPostalCode AS POBoxPostalCode,
  OneTimeAccountBP.PostalCode AS PostalCode,
  OneTimeAccountBP.Region AS Region,
  OneTimeAccountBP.TaxID1 AS TaxID1,
  OneTimeAccountBP.TaxID2 AS TaxID2,
  OneTimeAccountBP.TaxID3 AS TaxID3,
  OneTimeAccountBP.TaxID4 AS TaxID4,
  OneTimeAccountBP.TaxID5 AS TaxID5,
  OneTimeAccountBP.StreetAddressName AS StreetAddressName,
  OneTimeAccountBP.ResponsibleType AS ResponsibleType,
  OneTimeAccountBP.TaxNumberType AS TaxNumberType,
  OneTimeAccountBP.BusinessType AS BusinessType,
  OneTimeAccountBP.IndustryType AS IndustryType,
  OneTimeAccountBP.OneTimeAccountBPSalutationText AS OneTimeAccountBPSalutationText,
  OneTimeAccountBP.AddressID AS AddressID,
  OneTimeAccountBP.IsNaturalPerson AS IsNaturalPerson,
  OneTimeAccountBP._CompanyCode AS _CompanyCode,
  OneTimeAccountBP._AccountingDocument AS _AccountingDocument,
  OneTimeAccountBP._FiscalYear AS _FiscalYear,
  OneTimeAccountBP._Address AS _Address
;

Learn More